need sql expert to help make solution to delete many products from prestashop tables
£20-250 GBP
Tamamlandı
İlan edilme: 8 yıldan fazla önce
£20-250 GBP
Teslimde ödenir
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
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 3 gün içinde
5,0 (24 değerlendirme)
6,1
6,1
14 freelancers are bidding on average £148 GBP for this job
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
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
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
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.