Form & SQL Table

[ce7]

Can someone please give me advise about my idea?

 

==============================================================

goals to achieve:

 

When customer add the products in to the shopping cart,

I like to replace the checkout buttom, so instead of check out right away,

customer will be direct to a form that request them to enter necessary information, such as

 

1. customer name

2. list of products in the shopping cart

3. list of products not list but wish to have (wishlist)

4. products in the shopping cart to be used in what type of job (like to make a list, plust a field "others" for customer to fill in different type of job that is not on the list)

5. what type of main equipment will be used on job (customer has there main equipment, and they need to purchase products to associate with their main equipment)

6. days of the job

7. location

8. any other information

======================================================================================================

 

Can I simply just copy Contact us and make the extra field? Or I need to have complicated code (which I like to avoid as I don't know PHP code well)

 

Do I need to make extra table for database to store those information or I add extra column in customer and product table?

 

Many thanks in advance.

 

Lyn

[ce7]

So far I had tried to modified "enhanced contact us".

What I like to achieve is that:

 

1. Clients select products into shopping cart

2. No checkout button for client to click, instead, they click button "Ask for Quote"

3. Page will link to a quotation page which similar to contact us email (enhanced contact us)

4. Clients need to insert certain fields to provide necessary information for correct quote.

5. The selected product in the shop cart will be a list sent together to store owner.

 

the new database tables I think about are includes:

1. quote customer table (to save data of customers who maybe placed order before or just new customer who ask for quote)

2. quote table (to save data about date information)

3. quote job table (to save the job information that customers are going to do who ask for products quotation)

4. quote job description (to save more details about the job information, include wishlist that maybe not list on store product categories)

5. quote job products (the products details that customer requested for quotation)

 

=======================================================================================

I am not sure the ways I think are in right direction or not, basically I need help about:

1. telling me if my database tables design can works or has better way to do?

2. how can I make the shopping cart list send together with email?

3. if my database design are kind of ok, in the case customer are not registered, how can I insert all the information into database and then send together with the email to store owner?

 

Can someone please help?

 

Many thanks in advance.

 

Lyn