One Stop Order Processing
One Stop Order Processing |
|
Importing One Stop Order Processing Orders (Custom import format)
You can import
information that has been exported from One Stop Order Processing (using the
OSOPExport view) or another application that can export a single CSV order information
file (e.g. Excel).
If you tick the Update information in existing orders option on the main
page you can import information into existing orders. This can be useful for
adding order tracking or other information from external systems. See the Advanced
Import section for more details.
Import file
format
The import
file is a standard CSV (Comma Separated Value) file. The first line contains
the field names separated by a comma (,). Each subsequent line contains values
for those fields, each value being separated by a comma (,). Microsoft Excel
can export information as a CSV file. You can create a template (example CSV
file) by using the One Stop Order Processing OSOPExport view and exporting
an order.
The order import
file can contain any of the fields described below, in any order. If you do
not know any of the information for a field don't include the field in the file
to import. Any information not supplied is defaulted from the other information
supplied. This is described below.
Minimum requirements
for an import file
You must have at
least 1 of the red fields and 1 of the green
fields in your import file to create a valid One Stop Order Processing order.
Including orders with more than 1 item or Updating orders
If there is more than 1 item per order or you want to update an existing order you must include a value for Order
ID (the
first value). Order lines with the same Order
ID are
imported into the same order. The first line in a group of order lines contains
the main order details. The subsequent order lines contain details for the other
order's items (and read from the Item ID, Item title, SKU, Item quantity,
Item price, Item tax, Item P&P, Item P&P tax, Item total, VAT rate, Item weight
fields).
|
Field
Name |
Description | Default
value If not included this value is used |
| Order ID | Unique Order number (e.g. 100006) | Invoice number |
| Transaction ID | Transaction ID (e.g. 72838485) | Order number |
| Invoice number | Invoice number (e.g. INT1001) | Automatically allocated from last sequential invoice number (setup in the import options), Order ID of not allocated. |
| Sales source | Where the order came from (e.g. MOTO) | OSOP |
| Listed on | Where the sale was listed (e.g. Website) | |
| Order number | Order number (e.g. 1023) | Order ID, then Invoice number |
| Sub-total | Total of all items sold (e.g. £85) | Total of all items in order |
| Discount | Discount applied to Sub-total | 0 |
| SubTotal tax | Total tax paid on all items sold (e.g. £15) | Total of all items' tax in order |
| Total P&P | Postage and Packing for all items (e.g. £10) | Total of all items' P&P |
| Total P&P tax | Tax on Postage and Packing (e.g. £1.75) | Total of all items' P&P Tax |
| Insurance | Insurance on whole order (e.g. £2) | |
| Insurance Tax | Insurance tax on whole order (e.g. £0.35) | If Tax rate given the required tax is split out from Insurance |
| Total Tax | Total of all Insurance, P&P and Items sold tax (e.g. £17.10) | Total of Insurance, P&P and Items tax |
| Grand total | Total of all items, Insurance and P&P and Taxes (e.g. £114.10) | Total of all Taxes, Insurance, P&P and Items |
| Fees | Any fees on sale (e.g. £5.70) | |
| Payment method | Payment type used for order (e.g. Paypal) | |
| Shipping method | Method used to send item (e.g. RoyalMail) | |
| Payment Status | Payment status of order. This can be one of the following values: |
Full Payment Received |
| Order date | Date order was placed (e.g. 16/09/2007 19:11:44) | Checkout Date, then Invoice Date and then Today's date |
| Invoice date | Invoice date. This is the Tax date/ point (e.g. 16/09/2007 19:11:44) | Order Date |
| Checkout date | Date checkout was completed (e.g. 16/09/2007 19:11:44) | Order Date |
| Payment date | Date payment was taken for order (e.g. 16/09/2007 19:11:44) | |
| Dispatch date | Date order was dispatched (e.g. 17/09/2007 16:00:00) | |
| Currency | Currency character used for monetary values (e.g. £) | Grand Total currency used |
| Paypal ID | Paypal transaction ID (e.g. 923849238928) | |
| PO num | Customer's Purchase Order number (e.g. OT412) | |
| VAT Number | Customer's VAT (TAX) code (e.g. 615 323 101) | |
| Total weight | Toal weight of order (e.g 1.02KG) | Total of all order items' weights |
| Delivery Instructions | Delivery instructions for courier (e.g. Leave in garage) | |
| Delivery Instructions2 | Delivery instructions #2 for courier (e.g. Leave in garage). These are added onto the end of the current delivery instructions (as specified in Delivery Instructions) | |
| Courier | Courier to use to send this order. (e.g. UPS) | |
| Tracking ID | Tracking ID to use (e.g. 1Z849 5674 671) | |
| Tracking Info. | Additional tracking information, (e.g. Next Day) | |
| Total items | Total number of items in the order (e.g. 2) | Total number of orders' items |
| Feedback left | Any feedback to give to customer (e.g. Good shopper) | |
| Notes | Notes on order. These can be amended or added to in the order's memo tab (e.g. Call customer when despatched) | |
| Feedback received | Comments received from customer (e.g. Excellent customer service) | |
| Invoice Customer | Customer name (e.g. John Symthe) | |
| Invoice Firstname | Customer firstname (e.g. John). This and the next field are combined to the Invoice Customer | |
| Invoice Lastname | Customer lastname (e.g. Smythe) | |
| Invoice Telephone | Customer Telephone number (e.g. 555 123 456) | |
| Invoice Fax | Customer Fax number (e.g. 555 654 321) | |
| Invoice Email | Customer's email address (e.g. support@tk.co.uk) | |
| Invoice Address line 1 | First line of address (e.g. Sparechton House) | |
| Invoice Address line 2 | Second line of address (e.g. 12 Parchdale Road) | |
| Invoice Address line 3 | Third line of address (e.g Farletontington) | |
| Invoice Address line 4 | Fourth line of address (e.g. Xexton) | |
| Invoice County | County (e.g. Wessex) | |
| Invoice Postcode | Postcode / Zip code (e.g. ZX2 5QC) | |
| Invoice Country | Country (e.g. United Kingdom) | |
| Invoice VAT number | Customer's VAT number (e.g. 615 323 101) | |
| Invoice Buyer ID | Buyers ID, username, login name or handle (e.g. filetpn63743) | Invoice Email, then Invoice Customer |
| Invoice Company | Company name (e.g. Aprelton Spares Ltd) | |
| Delivery Customer | Delivery customer name (e.g. Amy Smythe) | Invoice Customer |
| Delivery Firstname | Delivery firstname (e.g. Amy). This and the next field are combined to the Delivery Customer | |
| Delivery Lastname | Delivery lastname (e.g. Smythe) | |
| Delivery Telephone | Delivery customer Telephone number (e.g. 555 323 466) | Invoice Telephone |
| Delivery Fax | Delivery customer Fax number (e.g. 555 234 281) | Invoice Fax |
| Delivery Email | Delivery customer's email address (e.g. deliveries@tk.co.uk) | Invoice Email |
| Delivery Address line 1 | Delivery first line of address (e.g. Sparechton Warehouse) | Invoice Address line 1 |
| Delivery Address line 2 | Delivery second line of address (e.g. 14 Larch Close) | Invoice Address line 2 |
| Delivery Address line 3 | Delivery third line of address (e.g Fox Business Park) | Invoice Address line 3 |
| Delivery Address line 4 | Delivery fourth line of address (e.g. Grosgripe) | Invoice Address line 4 |
| Delivery County | Delivery county (e.g. Wessex) | Invoice County |
| Delivery Postcode | Delivery postcode / Zip code (e.g. ZS5 7IK) | Invoice Postcode |
| Delivery Country | Delivery country (e.g. United Kingdom) | Invoice Country |
| Delivery VAT Number | Delivery customer's VAT number (e.g. 615 323 101) | Invoice VAT Number |
| Delivery Buyer ID | Delivery buyers ID, username, login name or handle (e.g. filetpn63743) | Invoice Email, then Invoice Customer |
| Delivery Company | Delivery company name (e.g. Aprelton Spares Ltd) | Invoice Company |
| Customer Name | Customer name in single value format Name, Email, Phone Number (e.g. "Bob Bobbins, customer@email.com, 01234567890") | |
| Customer Address | Custoer address in single value format Customer Name, Address Line 1, Address Line 3, County, Post Code, Country. (e.g."Customer Name, 1 Road Name, City, County, AB1 2CD, United Kingdom") | |
| Item ID | Sales ID of item. This is normally unique (e.g. 832478325) | SKU |
| Item title | Description of item (e.g. Fluffy Dog in box) | SKU |
| Item title2 | Description of item #2. This value is added onto the end of the current Item title. If the import format has separate fields for the item (e.g. item size and colour) you can use these extra title fields to add all the details to the item title. | |
| Item title3 | Description of item #3. This value is added onto the end of the current Item title. If the import format has separate fields for the item (e.g. item size and colour) you can use these extra title fields to add all the details to the item title. | |
| Item title4 | Description of item #4. This value is added onto the end of the current Item title. If the import format has separate fields for the item (e.g. item size and colour) you can use these extra title fields to add all the details to the item title. | |
| Item title5 ... Item title20 | Additional value to add to the end of the current Item title. This allows for up to 20 values that contain information that needs to be included in the item title | |
| Item Message | Item message. This can be used as the gift message for this order line. | |
| Item Field1 ... Item Field5 | Additional field information. You can put any additional information for your order in this field. e.g. Box size for this item in the order | |
| SKU | Your own part number of item (e.g. IL1) | Item ID then Item title |
| Item quantity | Number of the item ordered (e.g. 1) | 1 |
| Item price | Cost of item. This can include tax (if you want to automatically split the tax out use the adjust orders to split VAT out in the import options) (e.g. £4.50) | Item total / Item quantity |
| Item tax | Tax on item (e.g. 0.79) | Can be calculated from Item price if you use the adjust orders to split VAT out in the import options. The tax (VAT) rate is taken from the VAT rate, unless this is blank. If it is the VAT rate used in the import options is used. |
| Item P&P | This item's postage and packing. The total P&P is the total of all the items' P&P, unless this field is left empty and the main P&P field is used (e.g. 0.55) | |
| Item P&P tax | This item's postage and packing tax (e.g. 0.10) | Can be calculated from Item price if you use the adjust orders to split VAT out in the import options. The tax (VAT) rate is taken from the VAT rate used in the import options is used. |
| Item total | Total cost of item(s), quantity * Item price (e.g. £50) | Item price * Item quantity |
| VAT rate | VAT rate specific to this product (e.g. 5%) | VAT rate given in Adjust orders to split VAT value in main import options. |
| Item weight | All the item's in this orderline's weight (e.g. 2KG) | |
| Shipped Qty | Number of these item's shipped (e.g. 2) | Item quantity (if item has been shipped) |
| Email Sent #1 | Has the first email setup been sent? (e.g. 1) | |
| Email Sent #2 | Has the second email setup been sent? (e.g. 0) | |
| Email Sent #3 | Has the third email setup been sent? (e.g. 1) | |
| Email Sent #4 | Has the fourth email setup been sent? (e.g. 0) | |
| Colour | RGB value for colour of item | |
| Actual Courier | Courier sent with (where label has been created) maybe different from what the customer is shown. e.g. Amazon Shipping | |
| Actual Tracking ID | Tracking ID used to identify consignment with Courier. e.g. Royal Mail Signed For 2nd Class Small Parcel (Drop Off) | |
| Actual Tracking Info. | Service sent with in the form the Courier will understand. e.g. 29d33ae4-811a-4b06-868f-e39bc43 | |
| nCourier | Internal ID for courier (value from IL_CourierFields.ini file). e.g. 1 | |
| nService | Internal ID for service (value from IL_CourierFields.ini file). e.g. 132 | |
| sTrackingImage | Image for label used. e.g. [_cf12110902270.PNG] | |
| sLabelPrintDate | Time and date when the label was printed. e.g. 11/12/2018 09:02:00 | |
| nLabelStatus | 0 if created (and the sLabelCourierDate field has a value in ). 1 if the label has been created and printed | |
| sLabelCourierDate | Label creation time and date. e.g. 11/12/2018 09:07:00 | |
| Width | Width of order. e.g. 10 | |
| Height | Height of order. e.g. 20 | |
| Depth | Depth of order. e.g. 30 | |
| Customer Name | Customer name in the form name, email, telephone. These are split into the correct fields. e.g. Bob Parchdale, bparch@me76h4.net, 0555 123 456 | |
| Customer Address | Address in the form Delivery name, Address line 1, City, County, Postcode (ZIP), Country. e.g. Bob Parchdale, 10 The Marchings, Palmdale, Wesex, WE14 2EA, UK | |
| Item Trans | Unique transaction ID used to identify this item line to make orders as shipped (used when orders are merged). e.g. 203-3546897-7887514 | |
| Item Cost Price | Cost price of the item sold. Used for Profit calculation, useful when cost price of items varies over time. e.g. 10.52 | |
| Custom:Entered val. 1 | These are values that a specific to your business or from the another application. These values appear on the Custom Value tab on each order. | |
| Custom:Entered val. 2 | ||
| Custom:Entered val. 3 | ||
| Custom:Entered val. 4 | ||
| Custom:Entered val. 5 | ||
| Custom:Entered val. 6 | ||
| Custom:Entered val. 7 | ||
| Custom:Entered val. 8 | ||
| Custom:Entered val. 9 | ||
| Custom:Entered val. 10 | ||
| Custom:Entered val. 11 | ||
| Custom:Entered val. 12 | ||
| Custom:Entered val. 13 | ||
| Custom:Entered val. 14 | ||
| Custom:Entered val. 15 | ||
| Custom:Entered val. 16 | ||
| Custom:Entered val. 17 | ||
| Custom:Entered val. 18 | ||
| Custom:Entered val. 19 | ||
| Custom:Entered val. 20 | ||
| Custom:Entered val. 21 | ||
| Custom:Entered val. 22 | ||
| Custom:Entered val. 23 | ||
| Custom:Entered val. 24 | ||
| Custom:Entered val. 25 | ||
| Custom:Entered val. 26 | ||
| Custom:Entered val. 27 | ||
| Custom:Entered val. 28 | ||
| Custom:Entered val. 29 | ||
| Custom:Entered val. 30 | ||
| Custom:Entered val. 31 | ||
| Custom:Entered val. 32 | ||
| Custom:Entered val. 33 | ||
| Custom:Entered val. 34 | ||
| Custom:Entered val. 35 | ||
| Custom:Entered val. 36 | ||
| Custom:Entered val. 37 | ||
| Custom:Entered val. 38 | ||
| Custom:Entered val. 39 | ||
| Custom:Entered val. 40 | ||
| Custom:Entered val. 41 | ||
| Custom:Entered val. 42 | ||
| Custom:Entered val. 43 | ||
| Custom:Entered val. 44 | ||
| Custom:Entered val. 45 | ||
| Custom:Entered val. 46 | ||
| Custom:Entered val. 47 | ||
| Custom:Entered val. 48 | ||
| Custom:Entered val. 49 | ||
| Custom:Entered val. 50 |
Advanced Import
To import information into existing orders you only need to include the Order
ID and the required information (e.g. Delivery Instructions). You
can not include an order's item details (e.g. product codes), but you can include
all other order details (including Custom Entered values). An example of a CSV
is shown below. This can be edited in Microsoft Excel and exported as a CSV
file.
Order ID,Delivery Instructions,Custom:Entered val. 1
426-8234341-9441161,Leave with neighbour if out,JJ98324928
283-61188984-5408319,Leave with neighbour if out,TY342334
402-48239431-2828328,Leave with neighbour if out,KL123123
129-11112346-3745908,Leave with neighbour if out,DS823748
277-8758482-2751516,Leave with neighbour if out,RB819283
One Stop Order Processing allows you to import and process orders for Ebay, Amazon, SellerDeck, Shopify, Magento, osCommerce, BigCommerce, RomanCart, eBid, XCart, Oxatis, Groupon, Wowcher, Paypal, Cdiscount. ekmpowershop, Etsy, Flubit, OpenCart, PinnacleCart, PrestaShop, WooCommerce, Weebly, ChannelAdvisor, ASOS Marketplace, OnBuy, Mighty Deals , Mail Order and Telephone Sales
Mole End Group of Companies |
|||||
| Products, plugins and utilities for SellerDeck | All your orders, from all your systems, all together in one simple-to-use application | Integrated label invoice paper and free software packages and templates. Print your invoice and labels at the same time | Print Amazon Despatch Notes with a peel out label with the customer's details on directly from Amazon | Print Ebay Invoices with a peel out label with the customer's details on directly from Ebay | |