joor.com

Mapped Fields - AMC

Suggest Edits

Below, you will find the field mapping for each data point.

For the Style, Image, and Inventory mapping, all data is sent from ApparelMagic Cloud to JOOR.

For the Order mapping, ApparelMagic Cloud will retrieve orders from JOOR and sync to their platform.

Style Mapping

JOOR UI FieldJOOR API FieldApparelMagic Cloud FieldConfigurable? (within AMC)Notes
1

STYLE FIELDS

2Style Namestyle_nameStyle Name or Web Title:white-check-mark:Web Title (or if empty, Style Number) can be added by editing the style, navigating to the E-Commerce tab, then clicking on the JOOR Product Configuration tab. Alternatively, this can be updated in bulk by uploading a CSV file.
3Style Numberstyle_numberStyle Number:x:
4-style_identifierStyle Number:x:
5Descriptionstyle_descriptionDescription (default) or Web Description:white-check-mark:Web Description (or if empty, Description) is customized the same as Web Title (see above)
6-made_to_order--
7Divisiondivision--
8Divisiondivision_code--
9Country of Originstyle_country_originOrigin:x:
10FabricationfabricationContent:x:
11Fabricationfabrication_code--
12Measurementsmeasurements--
13Silhouettesilhouette--
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--
22

MATERIALS FIELDS

23Materialmaterial--
24

PRICES FIELDS

25Currency/Price Labelprice_labelPrice Group:x:All price groups set up in ApparelMagic Cloud will be sent to JOOR.
26Currency/Price Labelprice_currencyCurrency:white-check-mark:This can be set in the JOOR plugin settings in ApparelMagic Cloud under the setting "Default Currency Name." If empty, the default value will be "DEFAULT APPARELMAGIC WHOLESALE PRICE."
27Wholesale Priceprice_wholesaleStandard Price:x:For additional price groups, these prices will sync as a JOOR wholesale price.
28Suggested Retailprice_retailMSRP:x:This retail price will be listed on JOOR for all ApparelMagic Cloud price groups.
29-price_currency_retailCurrency:x:The retail price currency will be the same as the wholesale price currency.
30

DELIVERIES FIELDS

31Linesheet Namedelivery_nameSeason:x:
32Linesheet Codedelivery_code--
33-style_display_order--
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_nameAttribute 2 Full Name + Attribute 3 Full Name:white-check-mark:The color name can be set to either Attribute 2 and Attribute 3 or just Attribute 2. Note: Color code will always be the abbreviation for both Attribute 2 and Attribute 3.
45Codecolor_codeAttribute 2 + Attribute 3:white-check-mark:
46Minimum Order Quantityminimum--
47-color_image--
48-color_hex--
49

SIZES FIELDS

50Size Labelsize_nameSize:x:
51Codesize_codeSize:x:
52Measurements or Descriptionsize_descriptionSize:x:
53-size_multiplier--
54-casepack_id--
55

BADGES FIELDS

56Badgesbadge_name--
57

TAGS FIELDS

58-tag_id--
59-tag_groupCategory:x:
60Tagtag_nameCategory:x:
61Valuetag_valueCategory:x:
62Codetag_value_code--
63

UPCS FIELDS

64UPC > Color Codesku_color_codeAttribute 2 + Attribute 3:x:
65UPC > Color Descriptionsku_color_name--
66UPC > Sizesku_sizeSize:x:
67UPCupcUPC:x:

Inventory Mapping

JOOR UI FieldJOOR API FieldApparelMagic Cloud FieldConfigurable? (within AMC)Notes
1Warehousewarehouse"Warehouse Name" field on the JOOR plugin:white-check-mark:
2Dateinventory_date"IMMEDIATE":x:
3-style_numberStyle Number:x:
4-style_identifierStyle Number:x:
5-style_id--
6-color_codeAttribute 2 & Attribute 3:x:
7-style_color_id--
8-sizeSize:x:
9-size_code--
10-inventorySee notes:white-check-mark:This will depend on the chosen inventory value to sync and the chosen warehouse to sync.
11-upcUPC:x:
12-made_to_order0:x:

