homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Gold Sponsor 2015!
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Adding a New Dimension to an Ecommerce Site
Adding Wishlist to existing site

5+ Year Member

Msg#: 4203032 posted 10:38 pm on Sep 16, 2010 (gmt 0)

I have a currently functioning e-commerce site under mySQL.

I want to add a 'wishlist' functionality, and I am attempting to figure out the best way to do so.

I currently have one table for products (each product), and another for inventory (each SKU since some products have multiple SKUs).

I have created in a separate database a way for users to register with the table users.

I want to have a way to allow people to place specific SKUs into a wishlist.

I have had two tables joined together before (product and category for example with a product_category table)... but I am having problems with this one since I have to have three tables joined together (inventory, wishlist, and users).

How do I accomplish this? Database structure gives me so many headaches... thank you for any help you can provide, and I hope my issue is clear.



WebmasterWorld Senior Member 5+ Year Member

Msg#: 4203032 posted 11:22 am on Sep 30, 2010 (gmt 0)

Using multiple SKUs for the same product may cause problems. Consider using a base product and then use attributes to cover options for a product and generate the sku.

In any case your product page should function the same when a product is added to the cart or when a product is added to the wishlist. In other words treat the wishlist as a secondary cart. A secondary storage similar to the cart storage should do.

I am not sure how you involved the categories tables with the products and wishlists. I don't think you need it.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved