$20 Reward - SQL Query to Export orders

[sampsonzak]

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!!

Edited January 8, 2021 by sampsonzak (see edit history)

[Prestachamps]

Hi, 

First of all the 20 bucks is not exactly what I would call a price ;)...I could imagine somebody getting rather offended. 

Anyhow, here are 2 points from my end : 

1. you should open this pulse inside Job Offers, and not here. 

2. https://addons.prestashop.com/en/data-import-export/47560-orders-csv-excel-export-pro.html - Put some money next to it, and there you have an existing option. It will help the developer and you get a  3 month free support next to it. I wouldn't call that expensive. 

I hope I managed to help, and the community is here to help you , usually for free. In case you have a project and some budget make sure you sue the Job Offer section. 

Kind Regards, 

Leo

Edited January 8, 2021 by Leo @ Prestachamps (see edit history)