In this case, you must also include the Option1 Name and Option1 Value columns.īefore you remove or exclude columns from your CSV file, verify whether the data in any other columns depends on the data in the columns that you want to remove or exclude. When you update products using a CSV file, the only required columns are Handle and Title.Įven though the Title and Handle columns are the only required columns when you update products using a CSV file, the data in some columns depends on the data in other columns.įor example, if you update a column that is related to variants, such as Variant SKU or Variant Grams, then the data in those columns depends on the data about the corresponding variants. If you're adding variants for a product, then the Handle column is also required.
When you create a product CSV file to import new products, the only required column is Title. These columns must be present under the following conditions: If you use Excel to edit your CSV, then check Excel's export settings when you export the CSV to ensure that your file uses commas between values.
The first line of your product CSV file must be the column headers as specified in the product CSV description table.Įach column must be separated by a comma. Formatting the product CSV fileįor your product CSV file to function correctly, verify the that it meets the following criteria: If you use multiple locations and you want to import or export inventory quantities, then use the inventory CSV file.īefore you use a product CSV file, review the following considerations. The sample file includes the Variant Inventory Qty column, which is only used for stores that have a single location. If you use the sample file to create your own import file, then make sure that you remove all the example products. Your import file probably contains many more products and variants. The sample file contains an example product and a couple of variants. You can download and view a sample product CSV file to use as a template.
Considerations for the product CSV file.
0 kommentar(er)
