Create a phpmyadmin query to find and replace a value in Magento 1 database
€8-30 EUR
Completed
Posted about 2 years ago
€8-30 EUR
Paid on delivery
Hi everyone,
I am looking for a freelancer who can help me to adjust the prices in category texts and page texts by means of find and replace within sql (phpmyadmin) (so not of the products themselves, because they have already been adjusted).
For example:
Everywhere where "€0.90" is visible now, gets replaced by "€1".
I assume this can be done with a sql query.
I would like to receive your help with this. Afterwards I like to see the query so that I can apply it for other words and values.
During the work we first work on a test server, then we transfer the files to the live server.
My budget for this task is €20.
Thanks in advance for your help!
Hi,
I have read your description carefully as per that you need to Create a phpmyadmin query to find and replace a value in Magento 1 database.
We have more than 8 years experience in this field and can perform your work.
So I can start work immediately as soon as we spoke more about your project.
I' ll provide you quality work according to your instructions.
Thanks!
Ambient Infotech
I would like to complete this now
I have rich experience of over 5 years in MySQL, MS SQL server in database queries, stored procedures, views, tables creations(manually, automation).
Hi, I have read description of your project, I can write sql query to update 0.90 with 1.
Message me in chat, to start work on it now and finish asap.
Thanks
Hello,
It looks like an easy job and can done by a simple query like "UPDATE products SET price=1 WHERE price=0.9".
I can work with screenshare. As you mentioned we can work on a development server or copy the table for backup and do the desired changes.
I have time to start to work right now. You can contact me for further details.
Best regards,
Ertugrul
Hi,
As the changes should be made in the MySQL database, I think Magento doesn't make any difference for this work. I can make a PHP/MySQL code to replace the fields you want, but I'd like to take a look at your database to see how it's set before. Thanks!
Hi there
I have worked with Magento before and inserted custom values into its db tables
I will make you the query that change the price from 0.9 to 1 euro in just 1 hour
Hey there!
I'am a fullstack web developer, linux system adminsitrator I think I can do it for you within a few hours. Yes it is a simple sql query, but first I will have some question about the database and the tables.
HI
the best way is download sql from database and make changes then upload
on that way u can make all thing changes right without any problem
im online
come to chat and lets talk
thanks
Hi there,
Hope you are doing well. I have seen your job requirements. I understand you are looking for a freelancer who can help you to adjust the prices in category texts and page texts by means of find and replace within SQL (phpmyadmin).
I can do this job perfectly as per your requirements. I will provide you an unlimited revision until you are happy & 100% satisfied.
Please feel free to message me via chat initiated. I am waiting for your kind response.
Thanks.