Suggested Related Product
19 posts by 5 authors in: Forums > CMS Builder
Last Post: November 12, 2010 (RSS)
By kitka - February 8, 2010
Is it possible to cross refrence products?
ie....For example....I am selling a Product "Tires" is there a way to show a link to a related similar product "ie rims"
Kinda like....Mya we suggest as well to puchase..... You see this in alot of shopping cart sites>>>>
The reason i ask is i have a customer who will featuring 1 product but may want tocross link another product on the same page?
Is this possible with CMS?
Re: [kitka] Suggested Related Product
By Codee - February 8, 2010
Re: [equinox69] Suggested Related Product
By kitka - February 8, 2010
Re: [kitka] Suggested Related Product
By Codee - February 8, 2010
Re: [equinox69] Suggested Related Product
By kitka - February 8, 2010
Re: [kitka] Suggested Related Product
By Chris - February 9, 2010
Depending on the data you have, it may make sense to create a category section and assign products to categories, then list other products in the same category as the current product as "related".
Taking this one step further, you could have the product's category field be multi-value. This would allow you to "tag" products with one or more categories, then your code could find other products with matching tags.
I hope this helps!
Chris
Re: [chris] Suggested Related Product
By kitka - February 9, 2010
Taking this one step further, you could have the product's category field be multi-value. This would allow you to "tag" products with one or more categories, then your code could find other products with matching tags.
I may seeem clueless here but how would one do this....(LOL)[/#000000]
Re: [kitka] Suggested Related Product
By Chris - February 9, 2010
You'd use a multi-value list field to select multiple categories for a product. Then, on the viewer page, split the product's category field out to get a list of all the categories this product is assigned to:
$categories = explode("\t", trim($productRecord['categories']));Then get related products which contain at least one of those categories in their own categories:
$where = "";
foreach ($category in $categories) {
if ($where) { $where .= " OR "; }
$where .= "categories LIKE '%\t" . mysql_escape($category) . "\t%'"
}
if ($where) {
list($relatedProducts,) = getRecords(array(
'tableName' => 'products',
'where' => $where,
'limit' => '10',
));
}
else {
$relatedProducts = array();
}Does that help?
Chris
Re: [chris] Suggested Related Product
By kitka - February 9, 2010
Thanks... I am going to be wrking on this this week so i will let you know...
thanks for all your insight and help
JIM
Re: [kitka] Suggested Related Product
My goal is to set up a product catalog for a small camera store building on the basic approach discussed in this post, but I’m not getting very far...
WHAT'S NEEDED
The client would like to show “suggested items” that work with specific cameras and specific accessories (like the big sites do).
There will eventually be many products, models and kits listed and these products will change over time.
There could be dozens of related products for a given product, in many different categories, like memory cards, flashes, lenses, filters, etc. for a specific camera. Or specific filters, lens caps, and accessories that work with a specific lens.
These relationships and products will also change over time and the client needs to be able to manage everything easily and intuitively.
FIRST APPROACH
One thought is to set up a multi-record editor for each of the main product categories (initially Cameras, Lenses, Filters Memory Cards, Batteries, Flashes, and Lighting) and then create specific product records for each product in the appropriate main category editor.
I could then set up multi-value pulldown lists in each of those editors that pulls the individual product titles from each of the other databases, and then use those to set up the related products lists on the detail pages.
IT’S A MESS
I mocked up a few products and some relationships and it’s become really messy.
If a product category gets added it seems (with my limited programming knowledge) that it would have to be manually added to each editor and then to each viewer.
Products need to be entered in ascending hierarchical order (batteries before cameras) or there are no batteries to assign to a camera.
Any name changes in a previously used title field results in a “Previous selection,( no longer in list)” issue. This could prove very confusing to the client.
And on... And on...
That's when I decided that there must be a better way.
HELP
I was hoping that someone might have some thoughts about a more realistic approach to use in setting up the databases and viewers for a project like this?
Thanks,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php