Import wizard: updating products

This page shows an overview of columns that can be connected to a variety of back office options.

Note: If you use different column names, or if certain columns are not included in the import sheet, this overview may vary. The left column is the import sheet column name, the right column the back office tool.

ADDITIONAL SETTINGS  
Behaviour Select Only update existing products in the drop-down menu if you are importing new products.
Find by Connect edited products to products in the back office. When editing products, this option is best left at Intern_ID.



SET FIELD TYPES  
Internal_ID Product - Product ID --> This field will only be shown, if you have added the Internal_ID as a column. This field is not required. However, it can be used to sort (Group by). 
Internal_Variant_ID Variant - Variant ID --> The variant ID can be used to group items in the Import Wizard
Visible Product - Visibility
Brand Product - Brand 
Supplier Product - Supplier

 

If you have added other interface languages to your back office, the language row will be expanded with them. For example, for France you will see FR_Title_short. 

NL_Title_Short Product - Title - English
NL_Title_Long  Product - Full title - English
NL_Description_Short Product - Description - English 
NL_Description_Long Product - Content - English 
NL_Variant Variant - Title - English



Price Variant - Price
Price_Old Variant - Price old incl
Price_Cost Variant - Price cost
Price_Unit Variant - Unit price
Unit Variant - Price old 
Tax Variant - Tax



Stock_Track   Variant - Inventory tracking enabled 
Stock_Disable_Sold_Out Variant - Inventory allow backorders 
Stock_Level Variant - Inventory level 
Stock_Alert  Variant - Inventory warning level
Stock_Min Variant - Inventory minimum 



Article_Code Variant - Article code
EAN  Variant - EAN 
SKU  Variant - SKU
Weight  Variant - Weight 
Volume  Variant - Volume 
Colli  Variant - Colli 
Size_X  Variant - Width (Size X) 
Size_Y Variant - Width (Size Y)
Size_Z Variant - Width (Size Z) 
Matrix  Matrix 



Data_01  Product - Data 01 
Data_02  Product - Data 02 
Data_03 Product - Data 03 



Varianten  
Buy_Min Variant - Minimum quantity
Buy_Max Variant - Maximum quantity



NL_Category_1 Product - Category 1 - English
NL_Category_2 Product - Category 2 - English
NL_Category_3 Product - Category 3 - English
NL_Meta_Title Product - Meta title - English 
NL_Meta_Description  Product - Meta description - English 
NL_Meta_Keywords  Product - Meta keywords - English



Afbeeldingen  
Images Product - images 
Tags Product - Tags