Skip to content
More support
  • There are no suggestions because the search field is empty.

Export Your Style Custom Report To Excel (Or CSV)

 

EXPORT TO EXCEL


Once you have created your Custom Report - you can export it to Excel.


You do this by clicking on the Excel icon in the top right corner.

NOTE: If you have more than 200 rows in the exported file, then the Style logo (images) will not be included. 

NOTE: Supplier users can only export data they have access to.





Now you get the choice of exporting on 3 levels:


  1. The Style is printing one line per style only
  2. The style/color is printing the same style multiple times - one per color
  3. The style/color/size is printing all the variants - the combinations of color and size in different lines. Here you can select to include SKU/Barcodes in the export.

INCLUDE COLOR GROUP

It is possible for you to include the Color group in your export.


You can select this in the Style/Color option and in the Style/color/size option.

GROUP BY STYLE

You can select to make an export where your data is grouped per style.

Then in your excel file, you will get one row pr style - but if you have data that is differentiated by color these cells will be split per color.


E.g. like where prices and a custom field are listed with their differentiated data


You can select this in the Style/Color option and in the Style/color/size option .

Please notice:

This will only be visible in the exported Excel file.


INCLUDE SKU/BARCODES & ASSORTMENTS' BARCODES

If you use SKUs and Barcodes you can export these in the third option Style/color/size.

Please notice:

You can not see the SKUs or Barcodes on your screen in the Custom Report - they are only in the export.

 

This export will also include any Barcodes for Assortment you have.

OVERWRITE WITH FUTURE PRICES

It is important to notice that Future Price can only be included in the Excel export.

In the Excel pop-up select "Overwrite with Future Price"

Now select a date where you want to see Future Prices.

The generated Excel file will include Future Prices for dates that are before the selected date you typed in.

INCLUDE IDs

For all 3 export options, you can include IDs

These are the Brand ID, Season ID, Style Category ID, Group ID, and Custom Fields IDs - for Allowed Values Custom Fields.

INCLUDE CARE INSTRUCTION OUTPUT

Remember:

Make sure you have set up Care Instruction Outputs.
And make sure you have marked at least one to be used in Custom Reports.


You have to have set up your Care Instruction output first.



Make sure to set a checkmark in the option for Care Instructions.


  • If your output contains Icons - it will only contain text - no images.
  • Sub-tabs - if you use sub-tabs these will be in the export. And they will only be per color if you use one of the export options that export per color.
  • Exceptions will not be exported.

EXPORT YOUR SAMPLE REQUESTS 

It is important to notice:

Sample Request data will only be exported in the first Excel export option.



HOW TO GET YOUR FILE

  • Report exports will be delivered directly to your email

EXPORT TO CSV


You can also export your Custom Report to CSV format - if you need that instead.

Just click on the CSV export icon right next to the Excel export button.

Your CSV file will be delivered directly to your email.

NOTE: The .csv export is no longer maintained. Therefore it might not reflect all columns you see on your screen.