Welcome to the One Stop Order Processing help desk
Knowledgebase - Click on the section titles to see more categories and articles: Magento > Importing Orders > Manual Import
How to Manually import your Magento Orders into One Stop Order Processing
Posted by OSOP Support, Last modified by Beth Rose on 23 March 2018 02:36 PM

Using Magento 1.6, 1.7 and 1.8 or below with One Stop Order Processing

You can import your orders from Magento into One Stop Order Processing. For more information about One Stop Order Processing click here. For more information about Magento click here.

NOTE: Support for importing orders from Magento 1.9 is included with One Stop Order Processing. Earlier versions of Magento require a paid for add-on supplied by a 3rd Party Company (current cost $15)

The following import method works with Magento version 1.6, 1.6.1, 1.6.2.0, 1.7, 1.8, 1.8.1.

To import your orders from Magento into One Stop Order Processing use the following procedure
:

1 Go to the following page and install the CSV & XLS Order Export extension.

http://design.fmo-group.com/magento-order-export.html

If you want to trial this extension for Magento click on the Click for Demo button (on the above website) 


2 
Once you have installed the extension (or used the demo site), login to your Admin page on your website (e.g. http://www.objeu627.co.uk/admin), example shown below:



3 
On the main Admin Panel select the System->Configuration menu option, shown below: 

Magento Admin Panel 


4 
. Once you are in the Configuration area, you will now need to select the different fields to export in the 'Export Field' area. As shown below, hold Control down and select the following fields:

Created At Original Price Shipping Street
Discount Amount Price Shipping Telephone
Grand Total Product Id Description
Increment Id Qty Ordered SKU
Order Currency Code Qty Shipped Weight
Shipping Amount Row Total Billing City
Shipping Description Tax Amount Billing Country Id
State Tax Percent Billing Email
Status Shipping City Billing First Name
Store Name Shipping Country Id Billing Last Name
Subtotal Shipping Email Billing Postcode
Tax Amount Shipping First Name Billing Street
Total Paid Shipping Last Name Billing Telephone
Name Shipping Postcode  

5 Once you have selected all the fields shown in the list, also make sure that the Use configuration product's info for export is set to Yes and Write order information only once is set to No , click Save Config at the top right, shown below:

Admin Panel Configuration 

6 
You now need to make sure that the fields are exported in the correct order for One Stop Order Processing to map. To do this click on the Config Page.
NOTE: 
You should click on Config Page AFTER clicking on Save Config.

7 You are shown the list of fields to export. You should put the numbers of the fields shown below next to the field where it appears on your screen. For example, if shipping_email appears as the fifth field put a 1 by that field in the right hand column (the Position column).

NOTE: The order of fields shown to you may not be the same as shown below. You should put the Position shown below next to the fields where they appear on your screen. When complete click on the Save button. 



8 
When you on the main Orders view (under the Sales->Orders menu option) tick any orders you would want to export and in the Actions field select Fmo Order Export, this will create and download a file for you to import into One Stop Order Processing, shown below. 

Magento Extension Export

9 
You can now import the orders into One Stop Order Processing. Click on the Import orders button ().

10 
In the Import Orders dialog click on the Add button and select Magento, shown below: 

11 You will now need to give the import a name and select an order file by clicking on the ... button, shown below: 

Select Magento Order File

12 In the OSOP Options, under 'Use OSOP compatible header for order import file', and insert the following header line:

Delivery Email,Order date,Item quantity,Delivery Telephone,Shipped Qty,Delivery Lastname,Delivery Address line 1,Delivery Postcode,Delivery Firstname,Delivery Country,Delivery Address line 3,Item weight,NA,Invoice Firstname,Invoice Email,Invoice Lastname,Invoice Postcode,Invoice Telephone,Invoice Address line 1,Invoice Country,NA,Listed on,Invoice Address line 3,Item ID,Item price,Item title,NA,Item total,SKU,VAT rate,Item tax,NA,Total P&P,Currency,Discount,Sub-total,Shipping method,Total Tax,NA,Grand total,Order ID

Magento Custom Header Fields

13 When you have entered the header line, click OK and continue by Importing the orders.

(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: