====== 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 | | new stock qty value | stock_qty_add | | 3 | | stock qty could be incremented/decremented instead of set as in prev fielf | 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 * *