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

Update Style Data Via Import

This article guides you through the steps to update and upload style data via the import function in Delogue

Introduction & Best Practice

The import feature allows you to update large volumes of style data by uploading Excel sheets. You can upload style data, any kind of custom field data, and certain price data in a single upload. Additionally, you can update style data with size information and color information, as well as custom fields set to 'per color' and 'per size'. This tool requires accurate, well-structured data. Carefully read each section’s instructions and review the guidelines before starting the import to avoid errors.

NOTE: To use this feature, your company must have the Professional license subscription

 

Table of Contents

 

Before You Start

1) Make sure the 'Import/Export' role is assigned to you as a user. To learn more about assigning different roles to a user, click here.

2) Remember not to change or delete any header information from the downloaded template files - otherwise the import will fail.

3) Follow the exact instructions about syntax when adding header information for custom field data.

 

 

Step-by-step Guide 

Style data import (incl. Custom Fields & Prices)


Navigate to: Admin > Import/Export > Import

  • Click the green 'Import' button
  • Select import type 'Styles'
  • Click 'Download Template File' 
  • Prepare Excel file - read more here
 
After you have prepared your Excel file navigate to: Admin > Import/Export > Import
  • Click the green 'Import' button
  • Select import type 'Styles'
  • Click 'Upload Excel File' 
  • Choose & upload the prepared Excel file
  • Set a check mark next to 'I am aware that import of data can not be undone'
  • Click 'Import'

  • Check whether the styles, custom fields, and prices have been successfully created

 

Prepare Excel File For Style Data Import 

Add Style Data to the downloaded template file

This is an example of how to fill out the Excel template to upload style data:
 
Screenshot 2025-06-18 at 15.58.47
  • Mandatory columns to fill out: Brand, Contact Person, Style Name, Supplier ID, Season (if defined in style header)
  • Under 'Contact Person' insert the contact person's email address found in: Admin > Company Info
 

NOTE: The spelling of States has to be according to the spelling in the platform. 
'Unpublished' can only be used to update deleted styles

 

Add Custom Field Data to the downloaded template file

When adding or updating custom fields through the import function make sure to create all necessary custom fields in Admin first - read how to create custom fields in Admin here.


This is an example of how to fill out the Excel template to upload style and custom field data:

Screenshot 2025-06-18 at 21.52.33

  • Mandatory columns to fill out: Brand, Contact Person, Style Name, Supplier ID, Season (if defined in style header)
  • Leave column 'Extra Text' blank
  • Add the header syntax 'CF:ID' for any custom field you want to add - e.g., 'CF:4711' and 'CF:12'. See below where to find the custom field ID information.

  • Add the custom field value under each header - e.g., ‘11’ as custom field '4711' is a numeric custom field and 'Yellow flag' as it is the choosen value from the allowed value custom field '12'.

  • In case you are filling out information for a date custom field, write the date in the following format: dd-mmm-yyyy - e.g., '01-jan-2022'

  • Save your file and upload it in Admin > Import/Export > Import

NOTE: Always add the header syntax for custom fields in the columns to the right of the ‘Extra Text’ header in your Excel file

 

To find the custom field ID information navigate to: Admin > Custom Fields > Styles

To find the custom field allowed value information navigate to: Admin > Custom Fields > Styles
  • Double click on the custom field 

  • View the available custom field values


Screenshot 2025-06-19 at 11.48.18-1

NOTE: We advise that you do not use spaces in any of the IDs because it might cause problems if you have to integrate it with your ERP system

 

Add Price Data to the downloaded template file

You can update the price types Currency, Number and Percentage via the import function. When adding or updating prices through the import function make sure to create all necessary prices in Admin first - read how to create prices in Admin here.

This is an example of how to fill out the Excel template to upload style, custom field and price data:

Screenshot 2025-06-18 at 22.01.22

  • Mandatory columns to fill out: Brand, Contact Person, Style Name, Supplier ID, Season (if defined in style header)
  • Leave column 'Extra Text' blank
  • Add the header syntax 'P:REF' for the price you want to update - e.g., 'P:B' as 'B' is the Ref ID from Admin. See below where to find the price reference ID information.

  • Add the price value under each header - e.g., ‘12’ as price 'B' is a currency price field

  • Save your file and upload it in Admin > Import/Export > Import

 

To find the price reference ID information navigate to: Admin > Prices > Calculation
 

 

NOTE: It is not possible to update Formula Price fields or Item Prices - they will be ignored in the update.

 

Style Size Data Import

Navigate to: Admin > Import/Export > Import

  • Create all necessary size ranges and size range sizes in Admin - read how to create size ranges in Admin here.
  • Click the green 'Import' button
  • Select import type 'Styles Sizes'
  • Click 'Download Template File' 
  • Prepare Excel file - read more here
 
After you have prepared your Excel file navigate to: Admin > Import/Export > Import
  • Click the green 'Import' button
  • Select import type 'Styles Sizes'
  • Click 'Upload Excel File' 
  • Choose & upload the prepared Excel file
  • Set a check mark next to 'I am aware that import of data can not be undone'
  • Click 'Import'
  • Check if the size ranges with all necessary size range sizes have been successfully added to your styles

 

