Jump to:

5451 Posts in 1673 Topics by 1197 members

Customising the CMS

SilverStripe Forums » Customising the CMS » Ecommerce Logic ~ Assitance

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

Page: 1
Go to End
Author Topic: 687 Views
  • Terminator4
    Avatar
    Community Member
    81 Posts

    Ecommerce Logic ~ Assitance Link to this post

    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

    687 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.