How to set up data in Delogue PLM for SPY system import

In "SPY system" it is possible to import (and maintain some) style data exported from Delogue PLM via Excel.

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

Please note: this set-up requires the PRO license to Delouge PLM

Mapping of fields in Delogue PLM and SPY system

All fields marked with * are mandatory for the 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 set up 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 PLM

Item list - Add colors

Note that colors imported into SPY need 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 the 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.