PRESTIMPORT: Prestashop Interface

This extension allows you to import Prestashop order data into Gestan invoices.

Configuration is carried out via the Tools → Application Settings → Extension Settings menu.

This screen allows you to select the product family for any transport and delivery charges. It also allows you to configure the VAT rates used.

The Country tab allows you to import a country mapping file if this differs from the default one.

Access: Business → Prestashop Import

The 1 button allows you to select the file to be processed, and the Import button triggers the process.

If a town is not found in the postcode file, it is automatically added. Please check that the information is correct before importing the data.

If the products in the file support stock management, stock movements are automatically created. Any stock alerts will be displayed in the Stock Alerts tab.

Some alphabets may not be recognised by the extension. The relevant row will then be displayed in red and the relevant columns will show “Unrecognised characters”. You can edit these elements directly in the table before importing the data.

The input file must be an XLSX (or XLS) file. This is an export file generated from Prestashop.

Some columns in the file will not be used during processing.

         B           F               I                 J                 K                     K                  L               M
 Order code | Conversion rate | Product reference | Quantity | Customer’s first name | Customer’s surname |  Customer’s email | Delivery country |
         N                    O                    P                  R             U                  V                 W
 Delivery Address 1 | Delivery Address 2 | Delivery Postcode | Delivery Town | Payment Amount | Payment Currency |  Total Product Price (excl. VAT) |
      AC                 AF                          AG                         AL                             AM                
 Comments | Total Product Price (incl. VAT) | Total VAT on Products | Total Amount Paid (incl. VAT) | Total Delivery Cost (incl. VAT) |
         AN                                       AO                           AT                        AU                  AV                    
 Total Delivery Cost (excl. VAT) | Total Amount Paid (excl. VAT) | Unit Price (excl. VAT) | Product price incl. VAT | Product minimum order value excl. VAT |
                  AW                           BA        BB          BF                  BG                BJ                 BK                   
 Product minimum order value incl. VAT | VAT rate | Total VAT | Buyer’s first name | Buyer’s surname | Invoice address 1 | Invoice Address 2 | 
          BL                    BN                   BO                BP                BQ
 Invoice Country | Invoice Region/Province | Invoice Postcode | Invoice Town | Billing Company

In the case of a Prestashop order containing several products, there will be several lines with the same order number. These lines will contain the same information, except for the products.

ℹ️ Other ‘Extensions’ articles

How to install an extension