Online Store data importing and exporting recognizes 25 product attributes. This means your CSV may contain up to 25 columns.
Here is a brief description of each attribute:
| Column name in import dialog |
Column name in CSV file |
Requirement | Type | Limits |
| SKU | sku | SKU or Name field is required | String | 255 symbols |
| Name | name | SKU or Name is required | String | 255 symbols |
| Description | description | Optional | String | No |
| Enabled | enabled | Optional | Boolean | "true", "yes", "on", "Y", "1" for enabled, any other values for disabled |
| Weight | weight | Optional | Floating number | Any valid floating number for weight, an empty value for digital product or services |
| Price | price | Optional | Floating number | Any valid floating number |
| Compare to price | recommended_price | Optional | Floating number | Any valid floating number |
|---|---|---|---|---|
| Quantity | quantity | Optional | Integer | Any valid integer, and empty value for the unlimited quantity |
| Image | image | Optional | String | http:// or https:// URLs |
| Category 1 | category1 | Optional | String | 255 symbols |
| Category 2 | category2 | Optional | String | 255 symbols |
| Category 3 | category3 |
Optional |
String | 255 symbols |
| Storefront page | showOnFrontpage | Optional | Boolean | "1" for true, "0" or empty value for false |
| Fixed shipping rate | shipping_freight | Optional (legacy) |
Floating number | Any valid floating number |
| Fixed shipping rate only | fixed_shipping_rate_only | Optional (legacy) |
Boolean | "true", "yes", "on", "Y", "1" for true, any other values for false |
| Shipping type | shippingType | Optional | Strings | One of these values: GLOBAL_METHODS, SELECTED_METHODS, FLAT_RATE, FREE_SHIPPING |
| Shipping markup | shippingMethodMarkup | Optional It is used with GLOBAL_METHODS shipping rate type |
Floating number | Any valid floating number |
| Flat Rate shipping amount | shippingFlatRate | Optional It is used with FLAT_RATE shipping rate type |
Floating number | Any valid floating number |
| Disabled shipping methods | shippingDisabledMethods | Optional It 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 | shippingEnabledMethods | Optional It is used with SELECTED_METHODS shipping rate type |
List of strings split by | symbol | A string is *ID of a shipping method |
| UPC | upc | Optional | String | 255 symbols |
| Brand | brand | Optional | String | 255 symbols |
| Page title | seo_title | Optional | String | 55 symbols |
| Meta description | seo_description | Optional | String | 160 symbols |
| Width | width | Optional | Floating number | 5 symbols |
| Height | height | Optional | Floating number | 5 symbols |
| Length | length | Optional | Floating number | 5 symbols |
This feature is available on all Online Store plans.
Other helpful articles
Importing products to your Online Store
Exporting your products from Online Store