Différences

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

--- en:addons:amazon [2026/08/18 16:30] – [Usage] ics02
+++ en:addons:amazon [2026/08/18 16:47] (Version actuelle) – [Input file format] ics02
@@ Ligne 32: / Ligne 32: @@
 {{: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 >