Mapped Fields - Zedonk

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 Flat File Field	Zedonk Field	Notes
1		Action Code
2	LINESHEETS FIELDS
3	Name of Linesheet	Linesheet Name	Catalogue Section 1 "Linesheet Name"
4	Linesheet Code	Linesheet Code
5	Start Ship Date	Linesheet Start Ship Date
6	Complete Ship Date	Linesheet Complete Ship Date
7		Linesheet Cancel Date
8	Season	Linesheet Season Name	Catalogue Section 2 "Linesheet Season Name"
9	Code	Linesheet Season Code
10	Year	Linesheet Season Year
11	Minimum Shipping Window	Linesheet Minimum Delivery Window
12		Linesheet Style Comments
13		Linesheet Style Display Order
14	STYLES FIELDS
15	Style Name	Style Name	Description
16	Style Number	Style Number	Style
17	Description	Style Description	Description
18	Minimum Order Quantity	Style Minimum Order Quantity
19	Material	Style Materials	Textile Content
20	Source of Materials	Style Source of Materials	SKID at product/colour level
21	Country of Origin	Style Country of Origin	Manufacturer Country
22	Fabrication	Style Fabrication	Fabric
23	Fabrication	Style Fabrication Code
24	Silhouette	Style Silhouette	Catalogue Section 6 "Silhouette"
25	Silhouette	Style Silhouette Code
26	Heel Height	Style Heel Height
27	Division	Style Division Name
28	Division	Style Division Code
29	Model Height	Style Model Height
30	Measurements	Style Measurements
31	Category	Style Category Gender	Catalogue Section 3 "Style Category Gender"
32	Category	Style Category	Catalogue Section 4 "Style Category"
33	Category	Style Subcategory	Catalogue Section 5 "Style Subcategory"
34	Contains Fur?	Style Contains Fur
35	Value	Style Tag Value 1
36	Code	Style Tag Value Code 1
38	COLORS FIELDS
39	Color Name	Color Name	Colour
40	Code	Color Code
41	SIZES FIELDS
42	Size Label	Individual Size Name	Size
43	Code	Size Code
44	Measurements or Description	Size Description
45		Size Order		Follows the same order as displayed in UI
46	Active?	Size Active
47	UPC	UPC	Barcode
48	Size Label	Casepack Name
49		Casepack Quantity
50	PRICES FIELDS
51	Currency/Price Label	Price Type Currency 1
52	Currency/Price Label	Price Type Label 1	Currency Name
53	Wholesale	Wholesale Price 1	Wholesale Price
54	Suggested Retail	Suggested Retail Price 1	RRP
55	IMAGES FIELDS
56		FTP Image Directory
57		Image FTP Filename 1
58		Image URL 1
59		Style Color Image FTP Filename
60		Style Color Image URL
61		Style Color Swatch FTP Filename
62		Style Color Swatch URL

Inventory Mapping

	JOOR UI Field	JOOR Flat File Field	Zedonk Field
1		UPC	Barcode
2	[Warehouse Details]	Quantity	Available to Sell
3	Warehouse	Warehouse
4	Date	Date
5	[Warehouse Details]	Style Number
6		Style ID
7	[Warehouse Details]	Color Name
8	[Warehouse Details]	Color Code
9		Style Color ID
10	[Warehouse Details]	Size Name
11	[Warehouse Details]	Size Code

Customer Mapping

	JOOR UI Field	JOOR Flat File Field	Zedonk Field
