Welcome to the One Stop Order Processing help desk



 
How to import your Presta Shop Orders Into One Stop Order Processing
Posted by Zoe Strassen, Last modified by Beth Rose on 14 August 2018 10:02 AM
The following guide explains how to import orders from Presta Shop into One Stop Order Processing.

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

You can manually import your orders by using the order export module you can purchase and have a go at the demo at the following link.

https://addons.prestashop.com/en/data-import-export/17596-orders-csv-excel-export.html

To create a compatible order export with OSOP using the Presta Shop Order Export module do the following:

(insert pic of main page)

On this page you will need to set the following fields to equal the following:

- File format = CSV
- Date format = Y-m-d H:i:s
- Each product has a seperate line = Yes 

You will then need to Click on the Filter Fields Tab.

You will need to move the following fields in the following order across to the right hand column.

Order ID, Total Products( with Tax), Total shipping(with tax), Payment Method, Carrier Name, Payment date, Order comment (message), Invoice Customer first name, Invoice Customer last name, Invoice phone, Invoice Other, Invoice address line 1, invoice address line 2, invoice city, Invoice Zip/Postal Code, invoice Country Name, Invoice company, Product ID, Product Name, Product Quantity, Product Unit Price(Incl Tax) 

You can then export your orders.



To import your Presta Shop Order Export file do the following:

  1. Click the Orange import orders button.
  2. Click Add
  3. Click "OSOP or other Shopping carts (CSV format)
  4. Name your import and attach your exported file
  5. Click next
  6. Change the date format to DD/MM/YYYY HH:MM:SS
  7. Tick use OSOP compatible header for order import file 
  8. Copy and paste the following header into the box.

    Order ID,Sub-total,Total P&P,Payment method,Shipping method,Order date,Delivery Instructions,Invoice Firstname,Invoice Lastname,Invoice Telephone,Invoice Fax,Invoice Address line 1,Invoice Address line 2,Invoice Address line 3,Invoice County,Invoice Postcode,Invoice Country,Invoice Company,Item ID,Item title,Item quantity,Item price

  9. Tick Order totals include Tax ( if you charge VAT on your orders)
  10. You can then import orders.


Tip: This module also allows an automatic order export to an email address when new orders are found
(0 vote(s))
Helpful
Not helpful

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