We have a MySQL database with several tables. There are 3 parts to this project.
PART 1
1. There is an excel file with products/quantities of new stock arriving. Need to have an interface to add this new stock to a temp table by uploading this excel file. Also need facility to add / delete / modify item details from a web interface. Should also be able to add items from a drop down list.
2. These new quantities should show in a separate column next to current stock.
3. When the new stock arrives, we should be able to press an “Add Stock” so that these new items are then added to the current stock.
PART 2
On a daily basis, we upload an excel file with products / quantities and reduce these from the stock. Need to modify this process and a log maintained for the stock reduced each day.
PART 3
Need to run a script on a daily basis that will calculate the stock reduced on each of the product in the last 60 days and update another table with this figure.
Dear Sir,
we are available via Skype, phone and e-mail and are always open for discussion of progress, issues, functionality changes etc I'll be glad to continue our discussion and hope to talk to you soon.
Also check ur PM for our work portfolio
Hi,
I am a ZCE having 5 year of experience in PHP 5, Wordpress, Joomla & other cms.
You can check my past rating of work to know more about my work.
I can do this work efficiently.
Thanks