Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a standard e-commerce database schema to apply the discounts/taxes/gift vouchers to products?

A good and flexible database schema illustrating e-commerce products and their rates management is required.

like image 325
suhair Avatar asked Nov 26 '08 10:11

suhair


People also ask

Which database is best for e-commerce?

Ecommerce transactions are not ideally suited for document databases, however. Relational databases work much better for transactional data. MongoDB, CouchDB, and Redis are examples of document databases that are used by stores.

How is database used in online shopping?

A database system helps e-commerce sites pinpoint potential customers based on compiled information. Marketing teams can use customer data that is stored within the database to create targeted lists that will be used for directing marketing efforts.


2 Answers

I agree with Chris Roberts, OSCommerce is a good place to start as well as DatabaseAnswers.org.

Hope that helps.

like image 94
domusvita Avatar answered Sep 21 '22 03:09

domusvita


I'm sure there are many examples about - try looking at some open source shopping cart tools.

As a general point, though, I think there are so many ways that a product pricing and discount / gift voucher system could work that finding a database schema that works for every possibility is unlikely!

Perhaps you can save yourself some heartache by refining the requirements a little?

like image 43
Chris Roberts Avatar answered Sep 22 '22 03:09

Chris Roberts