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

Step-by-step guide

...

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

Style Info

• Style# - Mandatory 
• Description 
• Sub-Category
• Fabric/Made From
• HTS Code
• Size Range - Mandatory 
• Season
• Year
• Maker
• Division
• Pattern #

Pricing Data

• Make Price 
• Buy Price
• Wholesale Price
• RRP Inc GST
• Discount
• Sale PriceCol

Colour

• Colour 1 - Mandatory 1 colour required 
• Colour 2 
• Colour 3 .. max number of colours is 35. 

Template 2 - Updating Prices (if you want to update prices only)

The only mandatory fields needed are Style # & any of the price fields. If you want to only update buy price, then you will only require Style # & buy price on your excel file. Only display the values that you need on the excel report. 

Image Removed

...

Template for importing per SKU. Note size range, size and GS1 fields are present

Image Removed

Template for importing per STYLE. Note size range is the only field that is different compared to "template for SKU"

Image Removed

Please note:

• All size ranges, product categories must be entered in the system before importing, otherwise the sizes will not import
• Ensure that your file is excel or csv
• Ensure that you have the column headers in row 1

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

...

• 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. 
• Add Styles to a Line: Select the line in which the styles should belong to. If the line is not yet created in the system you can also add this on fly by clicking Create New Line. 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. Once all basic details have been field you need to think about if you are importing per STYLE or per SKU.
Per SKU refers to every line item including colour & size. Normally you would select this option if you are importing GS1 barcodes at the same time. 
Depending on your situation please select the relevant option.

Image Removed

...

...

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.

    Image Added

  • Below is the Importing per Style template. Only the Size Range is required—individual sizes and GS1 barcodes are not needed.

    Image Added

• All Size Ranges and Product Categories must be set up in your system before importing; otherwise, the import will fail.
  

Step-by-step guide

1. Once your file is correctly formatted, you're ready to import.

   To start, navigate to the Productsscreen

   Image Added

   
    
   

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

...

3. 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 theImport 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.

1. Under "Choose An Existing Template," selectCreate New

2. Enter your desired template name and click Save.

3. Make sure to click Save in the bottom right corner as well

   Image Added

To reuse this template, just select it from the Choose an Existing Template dropdown. The saved fields will auto-populate.