Table of Contents
uDropshipBatch configuration reference
Templates
Export Orders
Format
The fields can be used in:
- simple format, using square brackets:
[order.increment_id]
or
- advanced format, using Magento CMS templating conventions:
{{var order.store.code}}
Fields
| 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 |
Examples
Sample Vendor 1
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
Sample Vendor 2
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
Sample UPS WorldShip Integration
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]
Import Orders
Format
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.
Fields
| 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 |
Examples
Sample Vendor 1
Template:
[po_id] [tracking_id] [shipping_date]
Input file:
10000001-1 1Z1234567890123456 2010-04-01 10000002-1 1Z2345678901234567 2010-04-02
Sample Vendor 2
Template:
[order_id];[tracking_id]
Input file:
10000001;1Z1234567890123456 10000002;1Z2345678901234567
Import Inventory
Format
same as for Import Orders
Fields
| 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) |
Price Comparison add-on specific Fields
| 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 |
Examples
Sample Vendor 1
Template:
[sku] [vendor_sku] [stock_qty]
Input file:
zol_g_med zol_g_med-vendor1 10
Sample Vendor 2
Template:
[vendor_sku];[stock_qty_add]
Input file:
zol_g_med-vendor2;3
Import new vendor/product associations
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
Import Products
This corresponds to vendor edit > preferences > Batch Products Import section.
All settings here are similar to Import Orders and Import Inventory except that it misses Import Template configuration.
The expected import file format depends on your setup in Configuration > Vendor Products Edit > Vendor Product Edit Form > Fieldsets. To get the template or the example file visit vendor portal Product Bulk Upload Single menu item where you can download them.
In case you import products from shopify using our Unirgy_Shopify module use shopify://* as value for Import Products Source Location setting.
Source/Destination Locations
Local File
At this time, for security purposes, file writing is allowed only into Magento's media/ or var/ folders and subfolders.
Examples
var/export/orders.txt
Remote FTP
Examples
ftp://username:password@vendor.server.com/path/to/orders.txt
Remote HTTP
Only for importing
Examples
http://username:password@vendor.server.com/path/to/orders.txt
Email attachment
Only for exporting
Examples
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=-
Schedule cron format
this use general crontab format http://en.wikipedia.org/wiki/Cron
Examples
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 * *
