Différences

Ci-dessous, les différences entre deux révisions de la page.

--- en:addons:prestimport [2026/08/26 13:44] – créée ics02
+++ en:addons:prestimport [2026/08/26 14:34] (Version actuelle) – [Versions] ics02
@@ Ligne 9: / Ligne 9: @@
 Configuration is carried out via the Tools → Application Settings → Extension Settings menu.
-{{:fr:addons:prestimport_01.png?nolink|}}
+{{:en:addons:prestimport_01_en.png?nolink|}}
 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.
-{{:fr:addons:prestimport_02.png?nolink|}}
+{{:en:addons:prestimport_02_en.png?nolink|}}
 The **Country** tab allows you to import a country mapping file if this differs from the default one.
 ===== Usage =====
+//**Access:** Business -> Prestashop Import//
+{{:en:addons:prestimport_03_en.png?nolink|}}
+The <badge>1</badge> button allows you to select the file to be processed, and the **Import** button triggers the process.
+:WARNING: 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.
+:INFO: 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.
+{{:en:addons:prestimport_04_en.png?nolink|}}
+:INFO: 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.
+===== Input file format =====
+The input file must be an XLSX (or XLS) file. This is an export file generated from Prestashop.
+:INFO: Some columns in the file will not be used during processing.
+<code>
+         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
+</code>
+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.
+===== Versions =====
+^Version ^Date ^Notes^
+|3.A1.09.01 | 26/08/26 | Adapted for Gestan A1.09.01 |
+|3.A1.08.02 |27/07/25| Migration to A1 format |
+|3.15.46.01 |08/07/25| First beta version |
+|3.15.46.00 |07/07/25| First alpha version |
+-----------------
+ℹ️ **Other ‘Extensions’ articles**
+[[en:wiki:admin:extensions|How to install an extension]]
+<nspages en:addons -nbCol=2 -textPages="" -h1 -r -simpleLineBreak >