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 [login to view URL] to host.
The fuctionality of the site will be similar or identical to the "[login to view URL]" site which appears to have everything I need at this time.
Should have
- 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)
Person#
Name
Location
Phone 1
Phone 2
Email
CC Name
CC number
CC expiration
Invoice table
Invoice#
Person#
Date
Sale type (BIN, auction)
Min Bid (set at time of listing)
Items table (many items to one invoice#)
Item#
Invoice#
Qty
Strike#
TPG#
Grade
Comments
Value
Minbid
Images table (many pictures to one item#)
Image#
Item#
Watchlist table (to support watchlist)
Person# (key)
Item#
Strike table (describes grader and condition)
strike#
TPG#
Code
Desc
Var (FS or ER)
Listingfee table (
Minbid
Fee ($)
Bids table (to track bids customers have made on items)
Bid#
Item#
Person# (bidder)
Datetime
Amount
Cancel (y/n)
Sales table
Item#
BegDate
Duration (days)
Enddate
Sale# (1 to 5 increment on relisting after no sale)
Billing table (to track dollars owed to customers)
Bill#
Billtype
Item#
Date
Shipping table (to store info on the shipment of coins to customers)
ShipID#
Item#
Date
Carrier
Ship#
Also, any suggestions would be great. Thank you.
We have gone through your requirement and we do have 5 years of experience and assure you the product of your choice and will complete the work on time with excellent quality, please do check your inbox for more details.