One Stop Order Processing
One Stop Order Processing |
|
Automatically importing One Stop Order Processing Orders (Custom import format)
This feature is available in Professional, Premium and Enterprise versions of One Stop Order Processing
You can automatically import orders in the OSOP using Automation for One Stop Order Processing. You can also click the Import button to import orders from a remote location.
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.
Order file
The file to import either a local PC file or a remote file.
Remote file
If this is a remote file (i.e. the Get file from remote server (e.g. internet site) is ticked) you can use wild cards (for example *.csv). If you use a wilcard, the first file that matches the criteria is downloaded. If you are using this approach you should also tick the Remove file after downloading button. For example, if you have a website that produces daily order files (e.g. 271013orders.csv and 281013orders.csv) you can use *.csv. This will download and load orders automatically.
If it is a remote file this should also include the path from the FTP root. This may be different from the website location. If you are unsure you can use the Test retrieving order file button to see if the folder is valid.
Local file
If it is a local file it should also include the drive and folder (e.g. C:\download\orders.csv).
Get file from remote server (e.g. internet site)
Tick this option to retrieve the orders file from a remote server that is running on a FTP server (on port 21).
Remote server
The remote server / host to retrieve the file from. This can be a website address or IP address.
Use passive FTP
If the server requires passive FTP support you can tick this option.
Port
The port to connect to the FTP server on. By default this is normally port 21.
Timeout
When the remote website is checked for files it can wait for a defined number of seconds before giving up. It is good to keep this to a small mumber (30 seconds) when you are setting up the connection, just incase the server name or other details are wrong.
Remove file after downloading
When you have downloaded an orders file you can remove it from the server. This should be ticked if you are importing files using a wildcard (e.g. *.csv) otherwise the same file may be imported each time.
Username
The username to use for the FTP login.
Password
The password to use for the FTP login.
Test retrieving order file
When you are setting the connection up you should click on this button to make sure the file can be retrieved. Any errors found are shown. If you have ticked Remove file after downloading the file will not be removed when testing (i.e. clicking on this button).
Other Information
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
If there is more than 1 item per 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 |
| 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 | |
| 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 | |