Mapped Fields

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

Style Mapping
Inventory Mapping
Customer Mapping
Order Export Mapping

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 Field	JOOR API Field	ApparelMagic Cloud Field	Configurable? (within AMC)	Notes
1	STYLE FIELDS
2	Style Name	style_name	Style Name or Web Title	✅	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.
3	Style Number	style_number	Style Number	❌
4	-	style_identifier	Style Number	❌
5	Description	style_description	Description (default) or Web Description	✅	Web Description (or if empty, Description) is customized the same as Web Title (see above)
6	-	made_to_order	-	-
7	Division	division	-	-
8	Division	division_code	-	-
9	Country of Origin	style_country_origin	Origin	❌
10	Fabrication	fabrication	Content	❌
11	Fabrication	fabrication_code	-	-
12	Measurements	measurements	-	-
13	Silhouette	silhouette	-	-
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	-	-
22	MATERIALS FIELDS
23	Material	material	-	-
24	PRICES FIELDS
25	Currency/Price Label	price_label	Price Group	❌	All price groups set up in ApparelMagic Cloud will be sent to JOOR.
26	Currency/Price Label	price_currency	Currency	✅	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."
27	Wholesale Price	price_wholesale	Standard Price	❌	For additional price groups, these prices will sync as a JOOR wholesale price.
28	Suggested Retail	price_retail	MSRP	❌	This retail price will be listed on JOOR for all ApparelMagic Cloud price groups.
29	-	price_currency_retail	Currency	❌	The retail price currency will be the same as the wholesale price currency.
30	DELIVERIES FIELDS
31	Linesheet Name	delivery_name	Season	❌
32	Linesheet Code	delivery_code	-	-
33	-	style_display_order	-	-
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	Attribute 2 Full Name + Attribute 3 Full Name	✅	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.
45	Code	color_code	Attribute 2 + Attribute 3	✅
46	Minimum Order Quantity	minimum	-	-
47	-	color_image	-	-
48	-	color_hex	-	-
49	SIZES FIELDS
50	Size Label	size_name	Size	❌
51	Code	size_code	Size	❌
52	Measurements or Description	size_description	Size	❌
53	-	size_multiplier	-	-
54	-	casepack_id	-	-
55	BADGES FIELDS
56	Badges	badge_name	-	-
57	TAGS FIELDS
58	-	tag_id	-	-
59	-	tag_group	Category	❌
60	Tag	tag_name	Category	❌
61	Value	tag_value	Category	❌
62	Code	tag_value_code	-	-
63	UPCS FIELDS
64	UPC > Color Code	sku_color_code	Attribute 2 + Attribute 3	❌
65	UPC > Color Description	sku_color_name	-	-
66	UPC > Size	sku_size	Size	❌
67	UPC	upc	UPC	❌

Inventory Mapping

	JOOR UI Field	JOOR API Field	ApparelMagic Cloud Field	Configurable? (within AMC)	Notes
1	Warehouse	warehouse	"Warehouse Name" field on the JOOR plugin	✅
2	Date	inventory_date	"IMMEDIATE"	❌
3	-	style_number	Style Number	❌
4	-	style_identifier	Style Number	❌
5	-	style_id	-	-
6	-	color_code	Attribute 2 & Attribute 3	❌
7	-	style_color_id	-	-
8	-	size	Size	❌
9	-	size_code	-	-
10	-	inventory	See notes	✅	This will depend on the chosen inventory value to sync and the chosen warehouse to sync.
11	-	upc	UPC	❌
12	-	made_to_order	0	❌

Customer Mapping

	JOOR UI Field	JOOR API Field	ApparelMagic Cloud Field	Configurable? (within AMC)
1	CUSTOMER FIELDS
2	-	customer_name	Customer Name	❌
3	Customer Code and Alias > Customer Code	customer_code	Joor Code or Customer ID	❌
4	Customer Code and Alias > Alias	customer_alias	-	-
5	-	company_number_name	-	-
6	-	company_number_code	-	-
7	-	customer_group_name	-	-
8	-	customer_group_code	-	-
9	-	customer_phone	Phone	❌
10	-	customer_contact	First Name & Last Name	❌
11	-	customer_contact_email	Email	❌
12	-	sales_rep_code	Salesperson ID
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	Ship to Name	❌
21	Shipping Addresses > Code	shipping_code	Ship to ID	❌
22	Shipping Addresses > Phone	shipping_phone	Phone	❌
23	Shipping Addresses > Address 1	shipping_address_1	Address	❌
24	Shipping Addresses > Address 2	shipping_address_2	Address 2	❌
25	Shipping Addresses > City	shipping_city	City	❌
26	Shipping Addresses > State	shipping_state	State	❌
27	Shipping Addresses > Zip	shipping_postal_code	Zip	❌
28	Shipping Addresses > Country	shipping_country	Country	❌
29	-	shipping_create_doors	-	-
30	SHIPPING METHODS FIELDS
31	Shipping Methods	shipping_method_name	Ship Via	❌
32	Shipping Methods	shipping_method_code	Ship Via	❌
33	BILLING ADDRESSES FIELDS
34	Billing Addresses > Store Name	billing_name	Customer Name	❌
35	Billing Addresses > Code	billing_code	Customer ID	❌
36	Billing Addresses > Phone	billing_phone	Phone	❌
37	Billing Addresses > Address 1	billing_address_1	Address	❌
38	Billing Addresses > Address 2	billing_address_2	Address 2	❌
39	Billing Addresses > City	billing_city	City	❌
40	Billing Addresses > State	billing_state	State	❌
41	Billing Addresses > Zip	billing_postal_code	Zip	❌
42	Billing Addresses > Country	billing_country	Country	❌
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	Credit Terms	❌
53	Payment Methods	payment_method_code	Credit Terms	❌
54	PRICE TYPES FIELDS
55	Currencies	price_type_currency_code	Currency	❌
56	Currencies	price_type_label	Price Group	❌
57	Currencies	price_type_retail_currency	-	-
58	DISCOUNTS FIELDS
59	Discounts > DISCOUNT %	discount_value	Discount	❌
60	Discounts > APPLY DISCOUNT TO	discount_line_item_level	FALSE	❌
61	WAREHOUSES FIELDS
62	Warehouses	warehouse_name	-	-
63	Warehouses	warehouse_code	-	-

