This will update the item sizes and give it a status whether it is approved or not and set the size to active or inactive.
- DEFAULT COLUMNS IN THE EXCEL SHEET
- MANDATORY COLUMNS FOR DATA
- FIELDS THAT CAN BE UPDATED
- UPDATING OR ADDING
See how to Import and where to select the type of Import: HERE
DEFAULT COLUMNS IN THE EXCEL SHEET
The following columns are the default ones - with a description of where to find the data.
|Headers in Excel||Explanation||Example of data|
|BRAND: ||The Item Brand name in the Item Header |
|ITEM NAME: ||Item Name in the Item Header |
|ITEM NO: ||Item No in the Item Header |
|SUPPLIER ID:||Supplier ID can be found in Admin->Supplier under the respective Supplier company |
|SIZE:||Are the Size/Weight rows under Item->Sizes|
|APPROVED:||Is the Approved field under Item->Sizes per Size/Weight|
|ACTIVE:||Is the Active field under Item->Sizes per Size/Weight|
MANDATORY COLUMNS FOR DATA
The following columns are mandatory to provide data in - otherwise, the import will not work:
- Item name
- Item No
- Supplier ID - if it is on your item it's mandatory
FIELDS THAT CAN BE UPDATED
With the update you can update the following fields:
UPDATING OR ADDING
For the "Size" column you can either Update the size row or if the value for a "Size" is not on your Item it will be created.
If you need to update several Sizes - you will need to add a line for each in your Excel sheet.
The same goes if you want to add several new Sizes - you will have to add a line for each in your Excel sheet.