Excel/Access Stock Database with update function
Budget: $30 – $250 USD
We want to automatically update a "Master Stock excel file by either uploading an "Additional" Stock file or by subtracting a "Subtract" stock file.
This inventory system would ideally:
- use the item code/ID in the additional or subtract files as the key and match or lookup the corresponding ID on the Master file and update the stock by adding or subtracting (depending on the file).
- Any items that cannot be uploaded or matched need to be highlighted to the user so they know the item did not upload or update correctly.
- We want to be able to repeat this process many times buy adding and subtracting files while automatically updating the master file.
- We then want to be able to download the latest Master Stock File whenever needed.
Important: It needs to be very user friendly.
I have attached a basic diagram and can forward sample files for reference.
Proficiency in working with Excel/Access databases is key for this job, and experience in inventory or stock management systems will be helpful too.
**Important: Only bids referencing or commenting on the project will be considered.
This inventory system would ideally:
- use the item code/ID in the additional or subtract files as the key and match or lookup the corresponding ID on the Master file and update the stock by adding or subtracting (depending on the file).
- Any items that cannot be uploaded or matched need to be highlighted to the user so they know the item did not upload or update correctly.
- We want to be able to repeat this process many times buy adding and subtracting files while automatically updating the master file.
- We then want to be able to download the latest Master Stock File whenever needed.
Important: It needs to be very user friendly.
I have attached a basic diagram and can forward sample files for reference.
Proficiency in working with Excel/Access databases is key for this job, and experience in inventory or stock management systems will be helpful too.
**Important: Only bids referencing or commenting on the project will be considered.