Customer Mapping

JOOR UI FieldJOOR API FieldApparelMagic Cloud FieldConfigurable? (within AMC)Notes
1

CUSTOMER FIELDS

2-customer_nameCustomer Name:x:
3Customer Code and Alias > Customer Codecustomer_codeJoor Code or Customer ID:x:
4Customer Code and Alias > Aliascustomer_alias--
5-company_number_name--
6-company_number_code--
7-customer_group_name--
8-customer_group_code--
9-customer_phonePhone:x:
10-customer_contactFirst Name & Last Name:x:
11-customer_contact_emailEmail:x:
12-sales_rep_codeSalesperson ID
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_nameShip to Name:x:
21Shipping Addresses > Codeshipping_codeShip to ID:x:
22Shipping Addresses > Phoneshipping_phonePhone:x:
23Shipping Addresses > Address 1shipping_address_1Address:x:
24Shipping Addresses > Address 2shipping_address_2Address 2:x:
25Shipping Addresses > Cityshipping_cityCity:x:
26Shipping Addresses > Stateshipping_stateState:x:
27Shipping Addresses > Zipshipping_postal_codeZip:x:
28Shipping Addresses > Countryshipping_countryCountry:x:
29-shipping_create_doors--
30

SHIPPING METHODS FIELDS

31Shipping Methodsshipping_method_nameShip Via:x:
32Shipping Methodsshipping_method_codeShip Via:x:
33

BILLING ADDRESSES FIELDS

34Billing Addresses > Store Namebilling_nameCustomer Name:x:
35Billing Addresses > Codebilling_codeCustomer ID:x:
36Billing Addresses > Phonebilling_phonePhone:x:
37Billing Addresses > Address 1billing_address_1Address:x:
38Billing Addresses > Address 2billing_address_2Address 2:x:
39Billing Addresses > Citybilling_cityCity:x:
40Billing Addresses > Statebilling_stateState:x:
41Billing Addresses > Zipbilling_postal_codeZip:x:
42Billing Addresses > Countrybilling_countryCountry:x:
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_nameCredit Terms:x:
53Payment Methodspayment_method_codeCredit Terms:x:
54

PRICE TYPES FIELDS

55Currenciesprice_type_currency_codeCurrency:x:
56Currenciesprice_type_labelPrice Group:x:
57Currenciesprice_type_retail_currency--
58

DISCOUNTS FIELDS

59Discounts > DISCOUNT %discount_valueDiscount:x:
60Discounts > APPLY DISCOUNT TOdiscount_line_item_levelFALSE:x:
61

WAREHOUSES FIELDS

62Warehouseswarehouse_name--
63Warehouseswarehouse_code--

Order Export Mapping

JOOR UI FieldJOOR API FieldApparelMagic Cloud FieldConfigurable? (within AMC)Notes
1

ORDER FIELDS

2-order_idJoor ID and Notes:x:
3Order Typeorder_type"6" if downloading orders, "7" if downloading invoices:white-check-mark:Can be set for AMC to pull either Approved or Shipped status orders (you can also set what status orders are set to in AMC)
4Order Commentsorder_commentsPrivate Notes:x:
5Price Typeorder_currencyCurrency:x:
6-order_currency_retail--
7-order_currency_name--
8Discountorder_discountDiscount:x:
9Discountorder_discount_percent--
10-order_shipping_totalFreight:x:
11Grand Totalorder_totalTotal:x:
12-order_sourceAdded to Notes:x:
13Season Codeorder_season_codeSeason:x:If season is needed on the order, the season must be added in JOOR in the season code field
14Order Typeorder_type_name--
15-order_type_code--
16Eventorder_eventAdded to Private Notes:x:
17-order_event_code--
18-order_delivery_name--
19-order_delivery_code--
20Sales Repsales_representativeSalesperson:x:
21-sales_representative_codeSalesperson:x:
22Created Datedate_createdDate:x:
23Order Datedate_approved--
24-date_modified--
25Delivery Window / Shipping Method > Start Ship Datedate_ship_startStart Date:x:
26Delivery Window / Shipping Method > Complete Ship Datedate_ship_endDue Date:x:
27Contact Informationcustomer_nameSee notes:x:Customer Code against ApparelMagic Customer ID, Customer Code against Joor ID, then Customer Name against Customer Name
28Contact Information > Customer Codecustomer_code--
29-company_name--
30-company_code--
31-customer_group_name--
32-customer_group_code--
33-customer_purchase_orderCustomer PO:x:
34-integration_purchase_order--
35Shipping Address > Buyer Namecustomer_buyer_name--
36

