Welcome to the One Stop Order Processing help desk



 
Knowledgebase: Xero
How to Export your orders into Xero
Posted by Zoe Strassen, Last modified by Zoe Strassen on 14 December 2018 12:27 PM

How to Export your orders into Xero

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

 For a full video tutorial on how to export your orders into Xero click here.

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 You will need to add the Xero view, you can do this by clicking the menu option View-> Add-> Accounts-> Xero

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.



Using One Stop Order Processing with eBay, Amazon, Magento, Shopify, Etsy, Onbuy, Flubit, X-Cart, eBid, SellerDeck, Oxatis, CubeCart, osCommerce, Interspire,CRE Loaded, ekmPowershop, Pinnacle Cart, Rakuten, RomanCart, Paypal, Asos, WooCommerce , PrestaShop, Groupon, Weebly, Mail Order, Telephone Sales, CDiscount,OpenCart, Channel Advisor, Royal Mail, MyHermes, UKMail, DPD, Yodel, UPS, Metapack, Parcel 2 go, Quickbooks, Sage, Xero, Parcelforce and Stripe

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).