The fields can be used in:
[order.increment_id]
or
{{var order.store.code}}
| Field | Notes | Shortcuts | Data Examples |
|---|---|---|---|
| order.increment_id | [order_id] | ||
| order.created_at | |||
| order.subtotal | |||
| order.grand_total | |||
| order.store.code | Available only as advanced format | ||
| order.store.name | Available only as advanced format | ||
| order.customer_id | |||
| billing.prefix | |||
| billing.firstname | |||
| billing.middlename | |||
| billing.lastname | |||
| billing.suffix | |||
| billing.company | |||
| billing.street | |||
| billing.city | |||
| billing.region | California | ||
| billing.region_code | Available only as advanced format | CA | |
| billing.postcode | |||
| billing.country_id | |||
| billing.telephone | |||
| billing.fax | |||
| shipping.* | Same as billing.* | ||
| po.increment_id | [po_id] | ||
| po.created_at | |||
| po.udropship_method | Shipping method | ups_03 | |
| item.sku | |||
| item.name | |||
| item.weight | |||
| item.price | |||
| item.qty | |||
| product_options | Custom product options of the order item | Option 1: Value 1; Option 2: Value 2 |
Header:
PO# Account# Shipper Name Address Delivery city State Zip sku quantity
Template:
[po_id] spfoxx UPS "[shipping.firstname] [shipping.lastname]" "[shipping.street]" residential "[shipping.city]" "{{var shipping.region_code}}" "[shipping.postcode]" "[item.sku]" "[item.qty]"
Output:
PO# Account# Shipper Name Address Delivery city State Zip sku quantity 198625 spfoxx UPS "NATE smith" "6666 MASSEY ST" residential DECATUR MS 88888 OP-TRPL-sdt 1 199097 spfoxx UPS "PAT DJohnson" "5555 WINDWARD" residential MASSILLON TX 47890 jh-ST-20-nhjo 1
Template:
H 401950 [order.created_at] [po_id] [shipping.firstname] [shipping.lastname] [shipping.street] [shipping.city] {{var shipping.region_code}} [shipping.postcode] [shipping.telephone] GROUND PO1 [item.qty] [item.price] [item.name] [product.description]
Output:
H 401950 2009456 199166 20091127 DONNA GEAD 9999 ALVIN RD CHARLOTTE CA 37589 492-222-2222 GROUND PO1 2 18.9 g5987 g5987-7 WINE GLASSES - SET OF TWO 14oz WINE GLASSES H 401950 2009456 199236 20091127 ALMA STAY 8888 POPPY LANE Los Angeles CA 95123 555-111-2222 GROUND PO1 1 15 GSHFS4-13 GSHFS4-13 16oz PINT ALE GLASSES - SET OF TWO
Header:
"Residential","country","ShipFNameLname","ShipLName","Shipcompany","ShipAddr","ShipCity","ShipState","ShipZip","OrderNumber","ShipPhone","Reference1","Reference2" Quantity SKU Name
Template:
"y","[shipping.country_id]","[order_id]"[shipping.firstname][shipping.lastname]","[shipping.lastname]","[shipping.company]","[shipping.street]","[shipping.city]","{{var shipping.region_code}}","[shipping.postcode]","[order_id]","[shipping.telephone]","[order_id]","[po_id]" [item.qty] [item.sku] [item.name]
The import template consists of 1 line, and will be used for order of fields and separator. The separator between 1st and 2nd columns will be used for all fields. The separator can be a space (multiple spaces will be ignored), tab, or other symbol (comma, semicolon, pipe, etc). The fields in imported file can be enclosed in double quotes.
| Field | Required | Example | Description |
|---|---|---|---|
| order_id | Yes* | 1000001 | order_id or po_id has to present, but not both |
| po_id | Yes* | 1000001-1 | |
| tracking_id | Yes | 1Z1234567890123456 | |
| shipping_date | 2010-04-01 | If not supplied, today's date will be used | |
| carrier | ups | Valid values: custom, ups, usps, fedex, dhl | |
| title | Some Custom Carrier | Free value title of the shipping method |
Template:
[po_id] [tracking_id] [shipping_date]
Input file:
10000001-1 1Z1234567890123456 2010-04-01 10000002-1 1Z2345678901234567 2010-04-02
Template:
[order_id];[tracking_id]
Input file:
10000001;1Z1234567890123456 10000002;1Z2345678901234567
At this time, for security purposes, file writing is allowed only into Magento's media/ or var/ folders and subfolders.
var/export/orders.txt
ftp://username:password@vendor.server.com/path/to/orders.txt
Only for importing
http://username:password@vendor.server.com/path/to/orders.txt
Only for exporting
mailto:autoprocess@vendor.server.com?from=admin@sample.store.com&subject=Orders export from sample store&body=Please find orders attached&filename=orders.txt
If filename is ”-” or empty, the exported orders will be set as email body.
mailto:autoprocess@vendor.server.com?from=admin@sample.store.com&subject=Orders export from sample store&filename=-
Add single or multiple CC or BCC:
mailto:autoprocess@vendor.server.com?from=admin@sample.store.com&subject=Orders export from sample store&cc=track@sample.store.com&bcc[]=bcc1@store.com&bcc[]=bcc2@store.com&filename=-