need sql expert to help make solution to delete many products from prestashop tables

£20-250 GBP

Completed

Posted

over 8 years ago

£20-250 GBP

Paid on delivery

hello, i have a prestashop site which is very unique in that the database contains millions of products and is very large. i need to reduce the size of the product database and so I need a way to bulk remove many products (approx 300,000 and above). i have been told that this must be done with care, as the products have links to many tables. i don't have a list of the products to delete, but i have the list of brands i want to delete (so using condition e.g. brand= "abc", delete all products with brand = "abc" from all tables, without bugs/errors. FREELANCER MUST BE VERY GOOD AT SQL AND UNDERSTAND PRESTASHOP DATABASES

Software Architecture

SQL

Project ID: 8827191

About the project

14 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@DragonOfDev

hi, Nice to meet you. I read your project carefully and understand your requirement fully. And I am very interesting your project. I have some skill and experience for this job as you see my profile. I can complete your project within 3 days without bugs. I wish you working with me. regards.

£233 GBP in 3 days

5.0

(24 reviews)

6.1

14 freelancers are bidding on average £148 GBP for this job

@bhaskarmandal

Hi, I am 5 years experienced web developer. I understand your points . I have previous experience this type of work. I can start this project now. Please check my profile for my work quality . Thanks, Bhaskar Mandal

£150 GBP in 3 days

4.9

(21 reviews)

4.7

@charlesmaxlin

I have good experience in developing applications for Mysql database, Please contact to discuss the requirements in detail. Regards, Charles

£150 GBP in 3 days

5.0

(13 reviews)

4.7

@logicalsoft

A proposal has not yet been provided

£77 GBP in 3 days

4.9

(19 reviews)

4.9

@markelof

Hi, I'm carefully read your project description. I can do it quickly without mistakes. I can promise you quality work without mistakes.

£75 GBP in 1 day

5.0

(19 reviews)

4.2

@kubust

I work everyday with huge volumens of data. I can help You within three days. Just contact in case of questions.

£222 GBP in 3 days

5.0

(8 reviews)

4.4

@ahmednayl12345

hello i can do that am db administrator and sql expert you can depend on me to do that wating for you thanks

£50 GBP in 1 day

5.0

(7 reviews)

3.9

@vishaltile

We are SQL professionals and we will deliver you in less time with quality for sure. Experts with more than 10 yrs of exp.

£111 GBP in 1 day

4.7

(10 reviews)

3.7

@slenders13

Dear client, I have a lot of experience with SQL Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

£100 GBP in 3 days

4.5

(5 reviews)

3.9

@fsarcosfree

Hi there, i can backup your db and do so test on another environment before we upload the new one to be sure that we won't have bugs/error and also i will maintain your db consistency =). SQL is my second language this is what i do every day i've been working as a DBA for more than 3 years and also i have a lot experience working with large DB (datawarehouse) so if you're interested please inbox me to discuss about details. Best regards, Flavio Sarcos

£130 GBP in 3 days

0.0

(0 reviews)

0.0

@xquite

Hello! I'm very good at SQL and relational databases. I will take a backup of your database, and create a query with which I will methodically execute your required conditions. I will meet your requirements. I would like us to discuss this further. Thank you.

£190 GBP in 3 days