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

Closed

I have:

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

and

- 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, woocommerce csv, woocommerce c++, stock update, php woocommerce, need a quick mysql script

Project ID: #4207128

Awarded to:

bcsaba

Think can do this for you.

$65 USD in 1 day
(27 Reviews)
4.3

13 freelancers are bidding on average $174 for this job

lightcresent

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)
8.9
kabirchy

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

$150 USD in 2 days
(743 Reviews)
8.1
mistersoft

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)
7.4
tomydeveloper

Hello,We are Wordpress expert with woocommerce.Ready to update.Please check pmb for portfolio.Thanks

$250 USD in 7 days
(223 Reviews)
7.4
coolguyinus2004

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)
7.3
DrTech76

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)
6.5
sehgals

pm sent...!

$160 USD in 1 day
(150 Reviews)
6.5
inzaghi2006

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)
5.8
jcodemasters

Please check message

$200 USD in 3 days
(47 Reviews)
5.5
indianbusybees

Hi, I am ready to start right away.

$200 USD in 3 days
(41 Reviews)
5.2
naranili

Please read my message at the PMB

$120 USD in 4 days
(37 Reviews)
5.3
codeware1

Hello Sir, Hope you are well and doing good!!! we are eager to work with you.We 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)
3.9
jigargandhi

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

$100 USD in 4 days
(2 Reviews)
2.1
Harshit101

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

$100 USD in 5 days
(0 Reviews)
0.0
sr24mguru

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)
0.0