Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Customising the CMS /

Ecommerce Logic ~ Assitance


Reply


799 Views

Avatar
Terminator4

Community Member, 81 Posts

10 January 2009 at 12:17pm

Hi again,
I have been creating my custom page to include a rates page for products. I also have service that also have rates however some of the fields that are required on the product rates page are not used for the general service since a rate refers to a product and a service does not but a service does work on a per hour or flat rate depending on the service.

What would be the best way to go about creating an ecommerce table to handle all the rates of the different specifications that are chosen by a client and thereafter preserving the order details which would be saved in the database with the facility/product code, quantity, flat rates, and references intact...?

1) Should one table be used for the rates and one for order with its status OR
2) Should there be two tables (one for the service, one for the product rates) and then an order table with the items combined?

Let me know what you guys think is the best approach and why.

Thanks