Mapped Fields - Shopify

Below you will find the field mapping for each data point:

Style Mapping
Inventory Mapping
Customer Mapping
Order Export Mapping

Style Mapping

	JOOR UI Field	JOOR API Field	Shopify Field	Notes
1	STYLE FIELDS
2	Style Name	style_name	Product :: Title
3	Style Number	style_number	Product :: Technical ID
4		style_identifier	Product :: Technical ID	Available, can also be managed in JOOR
5	Description	style_description	Product :: Description
6		made_to_order
7	Division	division
8	Division	division_code
9	Country of Origin	style_country_origin
10	Fabrication	fabrication		Available
11	Fabrication	fabrication_code		Available
12	Measurements	measurements		Available
13	Silhouette	silhouette	Product :: Product Type	Available
14	Silhouette	silhouette_code
15	Source of Materials	source_of_materials
16	Heel Height	heel_height
17	Contains Fur?	contains_fur
18		delivery_overwrite
19	Minimum Order Quantity	minimum
20	CATEGORIES FIELDS
21	Category	category_id		A default category for all synced styles can be set (see Styles, Images, and Linesheets - Shopify)
22	MATERIALS FIELDS
23	Material	material	Product :: Variant :: option=Material (or assimilable)	Available
24	PRICES FIELDS
25	Currency/Price Label	price_label	Integrations Settings :: Price Label (default is blank)	Available
26	Currency/Price Label	price_currency	Integrations Settings :: Price Currency (default is $)	Available
27	Wholesale	price_wholesale		Available, can also be managed in JOOR
28	Suggested Retail	price_retail	Product :: Price	Available, can also be managed in JOOR
29		price_currency_retail		Available
30	DELIVERIES FIELDS
31	Name of Linesheet	delivery_name	Product :: Collections // Collections :: Title
32	Linesheet Code	delivery_code	Collections :: Technical ID
33		style_display_order	Collections :: Position (as displayed)	Can be managed in JOOR
34	Season	season_name
35	Year	season_year
36	Code	season_code
37	Start Ship Date	date_delivery_start
38	Complete Ship Date	date_delivery_end
39	Visible to All My Connections?	public
40	COLOR EXCLUSIONS FIELDS
41		color_name
42		color_code
43	COLORS FIELDS
44	Color Name	color_name	Product :: Variant :: option=Color (or assimilable)	Available
45	Code	color_code	Product :: Variant :: option=Color (or assimilable)	Available
46	Minimum Order Quantity	minimum
47		color_image
48		color_hex
49	SIZES FIELDS
50	Size Label	size_name	Product :: Variant :: option=Size (or assimilable)	Available
51	Code	size_code		Available
52	Measurements or Description	size_description
53		size_multiplier		Available if casepacks are used
54		casepack_id		Available
55	BADGES FIELDS
56	Badges	badge_name
57	TAGS FIELDS
58		tag_id
59		tag_group
60	Tag	tag_name
61	Value	tag_value
62	Code	tag_value_code
63	UPCS FIELDS
64	UPC > Color Code	sku_color_code	Product :: Variant :: option=Color (or assimilable)
65	UPC > Color Description	sku_color_name	Product :: Variant :: option=Color (or assimilable)
66	UPC > Size	sku_size	Product :: Variant :: option=Size (or assimilable)
67	UPC	upc	Product :: Variant :: Barcode // Product :: Barcode (if no variant)

Inventory Mapping

	JOOR UI Field	JOOR API Field	Shopify Field
1	Warehouse	warehouse	Locations :: Location Name
2	Date	inventory_date	"IMMEDIATE"
3	[Warehouse Details]	style_number
4		style_identifier
5	[Warehouse Details]	style_id
6	[Warehouse Details]	color_code
7	[Warehouse Details]	style_color_id
8	[Warehouse Details]	size
9	[Warehouse Details]	size_code
10		inventory	Inventory :: Available
11		upc	Product :: Barcode + Product :: Technical ID
12		made_to_order

Customer Mapping

	JOOR UI Field	JOOR API Field	Shopify Field
