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

How to Import Ebay, Amazon, Playtrade, osCommerce, eBid, CRE Loaded, RomanCart and One Stop Order Processing Orders into MYOB Accounting

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

This solution uses One Stop Order Processing and MYOB Accounting

You can import your Ebay, Amazon, Playtrade, osCommerce, eBid, CRE Loaded, RomanCart and One Stop Order Processing orders into MYOB Accounting as a series of Item Sales, into a selected account. All orders are imported as a single customer (InternetOrders) 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 MYOB view isn't available you can Import the MYOB.mev view from the installation directory (e.g. C:\OSOP\Main). Or download from here:

2 Click on the Export Orders button (Export Orders). This will display the Export orders details dialog, shown below.



Click on the Export orders button.

This will create a csv file in the root of drive C. You can change this location.


3
Start MYOB Accounting


4 Create an Income account called InternetSales, shown below:




5 Click on the Details tab and select the relevant VAT code.




6 Create a new customer called InternetOrders.



You only need to enter the Name.


7 Create a product called Goods.



You need to enter the name of the product as Goods and also tick I Sell This Item. Change the Income account to InternetSales.


8 Select the File->Import Data->Sales->Item Sales menu option.


9 Change the Import File Format to Comma-separated, shown below:



Click on Continue.


10 Select the file to import (in this example C:\OSOP\MYOB.csv) and click on Open.


11 Click on Match All to map the fields, shown below:



Click on Import.


12 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.ebaypaper.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