Guides
joor.com

Mapped Fields - Shopify

Suggest Edits

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

Style Mapping

JOOR UI FieldJOOR API FieldShopify FieldConfigurable? (within Shopify)Notes
1

STYLE FIELDS

2Style Namestyle_nameProduct :: Title
3Style Numberstyle_numberProduct :: Technical ID
4-style_identifierProduct :: Technical IDAvailable, can also be managed in JOOR
5Descriptionstyle_descriptionProduct :: Description
6-made_to_order--
7Divisiondivision--
8Divisiondivision_code--
9Country of Originstyle_country_origin--
10Fabricationfabrication--Available
11Fabricationfabrication_code--Available
12Measurementsmeasurements--Available
13SilhouettesilhouetteProduct :: Product TypeAvailable
14Silhouettesilhouette_code--
15Source of Materialssource_of_materials--
16Heel Heightheel_height--
17Contains Fur?contains_fur--
18-delivery_overwrite--
19Minimum Order Quantityminimum--
20

CATEGORIES FIELDS

21Categorycategory_id--A default category for all synced styles can be set (see Styles, Images, and Linesheets - Shopify)
22

MATERIALS FIELDS

23MaterialmaterialProduct :: Variant :: option=Material (or assimilable)Available
24

PRICES FIELDS

25Currency/Price Labelprice_labelIntegrations Settings :: Price Label (default is blank)Available
26Currency/Price Labelprice_currencyIntegrations Settings :: Price Currency (default is $)Available
27Wholesaleprice_wholesale--Available, can also be managed in JOOR
28Suggested Retailprice_retailProduct :: PriceAvailable, can also be managed in JOOR
29-price_currency_retail--Available
30

DELIVERIES FIELDS

31Name of Linesheetdelivery_nameProduct :: Collections // Collections :: Title
32Linesheet Codedelivery_codeCollections :: Technical ID
33-style_display_orderCollections :: Position (as displayed)Can be managed in JOOR
34Seasonseason_name--
35Yearseason_year--
36Codeseason_code--
37Start Ship Datedate_delivery_start--
38Complete Ship Datedate_delivery_end--
39Visible to All My Connections?public--
40

COLOR EXCLUSIONS FIELDS

41-color_name--
42-color_code--
43

COLORS FIELDS

44Color Namecolor_nameProduct :: Variant :: option=Color (or assimilable)Available
45Codecolor_codeProduct :: Variant :: option=Color (or assimilable)Available
46Minimum Order Quantityminimum--
47-color_image--
48-color_hex--
49

SIZES FIELDS

50Size Labelsize_nameProduct :: Variant :: option=Size (or assimilable)Available
51Codesize_code--Available
52Measurements or Descriptionsize_description--
53-size_multiplier--Available if casepacks are used
54-casepack_id--Available
55

BADGES FIELDS

56Badgesbadge_name--
57

TAGS FIELDS

58-tag_id--
59-tag_group--
60Tagtag_name--
61Valuetag_value--
62Codetag_value_code--
63

UPCS FIELDS

64UPC > Color Codesku_color_codeProduct :: Variant :: option=Color (or assimilable)
65UPC > Color Descriptionsku_color_nameProduct :: Variant :: option=Color (or assimilable)
66UPC > Sizesku_sizeProduct :: Variant :: option=Size (or assimilable)
67UPCupcProduct :: Variant :: Barcode // Product :: Barcode (if no variant)

Inventory Mapping

JOOR UI FieldJOOR API FieldShopify FieldConfigurable? (within Shopify)Notes
1WarehousewarehouseLocations :: Location Name
2Dateinventory_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-inventoryInventory :: Available-
11-upcProduct :: Barcode + Product :: Technical ID-
12-made_to_order--

Customer Mapping

JOOR UI FieldJOOR API FieldShopify FieldConfigurable? (within Shopify)Notes
1

CUSTOMER FIELDS

2-customer_nameCustomers :: Overview :: First Name + Customers :: Overview :: Last Name + (if it exists) Customer :: Overview :: Company
3Customer Code and Alias > Customer Codecustomer_codeCustomers :: Technical ID
4Customer Code and Alias > Aliascustomer_aliasCustomers :: 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_phoneCustomers :: Overview :: Phone Number
10-customer_contactCustomers :: Overview :: First Name + Customers :: Overview :: Last Name
11-customer_contact_emailCustomers :: Overview :: Email
12-sales_rep_code--
13

BUYERS FIELDS

14Buyers > Buyer Namebuyer_name--
15-buyer_title--
16Buyers > Email Addressbuyer_email--
17-buyer_phone--
18-buyer_fax--
19

SHIPPING ADDRESSES FIELDS

20Shipping Addresses > Store Nameshipping_nameCustomers :: Address : First Name + Customers :: Address :: Last Name + (if it exists) Customers :: Address :: Company
21Shipping Addresses > Codeshipping_codeCustomers :: Address :: Technical ID
22Shipping Addresses > Phoneshipping_phoneCustomers :: Address :: Phone
23Shipping Addresses > Address 1shipping_address_1Customers :: Address :: Address
24Shipping Addresses > Address 2shipping_address_2Customers :: Address :: Apartment, Suite, Etc.
25Shipping Addresses > Cityshipping_cityCustomers :: Address :: City
26Shipping Addresses > Stateshipping_stateCustomers :: Address :: State
27Shipping Addresses > Zipshipping_postal_codeCustomers :: Address :: Zip Code
28Shipping Addresses > Countryshipping_countryCustomers :: Address :: Country/Region
29-shipping_create_doors--
30

SHIPPING METHODS FIELDS

31Shipping Methodsshipping_method_name--
32Shipping Methodsshipping_method_code--
33

