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.

Table of Contents

• Mapping of fields in Delogue PLM and SPY system

• Before you start importing into SPY system
• Setup in Delogue PLM
• Setup Custom report for SPY Export
• This is how it looks in SPY after the import

Mapping of fields in Delogue PLM and SPY system

Delogue PLM field name	SPY field name	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 deliveries per 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 Only YES/NO values allowed	NOOS	YES / NO	NO	-
Custom field - Allowed value*	Assortment Template*	text	NO	-	Make sure the selected assortment table fits with the size range
Custom field - Allowed value	FEDAS	text	NO	-
Custom field - Allowed value	Designer	text	NO	-

---

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

Measurement chart - Size range

Custom fields:

---

Setup Custom report for SPY Export

Create new report

1) Select at least one brand and season.
 

2) Select relevant style data fields and custom fields:

 

 

3) Use Drag n' drop to sort the order to match the order of columns in SPY import file: 

 

4) Select export report to Excel:

 

 

5) Select style/color:

 

 

6) When you open the Excel export file, then delete column C: Style color ID 

 

7) Copy the lines excluding the header:

 

9) 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: