![]() ![]() Some CSV columns are related to other columns, and can't be left blank when the other related columns aren't also left blank. The following table describes which columns must have a value, and the default value that is created automatically if the column is blank. The column isn't present in the CSV file, but the values can't be blank.The column is present, but the values in that column are blank.When a column requires a value, but is blank, then a default value is created automatically in the following cases: In addition to the Title column, some other columns must have a value. Columns in the product CSV file that must contain values But if you replace your international market with your own market, then in the header name, International changes to the name of the market.įor example, if you create a market for each individual continent, and one of your market names is South America then column heading Price / International becomes Price / South America, and column heading Compare-at price / International becomes Compare-at price / South America in the CSV export file. By default your CSV has the Price / International and Compare-at Price / International columns. If you have Shopify Markets set up on your store, then your CSV export reflects the unique markets that you created. If your data depends on a column that is missing, then you receive an error when you try to import your product CSV file. 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. Each column must be separated by a comma.The first line of your product CSV file must be the column headers as specified in the product CSV description table.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.If you use the sample file, then be aware of the following details: You can download and view a sample product CSV file to use as a template. Adding multiple product images in a CSV file.Overwriting product details using an import CSV file.Considerations for the product CSV file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |