Versions Compared

Version Old Version 13 New Version 14
Changes made by

Sandra Petrovic

Sandra Petrovic

Saved on

Key

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

The system allows you to easily import your style information through excel or csv. See the steps below.

Template 1 - Importing All Style Information

We can import a number of fields in the system depending on what you require. Below is a list of fields available to be imported:

Style Information

  • Style#- Style Number - Mandatory Field

  • Description -  Style Description

  • Department - Level 1 of a product category e.g. Apparel, Fashion, Ladies, Mens etc.

  • Product Group - Level 2 of a product category e.g. Accessories, Bottoms, Outerwear

  • Product - Level 3 of a product category i.e. Skirt, Shorts, Jackets, Blazer, Coats

  • Fabric/Made From- The name of the fabric

  • Fabric Composition - e.g. 100% Cotton

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

  • Size Range- 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

...

  • Colour 1 - Mandatory 1 colour required and max is 35

  • Colour 2 

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

...

For more information on importing prices, see the Updating Buy, Wholesale & RRP Prices through Excel help doc.


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.

    • See importing per Style template below. Note that only size range is required, not the individual sizes. The GS1 barcode is not required either.

  • All Size Ranges and Product Categories must be entered into your system before importing, otherwise the import will not 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. 

...

  1. Once your file is formatted you are ready to import. To begin, go to the Product Search screen

     

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

  3. 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 - 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 - 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 choose to create a new line from the Style Importer. Follow the prompts on how to create the line.

  • 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. Remember that multiple Trading Entities cannot be updated at once, separate imports need to be done per Trading Entity.

...

  • Under Choose An Existing Template select Create New

  • Enter the name you wish to save your template under and select Save

  • Please ensure that you select Save in the bottom right hand corner also

  • When you need to use this template again you simply have to click on the drop down field under Choose an Existing Template and select your template name. It will then automatically populate the fields you saved against the 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.