In  SPY system it is possible to import (and maintain some) style data from an Excel-file.


To ease your data import it is a good idea to align the data structure you have in Delogue PLM with the data structure you have in SPY system.


Mapping of fields in Delogue PLM and SPY system

All fields marked with * are mandatory for the import.

UPDATE = By importing the style number again, if yes then you are able to update the data. If no, then the data will not be updated by making new import.

ADD = If yes, then you can add additional data by making a new import.


Delogue PLM field name

SPY import HEADER

INPUT TYPE

UPDATE

ADD

COMMENT

Style number

Style No.*

text

NO

-


Style name

Style Name*

text

YES

-


Size range

Sizeset*

text

NO

-

Sizeset and Assortment Template are related.

Season

Season*

text

NO  

YES


Custom field - Allowed value, Multiple values allowed

Deliveries*

text

NO  

YES

Multiple del. Pr line = Jan, Feb

Country of origin

Country of Origin

text

YES

-


Brand

Brand*

text

YES

-


Custom field - Numeric

Weight (g)

text

YES

-


Custom field - Allowed value

Quality

text

YES

-


Custom field - Allowed value

Customs Tariff

text

YES

-


Group, Style Category or Custom field - Allowed value

Type

text

YES

-


Group, Style Category or Custom field - Allowed value

Category

text

YES

-


Custom field - Allowed value

Gender

text

YES

-


Color name

Color*

text

NO

YES


Custom field - Allowed value

Sub-Brand

text

YES

-


Supplier name

Supplier

text

YES

-


Custom field - text field

Dimension

text

YES

-


Description or Custom field - text box (for long text)

Description

text

YES

-


Custom field - Allowed value

NOOS

YES / NO

NO

-


Custom field - Allowed value

Assortment Template*

text

NO

-

Make sure the selected assortment table fits with the size range


Before you start importing into SPY system

Make sure that, once you setup your account:

  1. Size set* in SPY system is created and name has the same name as Size range in Delogue PLM.
  2. Brand* in SPY system is created and name has the same name as Brand in Delogue PLM.
  3. Customs Tariff in SPY system is created and name has the same name as  Allowed values - Custom fields in Delogue PLM.
  4. Type in SPY system is created and name has the same name as Group or Allowed values - Custom Field in Delogue PLM.
  5. Category in SPY system is created and name has the same name as Style Category or Allowed values - Custom Field in Delogue PLM.
  6. Gender in SPY system is created and name has the same name as Allowed values - Custom Field in Delogue PLM.
  7. Sub-Brand in SPY system is created and name has the same name as Allowed values - Custom Field in Delogue PLM.
  8. Assortment table* in SPY system is created and name has the same name as Allowed values - Custom Field in Delogue PLM.


Make sure that, before every import:

  1. Season name* in SPY system is created and has the same name as Season in Delogue PLM.
    1. Deliveries* in SPY system are created and has the same name as the Allowed values in Custom fields in Delogue PLM.
  2. Quality in SPY system is created and name has the same name as  Allowed values in Custom fields in Delogue PLM.
  3. Color name in SPY system is created and name has the same name as Color Name in Delogue PLM.
  4. Supplier in SPY system is created and name has the same name as Supplier name in Delogue PLM.


Setup in Delogue


Item list - Add colors

Note that colors imported into SPY needs to be updated in SPY in case of "inactive" status.


Measurement chart - Size range

Note that inactive colors will have no impact on this import.


Custom fields:

Note that you can use Custom field per color to handle different deliveries per color.


Setup Custom report for SPY Export

Create new report

Select at least one brand and season.

Make sure to select "All styles"


Select relevant style data:


Select relevant custom fields:


Sort the order to match order of columns in SPY import file:


Select export report to Excel:


Select style/color:


When you open the Excel export file, then delete 2nd column: Style color ID


Copy the lines excluding the header:

And paste it into the Import file for SPY system:



This is how it looks in SPY after the import:

Style > Basic Information:

Style > Materials:



Note:

Follow the STYLE IMPORT GUIDE provided by SPY system to import the file.

Before making your first import, we recommend that you reach out to both Delogue PLM and SPY system.

And start with testing import of 1 style only, before uploading more styles.