Migration Hub

This is the name of your product. The Title header is the only required field to import your CSV file. If this header is missing, the CSV will not be accepted.

Example accepted values:
Logo T-shirt, Ceramic cup

Each product should have a unique name, and Shopify will consider any additional occurrences of the same product name a "duplicate". Shopify will not import multiple duplicate products sharing the same name.

The only time you should have multiple lines sharing the same product name is when you have a product with multiple options. You can learn more about formatting product options under the Option headers description.

The retail selling price of your product. If there is a currency symbol appearing in your values, our system will ignore the currency symbol and will only import the numerical value.

Example accepted values:
45.50, $25

Default value if missing:
0.00

Enable inventory tracking on your product.

Accepted values (strict):
shopify which will allow Shopify to track inventory of the item.
Or, you can leave the field blank to disable inventory tracking on the product.

Default value if missing:
The field will be left blank, disabling inventory tracking.

In most cases, you will want to add the Variant Inventory Tracker header to your file and put the shopify value for every product line.

The name of the brand or vendor of your product. You can choose to use this information internally only, or display it on your customers as well. The value must be at least 2 characters in length.

Example accepted values:
ABC Goods, Nike

Default value if missing:
The name of your store as shown in your "Store details" settings will be used as the Vendor.

Publish your product to your online channel, and allow customers to find the item on your ecommerce website after importing.

Accepted values (strict):
TRUE which will publish your product to the online channel.
FALSE which will hide the product from your online channel.

Default value if missing:
TRUE

If your products are not ready for online sales (ex. product does not have a descritpion to display online, or no photos) then it is suggested to add the Published header to your file and put the FALSE value for every product line.

As a note, there is no field to publish the product to the POS channel after import. Please use view the Tags header to learn about using Tags to organize your products instead.

Charge taxes on product, or disable taxes being charged on the sale of the product.

Accepted values (strict):
TRUE which will enable taxes on the product.
FALSE which will disable taxes being charged for the product.

Default value if missing:
TRUE

If you have products with special tax rules (ex. reduced tax fee for certain product types) then you will put a value of TRUE for the product, and apply a Tax Override on the product in your settings.

Enable variant options for your products, such as size and color. To add product options to a product, please make sure that the Title is the same for each line, and fill out the needed "Option Name" and "Option Value" fields (up to a maximum of 3 different options per product).

Example accepted values:

• (Image) Example with up to 1 option per product
• (Image) Example with up to 2 options per product
• (Image) Example with up to 3 options per product
• (Video) Tutorial on using Option Fields

Default value if missing:
Blank, making the product a singular product with no options.

A parent product can only have up to 100 variant option combinations. If you have more than 100 variant combinations for a parent product, that product will not be uploaded.

An SKU is an optional field that can help you identify your products with a unique code or naming convention. The SKU Code can help you with tasks such as inventory management by allowing you to find and identify products without needing to use the full name of the product.

Example accepted values:
ABC123, ZYX9-SM-BL

To learn more about the benefits of using SKU codes, please view our best practices video here.

The Barcode / UPC is an optional field, but if you want to scan your products' existing barcode labels on the POS to add them to the cart, you must import this data to do so. Barcodes should be between 3-39 digits long, and can be alpha-numeric.

Example accepted values:
100012349, 10002AA

It is important to make sure the Barcode / UPC code you are importing is an exact match to how your code is scanned. Some systems may encrypt your Barcode data on your export or on your physical label.

To learn how to check your Barcodes and make sure they work in Shopify, please view our best practices video here.

Indicates the current quantity of your product. Only whole numbers are accepted.

This field cannot be used if you have more than 1 location in your Shopify settings. If you have multiple locations in your Shopify settings, the column and it's values are ignored when imported. All products will be imported with a starting quantity of 0 instead.

Please visit our FAQ page after you've imported your products to learn how to update your quantity counts for multiple locations.

This is an optional field that will put your product into a category for organizational purposes. The use of Product Types can be customer facing purposes and/or for internal purposes.

Example accepted values:
Women's Apparel, Shoes

Each product can only have one Product Type. If you have more granular categorization or sub-categories, please use the Tags header to further organize your products.

This is an optional field that will track the business cost of your product. If there is a currency symbol appearing in your values, our system will ignore the currency symbol and will only import the numerical value.

Example accepted values:
45.50, $25

It is optional to add Tags to your products, however Tags can help you organize your products for many things such as setting product sub-categories, applying special tax rules, and setting channel availability.

You can add multiple tags by separating each tag with a comma.

Example accepted values:
Spring 2022 which will add a single Tag of "Summer 2022" to the product.
Unisex, Summer, POS Only which will add 3 tags to the product ("Unisex", "Summer", and "POS Only").

View how you can perform bulk actions to your Tagged products in this video.

The CSV must contain a URL web address for the image to be imported. If you do not have a URL for your image, you can add your image photos in Shopify Admin after your import is complete.

You can add multiple tags by separating each tag with a comma.

Example accepted value:
https://cdn.shopify.com/static/share-image-common.jpg

Shopify will save a copy of any successfully uploaded images in your store. This will allow the image to be used even if the original URL is deleted.

The contents of this field will display on the Online Store for the Product. The field can be left blank, showing no description for the product when viewed online.

