When supplying the Order Feed, the files should conform to the formats shown in the following tables.
The first table contains Recommended Data that should be completed as fully as possible, with the Mandatory column indicating which data is actually required in order for the feed to be successful.
The second table contains Optional Data, which is not essential but is still recommended in order for your consumers to have the optimum experience.
Table 2. Recommended Data
Column Name (CSV) |
Field Name (XML, XLSX) |
Format |
Notes |
Example Data |
Mandatory? |
Recommended for International Orders? |
Order No.
|
<OrderNumber>
|
Unique, string, max. length 20 (14 if using CollectPlus) |
|
100085 875
|
Yes |
Yes |
Order Date
|
<OrderDate>
|
DateTimeFormat: yyyy-MM-ddTHH:mm:ss
|
|
2017-05 -15T11 :00:00
|
Yes |
Yes |
Shipping First Name
|
<Shipping First Name>
|
String, max. length 50 |
|
Joanna
|
Yes |
Yes |
Shipping Last Name
|
<Shipping Last Name>
|
String, max. length 50 |
|
Smith
|
No |
No |
Shipping Building Number
|
<Building Number>
|
String, max. length 5 |
|
150
|
No |
No |
Shipping Address 1
|
<Shipping Address1>
|
String, max. length 70 |
|
Pershore Close
|
Yes |
Yes |
Shipping Address 2
|
<Shipping Address2>
|
String, max. length 70 |
|
Gants Hill
|
No |
No |
Shipping Address 3
|
<Shipping Address3>
|
String, max. length 70 |
|
Shed End
|
No |
No |
Shipping City
|
<Shipping City>
|
String, max. length 50 |
|
Ilford
|
Yes |
Yes |
Shipping County
|
<Shipping County>
|
String, max. length 50 |
Obligatory for orders from Mexico and for UPS orders. |
Essex
|
No |
No |
Shipping Postcode
|
<Shipping PostCode>
|
String, max. length 10 |
Obligatory for UPS orders (5 or 9 characters). |
IG2 6RR
|
Yes |
Yes |
Shipping Country
|
<Shipping Country>
|
String, ISO2 Country Code |
|
GB
|
Yes |
Yes |
Email
|
<Email>
|
String, max. length 50 |
Emails will be sent to this address. |
hello@ metapack .com
|
Yes |
Yes |
Phone
|
<Phone>
|
String, max. length 20 |
|
020749 00000
|
Yes |
Yes |
Shipping Cost
|
<Shipping Cost>
|
Decimal |
Outbound shipping cost |
10.0
|
No |
Yes |
Total
|
<Total>
|
Decimal |
|
89.98
|
Yes |
Yes |
Currency
|
<Currency>
|
String, ISO3 Currency Code |
|
GBP
|
Yes |
Yes |
SKU
|
<SKU>
|
String, max. length 50 |
Should correspond to a SKU within the uploaded inventory feed. |
30D24L RED
|
Yes |
Yes |
Item Title
|
<ItemTitle>
|
String, max. length 250 |
|
Tall Ring Wrap Dress
|
Yes |
Yes |
Quantity
|
<Quantity>
|
Integer |
|
2
|
Yes |
Yes |
Price
|
<Price>
|
Decimal |
|
44.99
|
Yes |
Yes |
Color
|
<Color>
|
String, max. length 20 |
Enhances the user experience if present. |
Red
|
No |
Yes |
Size
|
<Size>
|
String, max. length 50 |
Small
|
No |
Yes |
VAT Rate
|
<VATRate>
|
Decimal |
VAT rate of the item |
20
|
No |
Yes |
VAT Value
|
<VATValue>
|
Decimal |
VAT value of the item |
15
|
No |
Yes |
Duty Paid
|
<DutyPaid>
|
String, max. length 1 |
For international orders. U = Duty Unpaid, P = Duty Paid. |
P
|
No
|
Yes
|
Duty Paid Value
|
<DutyPaid Value>
|
Integer, max. length 6 |
If DutyPaid = P, this field should contain details of the duties/tariffs applied. |
10
|
No
|
Yes
|
Tracking Number
|
<Tracking Number>
|
String, max. length 250 |
Outbound shipping - relevant for customs declarations. |
91379721 9841201
|
No
|
Yes
|
Carrier Name
|
<Carrier Name>
|
String, max. length 50 |
Royal Mail
|
No
|
Yes
|
Service
|
<Service>
|
String, max. length 50 |
Tracked 48
|
No
|
Yes
|
Customs description
|
<Customs Description>
|
String, max. length 50 |
Women's dress
|
No
|
Yes
|
Country Of Origin ISO2 Code
|
<Country OfOrigin ISO2Code>
|
String, ISO2 Country Code |
GB
|
No
|
Yes
|
Item Weight
|
<ItemWeight>
|
Decimal |
In KG - relevant for customs declarations. |
0.5
|
No
|
Yes
|
HS Code
|
<HSCode>
|
String, max. length 50 |
Harmonised code of the item. |
6109. 10.00
|
No
|
Yes
|
Retailer Name
|
<Retailer Name>
|
String, max. length 50 |
|
Metapack
|
Yes
|
Yes
|
Number of Parcels
|
<Number ofParcels>
|
Integer |
|
1
|
No
|
Yes
|
Airway Bill Number
|
<AirwayBill Number>
|
String, max. length 250 |
Relevant for customs declarations. |
612345 678
|
No
|
Yes
|
Original ATA
|
<OriginalATA>
|
String, max. length 50 |
LHR
|
No |
Yes |
Customs Entry Number
|
<Customs EntryNumber
|
String, max. length 250 |
658654 0597
|
No |
Yes |
Commercial Invoice Link
|
<Commercial InvoiceLink>
|
String, max length 250 |
metapack. global /direct download
|
No |
Yes |
Retailer Building Number
|
<Retailer Building Number>
|
String, max. length 50 |
|
150
|
No |
Yes |
Retailer Address 1
|
<Retailer Address1>
|
Unit 87
|
No |
Yes |
Retailer Address 2
|
<Retailer Address2>
|
Whitehall Industrial Estate
|
No |
Yes |
Retailer Address 3
|
<Retailer Address3>
|
Whitehall Road
|
No |
Yes |
Retailer City
|
<Retailer City>
|
Leeds
|
No |
Yes |
Retailer County
|
<Retailer County>
|
West Yorkshire
|
No |
Yes |
Retailer Postcode
|
<Retailer Postcode>
|
LS12 5JB
|
No |
Yes |
Retailer Country Code
|
<Retailer Country Code>
|
GB
|
No |
Yes |
Account
|
<Account>
|
Arcadia
|
Yes |
Yes |
Table 3. Optional Data
Column Name (CSV) |
Field Name (XML, XLSX) |
Format |
Notes |
Example Data |
Recommended for International Orders? |
Salutation
|
<Salutation>
|
String, max. length 50 |
|
Mrs.
|
No |
Customer Id
|
<CustomerId>
|
528120 00000
|
Shipping Customer Type
|
<Shipping Customer Type>
|
Enum values: 1=VIP, 2=Regular, 3=Serial Returner, 4=Potential Fraud, 5=First Time Buyer, 6=Low Spend Customer, 0=Unknown. |
|
3
|
Shipping Neighborhood
|
<Shipping Neighborhood>
|
String, max. length 50 |
Obligatory for orders from Mexico. |
Centro
|
Billing Name
|
<Billing Name>
|
String, max. length 100 |
|
Joanna Smith
|
Billing Building Number
|
<Billing Building Number>
|
String, max. length 5 |
|
150
|
Billing Address 1
|
<Billing Address1>
|
String, max. length 50 |
|
Pershore Close
|
Billing Address 2
|
<Billing Address2>
|
|
Gants Hill
|
Billing Address 3
|
<Billing Address3>
|
|
Shed End
|
Billing City
|
<Billing City>
|
|
Ilford
|
Billing County
|
<Billing County>
|
|
Essex
|
Billing Postcode
|
<Billing PostCode>
|
String, max. length 10 |
|
IG2 6RR
|
Billing Country
|
<Billing Country>
|
String, ISO2 Country Code |
|
GB
|
Billing Phone
|
<Billing Phone>
|
String, max. length 20 |
|
480000 00000
|
Source
|
<Source>
|
String, max. length 50 |
|
www. metapack. global
|
External Reference
|
<External Reference>
|
String, max. length 20 |
Additional number that can serve as a secondary order number. This is searchable within the Returns portal. |
777-0383751-8016317
|
Internal Account Number
|
<Internal Account Number>
|
String, max. length 250 |
|
520022
|
Weight Unit Of Measure
|
<Weight UnitOf Measure>
|
String, max. length 50 |
KG is the only UOM supported at this time. |
KGS
|
Incoterms
|
<Incoterms>
|
String, max. length 3 |
Incoterms |
DDP
|
Yes |
Retailer Product Title
|
<Retailer ProductTitle>
|
String |
Required if the 'Retailer Product Color' or 'Retailer Product Size' is populated. |
Ring Wrap Dress Long Sleeved
|
No |
Retailer Product Color
|
<Retailer ProductColor>
|
Required if the 'Retailer Product Title' or 'Retailer Product Size' is populated. |
Bright Red
|
Retailer Product Size
|
<Retailer ProductSize>
|
Required if the 'Retailer Product Title' or 'Retailer Product Color' is populated. |
34
|
URL Image 1
|
<ImageLink>
|
String, max. length 250 |
|
metapack. global /direct download
|
Total Weight
|
<TotalWeight>
|
Decimal |
In KG |
0.5
|
Item Width
|
<ItemWidth>
|
In CM - at product level |
10
|
Item Length
|
<ItemLength>
|
Item Height
|
<ItemHeight>
|
Total Width
|
<TotalWidth>
|
In CM - at order level |
20
|
Total Length
|
<TotalLength>
|
Total Height
|
<TotalHeight>
|
Eligible For Free Shipping
|
<EligibleFor FreeShipping>
|
Boolean |
1 = Eligible 0 = Ineligible. If empty, the order is marked as Ineligible. |
1
|
Import HS Code
|
<ImportHSCode>
|
String, max. length 50 |
Harmonised code of the item based on its destination country. |
6109.10. 00.00
|
Yes |
Master Air Waybill Number
|
<MasterAirWay billNumber>
|
String, max. length 250 |
Relevant for customs declarations. |
9991234 5678
|
Master Air Waybill Number URL
|
<MasterAirWay billNumberURL>
|
String, max. length 250 |
URL of PDF copy of the master airwaybill number. Outbound shipping - relevant for customs declarations. |
|
House Air Waybill Number
|
<HouseAirWay billNumber>
|
String, max length 250 |
Outbound shipping - relevant for customs declarations. |
9991234 5678
|
Postage Label
|
<Postage Label>
|
String, max. length 250 |
|
metapack. global /direct download
|
No |
Warehouse DC Code
|
<Warehouse DCCode>
|
String, max. length 50 |
Product-level Distribution Centre code.
Mandatory for both Multiple Destinations and Live Exchanges.
|
GB0064
|
Return Carrier
|
<Return Carrier>
|
For the in-box label |
dhl-germany
|
Return Tracking Number
|
<Return Tracking Number>
|
String, max. length 250 |
5403272 86541
|
Return Label Link
|
<Return Label Link>
|
String, max. length 20 |
metapack. global /direct download
|