matty102 Posted February 10, 2005 Share Posted February 10, 2005 Hi all, Is there a way I can list a product in two Categories without it being a duplicate?. i.e doesn't show twice when listing all items but appears in two different Categories. Some of my products are linked to different Categories but If I list all items it looks like there are loads of duplicate products because they are basically the same but appear in two different categories. I only want the one product entered to appear in both Categories! Hope that makes sense!. :'( Thxs for any help. Link to comment Share on other sites More sharing options...
Benm Posted February 10, 2005 Share Posted February 10, 2005 I dont know if it can be done from the admin interface, but you can easily do this in the database directly. In the products_to_categories table, insert a new record with your product id and the id of the additional category. This way, the product is displayed in both categories, but is still a single product - if you'd edit it under one category, it'd change under the other one as well. Link to comment Share on other sites More sharing options...
k1w1guy Posted February 10, 2005 Share Posted February 10, 2005 Hi all, Is there a way I can list a product in two Categories without it being a duplicate?. i.e doesn't show twice when listing all items but appears in two different Categories. Some of my products are linked to different Categories but If I list all items it looks like there are loads of duplicate products because they are basically the same but appear in two different categories. I only want the one product entered to appear in both Categories! Hope that makes sense!. :'( Thxs for any help. <{POST_SNAPBACK}> Have you tried the "COPY TO" commmand in Admin - Categories/Products? Pete Link to comment Share on other sites More sharing options...
matty102 Posted February 10, 2005 Author Share Posted February 10, 2005 I dont know if it can be done from the admin interface, but you can easily do this in the database directly. In the products_to_categories table, insert a new record with your product id and the id of the additional category. This way, the product is displayed in both categories, but is still a single product - if you'd edit it under one category, it'd change under the other one as well. <{POST_SNAPBACK}> Ok, thanks a lot Benm. I will give this a shot. If anyone else knows of any other ways please let me know. Cheers. Link to comment Share on other sites More sharing options...
matty102 Posted February 10, 2005 Author Share Posted February 10, 2005 Have you tried the "COPY TO" commmand in Admin - Categories/Products? Pete <{POST_SNAPBACK}> Hi Pete, Yes I have tried this but what this does is put the product into two different Categories (great) but if I then view all products I have two of the same product so will end up with loads of duplicates which I don't really want to do. Link to comment Share on other sites More sharing options...
wheeloftime Posted February 10, 2005 Share Posted February 10, 2005 Hi Pete, Yes I have tried this but what this does is put the product into two different Categories (great) but if I then view all products I have two of the same product so will end up with loads of duplicates which I don't really want to do. <{POST_SNAPBACK}> Did you use Link or Clone when copying ? With Link you only have one product shown in several categories and with Clone you will have the same product multiple times. Viewing all products should take this difference into account. Link to comment Share on other sites More sharing options...
matty102 Posted February 10, 2005 Author Share Posted February 10, 2005 Did you use Link or Clone when copying ? With Link you only have one product shown in several categories and with Clone you will have the same product multiple times. Viewing all products should take this difference into account. <{POST_SNAPBACK}> Thanks Pete! This has worked fine. I suppose I should of spotted this really! Thanks again, I owe you a beer!!! :thumbsup: Link to comment Share on other sites More sharing options...
wheeloftime Posted February 10, 2005 Share Posted February 10, 2005 Thanks Pete! This has worked fine. I suppose I should of spotted this really! Thanks again, I owe you a beer!!! :thumbsup: <{POST_SNAPBACK}> Not Pete but WC :rolleyes: Link to comment Share on other sites More sharing options...
matty102 Posted February 10, 2005 Author Share Posted February 10, 2005 Not Pete but WC? :rolleyes: <{POST_SNAPBACK}> God, I am having a bad day!. Even buying drinks for the wrong people now!!. Sorry! & Thanks! :D Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.