Đang Thực Hiện

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

Kỹ năng: MySQL, Prestashop, SQL

Xem thêm: 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

Về Bên Thuê:
( 2 nhận xét ) Pully, Switzerland

Mã Dự Án: #15208470

Đã trao cho:

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 Thêm

$18 USD trong 1 ngày
(23 Đánh Giá)
4.7

33 freelancer đang chào giá trung bình $26 cho công việc này

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 Thêm

$24 USD trong 1 ngày
(444 Đánh Giá)
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 Thêm

$35 USD trong 1 ngày
(153 Đánh Giá)
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 Thêm

$15 USD trong 0 ngày
(62 Đánh Giá)
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 Thêm

$20 USD trong 1 ngày
(37 Đánh Giá)
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 Thêm

$30 USD trong 1 ngày
(17 Đánh Giá)
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 trong 1 ngày
(23 Đánh Giá)
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 Thêm

$55 USD trong 1 ngày
(10 Đánh Giá)
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 Thêm

$100 USD trong 1 ngày
(2 Đánh Giá)
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 trong 1 ngày
(1 Đánh Giá)
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 Thêm

$20 USD trong 1 ngày
(1 Đánh Giá)
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 Thêm

$25 USD trong 1 ngày
(2 Đánh Giá)
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 Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
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 trong 0 ngày
(0 Đánh Giá)
0.0
sandesh267

A proposal has not yet been provided

$27 USD trong 2 ngày
(0 Đánh Giá)
0.0
Jastevens08

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
Venkyi

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

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0