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.
- DEFAULT COLUMNS IN THE EXCEL SHEET
- MANDATORY COLUMNS FOR DATA
- FIELDS THAT CAN BE UPDATED
- WHAT WILL BE UPDATED
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 |
|
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.