The system allows lets you to easily import your style information through excel or csv. See the steps below.
Template 1 - Importing All Style Information
We can import a number of fields in the system depending on what you require. Below is a list of fields available to be imported:
Style Information
...
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 Composition - e.g. 100% Cotton
...
HTS Code - HS Code is used when importing and exporting goods
...
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.
Template 2 - ONLY Updating Prices
The only mandatory fields needed are Style Number & any of the price fields.
If you want to only update buy price, then you will only require Style Number & buy price on your excel file.
It’s important to only display the values that you need on the excel report.
...
information via XLS or CSV.
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 excel 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 number eg. 30 not $30
...
The price field can't be 0.00 and can't include $ format
...
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 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 completing the fields on the left hand side you can then , just drag your file to into theImport Fields. section
...
5. Drag your fields under the "FIELD MATCHER" column one by one.
Then you need to try and match up the fields with the fields under "INDIGO8 IMPORT FIELDS".
This essentially tells you that for the excel column called WHOLESALE that we will be inserting that into the Indigo8 field called Wholesale Price.
...
6. Once all the fields are matching up correctly click the Import button
...
7. Give it a few moments and you should get a similar screen to the below and you're done.
...
You will then need to refresh your line to check that your information has been imported correctly or if your prices have been updated correctly (if that is the option you have selected).
8. As a last step you can save the fields that you have dragged across as a template so that next time you don't need to do not need to re-drag your fields across again.
Under Choose An Existing Template select Create New
...
Then enter the template name and click Save
...
Please ensure that you click Save on the bottom right corner as well.
...
In the future all that you need to do is select the template and it should be appearing for you on the drop down.
...
Essentially the idea is to drag your file into the "Import Fields" column and then to match those fields with the "Indigo8 Import Fields".
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| hidden | true |
|---|
...
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," selectCreate 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 |