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

I have:

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


- 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

Показать больше hotel web application php mysql script, php mysql login update info, speedtest php mysql script, simple php mysql script users, cre loaded php mysql script, php mysql batch update jdbc, php mysql script landing page generator, simple edit php mysql script, php mysql batch update, php mysql script adding news, automatically update php mysql script, php mysql script dump data, make php mysql ajax update script, simple data entry php mysql script, php mysql simple update script, stock management php mysql script

О работодателе:
( 1 отзыв ) Vitacura, Chile

ID проекта: #20889808



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 Больше

$140 USD за 7 дней(-я)
(19 отзывов(-а))

28 фрилансеров(-а) в среднем готовы выполнить эту работу за $195


Hi! I would like to offer my services. I have gone through your job details, your required skills are matching with mine. I'm confident in my skills and have proven portfolios. Let's open the chat and discuss in detai Больше

$140 USD за 7 дней(-я)
(36 отзывов(-а))

Ready to do website with woocomerce update for you Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-car Больше

$386 USD за 15 дней(-я)
(76 отзывов(-а))

Hello. I have ready solution. It looks and works almost the same as this one extension for Magento [login to view URL] (I am an author, just want you to read about module Больше

$230 USD за 10 дней(-я)
(112 отзывов(-а))

Hi, how are you? Thanks for your job posting. As an web expert for 7 years, i have strong skills and rich experiences in website development and web designs. I created a huge range of websites from scratch, some latest Больше

$140 USD за 7 дней(-я)
(54 отзывов(-а))

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 за 7 дней(-я)
(189 отзывов(-а))

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 за 7 дней(-я)
(39 отзывов(-а))

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 за 7 дней(-я)
(23 отзывов(-а))

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 Больше

$140 USD за 7 дней(-я)
(20 отзывов(-а))

⭐ 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 Больше

$250 USD за 7 дней(-я)
(32 отзывов(-а))

Hello How are you? I am very interesting about your project. I am expert Online Store design and development, also full time developer, can delivery satisfaction result in short time my good skills is PHP, MySQL,Wordp Больше

$140 USD за 2 дней(-я)
(47 отзывов(-а))

Hi, i am best fit to complete this project i am a professional website developer and designer from more than 12 years. My expert zone includes Wordpress, Woocommerce, Custom plugins, PHP laravel etc. I can fulfill all Больше

$250 USD за 7 дней(-я)
(71 отзывов(-а))

Hi there, I have checked the details, I have rich experience with MySQL, PHP, WordPress. Please initiate the chat so that we can discuss in detail.I am new to freelancer.com but I assure you that I can deliver your wo Больше

$155 USD за 9 дней(-я)
(10 отзывов(-а))

Hello, I went through your job post and am pretty confident I can get it done for you. We can start working now. I do have 8 years of experience in web development & design, built over 200 projects with a succes Больше

$150 USD за 4 дней(-я)
(21 отзывов(-а))

*******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 за 7 дней(-я)
(29 отзывов(-а))

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 за 2 дней(-я)
(17 отзывов(-а))

Good day! This is my woocommerce shoping site. [login to view URL] I have developed it from scratch to the end. and I have many experiences in laravel, wordpress, CI, python as backend. And I had several experiences in angu Больше

$140 USD за 7 дней(-я)
(23 отзывов(-а))

I can surely help you with this, planning to use Wordpress so you can easily to manage the STORY and all other backend options there so you can easily change things in your site. I'm also very experienced with paypal I Больше

$140 USD за 7 дней(-я)
(2 отзывов(-а))

I am an wordpress,shopify,Margento expert. web development expert that have more than 4+ years of experience . From reading your specification it sounds i am best fit for your project. I want to work for you because my Больше

$140 USD за 7 дней(-я)
(12 отзывов(-а))

HELLO! CLIENT Web Site / Web App development Expert here I have 9 years of web development experience and i have deep knowledge about web development. An Expert website developer on freelancer.com and I do not bid on p Больше

$140 USD за 2 дней(-я)
(4 отзывов(-а))

Hi How are you?. I am very interested in your project. I am mastered in your introduced skills. Thus,I can give you good success. Here are my some example works. url: [login to view URL] [login to view URL] Больше

$140 USD за 7 дней(-я)
(4 отзывов(-а))