Looking to use data from either cvs or xml files that are already generated into an inventory scheme. There will need to be a way to either setup a new area(Machine) with items being set by price from the cvs file(as well as user defined to compare) and sold items subtracted. I also will require a way to report what items are sold and define an amount of how many items to pull for restock ie:
Location Item par sold pull filled to fill time
A1 Cheetos 10 6 4 8 Monday 12:00
A3 Fritos 10 9 8 9 Monday 12:00
Instead of pulling 6 items when sold I want the items to be user defined for how many to pull in pairs(see above example defined with 4's) This amount will be either 4, 8, 12, or 24 .The filling time will be defined by another file that will come into a dir once a day along with the sales information. Basically leaving us with a rolling inventory that is scheduled, preferably by calendar, for each location to be refilled.
Here is an example of the csv file showing sales information
EE100040786,564285874,R,473690******2558,3,0008,1,05/19/2011,04:58:29
EE100040786,564288283,R,473690******2558,2,0009,1,05/19/2011,05:15:50
EE100040778,564292957,R,434258******9524,1,0001,1,05/19/2011,05:50:22
EE100041159,564296858,R,461046******6974,1,001D,1,05/19/2011,06:11:13
machine ID,N/A,N/A,N/A,Price,Selection(A1 or whatever is defined),Amount,Date,Time
I would also like the ability to edit the inventory of an "machine ID" for shorts of product or just recounting inventory. This will be used to help track inventory in vending machines using generated data like the one showed above. This is for a small business with no time to waste, so please only serious inquires.
I also have examples of exactly what I am looking for