Update data via Import

Style Size data update via import

This update is used to set the size range and what sizes are active for the Style. 

You can either use the Size ID or the Size Name to define what size should be active or not.



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 Style Brand name in the Style Header  
STYLE NAME:   Style Name in the Style Header  
STYLE NO:    Style No in the Style Header  
SEASON:   Is the Season name in the Style Header. If your company uses Project, make sure you do not include the Project name   
SUPPLIER ID:  Supplier ID can be found in Admin->Supplier under the respective Supplier company      
SIZE RANGE ID: The Size Range ID can be found in Admin->Sizes (see illustration below  
SIZE ID: Size ID can be found in Admin->Sizes on the pop-up that you see when you click on the Size ID button  
SIZE NAME: Size Name can be found in Admin->Sizes on the pop-up that you see when you click on the Size ID button  
ACTIVE: Is the check-mark for each Size on the Style's Measurement Chart
  1. Active
  2. Inactive

 

How to find the Size Range ID, Size ID, and Size Name in Admin->Sizes



MANDATORY COLUMNS FOR DATA


These columns are mandatory to enter data in - if you don't do this - the import can not work.

  • Brand
  • Style Name
  • Style No
  • Season
  • Supplier ID - if it is in your style it's mandatory

FIELDS THAT CAN BE UPDATED

With the update import - it is possible to update the following fields:

  • Size Range ID
  • Size ID
  • Size Name
  • Active

WHAT WILL BE UPDATED

When you update you will need to add both the Size Range ID and either the Size ID or Size Name.


It is not possible to just set the size range on a Style - you will need to set at least one of the sizes too.


If you need to set multiple Sizes to active or inactive you will need to add one row per size to your Excel sheet.