2017-02-16
Rating 5 stars - 1 votes

How to Import Orders to PrestaShop

When you decide to move data to new website for some reason, you’d like to copy orders, since they keep essential information about sales, made at your store throughout definite period of time. To make this task less challenges and more consistent, you may consider Store Manager for PrestaShop.


PrestaShop import orders facility has been introduced to Store Manager for PrestaShop PRO Edition recently (version 2.29.1.1683). Using this or newer application version, you can accomplish order transfer through import wizard.


This extended tutorial covers the entire procedure of PrestaShop order import from .csv performed through Store Manager and contains screen captures for better visualization.


What Fields Should PrestaShop Import Orders File Include?

In order to create order record through import, it is obligatory to have data in the following .csv file columns:

  • Order ID – this field stands for order ID
  • Order Reference – insert order number in this field
  • Payment Method – indicate payment method used by customer for each order to be created
  • Payment Module – add payment module respectively in this column
  • Total Discount – provide order total discount value
  • Total Paid – insert total paid value
  • Total Price for Products – specify total product price in the file
  • Total Price for Product without Tax – indicate total product price excluding tax value
  • Total Shipping – indicate total delivery cost value
  • Total Wrapping – add wrapping cost for each order you are going to import
  • Status – order status must be specified in this field
  • Gender – customer gender must be indicated (Mr./Mrs.)
  • Firstname – specify customer firstname
  • Lastname – add customer lastname
  • Customer E-mail – email address of customer, that has place the order, should be specified here
  • Delivery Address 1 – indicate shipping address for order to be imported
  • Delivery City – specify what order delivery city is
  • Invoice Address 1 – make sure this field contains invoice address
  • Invoice City – add city name in this field
  • Product Name – provide name of product, each of imported order contains
  • Product Quantity – indicate how many items of each product the order contains
  • Product Price – specify regular product price
  • Product Reference – insert ordered product reference in this column

Each order takes separate row in the import file. If an order contains more than one product, it takes as many rows as many products have been ordered. Order details will be duplicated for each of items.


Download sample of .csv file for order import Click to Download


Having these details you will be able to create order record at target PrestaShop store. If you want to create customer or addresses, they should be specified in the source file. Generally, all the characteristics of PrestaShop import orders file can be gleaned from exporting existing orders via export wizard respectively. Detailed order export guidance is in this post – https://www.prestashopmanager.com/useful-articles/prestashop-orders/export-prestashop-orders-quickly-and-with-ease/


Configuring PrestaShop Import Orders Settings

Before you upload .csv storing sales, you need to configure settings within PrestaShop order import wizard. Keep to steps outlined below and consider highlighted recommendations to create orders properly.


  1. Navigate to Tools->Import/Export->Import/Export orders or access order import wizard from Order section of Store Manager. Click Import action at the starting page.


  2. Select .csv or .txt file sales information is arranged in.


  3. Make sure file delimiters are set properly and look through data in preview box.


  4. Import Orders to PrestaShop FREE with Store Manager for PrestaShop

    Import Now

  5. Set identifiers for all entities and complete mapping configuration on the following PrestaShop order import from .csv step

  6. 1. Order identifier – it is possible to identify orders by Order Reference or Order ID. Both fields are required and must be filled in source file.



    Whatever identifier you select from this dropdown, its value should be unique for each order. If, for example, you select reference as identifier, and there are two orders having identical reference, only one order will be created in the process of PrestaShop order import from .csv.



    2.Customer identifier – this dropdown lists two options – customer ID and e-mail address. In case customers are available at store, you import orders to, you can identify them by ID. On contrary, e-mail address must figure as identification method.



    3.Address identifier – Prestashop import orders wizard lets you identify addresses by multiple fields – first name, address 1, city, VAT number, etc. It is recommended to apply several fields to make addresses identification more accurate. Address ID can be used as identifier if it exists for current customer at target store.



    4.Product identifier – check box for product details that will be used as identifier.



    The mapping process can be fulfilled easily in case .csv file columns are titled identically to database fields, what is true if you exported file with Store Manager. Ensure all required fields as well as identifiers are mapped.



  7. Set import options at the last step of sales import.

  8. First you need to choose between two import methods – “Add Only” or “Just Add”.


    The first method lets you create orders by selected identifier (when Reference is chosen as identifier) without checking whether order with such an identifier already exists at PrestaShop.


    You can also notice “Update product stock” checkbox at this step. This option lets you subtract stock for products (if they exist at PrestaShop store, to which you import orders) if imported orders contain them.




  9. Having set these options, confirm order import and view summary.



    PrestaShop order import is certainly an important part of data transfer that can be performed flawlessly with Store Manager for PrestaShop application.