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
same as for Import Orders
Field | Required | Example | Description |
---|---|---|---|
sku | Yes* | zol_g_med | sku or vendor_sku has to present, this required to find correct product |
vendor_sku | Yes* | zol_g_med-vendor1 | |
stock_qty | 10 | ||
stock_qty_add | 3 | ||
vendor_cost | 99.95 | supported if using multivendor add-on | |
stock_status | 0 or 1 for “out of stock” or “in stock” | supported if NOT using multivendor add-on | |
status | 0, 1, -1 for “inactive”, “active”, “pending” | status of vendor offer in multivendor data | |
priority | any numeric value | third parameter to check in decision method (after in stock and stock qty) |
Field | Required | Example | Description |
---|---|---|---|
vendor_price | 19.99 | vendor offer price | |
special_price | 17.99 | vendor offer special price during special from/to date range | |
special_from_date | 2015-05-01 | special price starting date | |
special_to_date | 2015-05-11 | special price ending date | |
state | New | offer state/condition defined in global/udropship/product_state config.xml node | |
state_descr | any text | state/condition detailed description | |
vendor_title | any text | promo title that will be included in offers table on product view page |
Template:
[sku] [vendor_sku] [stock_qty]
Input file:
zol_g_med zol_g_med-vendor1 10
Template:
[vendor_sku];[stock_qty_add]
Input file:
zol_g_med-vendor2;3
New vendor/product associations you can import only from admin area
Sales > Dropship > Batches import/export > Batches > Create Inventory Import Batch
Also you need to set “Yes” in
Configuration > Drop Shipping > Orders Batch Options > Allow import new vendor/product association with inventory import
Also if you do import of big files you might consider turn off logs, i.e. set “No” in
Configuration > Drop Shipping > Orders Batch Options > Save inventory import data in batch
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=-
this use general crontab format http://en.wikipedia.org/wiki/Cron
Daily at 7am UTC
0 7 * * *
Bi-Weekly monday/thursday 7am UTC
0 7 * * 1,4
Monthly 1 day of month 7am UTC
0 7 1 * *