Hello,
Please find below my proposal for your business.
Table:
Inventory table
-Product basic information (id-number,name, style, size, asking prize, minimum prize, condition of the product)
-This is expendable
Customer table
-Customer basic information (name, address, telephone number, email address + 3 other fields for basic informations)
-This is expendable
Transaction table
-customer buy product (transaction time,customer name, product name)
Selling Cycle table
- Selling Cycle information (product name, price, from date, to date, last selling date)
Form:
-Inventory entry form
-customer entry form
-transaction form (this is where you can enter commisson and it will auto-deduct for you)
-Function:
-Print the form (I can help you create template)
-Generate a list of product less than 7 days of selling period left
-Generate a list of product that has not been sold or picked up after selling period has ended
-Generate a list of product that has sold for chosen period
Bonus:
if this program could operate directly from our excelsheet where we write the daily sales and mark the sold dresses from there.
This can be further discussed. Using the database is to replace the use of excelsheet. I need to examine the excelsheet that you are using and see if I can find a suitable solution for you.
Also, If you can provide a sample or two for each process above, that can greatly help me shape your solution more accurately. This can be discussed if I am selected as winning bidder.