Below you will find the field mapping for each data point:
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**STYLE FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
2
</td>
<td style={{ textAlign: "left" }}>
Style Name
</td>
<td style={{ textAlign: "left" }}>
style\_name
</td>
<td style={{ textAlign: "left" }}>
Product :: Title
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
3
</td>
<td style={{ textAlign: "left" }}>
Style Number
</td>
<td style={{ textAlign: "left" }}>
style\_number
</td>
<td style={{ textAlign: "left" }}>
Product :: Technical ID
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
4
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
style\_identifier
</td>
<td style={{ textAlign: "left" }}>
Product :: Technical ID
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available, can also be managed in JOOR
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
5
</td>
<td style={{ textAlign: "left" }}>
Description
</td>
<td style={{ textAlign: "left" }}>
style\_description
</td>
<td style={{ textAlign: "left" }}>
Product :: Description
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
6
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
made\_to\_order
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
7
</td>
<td style={{ textAlign: "left" }}>
Division
</td>
<td style={{ textAlign: "left" }}>
division
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
8
</td>
<td style={{ textAlign: "left" }}>
Division
</td>
<td style={{ textAlign: "left" }}>
division\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
9
</td>
<td style={{ textAlign: "left" }}>
Country of Origin
</td>
<td style={{ textAlign: "left" }}>
style\_country\_origin
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
10
</td>
<td style={{ textAlign: "left" }}>
Fabrication
</td>
<td style={{ textAlign: "left" }}>
fabrication
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
11
</td>
<td style={{ textAlign: "left" }}>
Fabrication
</td>
<td style={{ textAlign: "left" }}>
fabrication\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
12
</td>
<td style={{ textAlign: "left" }}>
Measurements
</td>
<td style={{ textAlign: "left" }}>
measurements
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
13
</td>
<td style={{ textAlign: "left" }}>
Silhouette
</td>
<td style={{ textAlign: "left" }}>
silhouette
</td>
<td style={{ textAlign: "left" }}>
Product :: Product Type
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
14
</td>
<td style={{ textAlign: "left" }}>
Silhouette
</td>
<td style={{ textAlign: "left" }}>
silhouette\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
15
</td>
<td style={{ textAlign: "left" }}>
Source of Materials
</td>
<td style={{ textAlign: "left" }}>
source\_of\_materials
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
16
</td>
<td style={{ textAlign: "left" }}>
Heel Height
</td>
<td style={{ textAlign: "left" }}>
heel\_height
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
17
</td>
<td style={{ textAlign: "left" }}>
Contains Fur?
</td>
<td style={{ textAlign: "left" }}>
contains\_fur
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
18
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
delivery\_overwrite
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
19
</td>
<td style={{ textAlign: "left" }}>
Minimum Order Quantity
</td>
<td style={{ textAlign: "left" }}>
minimum
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
20
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**CATEGORIES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
21
</td>
<td style={{ textAlign: "left" }}>
Category
</td>
<td style={{ textAlign: "left" }}>
category\_id
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
A default category for all synced styles can be set (see [Styles, Images, and Linesheets - Shopify](doc:styles-images-and-linesheets-shopify))
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
22
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**MATERIALS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
23
</td>
<td style={{ textAlign: "left" }}>
Material
</td>
<td style={{ textAlign: "left" }}>
material
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Material (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
24
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**PRICES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
25
</td>
<td style={{ textAlign: "left" }}>
Currency/Price Label
</td>
<td style={{ textAlign: "left" }}>
price\_label
</td>
<td style={{ textAlign: "left" }}>
Integrations Settings :: Price Label (default is blank)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
26
</td>
<td style={{ textAlign: "left" }}>
Currency/Price Label
</td>
<td style={{ textAlign: "left" }}>
price\_currency
</td>
<td style={{ textAlign: "left" }}>
Integrations Settings :: Price Currency (default is $)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
27
</td>
<td style={{ textAlign: "left" }}>
Wholesale
</td>
<td style={{ textAlign: "left" }}>
price\_wholesale
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available, can also be managed in JOOR
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
28
</td>
<td style={{ textAlign: "left" }}>
Suggested Retail
</td>
<td style={{ textAlign: "left" }}>
price\_retail
</td>
<td style={{ textAlign: "left" }}>
Product :: Price
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available, can also be managed in JOOR
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
29
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
price\_currency\_retail
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
30
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**DELIVERIES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
31
</td>
<td style={{ textAlign: "left" }}>
Name of Linesheet
</td>
<td style={{ textAlign: "left" }}>
delivery\_name
</td>
<td style={{ textAlign: "left" }}>
Product :: Collections // Collections :: Title
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
32
</td>
<td style={{ textAlign: "left" }}>
Linesheet Code
</td>
<td style={{ textAlign: "left" }}>
delivery\_code
</td>
<td style={{ textAlign: "left" }}>
Collections :: Technical ID
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
33
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
style\_display\_order
</td>
<td style={{ textAlign: "left" }}>
Collections :: Position (as displayed)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Can be managed in JOOR
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
34
</td>
<td style={{ textAlign: "left" }}>
Season
</td>
<td style={{ textAlign: "left" }}>
season\_name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
35
</td>
<td style={{ textAlign: "left" }}>
Year
</td>
<td style={{ textAlign: "left" }}>
season\_year
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
36
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
season\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
37
</td>
<td style={{ textAlign: "left" }}>
Start Ship Date
</td>
<td style={{ textAlign: "left" }}>
date\_delivery\_start
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
38
</td>
<td style={{ textAlign: "left" }}>
Complete Ship Date
</td>
<td style={{ textAlign: "left" }}>
date\_delivery\_end
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
39
</td>
<td style={{ textAlign: "left" }}>
Visible to All My Connections?
</td>
<td style={{ textAlign: "left" }}>
public
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
40
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**COLOR EXCLUSIONS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
41
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
color\_name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
42
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
color\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
43
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**COLORS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
44
</td>
<td style={{ textAlign: "left" }}>
Color Name
</td>
<td style={{ textAlign: "left" }}>
color\_name
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Color (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
45
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
color\_code
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Color (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
46
</td>
<td style={{ textAlign: "left" }}>
Minimum Order Quantity
</td>
<td style={{ textAlign: "left" }}>
minimum
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
47
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
color\_image
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
48
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
color\_hex
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
49
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**SIZES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
50
</td>
<td style={{ textAlign: "left" }}>
Size Label
</td>
<td style={{ textAlign: "left" }}>
size\_name
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Size (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
51
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
size\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
52
</td>
<td style={{ textAlign: "left" }}>
Measurements *or* Description
</td>
<td style={{ textAlign: "left" }}>
size\_description
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
53
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
size\_multiplier
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available if casepacks are used
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
54
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
casepack\_id
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Available
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
55
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**BADGES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
56
</td>
<td style={{ textAlign: "left" }}>
Badges
</td>
<td style={{ textAlign: "left" }}>
badge\_name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
57
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**TAGS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
58
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
tag\_id
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
59
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
tag\_group
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
60
</td>
<td style={{ textAlign: "left" }}>
Tag
</td>
<td style={{ textAlign: "left" }}>
tag\_name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
61
</td>
<td style={{ textAlign: "left" }}>
Value
</td>
<td style={{ textAlign: "left" }}>
tag\_value
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
62
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
tag\_value\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
63
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**UPCS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
64
</td>
<td style={{ textAlign: "left" }}>
UPC > Color Code
</td>
<td style={{ textAlign: "left" }}>
sku\_color\_code
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Color (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
65
</td>
<td style={{ textAlign: "left" }}>
UPC > Color Description
</td>
<td style={{ textAlign: "left" }}>
sku\_color\_name
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Color (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
66
</td>
<td style={{ textAlign: "left" }}>
UPC > Size
</td>
<td style={{ textAlign: "left" }}>
sku\_size
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: option=Size (or assimilable)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
67
</td>
<td style={{ textAlign: "left" }}>
UPC
</td>
<td style={{ textAlign: "left" }}>
upc
</td>
<td style={{ textAlign: "left" }}>
Product :: Variant :: Barcode // Product :: Barcode (if no variant)
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
</th>
<th style={{ textAlign: "left" }}>
JOOR UI Field
</th>
<th style={{ textAlign: "left" }}>
JOOR API Field
</th>
<th style={{ textAlign: "left" }}>
Shopify Field
</th>
<th style={{ textAlign: "left" }}>
Configurable? (within Shopify)
</th>
<th style={{ textAlign: "left" }}>
Notes
</th>
</tr>
|
|
1
|
<td style={{ textAlign: "left" }}>
Warehouse
</td>
<td style={{ textAlign: "left" }}>
warehouse
</td>
<td style={{ textAlign: "left" }}>
Locations :: Location Name
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
2
</td>
<td style={{ textAlign: "left" }}>
Date
</td>
<td style={{ textAlign: "left" }}>
inventory\_date
</td>
<td style={{ textAlign: "left" }}>
"IMMEDIATE"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
3
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
style\_number
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
4
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
style\_identifier
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
5
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
style\_id
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
6
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
color\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
7
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
style\_color\_id
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
8
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
size
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
9
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
size\_code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
10
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
inventory
</td>
<td style={{ textAlign: "left" }}>
Inventory :: Available
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
11
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
upc
</td>
<td style={{ textAlign: "left" }}>
Product :: Barcode + Product :: Technical ID
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
12
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
made\_to\_order
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
</th>
<th style={{ textAlign: "left" }}>
JOOR UI Field
</th>
<th style={{ textAlign: "left" }}>
JOOR API Field
</th>
<th style={{ textAlign: "left" }}>
Shopify Field
</th>
<th style={{ textAlign: "left" }}>
Configurable? (within Shopify)
</th>
<th style={{ textAlign: "left" }}>
Notes
</th>
</tr>
|
|
1
|
<td>
<p style="background-color:#5a6f82;color:white;">**CUSTOMER FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
2
</td>
<td>
*
</td>
<td>
customer\_name
</td>
<td>
Customers :: Overview :: First Name + Customers :: Overview :: Last Name + (if it exists) Customer :: Overview :: Company
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
3
</td>
<td>
Customer Code and Alias > Customer Code
</td>
<td>
customer\_code
</td>
<td>
Customers :: Technical ID
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
4
</td>
<td>
Customer Code and Alias > Alias
</td>
<td>
customer\_alias
</td>
<td>
Customers :: Overview :: First Name + Customers :: Overview :: Last Name + (if it exists) Customer :: Overview :: Company
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
5
</td>
<td>
*
</td>
<td>
company\_number\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
6
</td>
<td>
*
</td>
<td>
company\_number\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
7
</td>
<td>
*
</td>
<td>
customer\_group\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
8
</td>
<td>
*
</td>
<td>
customer\_group\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
9
</td>
<td>
*
</td>
<td>
customer\_phone
</td>
<td>
Customers :: Overview :: Phone Number
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
10
</td>
<td>
*
</td>
<td>
customer\_contact
</td>
<td>
Customers :: Overview :: First Name + Customers :: Overview :: Last Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
11
</td>
<td>
*
</td>
<td>
customer\_contact\_email
</td>
<td>
Customers :: Overview :: Email
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
12
</td>
<td>
*
</td>
<td>
sales\_rep\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
13
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**BUYERS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
14
</td>
<td>
Buyers > Buyer Name
</td>
<td>
buyer\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
15
</td>
<td>
*
</td>
<td>
buyer\_title
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
16
</td>
<td>
Buyers > Email Address
</td>
<td>
buyer\_email
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
17
</td>
<td>
*
</td>
<td>
buyer\_phone
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
18
</td>
<td>
*
</td>
<td>
buyer\_fax
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
19
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SHIPPING ADDRESSES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
20
</td>
<td>
Shipping Addresses > Store Name
</td>
<td>
shipping\_name
</td>
<td>
Customers :: Address : First Name + Customers :: Address :: Last Name + (if it exists) Customers :: Address :: Company
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
21
</td>
<td>
Shipping Addresses > Code
</td>
<td>
shipping\_code
</td>
<td>
Customers :: Address :: Technical ID
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
22
</td>
<td>
Shipping Addresses > Phone
</td>
<td>
shipping\_phone
</td>
<td>
Customers :: Address :: Phone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
23
</td>
<td>
Shipping Addresses > Address 1
</td>
<td>
shipping\_address\_1
</td>
<td>
Customers :: Address :: Address
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
24
</td>
<td>
Shipping Addresses > Address 2
</td>
<td>
shipping\_address\_2
</td>
<td>
Customers :: Address :: Apartment, Suite, Etc.
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
25
</td>
<td>
Shipping Addresses > City
</td>
<td>
shipping\_city
</td>
<td>
Customers :: Address :: City
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
26
</td>
<td>
Shipping Addresses > State
</td>
<td>
shipping\_state
</td>
<td>
Customers :: Address :: State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
27
</td>
<td>
Shipping Addresses > Zip
</td>
<td>
shipping\_postal\_code
</td>
<td>
Customers :: Address :: Zip Code
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
28
</td>
<td>
Shipping Addresses > Country
</td>
<td>
shipping\_country
</td>
<td>
Customers :: Address :: Country/Region
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
29
</td>
<td>
*
</td>
<td>
shipping\_create\_doors
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
30
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SHIPPING METHODS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
31
</td>
<td>
Shipping Methods
</td>
<td>
shipping\_method\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
32
</td>
<td>
Shipping Methods
</td>
<td>
shipping\_method\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
33
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**BILLING ADDRESSES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
34
</td>
<td>
Billing Addresses > Store Name
</td>
<td>
billing\_name
</td>
<td>
Customers :: Address :: First Name + Customers :: Address :: Last name + (if it exists) Customers :: Address :: Company
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
35
</td>
<td>
Billing Addresses > Code
</td>
<td>
billing\_code
</td>
<td>
Customers :: Address :: Technical ID
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
36
</td>
<td>
Billing Addresses > Phone
</td>
<td>
billing\_phone
</td>
<td>
Customers :: Address :: Phone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
37
</td>
<td>
Billing Addresses > Address 1
</td>
<td>
billing\_address\_1
</td>
<td>
Customers :: Address :: Address
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
38
</td>
<td>
Billing Addresses > Address 2
</td>
<td>
billing\_address\_2
</td>
<td>
Customers :: Address :: Apartment, Suite, Etc
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
39
</td>
<td>
Billing Addresses > City
</td>
<td>
billing\_city
</td>
<td>
Customers :: Address :: City
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
40
</td>
<td>
Billing Addresses > State
</td>
<td>
billing\_state
</td>
<td>
Customers :: Address :: State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
41
</td>
<td>
Billing Addresses > Zip
</td>
<td>
billing\_postal\_code
</td>
<td>
Customers :: Address :: Zip Code
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
42
</td>
<td>
Billing Addresses > Country
</td>
<td>
billing\_country
</td>
<td>
Customers :: Address :: Country/Region
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
43
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**CUSTOMER LOCATIONS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
44
</td>
<td>
*
</td>
<td>
location\_phone
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
45
</td>
<td>
*
</td>
<td>
location\_address\_1
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
46
</td>
<td>
*
</td>
<td>
location\_address\_2
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
47
</td>
<td>
*
</td>
<td>
location\_city
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
48
</td>
<td>
*
</td>
<td>
location\_state
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
49
</td>
<td>
*
</td>
<td>
location\_zip
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
50
</td>
<td>
*
</td>
<td>
location\_country
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
51
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**PAYMENT METHODS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
52
</td>
<td>
Payment Methods
</td>
<td>
payment\_method\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
53
</td>
<td>
Payment Methods
</td>
<td>
payment\_method\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
54
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**PRICE TYPES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
55
</td>
<td>
Currencies
</td>
<td>
price\_type\_currency\_code
</td>
<td>
Integrations Settings :: Price Label (default is blank)
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
56
</td>
<td>
Currencies
</td>
<td>
price\_type\_label
</td>
<td>
Integrations Settings :: Price Currency (default is $)
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
57
</td>
<td>
Currencies
</td>
<td>
price\_type\_retail\_currency
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
58
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**DISCOUNTS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
59
</td>
<td>
Discounts > DISCOUNT %
</td>
<td>
discount\_value
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
60
</td>
<td>
Discounts > APPLY DISCOUNT TO
</td>
<td>
discount\_line\_item\_level
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
61
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**WAREHOUSES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
62
</td>
<td>
Warehouses
</td>
<td>
warehouse\_code
</td>
<td>
Locations :: Location Technical ID
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
63
</td>
<td>
Warehouses
</td>
<td>
warehouse\_name
</td>
<td>
Locations :: Location Name
</td>
<td>
</td>
<td>
</td>
</tr>
</th>
<th>
JOOR UI Field
</th>
<th>
JOOR API Field
</th>
<th>
Shopify Field
</th>
<th>
Configurable? (within Shopify)
</th>
<th>
Notes
</th>
</tr>
|
|
1
|
<td>
<p style="background-color:#5a6f82;color:white;">**ORDER FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
2
</td>
<td>
*
</td>
<td>
order\_id
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
3
</td>
<td>
Order Type
</td>
<td>
order\_type
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
4
</td>
<td>
Order Comments
</td>
<td>
order\_comments
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
5
</td>
<td>
Price Type
</td>
<td>
order\_currency
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
6
</td>
<td>
*
</td>
<td>
order\_currency\_retail
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
7
</td>
<td>
*
</td>
<td>
order\_currency\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
8
</td>
<td>
Discount
</td>
<td>
order\_discount
</td>
<td>
Order :: Discount (+ sum of JOOR line items discounts)
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
9
</td>
<td>
Discount
</td>
<td>
order\_discount\_percentage
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
10
</td>
<td>
Shipping Fee
</td>
<td>
order\_shipping\_total
</td>
<td>
Shipping Fee
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
11
</td>
<td>
Grand Total
</td>
<td>
order\_total
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
12
</td>
<td>
Event
</td>
<td>
order\_source
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
13
</td>
<td>
Season
</td>
<td>
order\_season\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
14
</td>
<td>
Order Type
</td>
<td>
order\_type\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
15
</td>
<td>
*
</td>
<td>
order\_type\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
16
</td>
<td>
Event
</td>
<td>
order\_event
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
17
</td>
<td>
*
</td>
<td>
order\_event\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
18
</td>
<td>
*
</td>
<td>
order\_delivery\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
19
</td>
<td>
*
</td>
<td>
order\_delivery\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
20
</td>
<td>
Sales Rep
</td>
<td>
sales\_representative
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
21
</td>
<td>
*
</td>
<td>
sales\_representative\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
22
</td>
<td>
Created Date
</td>
<td>
date\_created
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
23
</td>
<td>
Order Date
</td>
<td>
date\_approved
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
24
</td>
<td>
*
</td>
<td>
date\_modified
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
25
</td>
<td>
Delivery Window / Shipping Method > Start Ship Date
</td>
<td>
date\_ship\_start
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
26
</td>
<td>
Delivery Window / Shipping Method > Complete Ship Date
</td>
<td>
date\_ship\_end
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
27
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**CUSTOMER FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
28
</td>
<td>
Contact Information
</td>
<td>
customer\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
29
</td>
<td>
Contact Information > Customer Code
</td>
<td>
customer\_code
</td>
<td>
Order :: Customer :: ID
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
30
</td>
<td>
*
</td>
<td>
company\_name
</td>
<td>
Order :: Shipping :: Last Name\
Order :: Billing :: Last Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
31
</td>
<td>
*
</td>
<td>
company\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
32
</td>
<td>
*
</td>
<td>
customer\_group\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
33
</td>
<td>
*
</td>
<td>
customer\_group\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
34
</td>
<td>
*
</td>
<td>
customer\_purchase\_order
</td>
<td>
"J-" + Order :: Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
35
</td>
<td>
*
</td>
<td>
integration\_purchase\_order
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
36
</td>
<td>
Shipping Address > Buyer Name
</td>
<td>
customer\_buyer\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
37
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**LINE ITEMS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
38
</td>
<td>
Order Information
</td>
<td>
item\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
39
</td>
<td>
Order Information
</td>
<td>
item\_number
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
40
</td>
<td>
Order Information
</td>
<td>
item\_style\_id
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
41
</td>
<td>
*
</td>
<td>
item\_style\_identifier
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
42
</td>
<td>
Order Information > Colors
</td>
<td>
item\_color
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
43
</td>
<td>
Order Information > Colors
</td>
<td>
item\_color\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
44
</td>
<td>
*
</td>
<td>
item\_upc
</td>
<td>
Second part of the JOOR UPC > Order :: Line Items :: Variant ID
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
45
</td>
<td>
Order Information
</td>
<td>
item\_size
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
46
</td>
<td>
Order Information
</td>
<td>
item\_size\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
47
</td>
<td>
Order Information > Total
</td>
<td>
item\_price
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
48
</td>
<td>
Order Information > Wholesale
</td>
<td>
item\_unit\_price
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
49
</td>
<td>
*
</td>
<td>
item\_price\_adjustment
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
50
</td>
<td>
Order Information > Sugg. Retail
</td>
<td>
item\_retail\_price
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
51
</td>
<td>
Order Information > Qty
</td>
<td>
item\_quantity
</td>
<td>
Order :: Line Items :: Quantity
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
52
</td>
<td>
Order Information > Qty
</td>
<td>
item\_multiplier
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
53
</td>
<td>
*
</td>
<td>
item\_price\_extended
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
54
</td>
<td>
*
</td>
<td>
item\_comment
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
55
</td>
<td>
*
</td>
<td>
item\_color\_comment
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
56
</td>
<td>
*
</td>
<td>
item\_door\_id
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
57
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**STYLE TAGS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
58
</td>
<td>
*
</td>
<td>
style\_tag\_group
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
59
</td>
<td>
*
</td>
<td>
style\_tag\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
60
</td>
<td>
*
</td>
<td>
style\_tag\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
61
</td>
<td>
*
</td>
<td>
style\_tag\_value
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
62
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**DIVISIONS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
63
</td>
<td>
*
</td>
<td>
division\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
64
</td>
<td>
*
</td>
<td>
division\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
65
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**DOOR FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
66
</td>
<td>
*
</td>
<td>
door\_id
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
67
</td>
<td>
Door
</td>
<td>
door\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
68
</td>
<td>
Door
</td>
<td>
door\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
69
</td>
<td>
*
</td>
<td>
door\_deleted
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
70
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**ORDER EXPORTS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
71
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
export\_success
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
72
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
export\_date
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
73
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
export\_message
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
74
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SHIPPING FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
75
</td>
<td>
Shipping Address > Code
</td>
<td>
shipping\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
76
</td>
<td>
Shipping Address > Shipping Name
</td>
<td>
shipping\_name
</td>
<td>
Order :: Shipping :: First Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
77
</td>
<td>
Shipping Address > Phone Number
</td>
<td>
shipping\_phone
</td>
<td>
Order :: Shipping :: Phone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
78
</td>
<td>
Shipping Address > Address 1
</td>
<td>
shipping\_address\_1
</td>
<td>
Order :: Shipping :: Address1
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
79
</td>
<td>
Shipping Address > Address 2
</td>
<td>
shipping\_address\_2
</td>
<td>
Order :: Shipping :: Address2
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
80
</td>
<td>
Shipping Address > City
</td>
<td>
shipping\_city
</td>
<td>
Order :: Shipping :: City
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
81
</td>
<td>
Shipping Address > State
</td>
<td>
shipping\_region
</td>
<td>
Order :: Shipping :: State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
82
</td>
<td>
Shipping Address > Zip
</td>
<td>
shipping\_postal\_code
</td>
<td>
Order :: Shipping :: Zip
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
83
</td>
<td>
Shipping Address > Country
</td>
<td>
shipping\_country
</td>
<td>
Order :: Shipping :: Country
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
84
</td>
<td>
*
</td>
<td>
shipping\_country\_iso\_three
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
85
</td>
<td>
*
</td>
<td>
shipping\_country\_iso\_two
</td>
<td>
Order :: Shipping :: Country Code
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
86
</td>
<td>
Shipping Method > Ship With
</td>
<td>
shipping\_method\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
87
</td>
<td>
*
</td>
<td>
shipping\_method\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
88
</td>
<td>
Shipping Address > Email
</td>
<td>
shipping\_email
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
89
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**BILLING FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
90
</td>
<td>
*
</td>
<td>
billing\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
91
</td>
<td>
Billing Address > Billing Name
</td>
<td>
billing\_name
</td>
<td>
Order :: Billing :: First Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
92
</td>
<td>
Billing Address > Phone Number
</td>
<td>
billing\_phone
</td>
<td>
Order :: Billing : Phone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
93
</td>
<td>
Billing Address > Address 1
</td>
<td>
billing\_address\_1
</td>
<td>
Order :: Billing :: Address1
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
94
</td>
<td>
Billing Address > Address 2
</td>
<td>
billing\_address\_2
</td>
<td>
Order :: Billing :: Address2
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
95
</td>
<td>
Billing Address > City
</td>
<td>
billing\_city
</td>
<td>
Order :: Billing :: City
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
96
</td>
<td>
Billing Address > State
</td>
<td>
billing\_region
</td>
<td>
Order :: Billing :: State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
97
</td>
<td>
Billing Address > Country
</td>
<td>
billing\_country
</td>
<td>
Order :: Billing :: Country
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
98
</td>
<td>
*
</td>
<td>
billing\_country\_iso\_three
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
99
</td>
<td>
*
</td>
<td>
billing\_country\_iso\_two
</td>
<td>
Order :: Billing :: Country Code
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
100
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**PAYMENT METHOD FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
101
</td>
<td>
Payment Method > Terms
</td>
<td>
payment\_method\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
102
</td>
<td>
*
</td>
<td>
payment\_method\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
103
</td>
<td>
*
</td>
<td>
tax\_id\_label
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
104
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**WAREHOUSE FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
105
</td>
<td>
*
</td>
<td>
warehouse\_name
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
106
</td>
<td>
*
</td>
<td>
warehouse\_code
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
107
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**OTHER FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
108
</td>
<td>
*
</td>
<td>
created\_by\_username
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
109
</td>
<td>
*
</td>
<td>
created\_by\_email
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
110
</td>
<td>
*
</td>
<td>
is\_personal\_order
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
111
</td>
<td>
*
</td>
<td>
order\_internal\_comments
</td>
<td>
*
</td>
<td>
*
</td>
<td>
</td>
</tr>
<tr>
<td>
112
</td>
<td>
*
</td>
<td>
taxes\_to\_add\_per\_billing\_country
</td>
<td>
Tax
</td>
<td>
</td>
<td>
Taxes can be set individually for each billing country (see [Orders - Shopify](doc:orders-shopify)).
</td>
</tr>
</th>
<th>
JOOR UI Field
</th>
<th>
JOOR API Field
</th>
<th>
Shopify Field
</th>
<th>
Configurable? (within Shopify)
</th>
<th>
Notes
</th>
</tr>
|
|
1
|