Prepare Excel File For Style Size Data Import 

This is an example how to add a size range with multiple active size range sizes to a style:
 
Screenshot 2025-06-19 at 13.14.08

  • Fill out column: Brand, Style No, Season, Supplier ID
  • Add the size range ID - e.g., '11'
  • Fill out one row for each size range size - e.g., '50', '56', '62', '68', '74', '80', '86'
  • Under size name fill out the size that should be associated as grading size - e.g., '80'
  • In column 'Active' enter 'Active' for every row
  • Save your file and upload it in Admin > Import/Export > Import

Screenshot 2025-06-19 at 13.10.32-1

Screenshot 2025-06-19 at 13.10.46 
 
 

Style Colour Data Import

Navigate to: Admin > Import/Export > Import

Create all necessary colours in Admin – read how to create colours in Admin here.

  • Click the green ‘Import’ button

  • Select import type ‘Styles Colors’

  • Click ‘Download Template File’

  • Prepare Excel file – read more below

 

After you have prepared your Excel file, navigate to: Admin > Import/Export > Import

  • Click the green ‘Import’ button

  • Select import type 'Styles Colors'

  • Click 'Upload Excel File'

  • Choose & upload the prepared Excel file

  • Set a check mark next to 'I am aware that import of data cannot be undone'

  • Click 'Import'

  • Check if all colours variants have been successfully added to your styles

 

Prepare Excel File For Style Colour Data Import

This is an example of how to add a colour range with multiple active colour range colours to a style:

Screenshot 2025-06-19 at 15.42.37

  • Fill out column: Brand, Style No, Season, Supplier ID

  • Fill out the color range ID – e.g., '3200' and '1680'

  • Fill out color ID2 - only in case you are using color ID2

  • Fill out one row for each colour variant – e.g., 'Buttercup' and 'Coral'

  • In column 'Active' enter 'Active' for every row

  • Save your file and upload it in Admin > Import/Export > Import

 

 

Style Custom Field Per Colour Data Import

Create all necessary custom fields in Admin - make sure they are set to 'diff. per color'. Read how to create custom fields in Admin here.

Navigate to: Admin > Import/Export > Import

  • Click the green 'Import' button
  • Select import type 'Style Custom Field Per Color'
  • Click 'Download Template File' 
  • Prepare Excel file - read more here
 
After you have prepared your Excel file navigate to: Admin > Import/Export > Import
  • Click the green 'Import' button
  • Select import type 'Style Custom Field Per Color'
  • Click 'Upload Excel File' 
  • Choose & upload the prepared Excel file
  • Set a check mark next to 'I am aware that import of data can not be undone'
  • Click 'Import'
  • Check if all custom field information has been successfully added to custom fields per color on your styles

Prepare Excel File for Style Custom Field Per Colour import

This is an example of how to add custom field information per colour to a style:
 
Screenshot 2025-06-19 at 09.29.24
  • Fill out column: Brand, Style Name, Style No, Season, Supplier ID, Color ID, (Color ID2 only in case you are using ID2)
  • Add the header syntax 'CF:ID' - e.g., 'CF:02' and 'CF:03'. You can read more about how to add custom field data to your import Excel file here.

  • Add custom field values to each row — e.g., ‘description a’ for color 1 for custom field '02', and ‘CAK’ for custom field '03'.

  • Set a check mark next to 'I am aware that import of data can not be undone'
  • Click 'Import'
  • Save your file and upload it in Admin > Import/Export > Import

 

Style Custom Field Per Size Data Import

Create all necessary custom fields in Admin - make sure they are set to 'diff. per size'. 
Read how to create Custom Fields in Admin here.

Navigate to: Admin > Import/Export > Import

  • Click the green 'Import' button
  • Select import type 'Style Custom Field Per Size'
  • Click 'Download Template File' 
  • Prepare Excel file - read more here
 
After you have prepared your Excel file navigate to: Admin > Import/Export > Import
  • Click the green 'Import' button
  • Select import type 'Style Custom Field Per Size'
  • Click 'Upload Excel File'
  • Choose & upload the prepared Excel file
  • Set check mark next to 'I am aware that import of data can not be undone'
  • Click 'Import'
  • Check if all custom field information has been successfully added to custom fields per size on your styles

Prepare Excel File for Style Custom Field Per Size import

 
This is an example of how to add custom field information per size to a style:
 
Screenshot 2025-06-19 at 10.10.31
  • Fill out column: Brand, Style Name, Style No, Season, Supplier ID
  • Add the header syntax 'CF:ID' - e.g., 'CF:100' and 'CF:106' You can read more about how to add custom field data to your import Excel file here.

  • Add custom field values to each row — e.g., ‘Amazon’ for size 1 for custom field '100', and ‘Fit-Specific-Style’ for custom field '106'

  • Save your file and upload it in Admin > Import/Export > Import

Next steps

Introduction - Update Data Via Import