1	CUSTOMER FIELDS
2		customer_name	Customers :: Overview :: First Name + Customers :: Overview :: Last Name + (if it exists) Customer :: Overview :: Company
3	Customer Code and Alias > Customer Code	customer_code	Customers :: Technical ID
4	Customer Code and Alias > Alias	customer_alias	Customers :: Overview :: First Name + Customers :: Overview :: Last Name + (if it exists) Customer :: Overview :: Company
5		company_number_name
6		company_number_code
7		customer_group_name
8		customer_group_code
9		customer_phone	Customers :: Overview :: Phone Number
10		customer_contact	Customers :: Overview :: First Name + Customers :: Overview :: Last Name
11		customer_contact_email	Customers :: Overview :: Email
12		sales_rep_code
13	BUYERS FIELDS
14	Buyers > Buyer Name	buyer_name
15		buyer_title
16	Buyers > Email Address	buyer_email
17		buyer_phone
18		buyer_fax
19	SHIPPING ADDRESSES FIELDS
20	Shipping Addresses > Store Name	shipping_name	Customers :: Address : First Name + Customers :: Address :: Last Name + (if it exists) Customers :: Address :: Company
21	Shipping Addresses > Code	shipping_code	Customers :: Address :: Technical ID
22	Shipping Addresses > Phone	shipping_phone	Customers :: Address :: Phone
23	Shipping Addresses > Address 1	shipping_address_1	Customers :: Address :: Address
24	Shipping Addresses > Address 2	shipping_address_2	Customers :: Address :: Apartment, Suite, Etc.
25	Shipping Addresses > City	shipping_city	Customers :: Address :: City
26	Shipping Addresses > State	shipping_state	Customers :: Address :: State
27	Shipping Addresses > Zip	shipping_postal_code	Customers :: Address :: Zip Code
28	Shipping Addresses > Country	shipping_country	Customers :: Address :: Country/Region
29		shipping_create_doors
30	SHIPPING METHODS FIELDS
31	Shipping Methods	shipping_method_name
32	Shipping Methods	shipping_method_code
33	BILLING ADDRESSES FIELDS
34	Billing Addresses > Store Name	billing_name	Customers :: Address :: First Name + Customers :: Address :: Last name + (if it exists) Customers :: Address :: Company
35	Billing Addresses > Code	billing_code	Customers :: Address :: Technical ID
36	Billing Addresses > Phone	billing_phone	Customers :: Address :: Phone
37	Billing Addresses > Address 1	billing_address_1	Customers :: Address :: Address
38	Billing Addresses > Address 2	billing_address_2	Customers :: Address :: Apartment, Suite, Etc
39	Billing Addresses > City	billing_city	Customers :: Address :: City
40	Billing Addresses > State	billing_state	Customers :: Address :: State
41	Billing Addresses > Zip	billing_postal_code	Customers :: Address :: Zip Code
42	Billing Addresses > Country	billing_country	Customers :: Address :: Country/Region
43	CUSTOMER LOCATIONS FIELDS
44		location_phone
45		location_address_1
46		location_address_2
47		location_city
48		location_state
49		location_zip
50		location_country
51	PAYMENT METHODS FIELDS
52	Payment Methods	payment_method_name
53	Payment Methods	payment_method_code
54	PRICE TYPES FIELDS
55	Currencies	price_type_currency_code	Integrations Settings :: Price Label (default is blank)
56	Currencies	price_type_label	Integrations Settings :: Price Currency (default is $)
57	Currencies	price_type_retail_currency
58	DISCOUNTS FIELDS
59	Discounts > DISCOUNT %	discount_value
60	Discounts > APPLY DISCOUNT TO	discount_line_item_level
61	WAREHOUSES FIELDS
62	Warehouses	warehouse_code	Locations :: Location Technical ID
63	Warehouses	warehouse_name	Locations :: Location Name

Order Export Mapping

	JOOR UI Field	JOOR API Field	Shopify Field	Notes
