List of all options on the product import sheet [NB]

The following table explains the columns in the CSV sample file and the required data format of each column. The rows in blue can only be imported by eCom (standalone) merchants:

  • Brand
  • Variant title (default language)
  • Price
  • Cost
  • Stock level
  • Article code
  • EAN
  • SKU

If you are a Retail with eCom (Omnichannel) merchant, you can manage these product details from your Retail account to ensure consistency between both platforms. For more information, please see our Retail article Updating product details that can't be imported in eCom.

Column name Description Notes
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. Required when updating existing products.
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. Required when updating existing products.
Visible Configure a product’s visibility:
  • Hide [N]
  • Show [Y]
  • Show when in stock [S]
Example: S
 
Brand Enter the product brand here.  
Supplier Enter the name of the product supplier here.  
EN_Title_Short Enter the product title/name here, which will be used in the category overview.

Required when creating new products. 
Only eCom stand-alone users can create new products using the import tool.

NOTE: Click here if you're not sure which version of eCom you're using.

EN_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 stand-alone users can create new products using the import tool.

NOTE: Click here if you're not sure which version of eCom you're using.

EN_Description_Short A short product description, which will be shown on the product page. Note: In some themes, this option cannot be used.   
EN_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.  
EN_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.

For example Size: 36, Color: Black.

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.

Required when creating new products. Only eCom stand-alone users can create new products using the import tool.

NOTE: Click here if you're not sure which version of eCom you're using.

EN_Canonical_Url  A canonical URL is a preferred version of pages with similar or identical content. If your online store contains pages that are very much alike or contain the same information, you can add a canonical URL here.  
Price  Enter the current product price here, without a currency prefix, for example, 49.99    
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.  
Price_Cost  The purchase price of the product in question. It is not visible to your customers. For example 29.99   
Price_Unit  Price per unit. 
Example: If you sell fabric or rope at $3.99 per meter, enter $3.99 here.
 
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  
Tax  The VAT rate, which must be entered as a decimal value, for example, 0.20  Required if you use manual taxes. 
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.   
Stock_Disable_Sold_Out Select here how you wish to track your stock:
  • Do not track (Enter an N with Stock_Track)
  • Track, deny purchases when out of stock [Y]
  • Track, allow purchases even when out of stock [N]
Example: N
 
Stock_Level  Number in stock for the product in question. Example: 100   
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
 
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
 
Article_Code  The article number for the product in question.
Example: 254631
 
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  
EAN European article numbering, a unique 13 digit barcode associated with an article.
Example: 2312340000007
 
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
 
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.  
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.  
Weight_unit

The unit of measurement of the "Weight_value" column.

Available units:

  • oz
  • lb
  • g
  • kg
 
Volume  The product volume. This value is calculated by multiplying the length x width x height. Example: 2927.77  
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.  
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.   
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.   
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.   
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.  
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.  
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.  
Size_Unit

The unit of measurement of the Size_X_Value, Size_Y_Value and Size_Z_Value columns.

Available units:

  • cm
  • in
 
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.  
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.  
Data_02     
Data_03     
Buy_Min  The minimum number of the product in question that customers have to order.
Example: 1 
 
Buy_Max  The maximum number of the product in question that customers are allowed to order.
Example: 10
 
EN_Category_1  The main category name. This option cannot be edited and can only be used when importing new products. Example: Men  
EN_Category_2 The subcategory name. This option cannot be edited and can only be used when importing new products.
Example: Trousers
 
EN_Category_3  The sub-subcategory name. This option cannot be edited and can only be used when importing new products.
Example: Shorts
 
EN_Meta_Title  The product title. The meta title is used as the link in search engines.  
EN_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.  
EN_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.   
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  
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  
Have more questions? Submit a request