The following table provides a description for all the column titles in a product export.
Language abbreviations in this table are identified by two placeholders: XX or X-language. Match these placeholders with the languages you have enabled in your eCom store. Use the language table located here to know how your languages will be abbreviated.
For instructions on importing new products, click here. To learn how to editing existing products via import, click here.
| Column order (approx) |
Export column titles |
Description |
|---|---|---|
| 01 | Internal_ID |
This field will turn each product into a unique product or product variant. If each product is unique, make sure to provide a unique number for each row. If you have four products, of which three are variants (for example sizes S, M, L and XL but all referring to the same product), enter the same number for all four. The number is determined at your own discretion and may, therefore, have any desired value. This column is required when updating existing products. |
| 02 | Internal_Variant_ID |
The variant ID will be created here, which can also be used to group items in the Import Wizard. When editing products, these fields have already been completed. If you are importing new products, this field may be left blank. Note: These numbers cannot be used in Back Office searches. This column is required when updating existing products. |
| 03 | Visible | Configure a product’s visibility:
|
| 04 | Brand | Enter the product brand here. |
| 05 | Supplier | Enter the name of the product supplier here. |
| 06 | XX_Title_Short | Enter the product title/name here, which will be used in the category overview.
NOTE: The title will also determine the initial web address of the product. For example: You add a product with a title entered as Red Sweatshirt. The web address of the product will be: https://www.yourdomain.com/red-sweatshirt.html Further changes to the title of your product will not adjust the web address to preserve any search engine ranking. To adjust the URL of the product, you need to change the Product URL. You can do this manually as explain in Managing product SEO data. To import changes to the URL, see Product URL. Required when creating new products. Only eCom versions not connected to a Retail store can create new products using the import tool. NOTE: Click here if you're not sure which version of eCom you're using. |
| 07 | XX_Title_Long |
Enter the long product title here. It will be used on the product page and is the H1 page header. When creating new products this field is required. Required when creating new products. Only eCom versions not connected to a Retail store can create new products using the import tool. NOTE: Click here if you're not sure which version of eCom you're using. |
| 08 | XX_Description_Short | A short product description, which will be shown on the product page. Note: In some themes, this option cannot be used. |
| 09 | XX_Description_Long | A longer description, shown in the Information area on product pages under "Content". HTML code is acceptable in this field, yet <div> tags are not supported. |
| 10 | XX_URL |
The URL of the product. NOTE: When you are importing new products to eCom, if this column is left blank, the product name will define the product's URL. Only eCom versions not connected to a Retail store can create new products using the import tool. NOTE: Click here if you're not sure which version of eCom you're using. |
| 11 | XX_Variant |
The variant name. When importing or editing product options, multiple drop-down menus cannot be used. All variants are listed in a single menu. NOTE: Omnichannel merchants can't import variant titles in their eCom store's default language. If their eCom store has multiple languages, they can import variant titles in those. |
| 13 | Price | Enter the current product price here, without a currency prefix, for example, 49.99 |
| 14 | Price_Old | Enter a price here if the product price has changed. For example, if the product was first sold for €49.99 and now for €39.99, enter 49.99 here. |
| 15 | Price_Cost | The purchase price of the product in question. It is not visible to your customers. For example 29.99 |
| 16 | Price_Unit | Price per unit. Example: If you sell fabric or rope at $3.99 per meter, enter $3.99 here. |
| 17 | Unit | The unit that matches the price per unit. To see all available units, check the file added at the bottom of the screen. Example: Liter |
| 18 | Tax |
The VAT rate, which must be entered as a decimal value, for example, 0.20. Required column if you use manual taxes. European countries, UK or Australia use manual taxes. |
| 19 | Stock_Track | Tell the system whether it should keep track of your stock (N or Y). If you select Y, the system will check Stock_Disable_Sold_Out settings. |
| 20 | Stock_Disable_Sold_Out | Select here how you wish to track your stock:
|
| 21 | Stock_Level | Number in stock for the product in question. Example: 100 |
| 22 | Stock_Min | The minimum number in stock for the product in question. For example, if you enter 10 here, the number in stock cannot reach a value lower than 10. If you have indicated that purchases are denied when a product is out of stock, customers can no longer order when the number in stock drops to 10. Example: 0 |
| 23 | Stock_Alert | Warning sent when the number in stock drops below the specified value. For example, if you enter 10 here, you will be notified that the number in stock for the product in question has dropped below 10. This notification is shown with an orange tick icon through SHOP > Products > Inventory in the left menu of the Back Office. Example: 10 |
| 24 | Article_Code | The article number for the product in question. Example: 254631 |
| 25 | HS_Code | Harmonized System code. This number is used with some integrate shipping carriers to tell customs officials what is inside the package. Example: 1001.11.2013 |
| 26 | EAN | European article numbering, a unique 13 digit barcode associated with an article. Example: 2312340000007 |
| 27 | SKU | Stock keeping unit, a unique code associated with an article. SKUs are unique codes associated with articles and used to identify product variants. Example: 88765.123 |
| 28 | Weight | The weight of the product in grams. It is associated to the cost of shipping. Use this column if the mass of your products is measured in grams. |
| 29 | Weight_value | The value of weight without units. The units as defined by the column "Weight_unit." Example: For a product weighing 50 oz, enter: 50. |
| 30 | Weight_unit |
The unit of measurement of the "Weight_value" column. Available units:
|
| 31 | Volume_Value | The value of the volume without units. The units are indicated by the "Volume_Unit" column. Can be used instead of the "Volume" column if the units are measured in inches. |
| 32 | Volume_Unit |
The unit of measurement of the Volume_Value column. Available units:
|
| 33 | Volume | The product volume. This value is calculated by multiplying the length x width x height. Example: 2927.77 |
| 34 | Colli | The plural form of “collo” (package), i.e. the individual shipment packing unit. Configure this option if you require several units to ship a given product. The Colli option is only used in combination with Paazl. |
| 35 | Size_X | The value of the width in centimeters. Only visible to customers when comparing products but also relevant for some shipping integrations. Can be used instead "Size_X_Value" if the width is currently measured in centimeters. |
| 36 | Size_Y | The value of the height in centimeters. Only visible to customers when comparing products but also relevant for some shipping integrations. Can be used instead "Size_Y_Value" if the height is currently measured in centimeters. |
| 37 | Size_Z | The value of the depth in centimeters. Only visible to customers when comparing products but also relevant for some shipping integrations. Can be used instead "Size_Z_Value" if the depth is currently measured in centimeters. |
| 38 | Size_X_Value | The value of the width without units. The units are indicated by the "Size_Unit" column. Can be used instead of the Size_X column if the units are measured in inches. |
| 39 | Size_Y_Value | The value of the height without units. The units are indicated by the "Size_Unit" column. Can be used instead of the Size_Y column if the units are measured in inches. |
| 40 | Size_Z_Value | The value of the depth without units. The units are indicated by the "Size_Unit" column. Can be used instead of the Size_Z column if the units are measured in inches. |
| 41 | Size_Unit |
The unit of measurement of the Size_X_Value, Size_Y_Value and Size_Z_Value columns. Available units:
|
| 42 | Matrix | Use the Matrix option only if you ship through Paazl. Each matrix can have its own price group. For example, if a given product is very light in weight, but, due to its dimensions, requires large shipment packaging, you can use a different matrix compared to regular packages. |
| 43 | Data_01 | Additional template data are used to specify certain elements of your online store at the product level. What you enter here will depend on the connection terms entered in the Template Editor. |
| 44 | Data_02 | |
| 45 | Data_03 | |
| 46 | Buy_Min | The minimum number of the product in question that customers have to order. Example: 1 |
| 47 | Buy_Max | The maximum number of the product in question that customers are allowed to order. Example: 10 |
| 48 | XX_Category_1 | The main category name. This option cannot be edited and can only be used when importing new products. Example: Men |
| 49 |
XX_Category_2 |
The subcategory name. This option cannot be edited and can only be used when importing new products. Example: Trousers |
| 50 | XX_Category_3 | The sub-subcategory name. This option cannot be edited and can only be used when importing new products. Example: Shorts |
| 51 | XX_Meta_Title | The product title. The meta title is used as the link in search engines. |
| 52 | XX_Meta_Description | A description with a maximum of 160 characters and a natural flow of text (avoid merely putting words separated by commas). This text is shown underneath links in search results. |
| 53 | XX_Meta_Keywords | Keywords are words that describe core product characteristics. Here you can enter words separated by commas. Meta keywords are no longer used by Google. |
| 54 | Images | Enter (an) image URL(s) here. A URL should start with http:// of https:// and end with an image extension, for example, .jpg of .png. If you want to add more images to the product in question, separate the image URLs by commas. Example: http://www.imageexample.com/example_image.png |
| 55 | Tags | Enter product keywords or key sentences here. If you want to add multiple tags, separate them by commas. Example: Black shorts with flower print |
| 56 | None. (Cannot be exported). | Enter the Google category. To locate the correct Google Category, click here. |