The system allows you to easily import your style information through xls or csv. See The system lets you easily import style information via XLS or CSV. Follow the steps below.
Excel Spreadsheet Formatting
Before importing any styles, you will need to format an excel spreadsheet.
...
The system allows you to import your style information through xls or csv
...
Make sure there is NO blank row at the top and that the column headers are in row 1
...
The filters need to be removed
...
The discount column needs to be a percentage number eg. 30 or %30 not $30
...
ensure your Excel spreadsheet is properly formatted:
The system supports XLS or CSV files only
Make sure No blank rows at the top; column headers must be in row 1
Remove all filters before importing
The discount column should be a percentage (e.g., 30 or 30%, not $30)
The price field cannot be 0.00
The negative can’t be on No negative values in the spreadsheet
There can only be 1 The file must contain only one worksheet tab on the excel
Things to Consider Before Importing
You have the option can choose to import either by Style or by SKU.
See importingBelow is the Importing by SKU template below. It includes size range, size , which includes Size Range, Size, and GS1 fields.
See importing 
Below is the Importing per Style template below. Note that only size range is required, not the individual sizes. The GS1 barcode is not required either.
. Only the Size Range is required—individual sizes and GS1 barcodes are not needed.
All Size Ranges and Product Categories must be entered into set up in your system before importing; otherwise, otherwise the import will not be successful.
If you are wanting to update pricing for multiple trading entities you will need to do seperate imports. For example if you want to import AUD pricing and USD pricing, you will need to import your file twice. fail.
Step-by-step guide
Once your file is correctly formatted, you are 're ready to import.
To beginstart, go navigate to the Product Search Productsscreen
You'll find the Style Importer is located down at the bottom of the Product Search screen. Once you click
Click the Style Importer button, and it will open in a new window
...
...
Before dragging in your file
...
, complete the fields
...
on the left
...
of the Style Importer
...
:
Choose an existing template - Here you can select from a pre-a Template - Select a saved template or you can create a new one . A template saves the fields so that you don’t have to match them each time you use the Style Importerto avoid re-matching fields each time.Instructions for creating your own template are listed at the end of this help doc.
Add Styles to a Line - You can add the styles to an exisiting collection by selecting the Pick an existing line from the drop down or if the line is not yet created in the system you can choose to create a new line from the Style Importer. Follow the prompts on how to create the linedropdown or create a new one if it doesn’t exist.
Select Buy Currency -If you are importing/updating pricing you can select the buy currency of the products on the excel file. Otherwise you can leave this blank if you are not importing this fieldChoose the currency if importing pricing, or leave blank if not.
Trading Entity - Similar to Buy Currency, if your importing/updating pricing information select the trading entity you are wanting to import/update. Otherwise you can leave this blank if you are not importing this field. Remember that multiple Trading Entities cannot be updated at once, separate imports need to be done per Trading Entity.
...
...
Select if updating pricing; otherwise, leave blank. Each Trading Entity must be imported separately
...
4. After filling out the fields on the left hand side you can then , simply drag your file to into the Import Fields section.
...
5. Once you drop your file into the Import Fields section the column headings from the excel will appear. You then need to drag the excel fields one by one to the Field Matcher and match each field with the corresponding Indigo8 Import Field.
...
Under Choose An Existing Template select Create New
Enter the name you wish to save your template under and select Save
Please ensure that you select Save in the bottom right hand corner also
When you need to use this template again you simply have to click on the drop down field under Choose an Existing Template and select your template name. It will then automatically populate the fields you saved against the template.
Keep in mind that if the the column headings on your excel don’t match the fields on your template then it won’t allow you to import.
...
Style Information
Style# - Style Number - Mandatory Field
Description - Style Description
Department - Level 1 of a product category e.g. Apparel, Fashion, Ladies, Mens etc.
Product Group - Level 2 of a product category e.g. Accessories, Bottoms, Outerwear
Product - Level 3 of a product category i.e. Skirt, Shorts, Jackets, Blazer, Coats
Fabric/Made From - The name of the fabric
Fabric Composition - e.g. 100% Cotton
HTS Code - HS Code is used when importing and exporting goods
Size Range - Mandatory
Season - e.g. Summer, Winter
Year - e.g. 2023
Maker - This is the Supplier
Division - If you have more than one brand
Pattern #
Del from date (must be dd/mm/yy)
Del to date (must be dd/mm/yy)
Drop - What shipment the style is arriving in
Weight - This is the weight of the product
...