One Stop Order Processing
www.1stoporders.co.uk

How to Import Ebay, Amazon, SellerDeck, Shopify, Magento, osCommerce, BigCommerce, RomanCart, eBid, XCart, Oxatis, Groupon, Wowcher, Paypal, Cdiscount. ekmpowershop, Etsy, Flubit, OpenCart, PinnacleCart, PrestaShop, WooCommerce, Weebly, ChannelAdvisor, ASOS Marketplace, OnBuy, Mighty Deals , Mail Order and Telephone Sales into KashFlow

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

This solution uses One Stop Order Processing and KashFlow

You can import your Ebay, Amazon, SellerDeck, Shopify, Magento, osCommerce, BigCommerce, RomanCart, eBid, XCart, Oxatis, Groupon, Wowcher, Paypal, Cdiscount. ekmpowershop, Etsy, Flubit, OpenCart, PinnacleCart, PrestaShop, WooCommerce, Weebly, ChannelAdvisor, ASOS Marketplace, OnBuy, Mighty Deals , Mail Order and Telephone Sales into Kashflow 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 KashFlow 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 () and select Kashflow.

This will create an CSV file in the C:\OSOP folder. If required, you can change the name by selecting the Kashflow 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 Kashflow at https://www.kashflow.com

4 You will need to create a Kashflow customer to import all the orders into (InternetSales). If you want to import orders into different accounts (e.g. Ebay orders into one account, Amazon orders into another acount). You need the Code shown on the Create Customer page in the Customer Code, shown above. An example is shown below:




5 Select the Settings option from the left handside of the main screen, shown below:



6 Select the Import Data option, shown below:



7 Select the Import CSV files button, shown below :



8 Select CSV format and click on Next, shown below:


9 Select Invoice for the type of data to import and click on Next



10 Select the exported orders file (create by One Stop Order Processing). This file be created file as

C:\OSOP\KashFlow.csv

Then click on Upload. This is shown below:

11 Tick the My first row contains column headings. This will then automatically map all the fields. Click on the Import button to import the orders. An example, is shown below:

12 The orders should then be imported.

One Stop Order Processing allows you to import and process orders for Ebay, Amazon, SellerDeck, Shopify, Magento, osCommerce, BigCommerce, RomanCart, eBid, XCart, Oxatis, Groupon, Wowcher, Paypal, Cdiscount. ekmpowershop, Etsy, Flubit, OpenCart, PinnacleCart, PrestaShop, WooCommerce, Weebly, ChannelAdvisor, ASOS Marketplace, OnBuy, Mighty Deals , Mail Order and Telephone Sales