In Progress

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

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

Skills: MySQL, Prestashop, SQL

See more: Hello, we need native Arabic translator who have good English knowledge. We need to translate lots of religious articles from Ar, prestashop product quantity list, prestashop product price currency, design query extract invoices line items shipto information contact details invoice product supplier information lineitem produc, change prestashop price comparison site, prestashop imports products need unique, oscommerce quantity price breaks per product attributes, quantity price break per product attribute, quantity changes price order form html code, oscommerce quantity price breaks per product sample, office need util extract data dot files, excel web query extract data, price range prestashop, oscommerce quantity price breaks per product, quantity price breaks per product installation, oscommerce quantity price breaks per product attribute, quantity price breaks per product para oscommerce, install quantity price breaks per product, quantity price breaks per product

About the Employer:
( 2 reviews ) Pully, Switzerland

Project ID: #15208470

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
(23 Reviews)
4.7

33 freelancers are bidding on average $26 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
(444 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
(153 Reviews)
7.3
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
(37 Reviews)
5.2
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
(17 Reviews)
4.7
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
(23 Reviews)
4.7
aspireedge

Hey, I have 7+year of experience in website design and development in Prestashop. please share some more detail with me and discuss more with me. Looking forward your reply. Regards, Vipul Relevant Skills and Experie More

$55 USD in 1 day
(10 Reviews)
4.1
Europa17

Dear,[url removed, login to view] you for reviewing me I have just read your project description carefully. I am suitable for this work and have enough power . I will provide the best product to you as you wanted. Relevant Skills and E More

$100 USD in 1 day
(2 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
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
(1 Review)
1.6
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
kandiaga

Hi, I think you are looking for something similar to the module I already build, here is the details: [url removed, login to view] I can adapt to fit your needs. Relevant Skills and E More

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

I can handle this. I have 6 years experience on SQL Servers Relevant Skills and Experience SQL SERVER/MySQL Proposed Milestones $12 USD - Do the query

$12 USD in 1 day
(0 Reviews)
0.0
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
(0 Reviews)
0.0
sandesh267

A proposal has not yet been provided

$27 USD in 2 days
(0 Reviews)
0.0
Jastevens08

A proposal has not yet been provided

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

It's very simple to extract the required data with my logic.

$30 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$25 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