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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Customising the CMS /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Ecommerce Logic ~ Assitance

Go to End



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.