LINE ITEMS FIELDS

37Order Informationitem_name--
38Order Informationitem_number--
39Order Informationitem_style_id--
40-item_style_identifier--
41Order Information > Colorsitem_color--
42Order Information > Colorsitem_color_code--
43-item_upc--
44Order Informationitem_size--
45Order Informationitem_size_code--
46Order Information > Totalitem_price--
47Order Information > Wholesaleitem_unit_pricePrice:x:
48-item_price_adjustment--
49Order Information > Sugg. Retailitem_retail_price--
50Order Information > Qtyitem_quantityQty:x:
51-item_multiplier--
52-item_price_extended--
53-item_commentItem Notes:x:
54-item_color_comment--
55-item_door_id--
56

STYLE TAGS FIELDS

57-style_tag_group--
58-style_tag_name--
59-style_tag_code--
60-style_tag_value--
61

ORDER DIVISIONS FIELDS

62-division_nameDivision:x:
63-division_codeDivision:x:
64

ORDER DOORS FIELDS

65-door_id--
66-door_name--
67-door_code--
68-door_deleted--
69-shipping_code--
70

ORDER EXPORTS FIELDS

71-export_success--
72-export_date--
73-export_massage--
74

SHIPPING FIELDS

75Shipping Address > Shipping Nameshipping_name--
76Shipping Address > Codeshipping_codeSee notes:x:Shipping Code against Ship to ID, then Shipping Name against Ship to Name
77Shipping Address > Phone Numbershipping_phonePhone:x:
78Shipping Address > Address 1shipping_address_1Address 1:x:
79Shipping Address > Address 2shipping_address_2Address 2:x:
80Shipping Address > Cityshipping_cityCity:x:
81Shipping Address > Stateshipping_regionState:x:
82Shipping Address > Zipshipping_postal_codeZip:x:
83Shipping Address > Countryshipping_countryCountry:x:
84-shipping_country_iso_two--
85-shipping_country_iso_three--
86Shipping Method > Ship Withshipping_method_nameShip Via:x:
87-shipping_method_codeShip Via:x:
88Shipping Address > Emailshipping_email--
89

BILLING FIELDS

90Billing Address > Billing Namebilling_name--
91-billing_codeSee notes:x:If the billing information passed does not match the ApparelMagic billing information, then add to Private Notes
92Billing Address > Phone Numberbilling_phone--
93Billing Address > Address 1billing_address_1--
94Billing Address > Address 2billing_address_2--
95Billing Address > Citybilling_city--
96Billing Address > Statebilling_region--
97Billing Address > Countrybilling_country--
98-billing_country_iso_two--
99-billing_country_iso_three--
100

PAYMENT METHOD FIELDS

101Payment Method > Termspayment_method_name--
102-payment_method_code--
103-tax_id_label--
104

WAREHOUSE FIELDS

105-warehouse_nameWarehouse:x:
106-warehouse_codeWarehouse:x:
107

OTHER FIELDS

108-created_by_username--
109-created_by_email--
110-is_personal_order--
111-order_internal_comments--

Updated 5 months ago