1. Product CSV Template
1.1. Click HERE to download the product CSV template.
2. General CSV guidelines
- CSVs should be in UTF-8 format.
- Any dates should be defined for the store’s local timezone.
- If importing a boolean value (true or false) use 1 or 0 in your CSV.
- Multiple values in a field get separated with commas.
- Images need to be pre-uploaded or available online in order to import to your store.
- External URLs are supported and imported into the media library if used.
- You can define the filename if the image already exists in the media library.
3. CSV columns and formatting
| CSV Column Name | Maps to product property | Example | Notes |
| ID | id | 100 | Defining this will overwrite data for that ID on import. Auto-generated if leave blank. |
| Type | type | simple, variation, virtual | Product Type. Valid values: simple, variable, grouped, external, variation, virtual, downloadable. Multiple types can be used CSV separated. |
| SKU | sku | sku-10293 | Defining this will overwrite data for that ID on import. Auto-generated if leave blank. |
| Name | name | My Product Name | Required. |
| Published | status | 1 | 1 for published ,0 for private ,-1 for draft . |
| Is Featured? | featured | 1 | 1 or 0 |
| Visibility in Catalog | catalog_visibility | visible | Supported values:visible ,catalog ,search ,hidden . |
| Short Description | short_description | This is a product's short description sample. | |
| Description | description | This is more information about a product. | |
| Date Sale Price Starts | date_on_sale_from | 2000-01-31 10:53:15 | Date or leave blank. |
| Date Sale Price Ends | date_on_sale_to | 2000-03-31 10:53:15 | Date or leave blank. |
| Tax Status | tax_status | taxable | Supported values:taxable ,shipping ,none . |
| Tax Class | tax_class | standard | Can use any existing tax class. |
| In Stock? | stock_status | 1 | 1 or 0 |
| Backorders allowed? | backorders | 1 | 1, 0, or notify |
| Sold individually? | sold_individually | 1 | 1 or 0 |
| Weight (unit) | weight | 100 | Parse only numbers. |
| Length (unit) | length | 20 | Parse only numbers. |
| Width (unit) | width | 30 | Parse only numbers. |
| Height (unit) | height | 10 | Parse only numbers. |
| Allow customer reviews? | reviews_allowed | 1 | 1 or 0 |
| Purchase Note | purchase_note | Design may be different from product image. | |
| Sale Price | sale_price | 20.90 | Sale price. Leave blank if no sale for this product. |
| Regular Price | regular_price | 25.90 | Regular price for this product. Non-sale price. |
| Stock | manage_stock / stock_quantity | 20 | Numeric stock level enables stock management. parent can be used for variations.Blank = no stock management. |
| Categories | category_ids | Accessories,Clothing > Male | CSV list of categories.> used for hierarchy. |
| Tags | tag_ids | Tag 1, Tag 2 | CSV list of tags. |
| Shipping Class | shipping_class_id | small product | Name of the shipping class. |
| Attribute 1 Name | attributes | color | Looks for global attribute or uses text if not found. Include as many as needed. “Used for variations” is set automatically. |
| Attribute 1 Value(s) | attributes | Blue, Red,Green | List of values for the attribute. Variations only need 1 value. First value will be used if multiple values found here. |
| Attribute 1 Default | default_attributes | Blue | Default value for variable products. |
| Attribute 1 Visible | attributes | 1 | 1 or 0. Mapping screen labels this as “Attribute Visibility” |
| Attribute 1 Global | attributes | 1 | 1 or 0.Mapping screen labels this as “Is a global attribute?” |
| Images | image_id / gallery_image_ids | image1.jpeg | If multiple images found, first image will be used as featured image. |
| Download 1 Name | downloads | Download 1 | |
| Download 1 URL | downloads | url.zip | |
| Download Limit | download_limit | 1 | n/a or a limit |
| Download Expiry Days | download_expiry | 1 | n/a or a day limit. |
| Parent | parent_id | id:100 or SKU-01 | Set parent ID. This setting is used for variable products. Can be just a numeric ID (e.g. id:100 or SKU-100). |
| Upsells | upsell_ids | id:100, id:101 or SKU-01, SKU-01 | List of product IDs or SKU IDs to use for up-selling. |
| Cross-sells | cross_sell_ids | id:100, id:101 or SKU-01, SKU-01 | List of product IDs or SKU IDs to use for cross-selling. |
| Position | menu_order | 1 | Use for sorting product order. |