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 ExcelExplanation
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 on 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.