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.



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 ExcelExplanation
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
  • Approved
  • NotApproved
ACTIVE:Is the Active field under Item->Sizes per Size/Weight
  • Active
  • Inactive



MANDATORY COLUMNS FOR DATA


The following columns are mandatory to provide data in - otherwise, the import will not work:

  • Brand
  • 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:

  • Size
  • Status
  • Approved


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.