Need a query to extract product name, quantity sold and price for each product per year in Prestashop

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

We need a query to generate the quantity sold and the price for each product in prestashop for each year. I can provide a database dump. We need to be able to export in excel/csv like the below example, I should be able to change the year in the query, for example to generate results for 2015, 2016 and 2017 separately.

Product | Quantity Sold | Price (CHF)

Product A | 446 | 49.95

Product B | 667 | 49.95

Product C | 553 | 49.95

Product D | 464 | 49.95

MySQL Prestashop SQL

Project ID: #15208470

About the project

31 proposals Remote project Active 6 years ago

Awarded to:

softechk

Hello, I have reviewed your project requirements. As mentioned in the project description, you need a query to generate the quantity sold and the price for each product in prestashop for each year. The results need to More

$18 USD in 1 day
(31 Reviews)
4.9

31 freelancers are bidding on average $22 for this job

yourbestcode

ONLY PAY WHEN YOU ARE COMPLETELY OK WITH MY WORK. I have read and understood all work requirement and I’m strongly confident to get the work done as your needs Regards, Trong Nguyen Relevant Skills and Experience I ha More

$24 USD in 1 day
(466 Reviews)
7.9
tomvnphp

Hi, I can develop a simple module to install to website admin, you can choose Year in dropdown to export Product, Quantity sold to CSV file. Thanks Relevant Skills and Experience I have more than 8 years experience in More

$35 USD in 1 day
(175 Reviews)
7.4
versacode

We are a group of electrical engineers and web developers. I understand that you would like to be able to export the mentioned details from your DB into CSV and we can write you a PHP script that can do this automatica More

$30 USD in 1 day
(48 Reviews)
5.9
softcarve

Hi, I would like to write a query to get quantity sold and price. please get in touch to discuss more. Relevant Skills and Experience sql Proposed Milestones $25 USD - after completion

$25 USD in 1 day
(93 Reviews)
5.8
weonlydo

Give me a small MySQL dump of your table/columns schema and I will send you back to query in no time at all. Relevant Skills and Experience MySQL volunteer previously on Experts Exchange, then StackOverflow. 10+ ye More

$15 USD in 0 days
(62 Reviews)
6.0
tarekfellah

Hello, I'm Prestashop expert, you can view my latest works on freelancer. Pay only when satisfied. Cordially. Relevant Skills and Experience PHP, MYSQL, Prestashop Proposed Milestones $20 USD - Create a query to retr More

$20 USD in 1 day
(49 Reviews)
5.4
ukgolang

I'll be able to supply you with the tested query within 24 hours. I will need access to a database dump with the relevant tables. Relevant Skills and Experience Ten years experience supporting Linux systems, and worki More

$20 USD in 1 day
(7 Reviews)
3.3
nidhi1509

A proposal has not yet been provided

$30 USD in 1 day
(6 Reviews)
3.0
jitendrabaraiya

hi i can do your job with accuracy. i have good knowledge of sql if you interested please reply me. Relevant Skills and Experience SQL Proposed Milestones $25 USD - ..

$25 USD in 1 day
(1 Review)
2.1
PavelStefan

Hello, I'm a PrestaShop Certified Developer with 5 years experience in PrestaShop and 7 years in programming. I created over 40 PrestaShop stores from scratch. Recently I developed 5 modules for my own which w More

$25 USD in 1 day
(2 Reviews)
0.7
etienneaubry

bonjour si vous le souhaitez je peux vous faire cela de suite Cordialement Expérience et Compétences appropriées prestashop html css Étapes proposées $20 USD - export csv

$20 USD in 0 days
(1 Review)
0.4
anirudhjdt

iam a expert in mysql Relevant Skills and Experience i have vast experience in mysql Proposed Milestones $25 USD - at end Additional Services Offered $1 USD - i a\can optimize database

$25 USD in 1 day
(0 Reviews)
0.0
m3skalina

Hi, It s very simple work! I can do in 1/2 hours. Thanks, Fabio

$20 USD in 1 day
(0 Reviews)
0.0
NandChavan

I am a software developer and have been working remotely for US/Can clients for past 10 year. I can start immediately, including VOLUNTARILY. Please contact me about the position. Relevant Skills and Experience Devel More

$25 USD in 1 day
(0 Reviews)
0.0
alexl02

I can do the query in 2 - 3 hours. Habilidades y experiencia relevante SQL Htos propuestos $15 USD - Query

$10 USD in 0 days
(0 Reviews)
0.0
MAYURI0069

I am a new freelancer,with lots of passion and eagerly waiting to work on a project and apply my knowledge for benefits of others. Relevant Skills and Experience I have knowledge of SQL. Proposed Milestones $10 USD More

$10 USD in 1 day
(0 Reviews)
0.0
JohnCSQL

This is a pretty straightforward query writer, happy to provide a script for future repeats. Relevant Skills and Experience 10+ years SQL dev Proposed Milestones $15 USD - Prep report from data dump and deliver scrip More

$15 USD in 1 day
(0 Reviews)
0.0
markingle

Update-able SQL query can be provided within 24 hours of receiving database dump along with very clear instructions how to update it for additional needs. Relevant Skills and Experience 20+ years of SQL experience. P More

$15 USD in 1 day
(0 Reviews)
0.0
neuzasilva10

. Habilidades e Experiência Relevantes I'm very experience doing queries to populate tables with more than 50 columns. Pré-pagamentos Propostos $25 USD - query

$25 USD in 1 day
(0 Reviews)
0.0
sandesh267

A proposal has not yet been provided

$27 USD in 2 days
(0 Reviews)
0.0