How to import Open Cart Orders into One Stop Order Processing

How to import Open Cart Orders into One Stop Order Processing

This guide will show you how to import your Opencart Orders into One Stop Order Processing

This feature is available in the Lite, Professional, Premium and Managed versions of One Stop Order Processing.

1 Install the following extension

http://www.opencart.com/index.php?route=extension/extension/info&extension_id=3749&filter_search=sales report

They provide a demo login so you can see how it works before purchasing their add on.

2 After installing the extension to export the orders do the following:

3 Login to your OpenCart shop

4 Select the Reports->Sales->ADV Orders menu option

5 Setup any order filtering required and then select the Export button

6 Select the XLS button on the (all details) order export.

7 Open the saved file in Excel (or other XLS file reader), shown below:



8 Save the file as a CSV file (CSV (Comma delimited)(*.csv) format

9. Open the import dialog

10 Click New -> OSOP Format

11. Name your import and attach your file.

12. Click Ok

13. Choose "Opencart" from the drop-down bar in the "Order File Format" section.

10. Click Ok

11. Click Import to import your orders into the software.

Importing your file into One Stop Order Processing

1. Open One Stop Order Processing

2.Click import 



3. Click add

4. Choose ' Other Shopping Carts'



5. Click 'Next'

6. Name your import and attach your file 

7. Click Ok

8. Choose Open cart from the custom hedaer drop down bar.

9. Import your orders. 

Please note : 

If you are using V3 of Open cart or higher you will need to resave your file with a data type of ANSI before importing.  The following steps show you how. 

1. Open the order file in Notepad 
2. Follow the menu option File -> Save as 
3. Change the Encoding to ANSI