With the "Styles" update - you can update some Style fields, Style Custom Fields, and Style Prices.



See how to Import and where to select the type of Import: HERE


DEFAULT COLUMNS IN THE EXCEL SHEET

The following columns are the default ones - with a description of where to find the data.


Headers in ExcelExplanation
Example of data
BRAND:  
The Style Brand name in the Style Header 
CONTACT PERSON:
The Designer company contact person’s email address. This can be found in Admin->Company Info
e.g: john.doe@acme.com
STYLE NAME:  
Style Name in the Style Header

STYLE NO:     
Style No in the Style Header

DESCRIPTION: 
Description in the Style Header

STATE: State in the Style Header
  • Delivered
  • Published
  • Unpublished
  • Deleted
  • WorkInProgress
  • Cancelled
SUPPLIER ID: Supplier ID can be found in Admin->Supplier under the respective Supplier company    

SUPPLIER NAME: 
Supplier company name in the Style Header

SEASON: 
Is the Season name in the Style Header. If your company uses Project, make sure you do not include the Project name

GROUP:   Group in the Style Header
CATEGORIES:Categories in the Style Header
EXTRA TEXT: 
Is only used if your company uses the Style name/number generator 



Please notice that the spelling of States has to be as listed. And please also remember at Unpublished can only happen if you are updating Deleted styles.



MANDATORY COLUMNS FOR DATA


These columns are mandatory to enter data in - if you don't do this - the import can not work.

  • Brand
  • Style Name
  • Style No
  • Season
  • Supplier ID - if it is on your style it's mandatory
  • Supplier name - if it is on your style it's mandatory


FIELDS THAT CAN BE UPDATED

With the update feature - it is possible to update the following fields:

  • Contact Person
  • Description
  • State
  • Group
  • Categories
  • Extra text - which will only have any effect if your company is using the Style name/number generator
  • Custom Fields
  • Prices


HOW TO UPDATE CUSTOM FIELDS

You can update any kind of Custom Field via the Update functionality.


The syntax for updating Custom Fields depends on what kind of Custom Field you want to update and what kind of data you have available.


For most Custom Fields you need to use the syntax CF:ID.


From the illustration above your syntax would be "CF:4711" in the header.

In the column, you will then enter the values you want for that Custom Field - say "11" since it is a Numeric one.



For Allowed Value Custom Fields (and Hierarchy Custom Fields) you can use two types of syntax.

The one just explained and one of type CFID:ID - let us look at two examples.


  • For the CF:ID your Column header would be "CF:12: and the value in the column would be "Yellow flag"
  • If instead you only have the Allowed ID to work with your syntax would be "CFID:12" in the header and in the column, you will then enter the ID - in this case, "3"
Any Custom Fields must be added to the right of the Columne "Extra text"


We advise that you do not use " " (space) in any of the IDs because it might cause problems if you have to integrate with your ERP system.


Format for your Custom Fields of type "Date"

The date you enter in your Excel sheet will have to keep a specific format - so that it matches the date format in Delogue PLM.


Your dates will have to be like: dd-mmm-yyyy (e.g. 01-jan-2022)


HOW TO UPDATE PRICES

You can update certain Prices via the Update functionality. 

It is Prices of these types.

  • Currency
  • Number
  • Percentage


You can not update Formula Price fields or Item Prices - they will be ignored in the update.


The syntax for updating Prices are: P:REF - where the REF  is the Ref ID from Admin->Prices

Any Prices must be added to the right of the Column "Extra text"