1	CUSTOMERS FIELDS
2		Profile Name	Customer
3	Customer Code and Alias > Customer Code	Customer Code	Account Number
4	Customer Code and Alias > Customer Alias	Customer Alias	Customer
5		Alternate Name
6		Website	Website
7		Company Number Name
8		Company Number Code
9		Customer Group Name
10		Customer Group Code
11	DISCOUNTS FIELDS
12	Discounts > DISCOUNT %	Discount	Trade Discount
13	Discounts > APPLY DISCOUNT TO	Discount Line Item Level	(always FALSE)
14	SALES REPS FIELDS
15	Assign Sales Reps	Sales Rep Code
16	WAREHOUSE FIELDS
17	Warehouses	Warehouse Name
18	Warehouses	Warehouse Code
19	BUYERS FIELDS
20	Buyers > Buyer Name	Buyer Name	Default Contact
21	Buyers > Email Address	Buyer Email	Default Contact Email
22	PAYMENT METHOD FIELDS
23	Payment Methods	Payment Terms	Payment Terms
24	Payment Methods	Payment Terms Code
25	SHIPPING METHOD FIELDS
26	Shipping Methods	Shipping Terms	Shipping Terms
27	Shipping Methods Code	Shipping Terms Code
28	CURRENCIES FIELDS
29	Currencies	Price Type Currency	Currency Code
30	Currencies	Price Type Name	Currency Name
31	SHIPPING FIELDS
32	Shipping Addresses > Code	Shipping Code	Delivery Address Description
33	Shipping Addresses > Store Name	Shipping Name	Delivery Company Name
34	Shipping Addresses > Address 1	Shipping Address 1	Delivery Address 1
35	Shipping Addresses > Address 2	Shipping Address 2	Delivery Address 2
36	Shipping Addresses > City	Shipping City	Delivery Town
37	Shipping Addresses > State	Shipping State	Delivery State
38	Shipping Addresses > Zip	Shipping Zip	Delivery Postcode
39	Shipping Addresses > Country	Shipping Country	Delivery Country
40	Shipping Addresses > Email	Shipping Email	Delivery Email
41	Shipping Addresses > Phone	Shipping Phone	Delivery Telephone
42	CREATE DOORS FIELDS
43	Doors	Create Doors
44	BILLING FIELDS
45	Billing Addresses > Code	Billing Code	Accounts Address Description
46	Billing Addresses > Store Name	Billing Name	Accounts Company Name
47	Billing Addresses > Address 1	Billing Address 1	Accounts Address 1
48	Billing Addresses > Address 2	Billing Address 2	Accounts Address 2
49	Billing Addresses > City	Billing City	Accounts Town
50	Billing Addresses > State	Billing State	Accounts State
51	Billing Addresses > Zip	Billing Zip	Accounts Postcode
52	Billing Addresses > Country	Billing Country	Accounts Country

Order Export Mapping

	JOOR UI Field	JOOR Flat File Field	Zedonk Field
