Importing Products
Product import is the fastest way to upload a catalog or make bulk changes to products (including price and other product details) in an existing catalog.
If a CSV file was exported from another source, like an inventory list from a supplier, then it needs to be rebuilt to Online Store dashboard format. If the format doesn't match, then the import fails. Learn more about the CSV File Format below.
Tips before importing products:
- Click the link to download the CSV template file. It can be used as a template for creating CSV files. It includes information about a sample product with values separated by a comma.
- Enter product data into the template, following the CSV file format. A file from another source may have columns not supported while importing to Online Store. Do not paste those columns into the file.
- While uploading the CSV file into Online Store, make sure columns in the file and columns in Online Store are in exactly the same order. It's recommended to delete all the empty columns from the file, so it doesn't cause any errors.
To import CSV files:
- From Catalog, select Products.
- Click Import Products.
- Click Choose file and select the CSV file from the computer.
- Select the delimiter used in the file (comma, semicolon, or tabulation).
- Select the character encoding used in the file:
Note: If you don’t know how your CSV file is encoded, try UTF-8. It’s the most universal charset.
6. Make sure Skip First Line is checked if you have column names as the first line in your file.
7. Arrange columns (drag and drop) to mimic CSV file:
8. Uncheck the columns that are not used in the file.
9. Use the Skip column option to exclude up to three columns:
10. Check the option Delete all products and categories before import if the catalog needs to be cleared before import.
Note: This will delete all the products in the store. They will be replaced with the products from the CSV imported file.
When the CSV file is uploaded, a notification that the file has been imported will appear.
CSV File Format
Product import recognizes 30 product attributes (columns). Here is a brief description of each attribute:
| Column name in import dialog | Description | Requirement | Type | Limits |
| SKU | Product SKU | SKU or Name field is required | String | 255 symbols |
| Name | Product name | SKU or Name field is required | String | 255 symbols |
| Product subtitle | Product subtitle | Optional | String | 128 symbols |
| Ribbon | Product ribbon text | Optional | String | 30 symbols |
| Ribbon color | Product ribbon color | Optional | String | 7 symbols |
| Description | Product description | Optional | String | No |
| Enabled | Product availability (enabled/disabled) | Optional | Boolean | "true", "yes", "on", "Y", "1" for enabled, any other values for disabled |
| Weight | Product weight | Optional | Floating number | Any valid floating number for weight, empty value for digital product or services |
| Price | Product price | Optional | Floating number | Any valid floating number |
| “Compare to” price(in CSV file -recommended_price) | Product sale price | Optional | Floating number | Any valid floating number |
| Quantity | Product stock quantity | Optional | Integer | Any valid integer, empty value for unlimited quantity |
| Image | URL path to main product image | Optional | String | http:// or https:// URLs |
| Category 1 | Category name or path to category (e.g.Books/Science/Biology) | Optional | String | 255 symbols |
| Category 2 | Path to the second category | Optional | String | 255 symbols |
| Category 3 | Path to the third category | Optional | String | 255 symbols |
| Store front page(in CSV file -showOnFrontpage) | Indicates that a product belongs to the store root category | Optional | Boolean | "1" for true, "0" or empty value for false |
| Fixed shipping rate(In CSV file -shipping_freight) | (Legacy) Product shipping freight value | Optional | Floating number | Any valid floating number |
| Fixed shipping rate only(in CSV file - fixed_shipping_rate_only) | (Legacy) Indicates that the product has only fixed shipping rate | Optional(legacy) | Boolean | "true", "yes", "on", "Y", "1" for true, any other values for false |
| Shipping rate type(in CSV file - shippingType) | Indicates that there is a product-specific shipping of certain type | Optional | Strings | One of these values: GLOBAL_METHODS, SELECTED_METHODS, FLAT_RATE, FREE_SHIPPING |
| Shipping markup(in CSV file -shippingMethodMarkup) | Fixed fee per item value that is added to global shipping rates (See product-specific shipping) | OptionalIt is used with GLOBAL_METHODS shipping rate type | Floating number | Any valid floating number |
| Flat Rate Shipping amount(in CSV file -shippingFlatRate) | Fixed rate per item value | OptionalIt is used withFLAT_RATE shipping rate type | Floating number | Any valid floating number |
| Disabled shipping methods(in CSV file -shippingDisabledMethods) | Shipping methods that are disabled for a product | OptionalIt is used with SELECTED_METHODS shipping rate type | List of strings split by | symbol | A string is *ID of a shipping method |
| Enabled shipping methods(in CSV file - shippingEnabledMethods) | Shipping methods that are enabled for a product ( | OptionalIt is used withSELECTED_METHODS shipping rate type | List of strings split by | symbol | A string is *ID of a shipping method |
| UPC | UPC (EAN) attribute | Optional | String | 255 symbols |
| Brand | Brand attribute | Optional | String | 255 symbols |
| Page title(in CSV file - seo_title) | SEO field, meta title tag | Optional | String | 55 symbols |
| Meta description(in CSV file -seo_description) | SEO field, meta description tag | Optional | String | 160 symbols |
| Width | Product dimension for shipping calculation | Optional | Floating number | 5 symbols |
| Height | Product dimension for shipping calculation | Optional | Floating number | 5 symbols |
| Length | Product dimension for shipping calculation | Optional | Floating number | 5 symbols |
Sample CSV File
Download a sample product CSV file to use as a template for creating your own CSV files. It includes information about a sample product, and the values are separated by a comma.
You can import this sample file with the following options in the import dialog:
