Create and automate syncing of value for 2 different MySQL tables + PHPExcel Work
£50-150 GBP
Paid on delivery
We have an online Point Of Sale system which runs on PHP and MYSQL, we also have an online store based on Wordpress (Woocommerce). On the POS system the stock levels are held in a table like this:
Column 1 = Item ID
Column 2 = Location ID
Column 3 = Quantity in Stock
We have 3 locations, hence the location ID, but online stock levels will only be linked to the 1st location (i.e. ID 1). We can make the POS and Woocommerce products have the same SKUI/ID so lookup is easy across tables.
We need a piece of software that can be run every hour, via CRON (or another way if it's more efficient), that will grab the information from the above table for each product, then compare it with the stock levels on the Woocommerce store and adjust accordingly.
For example: There is 5x Product A and the online store has 6, then this needs to be reduced to 5 on the online store. But if the online store has 4, then Location 1 must be reduced to 4.
Additional Information:
The software must be able to work when products are added or removed. There may also be some items that will be on our POS that won't be available on the online store so it must work with this also without causing errors.
The last thing we need done is a report for all stock levels via the POS. Currently on our POS system we can output an xlsx file of the stock levels per store but it does not offer a report for the total stock levels of all stores combined. The reports are made using PHPexcel. This should be fairly straight forward to do.
Additional information:
The software for the report must take into consideration that additional stores may be added or removed in the future.
Please include the word ELQD in your proposal otherwise your bid will be ignored. This is to stop spammers.
Project ID: #7029069
About the project
16 freelancers are bidding on average £150 for this job
ELQD Hello, I am ready to implement a script to sync stock levels as well as create a report with PHPExcel. Can you please contact me to discuss the requirements of this project in more detail? Why hire me? - More
Hi! This project draw my attention and I am really willing to work with you. I am just interested in more details that you might give about the project. I think, we have enough experience to help you with this More
hi We have gone through your requirement and could do it perfectly with accuracy. please let us know if you want to clarify in details.. also if you want us to share our skill and previous work let us know.
ELQD Hello, I'm a WordPress developer and I'll be happy to create this bridge between your POS and your WordPress site. Thanks and God bless! ThemePlugger
ELQD Hello, I have expertise in database, I can fulfill your requirement. Can we have more discussion. I have 4 years of experience in php,mysql,codeigniter,wordpress,woocommerce,opencart,payment gateway.
Hello I will do this job perfectly assuring professional results, Ready to start quality work immediately Regards