Jump to content

$20 Reward - SQL Query to Export orders


Recommended Posts

Posted (edited)

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 by sampsonzak (see edit history)

Share this post


Link to post
Share on other sites
Posted (edited)

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 by Leo @ Prestachamps (see edit history)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More