BILLING ADDRESSES FIELDS

34Billing Addresses > Store Namebilling_nameCustomers :: Address :: First Name + Customers :: Address :: Last name + (if it exists) Customers :: Address :: Company
35Billing Addresses > Codebilling_codeCustomers :: Address :: Technical ID
36Billing Addresses > Phonebilling_phoneCustomers :: Address :: Phone
37Billing Addresses > Address 1billing_address_1Customers :: Address :: Address
38Billing Addresses > Address 2billing_address_2Customers :: Address :: Apartment, Suite, Etc
39Billing Addresses > Citybilling_cityCustomers :: Address :: City
40Billing Addresses > Statebilling_stateCustomers :: Address :: State
41Billing Addresses > Zipbilling_postal_codeCustomers :: Address :: Zip Code
42Billing Addresses > Countrybilling_countryCustomers :: 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

52Payment Methodspayment_method_name--
53Payment Methodspayment_method_code--
54

PRICE TYPES FIELDS

55Currenciesprice_type_currency_codeIntegrations Settings :: Price Label (default is blank)
56Currenciesprice_type_labelIntegrations Settings :: Price Currency (default is $)
57Currenciesprice_type_retail_currency--
58

DISCOUNTS FIELDS

59Discounts > DISCOUNT %discount_value--
60Discounts > APPLY DISCOUNT TOdiscount_line_item_level--
61

WAREHOUSES FIELDS

62Warehouseswarehouse_codeLocations :: Location Technical ID
63Warehouseswarehouse_nameLocations :: Location Name

Order Export Mapping

JOOR UI FieldJOOR API FieldShopify FieldConfigurable? (within Shopify)Notes
1

ORDER FIELDS

2-order_id--
3Order Typeorder_type--
4Order Commentsorder_comments--
5Price Typeorder_currency--
6-order_currency_retail--
7-order_currency_name--
8Discountorder_discountOrder :: Discount (+ sum of JOOR line items discounts)
9Discountorder_discount_percentage--
10Shipping Feeorder_shipping_totalShipping Fee
11Grand Totalorder_total--
12Eventorder_source--
13Seasonorder_season_code--
14Order Typeorder_type_name--
15-order_type_code--
16Eventorder_event--
17-order_event_code--
18-order_delivery_name--
19-order_delivery_code--
20Sales Repsales_representative--
21-sales_representative_code--
22Created Datedate_created--
23Order Datedate_approved--
24-date_modified--
25Delivery Window / Shipping Method > Start Ship Datedate_ship_start--
26Delivery Window / Shipping Method > Complete Ship Datedate_ship_end--
27

CUSTOMER FIELDS

28Contact Informationcustomer_name--
29Contact Information > Customer Codecustomer_codeOrder :: Customer :: ID
30-company_nameOrder :: 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--
36Shipping Address > Buyer Namecustomer_buyer_name--
37

LINE ITEMS FIELDS

38Order Informationitem_name--
39Order Informationitem_number--
40Order Informationitem_style_id--
41-item_style_identifier--
42Order Information > Colorsitem_color--
43Order Information > Colorsitem_color_code--
44-item_upcSecond part of the JOOR UPC > Order :: Line Items :: Variant ID
45Order Informationitem_size--
46Order Informationitem_size_code--
47Order Information > Totalitem_price--
48Order Information > Wholesaleitem_unit_price--
49-item_price_adjustment--
50Order Information > Sugg. Retailitem_retail_price--
51Order Information > Qtyitem_quantityOrder :: Line Items :: Quantity
52Order Information > Qtyitem_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--
67Doordoor_name--
68Doordoor_code--
69-door_deleted--
70

ORDER EXPORTS FIELDS

71[Order View Page] > Export Statusexport_success--
72[Order View Page] > Export Statusexport_date--
73[Order View Page] > Export Statusexport_message--
74

SHIPPING FIELDS

75Shipping Address > Codeshipping_code--
76Shipping Address > Shipping Nameshipping_nameOrder :: Shipping :: First Name
77Shipping Address > Phone Numbershipping_phoneOrder :: Shipping :: Phone
78Shipping Address > Address 1shipping_address_1Order :: Shipping :: Address1
79Shipping Address > Address 2shipping_address_2Order :: Shipping :: Address2
80Shipping Address > Cityshipping_cityOrder :: Shipping :: City
81Shipping Address > Stateshipping_regionOrder :: Shipping :: State
82Shipping Address > Zipshipping_postal_codeOrder :: Shipping :: Zip
83Shipping Address > Countryshipping_countryOrder :: Shipping :: Country
84-shipping_country_iso_three--
85-shipping_country_iso_twoOrder :: Shipping :: Country Code-
86Shipping Method > Ship Withshipping_method_name--
87-shipping_method_code--
88Shipping Address > Emailshipping_email--
89

BILLING FIELDS

90-billing_code--
91Billing Address > Billing Namebilling_nameOrder :: Billing :: First Name
92Billing Address > Phone Numberbilling_phoneOrder :: Billing : Phone
93Billing Address > Address 1billing_address_1Order :: Billing :: Address1
94Billing Address > Address 2billing_address_2Order :: Billing :: Address2
95Billing Address > Citybilling_cityOrder :: Billing :: City
96Billing Address > Statebilling_regionOrder :: Billing :: State
97Billing Address > Countrybilling_countryOrder :: Billing :: Country
98-billing_country_iso_three--
99-billing_country_iso_twoOrder :: Billing :: Country Code
100

PAYMENT METHOD FIELDS

101Payment Method > Termspayment_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_countryTaxTaxes can be set individually for each billing country (see Orders - Shopify).

Updated over 1 year ago