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:
...
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 Productsscreen
You'll find the Style Importer at the bottom of the Product Search screen.
...
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 completing the fields on the left, simply just drag your file into theImport Fields section.
...
5. Once you drop After dropping your file into the Import Fields section, the column headings from the excel Excel file will appear. You then need to drag the excel fields one by one to the Drag each field to the Field Matcher and match each field it with the corresponding Indigo8 Import Field.
...
6. Before importing you can specify , choose whether you are 're importing per by Style or by SKU. You can select this from the drop down located SKU using the dropdown in the top right hand corner.
...
7. Once all the fields are matching correctly matched in the Field Matcher and you have entered in all required information you can now import your excel file. Do this by selecting required details are entered, click the Import button at the bottom of the Style Importer to proceed.
...
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 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 check review the information that you 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
...
Style Information
...
Style# - Style Number - Mandatory Field
...
Description - Style Description
...
To reuse this template, just select it from the Choose an Existing 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.
dropdown. The saved fields will auto-populate.
Style Details
Style# – Unique style number (Mandatory)
Description – Style name
Department – Top-level category (e.g. Apparel,
...
Mens, Ladies
...
)
Product
...
Group – Mid-level category (e.g.
...
Bottoms, Outerwear)
Product
...
– Specific type (e.g. Skirt,
...
Jackets)
Fabric/Made From
...
– Fabric name
Fabric
...
Composition – e.g. 100% Cotton
HTS Code
...
Size Range - Mandatory
...
– For importing/exporting
Other Details
Size Range – (Mandatory)
Season & Year – e.g. Summer
...
2023
Maker
...
– Supplier name
Division
...
Pattern #
...
– If multiple brands exist
Pattern#
Delivery Dates – From & To (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
...
Drop – Shipment batch
Weight – Product weight
Pricing
Make Price
Buy Price
Wholesale Price
RRP (Inc. GST)
Discount
Sale Price
...
Colours
Colour
...
Colour 2
...