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

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I have:

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

and

- a CSV export from a offline product database with thef following fields: product SKU (product code), regular price, sale price, stock quantity. 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, (dropbox folder). Each file has a unique name.

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

- after completion it sends email to specified addresses 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 :)

Finally once approved it needs to be replicated for a second website.

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.

MySQL PHP WordPress

Project ID: #20889808

About the project

22 proposals Remote project Active 4 years ago

Awarded to:

AndreiPPB

Hi there! I am very interested in your project. My core skills are Node.js, React.js, HTML/CSS/Javascript/Bootstrap, MySQL/ MSSQL, MongoDB and My Frameworks are ASP.NET, Laravel, CI, Wordpress... etc. Also I have many More

$140 USD in 7 days
(20 Reviews)
5.7

22 freelancers are bidding on average $202 for this job

ahsansaleemnaz

I can update the script of your WooCommerce website and and can do that in quick time . For further discussions let's talk over in chat

$500 USD in 7 days
(253 Reviews)
6.9
PixelsInn

Hi There! I'm Woo-commerce expert and I'm ready to start your work of adding scripts. Kindly contact me for quick results. Thank you

$400 USD in 7 days
(41 Reviews)
6.6
DevStar925

Hi, How are you? I am very interested in your project. Also I have enough experience on cron job and php/mysql. If you give me a chance, I will do my best for you. I want to discuss more via chat. Regards//

$400 USD in 7 days
(23 Reviews)
6.4
kyleevert

Dear Client! I am very happy to see your project detail. I think it is just my project. :) I already read your requirement and understood fully. As you can see in my profile, (my review: https://www.freelancer.com/u/ky More

$140 USD in 7 days
(21 Reviews)
6.1
Grisha97924

⭐ Hi, Dear I understood all details. I have rich experience in CSS, HTML, HTML5, Wordpress, Javascript, jQuery / Prototype, Bootstrap 4, PHP, Mysql. I'm very interested in your project. Please send me a message so th More

$250 USD in 7 days
(33 Reviews)
5.9
bluebear1888

*******Hello, dear!!!********* please, give me chance of chatting. I will my best to make clients satisfied with good quality and to meet timeline. I will waiting for your reply.

$140 USD in 7 days
(29 Reviews)
5.3
gtnt20905baroli

I have good experience php,wordpress python, and many more things . Please let me know your details. Then we can discuss via chat. Thanks.

$140 USD in 2 days
(18 Reviews)
4.8
ibrahimsh96

Hello I am interested to work with you and I am absolutely sure that I can do the project very well in the shortest possible time. let's discuss the details. Please look at my skill and profiles. And then Check my expe More

$140 USD in 7 days
(1 Review)
3.0
threedgame538

Iam a professional wordpress developer with an experience of 4+ years and iam also expert in PHP,Laravel, HTML,Css,javascript,ajax,jquery,woocommerce,wordpress plugins.I have made a lot of wordpress websites like creat More

$150 USD in 5 days
(0 Reviews)
0.0
shipumh

Hi judging from the requirements,it should be pretty straightforward task,it can be done without modifying the script codes.

$133 USD in 10 days
(0 Reviews)
0.0