One Stop Order Processing
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
Stop Order Processing and MYOB
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:
on the Export Orders button (). This will display the Export orders details
dialog, shown below.
Click on the Export
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:\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.