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.
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 want. Below is a list of fields available to be imported:
Style Info
- Style# - Mandatory
- Description - (style name)
- Department (Level 1 of a product category) usually gender
- Product Group (Level 2 of a product category) usually fashion, accessorries
- Product (Level 3 of a product category) usually tops, dresses, knits
- Fabric/Made From (the name of the fabric)
- Fabric Composition (for example 100% cotton)
- HTS Code
- Size Range - Mandatory
- Season
- Year
- Maker
- Division
- Pattern #
- Del from date (must be dd/mm/yy)
- Del to date (must be dd/mm/yy)
- Drop
- Weight
Pricing Data
- Make Price
- Buy Price
- Wholesale Price
- RRP Inc GST
- Discount
- Sale Price
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.
Don't forget - Importing per Style or SKU
Template for importing per SKU. Note size range, size and GS1 fields are present
Template for importing per STYLE. Note size range is the only field that is different compared to "template for SKU"
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.
Go to Product Search screen
3. In the bottom left corner click Style Importer and the below screen should appear. Essentially the idea is to drag your file into the "Import Fields" column and then to match those fields with the "Indigo8 Import Fields".
Firstly, you need to select the items on the left hand side.
- 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.
4. Drag your formatted file under "IMPORT FIELDS" you will see all the fields from your excel file appearing.
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.
