Existing WordPress Website - Update prices at will in Woo-commerce via SQL script.

Update prices in Woo-commerce via SQL script.

We have an existing WordPress site using woo-commerce to sell products.

We have a large number of products and these products are split into categories and the majority of products are variable products.

We have tried using plugins and the bulk price updater in WordPress/Woo-commerce but both either time out (server restrictions) or fail mid point leaving us having to find out where it failed and resume updating prices manually.

I understand this can be done directly in SQL via script but possibly needs a cache to be cleared to display new prices.

I'd like to be able to update the prices in any particular category (and ideally brand - which is split by product tags) via an SQL script, which we can run on the database whenever needed (on whichever product category (and/or brand) we need to update).

We would need instructions on running the script to ensure we could replicate this task when needed.

Ideally the script will allow for prices to be updated by $ amount.

WordPress 5.2.2

Woo commerce V3.65 but will be updating to 3.7 imminently.

MySQL - 5.5.5-10.2.26-MariaDB

We can either supply a copy of the database and/or a Dev site for testing purposes once the project has been awarded.

Skills: PHP, WordPress, MySQL, HTML, SQL

See more: website update prices, wordpress existing html website, can update existing flash website, convert existing php website wordpress web site, copy existing wordpress website, convert existing joomla website wordpress, feed wordpress blog existing coldfusion website, integrate wordpress existing html website, move wordpress installation update sql, update existing consulting website joomla, update existing html website, convert existing wordpress website responsive, working existing wordpress website, newsletter and discount option for existing shop in wordpress (woo commerce), newsletter and discount option for existing shop in wordpress woo commerce, woo commerce wordpress website developer, refresh / update an existing wordpress website, existing wordpress website, edit existing wordpress website, Wordpress, Woo Commerce, Magento, Prestashop, E Commerce, Website Design

About the Employer:
( 3 reviews ) Perth, Australia

Project ID: #20784094

32 freelancers are bidding on average $195 for this job


Hi sir, After carefully reviewing the experience requirements for the job description, we feel that we are suitable for the job. Our latest WordPress projects are: [login to view URL], [login to view URL], 18.218 More

$203 USD in 3 days
(1137 Reviews)

Hi there, So would you be updating the prices (across selected categories / brands) by $ amounts (either plus / minus)? OR would you like a percentage price update? I have a 99% project completion rate and a 4.99 rep More

$198 USD in 3 days
(1042 Reviews)

I CAN DO IT Hello Employer Please send me details and do final deal. I am ready to start work right now, I assure for this project that i can do it as per your need. Kindly initiate chat. Thank you

$180 USD in 3 days
(435 Reviews)

Hello, I will create script to import large number of update in prices via SQL script in any particular category. I will complete this work in 3 days. Looking for your reply to start this work immediately. I will be a More

$84 USD in 3 days
(1292 Reviews)

Hello. Wordpress development expert ready to help you with price update functionality. I have more 400 good reviews and more 9 years of development experience behind, so all will be done with best quality and timeframe More

$250 USD in 5 days
(560 Reviews)

Hi Sir/Mam, I have 5+ years of experience in native android app development, I am confident that I can finish it very soon. Also I will use cloud based server so you dont need to pay any server charges . Regards,

$190 USD in 7 days
(472 Reviews)

Greetings! My name is Lucky. We would love to have the opportunity to discuss your project with you. Surely, we are ready to help you to update prices in Woo-commerce via SQL script Included: - Will be update the pri More

$200 USD in 5 days
(464 Reviews)

Hi, I am vastly experience in developing WordPress sites. I have already design and developed 400+ websites in wordpress. I have also developed many Wordpress plugins. I am working on this for years. I can develop any More

$250 USD in 5 days
(282 Reviews)

Hi There, Greetings of the day!! I've read/gone through your job description and interested to work in your project. I am an experienced woocommerce website developer, Develop near about 550 websites. I can build a More

$700 USD in 7 days
(236 Reviews)

Hello, I just completed a customization project with Variable Product plugin of WooCommerce. I can write a SQL script to update the product prices for your WooCommerce website which is later compatible with 3.7 versio More

$250 USD in 5 days
(282 Reviews)

Hello, I've read your project description and I want to tell you that I can Update prices in Woo-commerce via SQL script in your Existing WordPress Website for you as per your [login to view URL] have a quick chat to More

$90 USD in 10 days
(195 Reviews)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] h More

$140 USD in 7 days
(131 Reviews)

Hello I understand whole requirements carefully as i read all things i m ready to work with you I am very confident that you will be completely satisfied with the quality, timeliness, and professionalism of my work. More

$199 USD in 7 days
(359 Reviews)

Hello . . When dealing with large data process such as updating db, add, delete, etc. I usually utilize partial progress/pagination where we don't execute the process at once, Instead we split them to be, for example More

$200 USD in 5 days
(116 Reviews)

Hello, How are you today ? I am good in html, css ,javascript,php,mysql. I am a talent Web designer & developer with WordPress,shopify,prestashop. My aim has always been to produce websites that look beautiful and pro More

$140 USD in 7 days
(116 Reviews)

Hi, i hope you're doing well. I've just read your project's description and i would like to help you with it. I'm an experienced web developer with the necessary Wordpress, WooCommerce and SQL skills for getting this More

$80 USD in 1 day
(246 Reviews)

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on it with more than 7 years experience. Please feel free to contact me. I am looking forward to hear from you. More

$130 USD in 2 days
(141 Reviews)

Hi, Can i have link of the website? I can help you to update the prices in any particular category via an SQL script .Need to check site once . Let’s get on a chat if you are available I am among the 2% specialist More

$250 USD in 7 days
(32 Reviews)

Hello I can handle this task. While reading your job description carefully, I thought I am the best candidate for this task. So, I am waiting for your response here. Please ping me. I will share my portfolios in our PM More

$750 USD in 7 days
(43 Reviews)

Hello Sir, I understand project scope but having few questions that needs to be clear in more detail. Please let me know if we can discuss the requirement over chat or call. I am working from last 12 years in PHP More

$140 USD in 7 days
(44 Reviews)