The system allows you to easily import your style information through excel or csv. Below details how you can do this. 

Step-by-step guide

1. Before importing any styles, you will need to format an excel spreadsheet. Contact an Indigo8 Rep if you need help to confirm the fields that you needSee the steps below.

Template 1 - Importing All Style

...

Information

We can import a number of fields in the system . You can be as detailed as required or as high level as you wantdepending on what you require. Below is a list of fields available to be imported:

Style InfoInformation

• Style#- Style Number - Mandatory

   

  Field

• Description -

   (style name)Department (

   Style Description

• Department - Level 1 of a product category

  ) usually gender 

  e.g. Apparel, Fashion, Ladies, Mens etc.

• Product Group 

  (

  - Level 2 of a product category

  ) usually fashion, accessorries

  e.g. Accessories, Bottoms, Outerwear

• Product

  (

  - Level 3 of a product category

  ) usually tops, dresses, knits 

  i.e. Skirt, Shorts, Jackets, Blazer, Coats

• Fabric/Made From

  (the 

  - The name of the fabric

  )

• Fabric

  Composition (for example 100% cotton)HTS Code

  Composition - e.g. 100% Cotton

• HTS Code - HS Code is used when importing and exporting goods

• Size Range- 

  Mandatory 

  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 

  required and max is 35

• Colour 2 

• Colour 3

  .. max number of colours is 35. 

  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. 

...

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

• The percentage and the negative can’t be on the spreadsheet

Things to Consider Before Importing

• You have the option to import by Style or by SKU.

  • See importing by SKU template below. It includes size range, size and GS1 fields

...

• • .

    Image Modified

...

• • See importing per

...

• • Style template below. Note that only size range is

...

Image Removed

Please note:

• All size ranges, product categories must be entered in the

  • required, not the individual sizes. The GS1 barcode is not required either.

    Image Added

• All Size Ranges and Product Categories must be entered into your system before importing, otherwise the

  sizes

  import will not

  import
• Ensure that your file is excel or csv
• Ensure that you have the column headers in row 1

...

• 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. 

Step-by-step guide

1. Once your file is formatted you are ready to import.

...

1. To begin, go to the Product Search screen
   
   Image Modified 
   

...

1. Style Importer is located down the bottom of the Product Search screen. Once you click the Style Importer button, it will open in a new window.
   

   Image Added

2. Before dragging your file across you need to complete the fields located on the left hand side of the Style Importer.

...

• Choose an existing template

  : This allows you to save the fields into a template. Will explain this function at the bottom of the manual.Choose Supplier: This is the maker/manufacturing of the goods. If the maker is not in your system you can add them on the fly by clicking Add New Supplier. 

  - Here you can select from a pre-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 Importer. Instructions for creating your own template are listed at the end of this help doc.

• Add Styles to a Line

  : Select the line in which the styles should belong to. If

  - You can add the styles to an exisiting collection by selecting the line from the drop down or if the line is not yet created in the system you can

  also add this on fly by clicking Create New Line. 

  choose to create a new line from the Style Importer. Follow the prompts on how to create the line

  . Once that is done you can continue to import your products

  .

• 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 field.

• 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

  
  Please note: 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. 
• Update Existing Styles: This function allows you to UPDATE ONLY the PRICES and COLORS based on your excel file. 

Image Removed

4. Drag your formatted file under "IMPORT FIELDS"  you will see all the fields from your excel file appearing. 

...

• . Remember that multiple Trading Entities cannot be updated at once, separate imports need to be done per Trading Entity.

...

4. Once you have completed the fields on the left hand side you can then drag your file to the Import Fields.

...

5. Drag your fields under the "FIELD MATCHER" column one by one.

...

This essentially tells you that for the excel column called WHOLESALE that we will be inserting that into the Indigo8 field called Wholesale Price. Image Removed

...

6. Once all the fields are matching up correctly click the Import button 

...

In the future all that you need to do is select the template and it should be appearing for you on the drop down.Image Removed

...

1. Essentially the idea is to drag your file into the "Import Fields" column and then to match those fields with the "Indigo8 Import Fields".