One Stop Order Processing
One Stop Order Processing for Ebay, Amazon, RomanCart, SellerDeck/Actinic, CubeCart, Rakuten, eBid, ekmPowershop, Magento, Pinnacle Cart, Shopify, Actinic Online/Oxatis, osCommerce, X-Cart, CRE Loaded, Interspire and other Systems, Mail Order and Telephone Sales
www.1stoporders.co.uk

How to Import Ebay, Amazon, X-Cart, eBid, SellerDeck, Actinic, Magento, CubeCart, osCommerce, BigCommerce, Interspire,CRE Loaded, ekmPowershop, Pinnacle Cart, Shopify, RomanCart, Paypal, Mail Order and Telephone Sales into Xero

This feature is available in Professional, Premium and Enterprise versions of One Stop Order Processing

This solution uses One Stop Order Processing and Xero

You can import your Ebay, Amazon, X-Cart, eBid, SellerDeck, Actinic, Magento, CubeCart, osCommerce, BigCommerce, Interspire,CRE Loaded, ekmPowershop, Pinnacle Cart, Shopify, RomanCart, Paypal, Mail Order and Telephone Sales into Xero as a series of Invoices, into a selected account. All invoices are imported as a single customer (Sales) for a single product (Goods). The total invoice cost and VAT is split into the relevant accounts.

The following instructions explain how to set this up.

1 If the Xero view isn't available you can Import the view from the installation directory (e.g. C:\OSOP\Main) or click here. For information on how to import views click here.

2 Tick the orders to export and click on the Export Orders button (Export Orders) and select Xero.

This will create an CSV file in the C:\OSOP folder. If required, you can change the name by selecting the Xero View and selecting the View->Change Export Options menu option or click on the button to the right of the View selection field ().

3 Login to Xero at https://login.xero.com/

4 Follow the menu option Accounts -> Sales menu option, shown below.



5 click on Import button, shown below:



6 Ignore Step 1 and Step 2, click Browse and select the file export from One Stop Order Processing (by default, C:\OSOP\Xero.csv). Tick Yes, update contact details with imported address details and Tax - inclusive, shown below:

7 Click on Import.

NOTE : Orders will be imported into the Xero Sales Account. If you want to import this into a different Xero account you should create a new account (In Xero, in the Settings->Report->Chart of Accounts page). The Tax is split at 20%. You can change this to a different rate (or use different Tax rates using a macro) by changing the value of the *TaxType field in the Xero One Stop Order Processing view.

8 The orders should then be imported.


Mole End Group of Companies
www.mole-end.biz
www.1stoporders.co.uk
www.integratedlabels.co.uk
www.invoicepaper.co.uk
www.palletpaper.co.uk
www.baypaper.co.uk
Products, plugins and utilities for Actinic Desktop and 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 Integrated Label Paper in Bulk, by the pallet. In Stock and ready for Despatch. Print Ebay Invoices with a peel out label with the customer's details on directly from Ebay