PHP/MySQL script to update Woocommerce Price & Stock data from a CSV file
$30-250 USD
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.
Project ID: #20889808
About the project
22 freelancers are bidding on average $202 for this job
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
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
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//
⭐ 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
*******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.
I have good experience php,wordpress python, and many more things . Please let me know your details. Then we can discuss via chat. Thanks.
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
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
Hi judging from the requirements,it should be pretty straightforward task,it can be done without modifying the script codes.