Importing and exporting products with CSV file

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.

Was this article helpful?
0 out of 0 found this helpful