Style Importer
The system lets you easily import style information via XLS or CSV.
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 completing the fields on the left, just drag your file into the Import Fields section
5. After dropping your file into the Import Fields section, the column headings from the Excel file will appear. Drag each field to the Field Matcher and match it with the corresponding Indigo8 Import Field.
6. Before importing, choose whether you're importing by Style or SKU using the dropdown in the top right corner.
7. Once all fields are correctly matched in the Field Matcher and required details are entered, click the Import button at the bottom of the Style Importer to proceed.
8. After a successful import, a confirmation screen will appear similar to the example below.
To verify a successful import, refresh your line on the Products Screen and review the imported details.
Saving a Template
Creating a new template saves your matched fields in the Field Matcher, so you won’t need to reassign them each time you import.
Under "Choose An Existing Template," select Create New
Enter your desired template name and click Save.
Make sure to click Save in the bottom right corner as well
To reuse this template, just select it from the Choose an Existing Template dropdown. The saved fields will auto-populate.
Style Details | Other Details | Pricing | Colours |
---|---|---|---|
Style# – Unique style number (Mandatory) | Size Range – (Mandatory) | Make Price | Colour 1 – (Mandatory) |
Description – Style name | Season & Year – e.g. Summer 2023 | Buy Price | can add maximum of 35 color |
Department – Top-level category (e.g. Apparel, Mens, Ladies) | Maker – Supplier name | Wholesale Price |
|
Product Group – Mid-level category (e.g. Bottoms, Outerwear) | Division – If multiple brands exist | RRP (Inc. GST) |
|
Product – Specific type (e.g. Skirt, Jackets) | Pattern# | Discount |
|
Fabric/Made From – Fabric name | Delivery Dates – From & To (dd/mm/yy) | Sale Price |
|
Fabric Composition – e.g. 100% Cotton | Drop – Shipment batch |
|
|
HTS Code – For importing/exporting | Weight – Product weight |
|
|