1	ORDERS FIELDS
2		order.account_id
3	Contact Information > Customer Code	order.customer_code	Account Code
4		order.company_name
5		order.company_code
6		order.customer_group_name
7		order.customer_group_code
8	Order Date	order.date_approved	Confirmation Date
9		order.designer_custom_url
10		order.designer_id
11		order.designer_payment_method_code
12	Contact Information	order.designer_profile_name
13		order.designer_shipping_method_code
14	Season	order.season_code
15	Season	order.season_name	Season
16	Season	order.season_year
17	Season	order.seasonname
18		order.shipping_account
19	Shipping Address > Code	order.shipping_code
20	Shipping Address > Shipping Name	order.shipping_name	Delivery Company Name
21	Shipping Address > Address 1	order.shipping_line1	Delivery Address 1
22	Shipping Address > Address 2	order.shipping_line2	Delivery Address 2
23	Shipping Address > City	order.shipping_city	Delivery Town
24	Shipping Address > State	order.shipping_state	Delivery State
25	Shipping Address > Zip	order.shipping_zip	Delivery Postcode
26	Shipping Address > Country	order.shipping_country	Delivery Country
27		order.shipping_country_code2
28	Shipping Address > Phone Number	order.shipping_phone	Delivery Telephone
29	Shipping Address > Email	order.shipping_email	Delivery Email
30	Delivery Window / Shipping Method > Start Ship Date	order.shipping_start	Delivery Start
31	Delivery Window / Shipping Method > Complete Ship Date	order.shipping_complete	Delivery Cancel
32		order.shipping_or_customer_code
33		order.shipping_company
34	Shipping Method > Ship With	order.shipping_method_name	Shipping Terms
35	Shipping Fee	order.shipping_price
36		order.billing_code
37	Billing Address > Billing Name	order.billing_name	Accounts Company Name
38	Billing Address > Address 1	order.billing_line1	Accounts Address 1
39	Billing Address > Address 2	order.billing_line2	Accounts Address 2
40	Billing Address > City	order.billing_city	Accounts Town
41	Billing Address > State	order.billing_state	Accounts State
42	Billing Address > Zip	order.billing_zip	Accounts Postcode
43	Billing Address > Country	order.billing_country	Accounts Country
44		order.billing_country_code2
45	Billing Address > Phone Number	order.billing_phone	Accounts Telephone
46		order.billing_company
47	Shipping Address > Buyer Name	order.buyer_display_name
48		order.buyer_phone
49	Price Type	order.currency_code	Currency Code
50	Price Type	order. price_type_name	Currency Name
51		order.division_code
52	Door	order.door_codes
53	Door	order.door_names
54	Order Type	order.order_type
55		order.type_code
56	Payment Method > Terms	order.payment_method	Payment Terms
57	Shipping Method > PO#	order.po_num	Order Reference
58		order.integration_po_num
59		order.public_id
60		order.public_status_id
61		order.rep_cc_emails
62		order.rep_send_ipad_emails
63		order.rep_user_email
64	Contact Information	order.retailer_profile_name
65	Sales Rep	order.sales_contact
66		order.sales_email
67		order.sales_phone
68		order.sales_rep_code
69	Sales Rep	order.sales_rep_display_name
70		order.sales_email
71	Event	order.source
72	Order Comments	order.special_instructions	Comments
73	Internal Note	order.internal_comments
74	Order Information	order.styles
75		order.tax_id_number
76		order.tax_label
77		order.terms
78	Total Quantity	order.total_units
79		order.warehouse_name
80		order.warehouse_code
81		order.retailer_brand_code
82	Event	order.event
83		order.event_code
84	Discount	order.order_discount_percent
85	Discount	order.discount_amount	Order Discount
86	Subtotal	order.calculated_order_subtotal
87	Grand Total	order.calculated_order_total
88		order.commissions
89	Created Date	order.created
90		order.modified
91	Order Status	order.status
92	[Order View Page] > Export Status	order.export_created
93	[Order View Page] > Export Status	order.export_description
94	[Order View Page] > Export Status	order.export_status
95	[Order View Page] > Export Status	order.export_success
96		order.id
97		order.joor_web_status_id
98		order.signature_file
99	Order Information	order.linesheet_name
100		order.linesheet_code
101	STYLES FIELDS
102		style.active_linesheets
103	Discount	style.style_discount_percent
104	Order Information > Sizes	style.available_sizes
105	Order Information > Country of Origin	style.country_of_origin
106		style.division_code
107	Order Information > Silhouette	style.silhouette
108		style.silhouette_code
109	Order Information > Fabrication Name - Code	style.fabrication
110	Order Information > Fabrication Name - Code	style.fabrication_code
111	Order Information	style.id
112	Order Information	style.image
113	Order Information	style.linesheet_name
114		style.linesheet_code
115	Order Information > Materials	style.materials
116	Order Information	style.name
117	Order Information	style.number
118	Order Information > Sugg. Retail	style.suggested_retail_price
119		style.heel_height
120		style.source_of_materials
121		style.contains_fur
122		style.measurements
123		style.description
124	COLORS FIELDS
125		color.active
126	Order Information > Colors	color.code
127		color.comment
128		color.door_id
129		color.door_name
130		color.door_code
131		color.id
132		color.image
133	Order Information > Colors	color.name
134		color.sizes
135		color.code_or_name
136	SIZES FIELDS
137	Order Information > Sizes	size.code
138	Order Information > Wholesale	size.item_price	Price
139		size.item_price_adjustment
140		size.item_price_extended
141		size.color_comment
142	Order Information > Style > Comment	size.modifications
143		size.original_price
144	Order Information > Qty	size.quantity	Quantity
145	Order Information > Qty	size.multiplier
146	Order Information > Total Units	size.total_units
147	Order Information	size.name
148		size.code_or_name
149		size.upc	Barcode
150	OTHER FIELDS
151		placeholder.counter_row