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.

Habilidades: PHP, WordPress, MySQL, HTML, SQL

Veja mais: 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

Acerca do Empregador:
( 3 comentários ) Perth, Australia

ID do Projeto: #20784094

38 freelancers estão ofertando em média $197 para esse trabalho


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 Mais

$203 USD in 3 dias
(1109 Comentários)

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 Mais

$198 USD in 3 dias
(1032 Comentários)

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 Mais

$84 USD in 3 dias
(1275 Comentários)

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 dias
(463 Comentários)

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 Mais

$200 USD in 5 dias
(428 Comentários)

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 Mais

$250 USD in 5 dias
(543 Comentários)

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 dias
(415 Comentários)

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 Mais

$250 USD in 5 dias
(269 Comentários)

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 Mais

$700 USD in 7 dias
(229 Comentários)

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 Mais

$90 USD in 10 dias
(183 Comentários)

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 Mais

$250 USD in 5 dias
(250 Comentários)

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. Mais

$199 USD in 7 dias
(352 Comentários)

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 Mais

$200 USD in 5 dias
(107 Comentários)

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 Mais

$140 USD in 7 dias
(117 Comentários)

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 Mais

$140 USD in 7 dias
(104 Comentários)

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. Mais

$130 USD in 2 dias
(132 Comentários)

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 Mais

$80 USD em 1 dia
(221 Comentários)

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 Mais

$750 USD in 7 dias
(43 Comentários)

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 Mais

$140 USD in 7 dias
(40 Comentários)

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 Mais

$250 USD in 7 dias
(31 Comentários)