This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
udropship:batch:reference [2015/10/30 20:12] wtsergo |
udropship:batch:reference [2021/12/29 13:55] wtsergo [Import Products] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== uDropshipBatch configuration reference ====== | ||
+ | ===== Templates ===== | ||
+ | |||
+ | ==== Export Orders ==== | ||
+ | |||
+ | === Format === | ||
+ | |||
+ | The fields can be used in: | ||
+ | * simple format, using square brackets: < | ||
+ | * advanced format, using Magento CMS templating conventions: | ||
+ | |||
+ | === 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# | ||
+ | </ | ||
+ | Template: | ||
+ | < | ||
+ | [po_id] spfoxx UPS " | ||
+ | </ | ||
+ | Output: | ||
+ | < | ||
+ | PO# Account# | ||
+ | 198625 spfoxx UPS "NATE smith" "6666 MASSEY ST" residential DECATUR MS 88888 OP-TRPL-sdt 1 | ||
+ | 199097 spfoxx UPS "PAT DJohnson" | ||
+ | </ | ||
+ | |||
+ | == Sample Vendor 2 == | ||
+ | Template: | ||
+ | < | ||
+ | H 401950 [order.created_at] [po_id] | ||
+ | </ | ||
+ | Output: | ||
+ | < | ||
+ | H 401950 2009456 199166 20091127 | ||
+ | H 401950 2009456 199236 20091127 | ||
+ | </ | ||
+ | |||
+ | == Sample UPS WorldShip Integration == | ||
+ | Header: | ||
+ | < | ||
+ | " | ||
+ | </ | ||
+ | Template: | ||
+ | < | ||
+ | " | ||
+ | </ | ||
+ | |||
+ | ==== 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' | ||
+ | | 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] | ||
+ | </ | ||
+ | |||
+ | Input file: | ||
+ | < | ||
+ | 10000001-1 1Z1234567890123456 2010-04-01 | ||
+ | 10000002-1 1Z2345678901234567 2010-04-02 | ||
+ | </ | ||
+ | |||
+ | == Sample Vendor 2 == | ||
+ | |||
+ | Template: | ||
+ | < | ||
+ | [order_id]; | ||
+ | </ | ||
+ | |||
+ | Input file: | ||
+ | < | ||
+ | 10000001; | ||
+ | 10000002; | ||
+ | </ | ||
+ | |||
+ | ==== Import Inventory ==== | ||
+ | |||
+ | === Format === | ||
+ | |||
+ | same as for Import Orders | ||
+ | |||
+ | === Fields === | ||
+ | |||
+ | ^ Field ^ Required ^ Example ^ Description ^ | ||
+ | | sku | Yes* | zol_g_med | ||
+ | | vendor_sku | Yes* | zol_g_med-vendor1 | | | ||
+ | | stock_qty | | 10 | | new stock qty value | ||
+ | | stock_qty_add | | 3 | | stock qty could be incremented/ | ||
+ | | 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 " | ||
+ | | 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/ | ||
+ | | state_descr | | any text | state/ | ||
+ | | 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] | ||
+ | </ | ||
+ | |||
+ | Input file: | ||
+ | < | ||
+ | zol_g_med zol_g_med-vendor1 10 | ||
+ | </ | ||
+ | |||
+ | == Sample Vendor 2 == | ||
+ | |||
+ | Template: | ||
+ | < | ||
+ | [vendor_sku]; | ||
+ | </ | ||
+ | |||
+ | Input file: | ||
+ | < | ||
+ | zol_g_med-vendor2; | ||
+ | </ | ||
+ | |||
+ | === Import new vendor/ | ||
+ | |||
+ | New vendor/ | ||
+ | ''// | ||
+ | Also you need to set " | ||
+ | ''// | ||
+ | Also if you do import of big files you might consider turn off logs, i.e. set " | ||
+ | ''// | ||
+ | |||
+ | ==== 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 '' | ||
+ | The expected import file format depends on your setup in // | ||
+ | In case you import products from shopify using our '' | ||
+ | |||
+ | |||
+ | ===== Source/ | ||
+ | |||
+ | ==== Local File ==== | ||
+ | |||
+ | At this time, for security purposes, file writing is allowed only into Magento' | ||
+ | |||
+ | === Examples === | ||
+ | |||
+ | < | ||
+ | var/ | ||
+ | </ | ||
+ | |||
+ | ==== Remote FTP ==== | ||
+ | |||
+ | === Examples === | ||
+ | |||
+ | < | ||
+ | ftp:// | ||
+ | </ | ||
+ | |||
+ | ==== Remote HTTP ==== | ||
+ | |||
+ | **Only for importing** | ||
+ | |||
+ | === Examples === | ||
+ | |||
+ | < | ||
+ | http:// | ||
+ | </ | ||
+ | |||
+ | ==== Email attachment ==== | ||
+ | |||
+ | **Only for exporting** | ||
+ | |||
+ | === Examples === | ||
+ | |||
+ | < | ||
+ | mailto: | ||
+ | </ | ||
+ | |||
+ | If filename is " | ||
+ | < | ||
+ | mailto: | ||
+ | </ | ||
+ | |||
+ | Add single or multiple CC or BCC: | ||
+ | < | ||
+ | mailto: | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== Schedule cron format ===== | ||
+ | |||
+ | this use general crontab format http:// | ||
+ | |||
+ | === Examples === | ||
+ | |||
+ | Daily at 7am UTC \\ | ||
+ | 0 7 * * * | ||
+ | |||
+ | Bi-Weekly monday/ | ||
+ | 0 7 * * 1,4 | ||
+ | |||
+ | Monthly 1 day of month 7am UTC\\ | ||
+ | 0 7 1 * * |