Project Detail

Description

This is going to be a huge project and we need a team of programmers to assist us in this venture.

The database that we will be using is from MOTORS.com. If you would like to see this information, please let me know and I will send you a link.

You will also find a few samples of the database here, too. This is a very large database approx 6 gigs. We will not purchase the database until we this project is very close to be released due the price of this database. Once this project is complete, we will retain full rights and ownership of all workmanship. If you have any questions, please let me know.

C. Scott Williams


Here are most of the features and functions we expect to see in our catalog:

OEM Parts Catalog

Customers
1. Consumers to purchase OEM parts from supplying dealers will need to:
a. Order parts & accessories online
b. Track orders
c. Get a price with a part number
d. VIN opt out (no VIN/no return)
e. Search the catalog for a specific part
f. Ask dealer for help looking up a part that is not in the catalog (Parts Request form)
g. Save parts in a cart for later ordering/purchase
h. Look at previously placed orders
i. Multiply shipping address
j. Each user must have a unique username & password with 6 to 16 charters as the username
i. No email address as a user name. They change too often.
k. Ability to cancel orders that have not been processed
l. Store user vehicle information for future orders
m. Approve orders that have been modified by supplier
n. Shipping Options – Next Day, Over Night, Ground
o. Choice of different shipping carriers: FedEx, UPS, USPS
p. Add comments to order or special instructions
q. Prices for each of the shipping options calculated and include as options
r. Lost password and username retrieval
s. No cookies required, use sessions instead

OEM Suppliers
2. Suppliers must have the ability to:
a. Set prices
i. Cost plus or list minus
ii. Coupons
iii. Specials
iv. Group buys
b. Set shipping information
i. A percentage of total
ii. Will-call orders
iii. TBD – no shipping price given
iv. Estimate shipping
v. Per item (or part)
vi. Free shipping (e.g. orders over $500)
vii. Exclude parts from shipping
1. hoods
2. fenders
3. doors
4. air bags
5. any order item too large for standard ground shipping
viii. Add shipping services
1. UPS
2. USPS
3. DHL
4. FedEx
5. Bax Global
c. Add items to their catalog
i. Add non-oem parts
ii. Add take-off parts
d. Define delivery areas
i. US shipping, including Alaska, Hawaii, and all US territories
ii. 48 State shipping (no Alaska, Hawaii, or military)
iii. No military shipping (APO, APE, etc.)
iv. Global
e. Accessories catalog
i. Add parts to this catalog that will be global to all OEM’s
1. picture
2. description
3. weight
4. title
f. OEM catalog
i. Be able to make corrections to this catalog such as:
1. corrections
2. prices
3. suppressions
4. obsolete
5. weight
ii. Add items to catalog that are not updated
g. Set sales tax
i. Tax on shipping
ii. Standard sales tax
h. Modify a customers order
i. Different levels of status
ii. Add items or remove items from customers order
iii. Contact customer through order form/screen
iv. Be able to make 1 or more parts on backorder
v. Customer must approve changes to order before shipping
1. pricing
2. shipping
i. Dealer Groups
i. Multiply shipping store locations
ii. Multiply users with access to the stores they control
j. Order processing
i. Take credit card information and process orders
ii. Paypal
iii. Checks
iv. NO online credit card processing
k. Add/modify sales agents
i. Admin (access to all)
ii. Stock agent (no order information)
iii. Shipping agent (no credit card information)
l. Add/modify coupons and specials
m. Modify store design through .css or templates
n. Modify buying properties
i. List minus pricing
ii. Cost plus pricing
o. Import database for cost & list
p. Add/modify customer information
q. Add/modify wholesale customers
i. Add customer
ii. Setup shipping information
iii. Special wholesale pricing
r. Store status
i. Who’s online?
ii. Click rate
iii. Where are they coming from?
s. Reports
i. Completed sales
ii. Returns
iii. Missed sales
iv. Taxes
v. Payments
vi. Shipments
t. Turn on & off accessories catalog

Resellers
3. Resellers must have the ability to:
a. Add/modify/remove suppliers
b. Set-up new suppliers
i. Add/modify username/password
ii. Add/modify storefront information
iii. Training
iv. Add/modify contact information
c. Turn on/off storefront
d. Billing
i. Month to month
ii. Annual
e. Invoicing of suppliers
f. Have access to all of their OEM Suppliers
g. Mass email to suppliers
h. Reports
i. Message center
j. Add/remove manufactures to suppliers

Admin
4. Admin must have the ability to:
a. Do all of the things a reseller can?
b. Add/modify/remove resellers
c. Invoice resellers
d. Turn resellers on and off
e. Import databases
f. Mass emails to resellers
g. Message center
h. Reports
i. Opt in News Letter



Additional information submitted:

02/28/2008 at 18:35 EST:
The database that we will be using is from MOTORS.com and you can read about it here:

ftp://ftp.motor.com/Public/Parts%20and%20Time/3RDGEN/3RDGEN%20Table%20Def.doc

If you cannot get there, try this:

ftp://ftp.motor.com
--> public
-->Parts and Time
-->3RDGEN
-->3RDGEN Table Def.doc

PLEASE -- -- -- NO OSCOMMERCE! -- -- -- PLEASE