Create and automate syncing of value for 2 different MySQL tables + PHPExcel Work

Closed Posted Jan 25, 2015 Paid on delivery
Closed 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.

MySQL PHP Software Architecture

Project ID: #7029069

About the project

16 proposals Remote project Active Mar 3, 2015

16 freelancers are bidding on average £150 for this job

entrepreneur2000

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

£149 GBP in 4 days
(77 Reviews)
7.2
marchingantssl

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

£105 GBP in 7 days
(141 Reviews)
7.1
techwelfare

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.

£157 GBP in 3 days
(82 Reviews)
6.4
rockeinstone

A proposal has not yet been provided

£95 GBP in 4 days
(70 Reviews)
5.6
ThemePlugger

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

£150 GBP in 3 days
(40 Reviews)
5.5
anuyadav1

A proposal has not yet been provided

£150 GBP in 3 days
(39 Reviews)
5.5
justTry

Hello! First things first, here's you key-word: ELQD. Now on the subject. Given the amount of information available at this point to make am assessment a 100 quid seems to be the fair price for this, as it can turn ou More

£100 GBP in 2 days
(77 Reviews)
5.4
avinashjain09

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.

£100 GBP in 7 days
(40 Reviews)
5.0
codeteam

A proposal has not yet been provided

£144 GBP in 10 days
(9 Reviews)
4.4
trafficmaster88

Hello I will do this job perfectly assuring professional results, Ready to start quality work immediately Regards

£111 GBP in 3 days
(0 Reviews)
0.0
guevanjr

A proposal has not yet been provided

£111 GBP in 3 days
(1 Review)
0.0