Create the product import template for each venue. Make sure all the cell formats are correct according to reseller manual. Otherwise it will create loads of products without any product names. (then we need to use sql queries to delete all of invalid products)
Create the product info report from the back office and add all the additional columns like size name 1,2,3,4 normal size 1,2,3,4 supplier, Store name, Barcode, etc. so it will be easy to copy paste all the product template information.
On the template adding the GROUP_NAME and GROUP_PARENTNAME will create groups for each product and it will put all those groups into pre-defined Larger groups when you are importing them to the new system. This will help us to organize the products spending less amount of time.
Enter all the barcode under “BK” BARCODE1 Column.
Supplier column will add all the suppliers to the system but the system will not assign any suppliers to the products.
When importing products from different venues to main server make sure not to add the product IDs on the template. Coz it will overwrite existing product’s sizes and prices.
Before importing the template make sure all the venues and pricing stores setup under main server. If not, it will import all the products under one venue and you won’t be able to change the pricing store after the import task.
During the product import the system is assigning new product IDs for all the products that getting from the product import template.
