When importing and exporting products, the attributes that you can view and edit in your CSV file depend on your export template. We’ve included tables that list all fields that are present in the Bulk Edit template, the fields you can add to a custom export template, and the fields that are present when exporting SKUs.
If a field is not in the list below (such as bulk pricing), it cannot be imported, exported, or created manually in the CSV file. Fields in bold are required or recommended. For a complete list of the minimum-required fields for creating a new product or variant, see Importing Your First Product.
Fields in the Bulk Edit Template
| Field | Description | Format / Additional Information |
|---|---|---|
| Item Type | Defines the item as a Product, SKU, or Rule | Type in Product for products, SKU for variants, and Rule for variant or modifier rules. |
| Product ID | The system-generated product identifier; cannot be created manually | This field is required for updating existing products, but must be blank for creating new products. |
| Product Name | The name of your product; must be unique | This field has a maximum length of 255 characters. |
| Product Type | Defines whether the item is physical or digital | Type in P for physical products, and D for digital products. |
| Product Code/SKU | Stock-keeping unit number you use for inventory; must be unique | This field is alphanumeric and has a maximum length of 255 characters. |
| Bin Picking Number | Identifies where in a warehouse the item is located | This field has a maximum length of 255 characters. |
| Brand Name | The brand or manufacturer of a product | Enter an existing brand name to assign a product to that brand, or enter a new brand name to create the brand upon import. |
| Option Set | The option set name | If you are on the v3 product experience, you should delete this field or create a custom export template that excludes it, as it can cause duplicated options upon import. |
| Option Set Align | Determine whether the options are to the right or below the product image |
Type in right to display product options to the right of the product image, or below to display options beneath the product image. If you are on the v3 product experience, you should delete this field or create a custom export template that excludes it, as it can cause duplicated options upon import. |
| Product Description | A description of your product | This field can contain text or HTML. |
| Price | Your product's base price | Use numbers only (24.99), but no units. Note: Pricing changes can take up to 10 minutes to appear on the storefront. See our FAQ on price changes for more information. |
| Cost Price | The cost of the product for you (accounting purposes only) | Use numbers only; no units. Note: Pricing changes can take up to 10 minutes to appear on the storefront. See our FAQ on price changes for more information. |
| Retail Price | The retail price (MSRP); if entered, it will appear next to your base or sale price | Use numbers only; no units. MSRP cannot be assigned to variants via import. Note: Pricing changes can take up to 10 minutes to appear on the storefront. See our FAQ on price changes for more information. |
| Sale Price | The sale price; if entered, it will replace the base price | Use numbers only; no units. Sale price cannot be assigned to variants via import. Note: Pricing changes can take up to 10 minutes to appear on the storefront. See our FAQ on price changes for more information. |
| Fixed Shipping Cost | The price to ship one unit of your product; the product will ship at that price internationally, regardless of all other shipping settings | Use numbers only; no units. |
| Free Shipping | Your product will ship for free; if enabled, this overrides any other shipping settings | Type in Y to enable free shipping, or N to disable free shipping on the product level. |
| Product Warranty | Product warranty information | This field can contain text or HTML, and has a maximum length of 65,535 characters. |
| Product Weight | The product’s weight (physical products only) | Use numbers only; no units. |
| Product Width | Your product's width for calculating shipping | Use numbers only; no units. |
| Product Height | Your product's height for calculating shipping | Use numbers only; no units. |
| Product Depth | Your product's depth for calculating shipping | Use numbers only; no units. |
| Allow Purchases? | Configures product purchasability in your storefront | Type in Y to allow the product to be purchased or pre-ordered, or N to indicate that the product cannot be purchased or pre-ordered on the storefront. |
| Product Visible? | Allows the product to be visible in your store | Type in Y to allow the product to be visible on the storefront, and N to disable product visibility. |
| Product Availability | A brief description of how long it takes for your product to ship | Use text only. This field has a maximum length of 255 characters. |
| Track Inventory | Enable or disable inventory tracking on the product. If enabled, track by option or by product | Type in none to disable inventory tracking entirely, by product to track inventory on the product level, or by option to track inventory by variant. |
| Current Stock Level | Number of units in stock (only applies if tracking inventory) | Use numbers only. |
| Low Stock Level | Inventory level at which you are sent an email notification to restock (only applies if tracking inventory) | Use numbers only. |
| Category | Categories and subcategories applied to the product | Use the format Category1; Category2/Subcategory1;Category2/Subcategory2. If your category name starts with a slash (/), denote it with \/ (like Mittens\/Gloves). You can assign a maximum of 1,000 categories per product. |
| Product File - 1 | The file name of your digital product (digital products only) | Use the file name and extension, such as filename.pdf. Before assigning a new digital file to a product, you must add it to the product_downloads/import folder of WebDAV. |
| Product File Description - 1 | A description of your file (digital products only) | |
| Product File Max Downloads - 1 | The maximum number of times a single customer can download their purchase (digital products only) | Use numbers only. |
| Product File Expires After - 1 | The period after which the download link will not work for your customer (digital products only) | Use # Days, # Weeks, # Months, # Years, or Never. |
| Product Image ID - 1 | The system-generated product image ID | The image ID must be included when updating existing images, but this field must be left blank when creating new images. |
| Product Image Path - 1 | Image file name (if stored in WebDAV) or full URL. This field is called Product Image File - 1 in the Bulk Edit template. | Use the file name and extension (imagename.jpg), or the URL path (https://fullurl.com/imagename.jpg). See Importing Variants, Images, and Other Complex Attributes for additional formatting requirements |
| Product Image Description - 1 | The alt tag for the product image | This field has a maximum length of 255 characters. |
| Product Image Is Thumbnail - 1 | If there is more than one image for the product, specify which one should be the thumbnail image | Type in Y to select this image to be used as the product thumbnail, or N to deselect the image. You can only select one thumbnail image per product. |
| Product Image Sort - 1 | If there is more than one image for the product, specify which order they should appear in (lower numbers appear earlier) | Use whole numbers only. |
| Search Keywords | Keywords for your store's search | Keywords must be separated by commas. Maximum length of 65,535 characters. |
| Page Title | Your product's page title on the storefront and in search results; will default to the product name if left blank | |
| Meta Keywords | Meta keywords; if left blank will default to those entered in your homepage SEO fields | Individual keywords must be separated by commas. This field has a maximum length of 65,535 characters. |
| Meta Description | Meta description; if left blank will default to what's entered in your homepage SEO fields | This field has a maximum length of 65,535 characters. |
| Product Condition | Product condition for Google Shopping | Type in New, Used, or Refurbished. Other values are not supported. |
| Show Product Condition? | Show the product condition on your product page | Type in Y to display the product condition field on the product page, or N to not display that field. |
| Sort Order | The order in which a product appears on a category page relative to other products; default is 0 | Use whole numbers only. You can use negative numbers. |
| Product Tax Class | The tax class applied to a product | This field has a maximum length of 255 characters. |
| Product UPC/EAN | Product's Universal Product Code (UPC) or European Article Number (EAN) | This field has a maximum length of 32 characters. |
| Stop Processing Rules | For Rules, stop processing all rules placed below that rule | Type in Y to stop processing rules, or N to continue to process rules. |
| Product URL | The relative path of your product's URL on your store; if left blank it will default to the product name | Use this format: /new-relative-url/. This field has a maximum URL length of 1,024 characters. |
| Redirect Old URL? | If you change the product URL in the CSV file, you can select whether or not to create a 301 redirect upon import | Type in Y to create a 301 redirect, or N to not create a redirect from the old product URL. |
| Global Trade Item Number | Product's Global Trade Item Number (GTIN) identifier | |
| Manufacturer Part Number | Product's Manufacturer Part Number (MPN) identifier | |
| Tax Provider Tax Code | Product's unique tax ID; use only if you have automatic tax calculation enabled. See Charging Product-Specific Tax Ratesfor more information | |
| Product Custom Fields | Additional product information that appears outside of the product’s description |
Use this format: name=value (like Color=Blue;Material=Cotton). Separate multiple custom fields with a semicolon (;). This field has a maximum length of 255 characters per each field name or value. You can assign a maximum of 200 custom fields per product. |
Manually Entered Fields
| Field | Description | Format |
|---|---|---|
| Brand + Name | The brand or manufacturer name and the product name | This field is read-only. To add or update product brands, use the Brand Name field. |
| Calculated Price | The calculated price shown on the storefront | |
| Product Not Visible | Enable to set the product as not visible in your store |
A value of Y indicates the product is not visible, while N means that the product can be viewed on your storefront. This field is read-only. Use the Product Visible? field to configure product visibility. |
| Product Inventoried | Indicates whether or not the product has inventory tracking enabled |
A value of Y indicates that the product tracks inventory, either on the product or variant level. N indicates that the product does not have inventory tracking enabled. This field is read-only. Use the Track Inventory field to configure if and how inventory is tracked. |
| Date Added | The date the product was added to the store. | This field uses the format MM/DD/YYYY by default, but you can apply a different format by creating a custom export template. |
| Date Modified | The date the product was last modified. | This field uses the format MM/DD/YYYY by default, but you can apply a different format by creating a custom export template. |
| Product File Path- 1 | The file location in WebDAV (digital products only) | This field references the WebDAV folders that the file is assigned to after it was added to the product. Use the Product File field to add files to your products. |
| Product File Total Downloads - 1 | The number of times the file has been downloaded (digital products only) | |
| Category Details | The ID, Name, and URL path of each category assigned to the product | This field is read-only. Update a category’s information by editing it in the control panel. |
| Product Image File - 1 | The location of the product image in WebDAV | This field references the WebDAV folders that the image is assigned to after it was added to the product. Use the Product Image Path field to add images to your products. |
| Product Image URL - 1 | The image’s full URL on your storefront | This field is read-only. Use the Product Image Path field to add images to your products. |
| Minimum Purchase Quantity | Setting this value will enforce a minimum quantity limit, on a per-order basis | Use numbers only. |
| Maximum Purchase Quantity | Setting this value will enforce a maximum quantity limit, on a per-order basis | Use numbers only. |
| Shipping Groups | Product's unique ShipperHQ shipping group; only available if ShipperHQ is enabled | |
| Origin Locations | Product's unique ShipperHQ origin group; only available if ShipperHQ is enabled | |
| Dimensional Rules | Product's unique ShipperHQ dimensional rule group; only available if ShipperHQ is enabled |
Supported Fields for SKU Import/Export
| Field | Description | Format |
|---|---|---|
| Product SKU | Stock-keeping unit value used for inventory tracking | This field is required for importing product SKUs, but the SKU values cannot be updated via CSV import. |
| Product UPC/EAN | Product's Universal Product Code (UPC) or European Article Number (EAN) | This field is alphanumeric and has a maximum length of 32 characters. |
| Stock Level | Number of units in stock; only applies if tracking inventory | Use numbers only. |
| Product Width | The width of the product or variant for calculating shipping | Use numbers only; no units. |
| Product Height | The height of the product or variant for calculating shipping | Use numbers only; no units. |
| Product Depth | The depth of the product or variant for calculating shipping | Use numbers only; no units. |
| Free Shipping | If applied, your product or variant will ship for free, overriding any other shipping settings | Type in Y to enable free shipping, or N to disable free shipping. |
| Fixed Shipping Cost | The price to internationally ship one unit of your product or variant, overriding any other shipping settings | Use numbers only; no units. |
| Product Weight | The weight of the product or variant for calculating shipping. |
This field is not present in the SKU Inventory Management template. Create a custom export template to include it when exporting your SKUs. Use numbers only; no units. |
