Order Feed File Specification

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