Online retail company needs a simple multi-user stock control / sales / product info system written in MS Access.? Probably requires around 8-10 forms, a few printed reports/output and some simple csv import/export functionality.
I was a s/w developer for 10 years but don't have the time to write it myself but I can help with design/testing, etc. There will be future enhancements.? Below are few notes I jotted down but all can be discussed:
Product information ??" access to all info from? one screen, questions, product issues, shipping rates, product image, etc with add/edit/delete
Invoices ??" process ebay orders, process website orders, pick list, post list?
with? dispatch method and? capture of customer information
Stock Control ??" stock in, stock out, location
Re-ordering ??" fully coded, with make instructions, lead times, supplier details?
Unallocated (not dispatched)/pending orders
Export to Excel
Customer returns management, issue tracking, etc ??" returns and product issues, DLR tracking, parcels in tracking
Potentials ??" store them, notify on back in-stock
Link to retail shop
Link to accounts and Admin
Maintenance lookup tables