You can upload regular text in this field, and also accepts HTML code if you have formatted and styled your text with code already.

Example accepted values:
This is a great sweater. (plain text)
<p>This is a great sweater.</p> (HTML code)

Any plain or regular text can be styled using our Rich Text Editor after the import is completed.

The retail selling price of your product. If there is a currency symbol appearing in your values, our system will ignore the currency symbol and will only import the numerical value.

Example accepted values:
45.50, $25

Default value if missing:
0.00

Enable inventory tracking on your product.

Accepted values (strict):
shopify which will allow Shopify to track inventory of the item.
Or, you can leave the field blank to disable inventory tracking on the product.

Default value if missing:
The field will be left blank, disabling inventory tracking.

In most cases, you will want to add the Variant Inventory Tracker header to your file and put the shopify value for every product line.

The name of the brand or vendor of your product. You can choose to use this information internally only, or display it on your customers as well. The value must be at least 2 characters in length.

Example accepted values:
ABC Goods, Nike

Default value if missing:
The name of your store as shown in your "Store details" settings will be used as the Vendor.

Publish your product to your online channel, and allow customers to find the item on your ecommerce website after importing.

Accepted values (strict):
TRUE which will publish your product to the online channel.
FALSE which will hide the product from your online channel.

Default value if missing:
TRUE

If your products are not ready for online sales (ex. product does not have a descritpion to display online, or no photos) then it is suggested to add the Published header to your file and put the FALSE value for every product line.

As a note, there is no field to publish the product to the POS channel after import. Please use view the Tags header to learn about using Tags to organize your products instead.

Charge taxes on product, or disable taxes being charged on the sale of the product.

Accepted values (strict):
TRUE which will enable taxes on the product.
FALSE which will disable taxes being charged for the product.

Default value if missing:
TRUE

If you have products with special tax rules (ex. reduced tax fee for certain product types) then you will put a value of TRUE for the product, and apply a Tax Override on the product in your settings.

Enable variant options for your products, such as size and color. To add product options to a product, please make sure that the Title is the same for each line, and fill out the needed "Option Name" and "Option Value" fields (up to a maximum of 3 different options per product).

Example accepted values:

• (Image) Example with up to 1 option per product
• (Image) Example with up to 2 options per product
• (Image) Example with up to 3 options per product
• (Video) Tutorial on using Option Fields

Default value if missing:
Blank, making the product a singular product with no options.

A parent product can only have up to 100 variant option combinations. If you have more than 100 variant combinations for a parent product, that product will not be uploaded.

An SKU is an optional field that can help you identify your products with a unique code or naming convention. The SKU Code can help you with tasks such as inventory management by allowing you to find and identify products without needing to use the full name of the product.

Example accepted values:
ABC123, ZYX9-SM-BL

To learn more about the benefits of using SKU codes, please view our best practices video here.

The Barcode / UPC is an optional field, but if you want to scan your products' existing barcode labels on the POS to add them to the cart, you must import this data to do so. Barcodes should be between 3-39 digits long, and can be alpha-numeric.

Example accepted values:
100012349, 10002AA

It is important to make sure the Barcode / UPC code you are importing is an exact match to how your code is scanned. Some systems may encrypt your Barcode data on your export or on your physical label.

To learn how to check your Barcodes and make sure they work in Shopify, please view our best practices video here.

Indicates the current quantity of your product. Only whole numbers are accepted.

This field cannot be used if you have more than 1 location in your Shopify settings. If you have multiple locations in your Shopify settings, the column and it's values are ignored when imported. All products will be imported with a starting quantity of 0 instead.

Please visit our FAQ page after you've imported your products to learn how to update your quantity counts for multiple locations.

This is an optional field that will put your product into a category for organizational purposes. The use of Product Types can be customer facing purposes and/or for internal purposes.

Example accepted values:
Women's Apparel, Shoes

Each product can only have one Product Type. If you have more granular categorization or sub-categories, please use the Tags header to further organize your products.

This is an optional field that will track the business cost of your product. If there is a currency symbol appearing in your values, our system will ignore the currency symbol and will only import the numerical value.

Example accepted values:
45.50, $25

It is optional to add Tags to your products, however Tags can help you organize your products for many things such as setting product sub-categories, applying special tax rules, and setting channel availability.

You can add multiple tags by separating each tag with a comma.

Example accepted values:
Spring 2022 which will add a single Tag of "Summer 2022" to the product.
Unisex, Summer, POS Only which will add 3 tags to the product ("Unisex", "Summer", and "POS Only").

View how you can perform bulk actions to your Tagged products in this video.

The CSV must contain a URL web address for the image to be imported. If you do not have a URL for your image, you can add your image photos in Shopify Admin after your import is complete.

You can add multiple tags by separating each tag with a comma.

Example accepted value:
https://cdn.shopify.com/static/share-image-common.jpg

Shopify will save a copy of any successfully uploaded images in your store. This will allow the image to be used even if the original URL is deleted.

The contents of this field will display on the Online Store for the Product. The field can be left blank, showing no description for the product when viewed online.

You can upload regular text in this field, and also accepts HTML code if you have formatted and styled your text with code already.

Example accepted values:
This is a great sweater. (plain text)
<p>This is a great sweater.</p> (HTML code)

Any plain or regular text can be styled using our Rich Text Editor after the import is completed.