Update data via Import

Item Size data update via Import

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 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
  • 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.