Update data via Import
      Back to home
      1. Knowledge base
      2. Export & Import
      3. 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.