
March 9th, 2005, 05:05 PM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 6
Time spent in forums: 1 h 4 m 26 sec
Reputation Power: 0
|
|
|
What is the correct table structure to cross sell products?
I have implemented an e-commerce system which is currently being used in about 10 different websites. I would like to develop to second phase to it by implementing cross sell/up sell so that I can display related products to the customer when viewing one item.
The way I’m planning on forming the relationship between two liked products is by creating a table that with the following fields:
Create table cross_sell…{
Id int..,
Product_id int.., - this will hold the ID of the source product I want to compare
Related_product_id int – this will hold the ID of the product that is similar to Product_id
}
I’m not so sure if this is the industry standard for creating cross-sell/up-sell relation, so I would greatly appreciate it if you provide me with some input.
|