Mapped Fields - Zedonk
Below, you will find the field mapping for each data point.
Style Mapping
JOOR UI Field | JOOR Flat File Field | Zedonk Field | Column Name/Number | 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 | Column Name/Number | Notes | |
---|---|---|---|---|---|
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 | Column Name/Number | Notes | |
---|---|---|---|---|---|
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 | Column Name/Number | Notes | |
---|---|---|---|---|---|
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 | - |
Updated about 1 year ago