One Stop Order Processing |
|
Using WooCommerce with One Stop Order Processing
You can import your orders from WooCommerce into One Stop Order Processing. For more information about One Stop Order Processing click here. For more information about WooCommerce click WooCommerce.
NOTE: This requires the WooCommerce paid for add-on from:
http://www.woothemes.com/products/ordercustomer-csv-export
To import your orders from WooCommerce into One Stop Order Processing use the following procedure:
1 Login
into your website by clicking on logging into your Administration area (e.g. http://www.mywebsite29.co.uk/admin).
2 Support for 2 of the most popular WooCommerce plugins have been built into One Stop Order Processing. These 2 import add-ons are described below:
Order/Customer CSV Export (paid for Add plugin)
This is available from:
http://www.woothemes.com/products/ordercustomer-csv-export/?utm_source=product&utm_medium=upsell&utm_campaign=wcaddons
When importing select WooCommerce Format 1. This plugin allows you to automate the export of orders from your website (these can then be automatically imported into One Stop Order Processing (using Professional or higher).
2 Select the Orders menu option , shown below.
3 Select the orders to export or tick Order. Click on the Export button, shown below.
4 Select the Selected orders, Plain CSV file and click on the Export Orders button, shown below. This will save the orders file to you computer.
5 You are now ready to import the orders into One Stop Order Processing using the OSOP Import format.
6 In the Options for the new import type, set the Date Format to the first type (DD/MM/YY HH:MM:SS).
7 Tick the Use OSOP compatible header for order import file.
8 Use the following value for the Custom format:
Order ID,NA,Order date,Payment Status,Total P&P,Total P&P tax,Fees,NA,Total Tax,NA,NA,Discount,Grand total,NA,Currency,Payment method,Shipping method,NA,Invoice Firstname,Invoice Lastname,Invoice Company,,Invoice Telephone,Invoice Address line 1,Invoice Address line 2,Invoice Postcode,Invoice Address line 3,Invoice Address line 4,Invoice Country,Invoice Country,Delivery Lastname,Delivery Address line 1,Delivery Address line 2,Delivery Postcode,Delivery Address line 3,Delivery Address line 4,Delivery Country,Delivery Company,Delivery Instructions,Item title,SKU,Item quantity,Item tax,Item total,NA,Item title2,NA,NA,NA,NA,NA,NA,NA
9 If you untick the 3 check boxes at the bottom of the options.
10
In the main Import dialog if you untick Split VAT out if you have included tax information on your website. If you don't include VAT in your shipping untick Adjust shipping VAT (in the Adjust Tax options on the import dialog).