Finalizat

SQL queries for Prestashop 1.7.8

Job Description:

Hi all,

I am looking for a SQL programmer who can program specific SQL queries to be used in the Prestashop back-end to retrieve .csv files which are identical in columns/data as the Prestashop example .csv files to import the below into a new database.

Can you help me with this? Please read on.

Specific request:

Prestashop has the option to import the following through the back-end using sample csv files.

- Categories

- Products

- Customers

- Addresses

See attached those sample .csv files.

I want you to program an individual .SQL query to be used in the SQL manager of the back-end of Prestashop that gives an output identical to the columns required to fill the individual sample .csv files.

For example; 1 query for categories, 1 query for products, 1 for customers and 1 for addresses. A total of 4 queries.

Please note that the .sql query show give the exact information, formatted in the correct way (for example dates) and the columns should be in the right order (exactly as in the sample files).

I will provide access to a working back end to test the queries.

We would like to have this completed as soon as possible as for a skilled programmer this should be a fairly straightforward task!

Thanks

Aptitudini: MySQL, SQL, Prestashop

Despre client:
( 10 recenzii ) Voorhout, Netherlands

ID Proiect: #35099851

Acordat lui:

jeevanoss

Hi, I am a prestashop Expert. I had looked the CSV file. For generate the Product image URL we need a PHP or MYSQL function. I can do this task in 1 day I have 10 years of experience with PHP, MySQL & Javascript. La Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(210 Recenzii)
7.4

32 freelanceri licitează în medie 172$ pentru acest proiect

seefattechnologi

^^GET QUALITY WORK ON TIME ^^will definitely do it^^ Hello^^ I am Sql/Prestashop Developer and immediatel available to get start^^ I am having more than 9+ years experience with different CMS and frameworks. I can ens Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(46 recenzii)
7.6
shivmirthyusl

Hi Good day, I read your job details and I can help you in developing a SQL queries for each category such as category, products, customers and addresses which has to be used in the backend of Prestashop that gives an Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(80 recenzii)
7.6
cmitexperts

Hi there! Did go through your job description and glad to share that I have experience in working with Prestashop development platform. I have more than ten years of industry experience and have been the part of dive Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(88 recenzii)
6.8
techwelfare

PRESTASHOP EXPERTS! We are working on prestashop since last 11 years. We could do it. Could we discuss in details over chat now? Thanks & Regards Techwelfare

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 15 zile
(92 recenzii)
6.6
kamransiyal9

HI! I am an expert web programmer. I am familiar with Laravel and I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, Prestashop,JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can sta Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(65 recenzii)
6.1
vashishtrupinder

Hello I'm a Prestashop expert and FULL-Time Developer. I have checked the job description and I have some queries about your Project Let me know when you are available to discuss further Thanks Azad

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(39 recenzii)
5.9
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping u Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(33 recenzii)
4.7
mihailsbond

Hi sir, I have read your requirements carefully. I have rich experience of completing similar tasks several times. Being prompt and punctual is the key point to makes me standing out and I can start work right NOW. Onc Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(4 recenzii)
3.6
perfomancedev

Greetings! Thanks for your job posting. i read your project details and i understood. I can help you with your project at a high level! I have rich experience in MySQL & Prestashop developing. My skills and experienc Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(3 recenzii)
3.3
Valuesolutions

Hello, I hope this finds you well. I have just seen your project requiring; SQL Prestashop MySQL I believe that my 10-year experience in this field is what you need right away. Avoid the headache of looking further. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(1 părere)
3.3
MelkonyanM

1. senior Web developer. 2. versed in Prestashop, MySQL, PHP. If you award me the project, I will do best to show the satisfy result to you. Thanks.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(2 recenzii)
3.0
davisclaimer

Hi, there. I have read your project and can give you satisfication. If you are looking for an experienced person, please contact me and cooperate with me. Best regards. Thanks.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(2 recenzii)
2.8
harfarooqi

Hi Good day! I am proficient in oracle, sql, mysql and postgresql databases with 4 years of experience as a backend developer. Please feel free to contact and discuss more about the project. Best

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(2 recenzii)
1.2
kashyapgajera92

Hi, I have been working with mysql, prestodb and other SQL engines and languages for over 5 years now. Please connect in chat with more details and the backend db access and I can get started.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
0.6
bhaskar93yadav

Greeting of the day! As per your project requirement, would be able to work on your project, please share me more info I have been working as developer last 5 yrs. I have extensive experience as the Full-stack develo Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(2 recenzii)
0.0
nostr77

Hello! You're right, typical task. (1) Query, (2) transform in a specific format, (3) export to csv (4) test ability to import in a commercial application (your side). I don't see pitfalls. Ready to start immediately.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(1 părere)
0.0
adlisamy

Hi there I would like to offer you my services as i've been working with sql queries on daily basis (postgres,oracle) and i've faced different types of complexities, so i think i can be a good fit for this task. If th Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
ahsanazl

Hi. I am an SQL expert. I can writeSQL queries for the back-end of Prestashop. I have gone through your attachments. I will work with efficiency and effectiveness . Feel free to hire me. Best regards, Ahsan Afzal

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
WaheedDogar

Hi sir I could accomplish these 4 queries task in 1-3day depending on how quickly you click the Chat button for me at the rate of $30/query. The address CSV seems a different format. Best Regards Waheed

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
mitronald583

Dear Bart ⭐⭐⭐PHP + MySQL EXPERT⭐⭐⭐ I will Deliver ?100%? Satisfaction!!! Being a TOP Web Developer, I am very interested in the job you want. I am expertise in PHP(8 years), MySQL(5 years). I have developed so many p Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0