Order Export Mapping

	JOOR UI Field	JOOR API Field	ApparelMagic Cloud Field	Configurable? (within AMC)	Notes
1	ORDER FIELDS
2	-	order_id	Joor ID and Notes	❌
3	Order Type	order_type	"6" if downloading orders, "7" if downloading invoices	✅	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)
4	Order Comments	order_comments	Private Notes	❌
5	Price Type	order_currency	Currency	❌
6	-	order_currency_retail	-	-
7	-	order_currency_name	-	-
8	Discount	order_discount	Discount	❌
9	Discount	order_discount_percent	-	-
10	-	order_shipping_total	Freight	❌
11	Grand Total	order_total	Total	❌
12	-	order_source	Added to Notes	❌
13	Season Code	order_season_code	Season	❌	If season is needed on the order, the season must be added in JOOR in the season code field
14	Order Type	order_type_name	-	-
15	-	order_type_code	-	-
16	Event	order_event	Added to Private Notes	❌
17	-	order_event_code	-	-
18	-	order_delivery_name	-	-
19	-	order_delivery_code	-	-
20	Sales Rep	sales_representative	Salesperson	❌
21	-	sales_representative_code	Salesperson	❌
22	Created Date	date_created	Date	❌
23	Order Date	date_approved	-	-
24	-	date_modified	-	-
25	Delivery Window / Shipping Method > Start Ship Date	date_ship_start	Start Date	❌
26	Delivery Window / Shipping Method > Complete Ship Date	date_ship_end	Due Date	❌
27	Contact Information	customer_name	See notes	❌	Customer Code against ApparelMagic Customer ID, Customer Code against Joor ID, then Customer Name against Customer Name
28	Contact Information > Customer Code	customer_code	-	-
29	-	company_name	-	-
30	-	company_code	-	-
31	-	customer_group_name	-	-
32	-	customer_group_code	-	-
33	-	customer_purchase_order	Customer PO	❌
34	-	integration_purchase_order	-	-
35	Shipping Address > Buyer Name	customer_buyer_name	-	-
36	LINE ITEMS FIELDS
37	Order Information	item_name	-	-
38	Order Information	item_number	-	-
39	Order Information	item_style_id	-	-
40	-	item_style_identifier	-	-
41	Order Information > Colors	item_color	-	-
42	Order Information > Colors	item_color_code	-	-
43	-	item_upc	-	-
44	Order Information	item_size	-	-
45	Order Information	item_size_code	-	-
46	Order Information > Total	item_price	-	-
47	Order Information > Wholesale	item_unit_price	Price	❌
48	-	item_price_adjustment	-	-
49	Order Information > Sugg. Retail	item_retail_price	-	-
50	Order Information > Qty	item_quantity	Qty	❌
51	-	item_multiplier	-	-
52	-	item_price_extended	-	-
53	-	item_comment	Item Notes	❌
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_name	Division	❌
63	-	division_code	Division	❌
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
75	Shipping Address > Shipping Name	shipping_name	-	-
76	Shipping Address > Code	shipping_code	See notes	❌	Shipping Code against Ship to ID, then Shipping Name against Ship to Name
77	Shipping Address > Phone Number	shipping_phone	Phone	❌
78	Shipping Address > Address 1	shipping_address_1	Address 1	❌
79	Shipping Address > Address 2	shipping_address_2	Address 2	❌
80	Shipping Address > City	shipping_city	City	❌
81	Shipping Address > State	shipping_region	State	❌
82	Shipping Address > Zip	shipping_postal_code	Zip	❌
83	Shipping Address > Country	shipping_country	Country	❌
84	-	shipping_country_iso_two	-	-
85	-	shipping_country_iso_three	-	-
86	Shipping Method > Ship With	shipping_method_name	Ship Via	❌
87	-	shipping_method_code	Ship Via	❌
88	Shipping Address > Email	shipping_email	-	-
89	BILLING FIELDS
90	Billing Address > Billing Name	billing_name	-	-
91	-	billing_code	See notes	❌	If the billing information passed does not match the ApparelMagic billing information, then add to Private Notes
92	Billing Address > Phone Number	billing_phone	-	-
93	Billing Address > Address 1	billing_address_1	-	-
94	Billing Address > Address 2	billing_address_2	-	-
95	Billing Address > City	billing_city	-	-
96	Billing Address > State	billing_region	-	-
97	Billing Address > Country	billing_country	-	-
98	-	billing_country_iso_two	-	-
99	-	billing_country_iso_three	-	-
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	Warehouse	❌
106	-	warehouse_code	Warehouse	❌
107	OTHER FIELDS
108	-	created_by_username	-	-
109	-	created_by_email	-	-
110	-	is_personal_order	-	-
111	-	order_internal_comments	-	-