I am looking for someone to design an online auction site where I could take possession of the inventory, sell to the highest bidder, cut checks to the owners of the inventory, track what needs to be sent out after payment is received. Currently using [url removed, login to view] to host.
The fuctionality of the site will be similar or identical to the "[url removed, login to view]" site which appears to have everything I need at this time.
- SQL database to store personal info, Items for auction, bidding information, payment tracking, pictures, items sold or unsold,
- login/registration process.
A watch list function for users.
A minimum bid setting and "buy now" button
An items bought history for users with details
An item search field
A contact page
An easy method of entering items for sale and uploading photos.
Needs to automatically relist sales 4 times at the end of each auction for a total of 5 listings
Need to be able to quickly identify items for sale, items sold and unsold, amounts owed to customers, amounts
Users will not be able to list items, only send them in with a printable online form or bid on items if they are logged in.
This is the table structure I came up and I thought it might help but if you have a better way please feel free to change it.
Person Table (stores customer information)
Sale type (BIN, auction)
Min Bid (set at time of listing)
Items table (many items to one invoice#)
Images table (many pictures to one item#)
Watchlist table (to support watchlist)
Strike table (describes grader and condition)
Var (FS or ER)
Listingfee table (
Bids table (to track bids customers have made on items)
Sale# (1 to 5 increment on relisting after no sale)
Billing table (to track dollars owed to customers)
Shipping table (to store info on the shipment of coins to customers)
Also, any suggestions would be great. Thank you.