Différences

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

--- en:addons:amazon [2026/08/18 16:27] – [Settings] ics02
+++ en:addons:amazon [2026/08/18 16:47] (Version actuelle) – [Input file format] ics02
@@ Ligne 12: / Ligne 12: @@
 This screen allows you to select the default product categories for the import. The first is used for products and the second for any transport and delivery charges.
+===== Usage =====
+//**Access:** Business -> Import Amazon//
+{{:en:addons:amazon_02_en.png?nolink|}}
+The <badge>1</badge> button allows you to select the file to be processed, and the **Import** button triggers the processing.
+:WARNING: If a town is not found in the postcode file, it is automatically added. Please remember to 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:amazon_03_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.
+If the **Mapping file** box is ticked in the settings, a mapping file for Amazon and Gestan product codes can be uploaded.
+{{:en:addons:amazon_04_en.png?nolink|}}
+===== Input file format =====
+The input file must be an XLSX (or XLS) file. This is an export file generated by Amazon.
+:INFO: Some columns in the file will not be used during processing.
+<code>
+  A                 C               D              F             H              J            K          L           M
+ ORDER NUMBER | PURCHASE DATE | PAYMENT DATE | BUYER’S NAME | PRODUCT CODE | DESCRIPTION |  QUANTITY | CURRENCY | PRODUCT TOTAL (incl. VAT) |
+ N                           O                              P                  R              S                       T
+ PRODUCT TOTAL INCL. VAT | SHIPPING TOTAL INCL. VAT | SHIPPING VAT | RECIPIENT’S NAME | DELIVERY ADDRESS 1 | DELIVERY ADDRESS 2 |
+ V                      W                      X                      Y                Z                   AA
+ DELIVERY TOWN | DELIVERY REGION/COUNTY | DELIVERY POSTCODE | DELIVERY COUNTRY | RECIPIENT’S TELEPHONE | PAYER’S NAME |
+   AB                   AC                    AE               AF                      AG
+ INVOICE ADDRESS 1 | INVOICE ADDRESS 2 | INVOICE TOWN | INVOICE REGION/COUNTY | INVOICE POST CODE |
+   AH                    AL                       AR          AV            BC                            BD
+ INVOICE COUNTRY | DELIVERY INSTRUCTIONS | BUSINESS ORDER | COMPANY NAME | PRODUCT TOTAL EXCL. VAT | SHIPPING TOTAL EXCL. VAT
+</code>
+In the case of an Amazon 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 ^Comments^
+|3.A1.09.00 | 12/08/26 | Adapted for Gestan A1.09.01 |
+|3.A1.08.02 | 25/03/14 | Migration to A1 format |
+|3.15.46.02 | 25/03/14 | First beta version |
+|3.15.46.01 | 25/03/14 | First alpha version |
+\\ \\
+-----------------
+ℹ️ **Other ‘Extensions’ articles**
+[[fr:wiki:admin:extensions|How to install an extension]]
+<nspages en:addons -nbCol=2 -textPages="" -h1 -r -simpleLineBreak >