Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The system allows you to 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 need.
Generally we recommend the following templates.

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


Updating Prices 

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 Added

Importing per Style or SKU

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

Image Added


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

Image Added



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


Go to Product Search screen

 

...

3. Once all basic details have been field you need to think about if you are importing per STYLE or per SKYSKU.
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 Added







Filter by label (Content by label)
showLabelsfalse
max5
spacesCL
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "CL"
labelskb-how-to-article

...