Need a query to extract product name, quantity sold and price for each product per year in Prestashop
$10-30 USD
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
Project ID: #15208470
About the project
31 freelancers are bidding on average $22 for this job
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
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
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
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 - ..
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
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
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
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
I can do the query in 2 - 3 hours. Habilidades y experiencia relevante SQL Htos propuestos $15 USD - Query
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
. 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