1	ORDER FIELDS
2		order_id
3	Order Type	order_type
4	Order Comments	order_comments
5	Price Type	order_currency
6		order_currency_retail
7		order_currency_name
8	Discount	order_discount	Order :: Discount (+ sum of JOOR line items discounts)
9	Discount	order_discount_percentage
10	Shipping Fee	order_shipping_total	Shipping Fee
11	Grand Total	order_total
12	Event	order_source
13	Season	order_season_code
14	Order Type	order_type_name
15		order_type_code
16	Event	order_event
17		order_event_code
18		order_delivery_name
19		order_delivery_code
20	Sales Rep	sales_representative
21		sales_representative_code
22	Created Date	date_created
23	Order Date	date_approved
24		date_modified
25	Delivery Window / Shipping Method > Start Ship Date	date_ship_start
26	Delivery Window / Shipping Method > Complete Ship Date	date_ship_end
27	CUSTOMER FIELDS
28	Contact Information	customer_name
29	Contact Information > Customer Code	customer_code	Order :: Customer :: ID
30		company_name	Order :: Shipping :: Last Name Order :: Billing :: Last Name
31		company_code
32		customer_group_name
33		customer_group_code
34		customer_purchase_order	"J-" + Order :: Name
35		integration_purchase_order
36	Shipping Address > Buyer Name	customer_buyer_name
37	LINE ITEMS FIELDS
38	Order Information	item_name
39	Order Information	item_number
40	Order Information	item_style_id
41		item_style_identifier
42	Order Information > Colors	item_color
43	Order Information > Colors	item_color_code
44		item_upc	Second part of the JOOR UPC > Order :: Line Items :: Variant ID
45	Order Information	item_size
46	Order Information	item_size_code
47	Order Information > Total	item_price
48	Order Information > Wholesale	item_unit_price
49		item_price_adjustment
50	Order Information > Sugg. Retail	item_retail_price
51	Order Information > Qty	item_quantity	Order :: Line Items :: Quantity
52	Order Information > Qty	item_multiplier
53		item_price_extended
54		item_comment
55		item_color_comment
56		item_door_id
57	STYLE TAGS FIELDS
58		style_tag_group
59		style_tag_name
60		style_tag_code
61		style_tag_value
62	DIVISIONS FIELDS
63		division_name
64		division_code
65	DOOR FIELDS
66		door_id
67	Door	door_name
68	Door	door_code
69		door_deleted
70	ORDER EXPORTS FIELDS
71	[Order View Page] > Export Status	export_success
72	[Order View Page] > Export Status	export_date
73	[Order View Page] > Export Status	export_message
74	SHIPPING FIELDS
75	Shipping Address > Code	shipping_code
76	Shipping Address > Shipping Name	shipping_name	Order :: Shipping :: First Name
77	Shipping Address > Phone Number	shipping_phone	Order :: Shipping :: Phone
78	Shipping Address > Address 1	shipping_address_1	Order :: Shipping :: Address1
79	Shipping Address > Address 2	shipping_address_2	Order :: Shipping :: Address2
80	Shipping Address > City	shipping_city	Order :: Shipping :: City
81	Shipping Address > State	shipping_region	Order :: Shipping :: State
82	Shipping Address > Zip	shipping_postal_code	Order :: Shipping :: Zip
83	Shipping Address > Country	shipping_country	Order :: Shipping :: Country
84		shipping_country_iso_three
85		shipping_country_iso_two	Order :: Shipping :: Country Code
86	Shipping Method > Ship With	shipping_method_name
87		shipping_method_code
88	Shipping Address > Email	shipping_email
89	BILLING FIELDS
90		billing_code
91	Billing Address > Billing Name	billing_name	Order :: Billing :: First Name
92	Billing Address > Phone Number	billing_phone	Order :: Billing : Phone
93	Billing Address > Address 1	billing_address_1	Order :: Billing :: Address1
94	Billing Address > Address 2	billing_address_2	Order :: Billing :: Address2
95	Billing Address > City	billing_city	Order :: Billing :: City
96	Billing Address > State	billing_region	Order :: Billing :: State
97	Billing Address > Country	billing_country	Order :: Billing :: Country
98		billing_country_iso_three
99		billing_country_iso_two	Order :: Billing :: Country Code
100	PAYMENT METHOD FIELDS
101	Payment Method > Terms	payment_method_name
102		payment_method_code
103		tax_id_label
104	WAREHOUSE FIELDS
105		warehouse_name
106		warehouse_code
107	OTHER FIELDS
108		created_by_username
109		created_by_email
110		is_personal_order
111		order_internal_comments
112		taxes_to_add_per_billing_country	Tax	Taxes can be set individually for each billing country (see Orders - Shopify).