PHP/MySQL script to update Woocommerce Price & Stock data from a CSV file

I have:

- a Wordpress website with Woocommerce shop, having about 150 products


- a CSV export from a offline product database with thef following fields: product SKU (product code), regular price, sale price, stock status. This export has more SKUs than the online shop.

What I need is a cron job php/mysql script to update/overwrite the data in the Woocommerce/WP MySQL database.

So your output would be a php script (file) that:

- runs at a specified interval/time,

- gets the CSV file from a specified URL,

- searches the WC product list for each SKU in the CSV; if it finds a match, it overwrites the SKU, regular price, sale price, stock status.

- after completion it sends an email to a specified address with a report of how many products were updated

Please note: some of the products in Woocommerce have variations!

I also ask you to provide a testing environment with wordpress and woocommerce installations so we can test the script fully before trying it out on our site - just in case something goes wrong :)

Please give a time estimate, too - a quick response time would have priority and you should be ready to start immediately.

Let me know if you have any questions or if anything is not clear.

Skills: MySQL, PHP, WordPress

See more: woocommerce mysql, woocommerce stock status, woocommerce csv update stock, php csv woocommerce, woocommerce database stock status, woocommerce product update script, php price update script, what is the price for wordpress website, test php code online, php mysql job, online shop website what price, i need a quick code for wordpress, how to start with wordpress website, how to start online job, file status 34, what is a test case, wordpress website price, what is a php file, woocommerce website, woocommerce php

About the Employer:
( 12 reviews ) Schwarzach, Austria

Project ID: #4207128

Awarded to:


Think can do this for you.

$65 USD in 1 day
(27 Reviews)

13 freelancers are bidding on average $174 for this job


Got Expertise in doing this sort of stuff... All payments through Milestone Payment (Escrow)... Online 16 Hours a day, Can start right away.. Thanks

$210 USD in 2 days
(459 Reviews)

Hi, I am ready to help you get this done. Best quality assured. Thanks

$150 USD in 2 days
(743 Reviews)

Will do this script as per your requirements. Already completed a lot of similar projects. Only quality result. Thanks!

$200 USD in 3 days
(389 Reviews)

Hello,We are Wordpress expert with [login to view URL] to [login to view URL] check pmb for [login to view URL]

$250 USD in 7 days
(223 Reviews)

PHP/MYSQL professional experianced developer here. can handle this woocommerce work of cronjob in a very efficient way.

$350 USD in 5 days
(271 Reviews)

Hi! I have such script ready from before. Just need to add the emailing part.I can provide test woocommerse installation, no problem with that. Kind Regards

$70 USD in 1 day
(246 Reviews)

pm sent...!

$160 USD in 1 day
(150 Reviews)

Hi, I'm very interested in your project. Just contact me and you will get it done soon. Thanks

$100 USD in 3 days
(71 Reviews)

Please check message

$200 USD in 3 days
(47 Reviews)

Hi, I am ready to start right away.

$200 USD in 3 days
(41 Reviews)

Please read my message at the PMB

$120 USD in 4 days
(37 Reviews)

Hello Sir, Hope you are well and doing good!!! we are eager to work with [login to view URL] are ready to start the project right away. Codeware is a website development company providing professional website design, website develo More

$180 USD in 7 days
(11 Reviews)

Hi i am ready to start now..i have very good experience with woocommerce..

$100 USD in 4 days
(2 Reviews)

I have created many sites on woocommerce. I will do it for you.

$100 USD in 5 days
(0 Reviews)

looking onto your requirements, we like to bring to notice that, we can deliver you the best work and that to on above mentioned time.

$220 USD in 12 days
(0 Reviews)