Hi all, I am offering $20 for someone to create an SQL query for me, with the details below:
For PrestaShop 1.7.2.4
SQL Query to export orders from 6th April 2019 >>> 5th April 2020.
NOTE:
- My store is multi-currency, but default currency is GBP. I want the order to be exported with the GBP value.
- Export must also include the TRACKING NUMBER related to that order
- Export only orders marked as "Shipped"
Example Result:
ORDERID - COUNTRY - NAME - ITEMSORDERED - GBP TOTAL - TRACKING NUMBER
3374,United States,John Doe,1,99.99,UH500736CN
(comma formatted or any format which I can easily put into Excel and turn into a table. I am not sure which is the best, I do not mind which as long as I can easily sort it into an Excel table)
itemsordered: numeric value
gbptotal: total value of order (in GBP only, base currency)
trackingnumber: the tracking number linked to that order.
Please Reply if you are interested and are able to make this for me, and I can make payment once confirmed working! I do not need a fancy module, just a working query which I can use in phpmyadmin or Prestashop backend.
Thank you very much!!