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 |
