Welcome to the List of All Available Order Export Tokens
This will give you a run down of each token available when exporting orders
Below is a full list of tokens available for use with the Default Order Export template.
Billing & Accounting Tokens:
Accounts Invoice ID
Amount Refunded
Billing Address (Comma Formatted)
Billing Address (Newline Formatted)
Billing Address 1
Billing Address 2
Billing City
Billing Company
Billing Country
Billing County
Billing Department
Billing First Name
Billing FullName
Billing Last Name
Billing Phone
Billing Post Code
Billing Suite
Exported to Accounts
Exported to Accounts Date
Payment ID
Payment Method
Shipping Amount Refunded
Accounts Invoice ID
Amount Refunded
Billing Address (Comma Formatted)
Billing Address (Newline Formatted)
Billing Address 1
Billing Address 2
Billing City
Billing Company
Billing Country
Billing County
Billing Department
Billing First Name
Billing FullName
Billing Last Name
Billing Phone
Billing Post Code
Billing Suite
Exported to Accounts
Exported to Accounts Date
Payment ID
Payment Method
Shipping Amount Refunded
Company Information Tokens:
Company Address
Company Address (Comma Formatted)
Company Address (Newline Formatted)
Company Country
Company Email
Company EORI Number
Company EORI Number (Northern Ireland)
Company Logo URL
Company Name
Company Phone
Company Postcode
Company State
Company Town
Company URL
VAT Number
Company Address
Company Address (Comma Formatted)
Company Address (Newline Formatted)
Company Country
Company Email
Company EORI Number
Company EORI Number (Northern Ireland)
Company Logo URL
Company Name
Company Phone
Company Postcode
Company State
Company Town
Company URL
VAT Number
Customer Information Tokens:
Contact Notes - Includes system generated notes.
Contact Notes Exc. System - Excludes system generated notes.
Customer Address 1
Customer Address 2
Customer Company
Customer County
Customer Email
Customer First Name
Customer Full Name
Customer Last Name
Customer Notes
Customer Post Code
Customer Reference
Customer Telephone
Customer Town
Customer VAT Number
Contact Notes - Includes system generated notes.
Contact Notes Exc. System - Excludes system generated notes.
Customer Address 1
Customer Address 2
Customer Company
Customer County
Customer Email
Customer First Name
Customer Full Name
Customer Last Name
Customer Notes
Customer Post Code
Customer Reference
Customer Telephone
Customer Town
Customer VAT Number
Shipping Tokens:
Channel Shipping Method
Consignment Number - The tracking number for a parcel.
Cubic Metre Volume - Packaging volume in cubic metres multiplied by the number of packages.
Customs Barcode
Delivery Confirmation Number
Despatch Date
Line Weight
Manifest Number
Number of Packages
Order Line Volume - Product volume in cubic metres multiplied by the quantity ordered.
Order Weight Str
Packaging Cost
Service
Service Code
ServiceFormat
Shipping Address (Comma Formatted)
Shipping Address (Newline Formatted)
Shipping Address 1
Shipping Address 2
Shipping City
Shipping Company
Shipping Country
Shipping Country 2 LetterCode
Shipping Country 3 Letter Code
Shipping County
Shipping Department
Shipping First Name
Shipping Last Name
Shipping Method Cost
Shipping Method Name
Shipping Phone
Shipping Post Code
Shipping Rule
Shipping Tracking Number
ShippingFullName
Total Line Weight
Tracking URL
Channel Shipping Method
Consignment Number - The tracking number for a parcel.
Cubic Metre Volume - Packaging volume in cubic metres multiplied by the number of packages.
Customs Barcode
Delivery Confirmation Number
Despatch Date
Line Weight
Manifest Number
Number of Packages
Order Line Volume - Product volume in cubic metres multiplied by the quantity ordered.
Order Weight Str
Packaging Cost
Service
Service Code
ServiceFormat
Shipping Address (Comma Formatted)
Shipping Address (Newline Formatted)
Shipping Address 1
Shipping Address 2
Shipping City
Shipping Company
Shipping Country
Shipping Country 2 LetterCode
Shipping Country 3 Letter Code
Shipping County
Shipping Department
Shipping First Name
Shipping Last Name
Shipping Method Cost
Shipping Method Name
Shipping Phone
Shipping Post Code
Shipping Rule
Shipping Tracking Number
ShippingFullName
Total Line Weight
Tracking URL
Order Tokens:
Air Number
Amazon Customisation Image URLs
Cancelled Date
Ebay Full Order Reference
Exchange Order Number
Highlight Multiple Quantity - Highlights if more than one of a single product line has been ordered.
IOSS Number
Item ID
Item Options For Order
Listing Name
Multiple Highlight
Order and Shipping Tax
Order Channel Source
Order Customs Declaration Category Override
Order Date
Order Discount European Format
Order Discounts
Order GUID
Order Import Date
Order Line Status
Order Line Tax
Order Notes
Order Number
Order Number(Channel)
Order Packaging Name
Order Return ID
Order Ship By Date
Order Shipping Cost
Order Shipping Cost European Format
Order Shipping Cost Ex Vat
Order Shipping Tax
Order Status
Order Subtotal
Order Subtotal inc Tax
Order Subtotal Inc Tax European Format
Order Tax
Order Tax European Format
Order Total
Order Total European Format
Order Weight
Ordered Product Channel SKU
Ordered Product Name
Ordered Product SKU
Parent Order Number
Prime Order
Priority Order
Qty Sent - Quantity Sent
Quantity Ordered
Quantity Returned
Return Notes
Returned Date
Supplier Sent To
Air Number
Amazon Customisation Image URLs
Cancelled Date
Ebay Full Order Reference
Exchange Order Number
Highlight Multiple Quantity - Highlights if more than one of a single product line has been ordered.
IOSS Number
Item ID
Item Options For Order
Listing Name
Multiple Highlight
Order and Shipping Tax
Order Channel Source
Order Customs Declaration Category Override
Order Date
Order Discount European Format
Order Discounts
Order GUID
Order Import Date
Order Line Status
Order Line Tax
Order Notes
Order Number
Order Number(Channel)
Order Packaging Name
Order Return ID
Order Ship By Date
Order Shipping Cost
Order Shipping Cost European Format
Order Shipping Cost Ex Vat
Order Shipping Tax
Order Status
Order Subtotal
Order Subtotal inc Tax
Order Subtotal Inc Tax European Format
Order Tax
Order Tax European Format
Order Total
Order Total European Format
Order Weight
Ordered Product Channel SKU
Ordered Product Name
Ordered Product SKU
Parent Order Number
Prime Order
Priority Order
Qty Sent - Quantity Sent
Quantity Ordered
Quantity Returned
Return Notes
Returned Date
Supplier Sent To
Picking & Packing Tokens:
Assigned By
Attention Required
Attention Required Message
Batch
Dispatched By
Packer
Pick Bin
Picker
Picker Special Instructions
Pickwave Created By - Shows SYSTEM when the pickwave was created automatically.
Requires Customs Declaration
Scanned Product Barcode
Special Instructions
Assigned By
Attention Required
Attention Required Message
Batch
Dispatched By
Packer
Pick Bin
Picker
Picker Special Instructions
Pickwave Created By - Shows SYSTEM when the pickwave was created automatically.
Requires Customs Declaration
Scanned Product Barcode
Special Instructions
Pricing & Tax Tokens:
Calculated Order And Shipping Tax
Calculated Order Total
Calculated Shipping Tax
Country VAT Number
Credit Note Reference
Currency Code
Currency Symbol
Exchange Rate
Item SubTotal - Single item price; kit components share the kit price equally.
Line Discount
Line Subtotal Raw
Line Total Plus Discount
Non Taxable Subtotal
Order SubTotal GBP
Order Total and Shipping Cost ex Tax
Order Total GBP
Pre Registration Tax Scheme
Single Item Tax
Single Price
Single Price Inc Tax
SubTotal
Subtotal inc Discount
Subtotal Inc Tax
Tax Class
Tax Class Formatted
Tax Externally Collected
Taxable Subtotal
Total
Total Line Exc VAT
Total Price
Total Price European Format
Calculated Order And Shipping Tax
Calculated Order Total
Calculated Shipping Tax
Country VAT Number
Credit Note Reference
Currency Code
Currency Symbol
Exchange Rate
Item SubTotal - Single item price; kit components share the kit price equally.
Line Discount
Line Subtotal Raw
Line Total Plus Discount
Non Taxable Subtotal
Order SubTotal GBP
Order Total and Shipping Cost ex Tax
Order Total GBP
Pre Registration Tax Scheme
Single Item Tax
Single Price
Single Price Inc Tax
SubTotal
Subtotal inc Discount
Subtotal Inc Tax
Tax Class
Tax Class Formatted
Tax Externally Collected
Taxable Subtotal
Total
Total Line Exc VAT
Total Price
Total Price European Format
Product Information Tokens:
Attribute Value
Country of Manufacture
Country of Manufacture Three Letter ISO Code
Country of Manufacture Three Number ISO Code
Country of Manufacture Two Letter ISO Code
Default Image
EAN - European Article Number (can also be known as IAN), a type of barcode.
ISBN - International Standard Book Number, a type of barcode used for publications.
Item Options
Last Cost Price Excluding VAT
MPN - Manufacturer Part Number
Parent Name
Parent Product Name
Parent SKU
PPI Image
Price
Price European Format
Product Cost
Product Harmonised Code
Product ID
Product Image
Product Name
Product Notes
Product Price
Product Price (Inc)
Product Price Inc European Format
Product Price Inc Tax
Product Price Inc Tax European Format
Product SKU
Product Special Attribute
Product Type Description
Product Weight
Product Weight Str
RRP
RRP European Format
SKU
Supplier SKU
UPC - Universal Product Code, a type of barcode.
Attribute Value
Country of Manufacture
Country of Manufacture Three Letter ISO Code
Country of Manufacture Three Number ISO Code
Country of Manufacture Two Letter ISO Code
Default Image
EAN - European Article Number (can also be known as IAN), a type of barcode.
ISBN - International Standard Book Number, a type of barcode used for publications.
Item Options
Last Cost Price Excluding VAT
MPN - Manufacturer Part Number
Parent Name
Parent Product Name
Parent SKU
PPI Image
Price
Price European Format
Product Cost
Product Harmonised Code
Product ID
Product Image
Product Name
Product Notes
Product Price
Product Price (Inc)
Product Price Inc European Format
Product Price Inc Tax
Product Price Inc Tax European Format
Product SKU
Product Special Attribute
Product Type Description
Product Weight
Product Weight Str
RRP
RRP European Format
SKU
Supplier SKU
UPC - Universal Product Code, a type of barcode.
Royal Mail Tokens:
RM AccountID
RM Department Reference
RM Items
RM Service Enhancement
RM Service Format
RM Service Level
Royal Mail Service Reference
RM AccountID
RM Department Reference
RM Items
RM Service Enhancement
RM Service Format
RM Service Level
Royal Mail Service Reference
Warehouse Tokens:
Total Units On Order
Unit Price Raw
Warehouse Address 1
Warehouse Address 2
Warehouse Address 3
Warehouse City
Warehouse Country
Warehouse County
Warehouse Name
Warehouse Post Code
Warehouse Zone
Total Units On Order
Unit Price Raw
Warehouse Address 1
Warehouse Address 2
Warehouse Address 3
Warehouse City
Warehouse Country
Warehouse County
Warehouse Name
Warehouse Post Code
Warehouse Zone
Other:
Blank Field
Current Date
Constant - A value that you choose that you want exported for each row in the export.
Blank Field
Current Date
Constant - A value that you choose that you want exported for each row in the export.
Comments
0 comments
Article is closed for comments.