The system lets you easily import style information via XLS or CSV. Follow the steps below.
Excel Spreadsheet Formatting
Before importing styles, 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
No negative values in the spreadsheet
The file must contain only one worksheet tab
Things to Consider Before Importing
You can choose to import either by Style or by SKU
Below is the Importing by SKU template, which includes Size Range, Size, and GS1 fields.
Below is the Importing per Style template. Only the Size Range is required—individual sizes and GS1 barcodes are not needed.
All Size Ranges and Product Categories must be set up in your system before importing; otherwise, the import will fail.
Step-by-step guide
Once your file is correctly formatted, you're ready to import.
To start, navigate to the Products screen
You'll find the Style Importer at the bottom of the Product Search screen.
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 a Template - Select a saved template or create a new one to 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 - Pick an existing line from the dropdown or create a new one if it doesn’t exist.
Select Buy Currency - Choose the currency if importing pricing, or leave blank if not.
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, simply drag your file 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.
6. Before importing you can specify whether you are importing per Style or by SKU. You can select this from the drop down located in the top right hand corner.
7. Once all the fields are matching correctly in the Field Matcher and you have entered in all required information you can now import your excel file. Do this by selecting the Import button at the bottom of the Style Importer.
8. Once the import is complete and has been successful you will see a screen similar to below:
9. To check that your styles have successfully imported you will need to refresh your line on the Products Screen and check the information that you imported.
Saving a Template
9. Creating a new template saves the fields that you have dragged across to the Field Matcher so that you can access it again and don’t have to re-drag your fields across each time you complete the import.
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
Pricing Data
Make Price
Buy Price
Wholesale Price
RRP Inc GST
Discount
Sale Price
Colour
Colour 1 - Mandatory 1 colour required and max is 35
Colour 2
Colour 3 etc.