

Learn more about how overwriting existing products affects the data in this column. Refer to the considerations section for more information. If you change the default market or add any new markets, then your column headers appear with those market names. This column heading name varies depending on the Shopify Markets that you have set up on your store. If you sell internationally, then this is the price of the product or variant. When the value is TRUE, it indicates that the product is a physical product. When the value is deny, it indicates that the product can't be purchased after its inventory level reaches zero. TRUE, which means that this product will be published and available in the online store sales channel. This is the same store name that you use when you log in to Shopify. For example, John's Apparel or johns-apparel. The name of the store as you entered it when you created your Shopify account. For example, if the value in the Title column is Black Sun Glasses, then the value in this column is black-sun-glasses. This value is created based on the value in the Title column. Columnĭefault value created when the column is blank Columns in the product CSV file that must have a value and the default values that are created automatically if no value is present. The following table describes which columns must have a value, and the default value that is created automatically if the column is blank.

TYPING OVERWRITING TEXT UPDATE
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.

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.
TYPING OVERWRITING TEXT DOWNLOAD
You can download and view a sample product CSV file to use as a template. This can be helpful if you want to exchange product information between Shopify and another system. By using a CSV file, you can import or export a large number of products and their details at one time. You use a CSV (comma-separated values) file to import products into your Shopify store, and to export products from your store.
