Module Prestashop

Bulk order import: CSV, Excel, JSON, XML and API, rules per customer

Let customers and staff import orders in bulk or one by one from CSV, Excel, JSON, XML or a REST API, with mapping templates, rules per group or customer, carrier and status control, approval and full history.

  • New

Order import Pro turns order files into real PrestaShop orders in a few clicks. Your B2B customers, retailers, sales reps, marketplaces or ERP send their orders the way they already produce them, and the module checks everything before creating them: no more manual typing, no more mistakes, and a huge time saving for your team and for your customers.

Every format, every channel: CSV and TXT (separator and encoding detected automatically), Excel .xlsx and .xls (read natively, no library to install), JSON and XML with nested product lines, rows pasted from a spreadsheet, a quick order form with product search, and a REST API with personal keys. Your team uses the same tools in the back office, for one customer or for many customers at once (customer read in the file, missing customers created on request), plus a manual entry form.

Mapping templates you configure once: drop an example file, the columns are read and mapped automatically (more than 25 order fields: order number, customer, delivery address or alias, carrier, status, message, currency, product by reference, EAN-13, UPC, ISBN, MPN, supplier reference or ID, quantity, price…). Default values, order grouping (by reference, per row or one order per file), decimal separator, Excel sheet, path of the orders in JSON / XML, status and carrier value mapping. Customers download a ready-to-fill example file (Excel, CSV, JSON, XML) from their account.

Access rules per customer group or per customer: allow or deny the import, choose the channels (file, quick order, API), the accepted formats and the templates. Free, limited or forced carriers. Order status per customer: "Payment accepted" for a key account paying by direct debit, "Awaiting payment" for another one, or the status read in the file. Payment method label, catalog prices or negotiated prices of the file, stock policy (reject, reduce the quantity, remove the line or allow backorders), saved or new delivery addresses, duplicate detection on the order number, quotas per import and per day, minimum amount, free shipping and approval by the merchant before creation. The most specific rule applies, and a tester shows which rule a customer gets.

Nothing is created blindly: every file is first analysed (dry run). The preview shows each order with its products, prices, address, carrier, status and estimated amount, and every error or warning with its row number. The user confirms, then the orders are created in chunks with a progress bar, through the standard PrestaShop order process (stock, invoices, emails, hooks of your other modules). Orders in error can be checked again later, and an error report gives back the original rows with an "Errors" column, ready to be fixed and imported again.

Follow everything: dashboard (imports, orders created, imported revenue, success rate, daily chart, channels, top customers, most frequent errors), import history with filters, detailed view with an activity timeline, approval workflow with reason sent to the customer, complete logs, email notifications to the customer and to the merchant, block on the order page (customer reference, file, rows) and on the customer page (rule applied, statistics). In the customer account, an "Order import" tab gathers file import, quick order, history, error reports and API keys.

Developers and ERP: REST API (orders in JSON or files, dry run, confirmation, status, imported orders with current status and tracking number), rate limiting, cron task for big imports and cleaning, hooks after each order and each import. Compatible with PrestaShop 1.7, 8 and 9, multistore, multilingual, without any override.

Features

  • Import from CSV / TXT, Excel .xlsx and .xls, JSON, XML, pasted rows
  • Quick order form with product search in the customer account
  • REST API with personal keys, dry run, status and order tracking
  • Back office import for one customer or many customers read in the file, manual entry
  • Automatic creation of missing customers (back office)
  • Mapping templates with sample file analysis and automatic column mapping
  • 25+ order fields: number, customer, delivery address or alias, carrier, status, message, currency, product, quantity, price
  • Products found by reference, EAN-13, UPC, ISBN, MPN, supplier reference or ID, combinations included
  • Default values, order grouping, decimal separator, Excel sheet, JSON / XML path
  • Status and carrier value mapping
  • Downloadable example files (Excel, CSV, JSON, XML) for the customers
  • Access rules per customer group or per customer, priorities and rule tester
  • Channels and formats allowed per rule
  • Free, limited or forced carriers, free shipping option
  • Order status per customer or read in the file, payment method label
  • Catalog prices or negotiated prices of the file
  • Stock policy: reject, reduce quantity, remove line or backorder
  • Saved or new delivery addresses, invoice address
  • Duplicate detection, quotas per import and per day, minimum amount
  • Approval by the merchant before creation, with reason sent to the customer
  • Dry run preview with errors and warnings per row
  • Creation in chunks with progress bar through the standard order process
  • Re-check of orders in error and re-importable error report
  • Dashboard: KPIs, daily chart, channels, top customers, frequent errors
  • History, detailed view, activity timeline and complete logs
  • Email notifications to the customer and to the merchant
  • Blocks on the order page, the customer page and the customer order detail
  • "Order import" tab in the customer account
  • Cron task (URL or command line) for queued imports and cleaning
  • Developer hooks after each order and each import
  • PrestaShop 1.7, 8 and 9, multistore, multilingual, no override
Tickets services
We intervene as soon as possible

It is sometimes necessary to intervene in an emergency agency to make changes to your Prestashop store. With the intervention ticket, Ether Creation, Prestashop solution expert, is committed to working on your shop during the day.

Installation and / or modification of a module, Adaptation of a theme, correction of graphic bugs, Graphic creation, Creation of an option or a feature, Training in the use of Prestashop, Etc.