Don't know what a .csv file is? It's a comma delimited database file. Commas are used to separate different fields in the database.
Product CSV file format
The first thing you'll want to check is that your CSV file is properly formatted.
- A record is a list of all the attributes of a product - end each record with a line break
- Fields are the names of the attributes - each record must have an id, code, or name
- Values are the data associated with each field - separate each value with a comma
- Products with multiple options - separate each option with a line break
- Values that contain a comma or line break - put quotation marks around them
- Values that contain quotes - put double quotation marks around them
Prepare your CSV file
- Open Notepad (Start > All Programs > Accessories > Notepad). Mac users can use TextEdit.
- On the first line, enter your fields separated by commas. See our list of supported fields.
path,code,name,options,price
- Add a record for each item. Separate each record with a single line break:
path,code,name,options,price
Shirts,F23,Polo Shirt,"Size S M L XL Color Marigold Taupe""Sea Green""",22.95
Pants,P12,Chinos,"Waist 32 34 36 Inseam 30 32 34",34.95
- Line 1 - Header row
- Line 2 - Entry for shirt with 2 options (size and color); code=F23; price=$22.95
- Line 3 - Entry for pants with 2 options (waist and inseam); code=P12; price=$34.95
Save the file with a
.csv file extension.
Your data is now in a simple format to upload to your store.
CSV file not importing correctly?
- Missing fields within records - If you want to leave a field empty, remember to include the comma, or the remaining fields will be off by one.
- Extra line breaks at the end of the file - After the last field in the last record, add one line break and save the file. Remove any extra line breaks at the end of the file.
See Also:
