Find solution
How to clear single product fpc cache in magento?

Is there any Magento extension that helps to define rules for product assignment to specific category?

  • We have a big Magento store with high SKUs. We have a requirement that says if a product has a specific word in title or description and has specific values of attributes, it should be assigned to specific category.  For example, If a product has shirt word in title or description and it has red as color attribute value, it should be automatically assigned to "Red shirt" category.

  • Answer:

    What's the point of using categories? It makes life much more difficult. Use attributes instead. Do you want "Red shirt" products? Then select (via attributes/layered navigation) all of the product "Type=Shirt" and "Color=Red". No need to duplicate what you have already with categories. And don't forget that products get assigned to categories as well as unassigned! When we reimplemented http://www.alexandalexa.com from scratch, I made it a mandate that we would use as little categories as possible for several good reasons (e.g. at some point content managers were assigning each product to over 20 categories!). We ended-up with max two category levels (e.g. Clothing - Shorts). The rest is in the attributes. So for instance, if you want Red (attribute) T-Shirts (category) for Boys (attribute) you can use http://www.alexandalexa.com/kids-clothing/t-shirts-tops/shop/red/boys Red (attribute) Shoes (category) for Boys (attribute) http://www.alexandalexa.com/shoes/shop/red/boys Anything Red for Boys: http://www.alexandalexa.com/shop/red/boys - this is using only attributes. Obviously Categories provide other advantages, such as customise the stye, SEO, manual sorting of products etc... We used "Improved Layered Navigation" by Amsty - http://amasty.com/improved-layered-navigation.html which is better than other badly implemented layered navigation modules out there. We also extended it at that time (2012) as we needed some more SEO functionalities and we added a sorting/merchandising capability that made life so much easier! (e.g. define the sorting via file, easy to upload and no reindexing needed).

Osvaldo Spadano at Quora Visit the source

Was this solution helpful to you?

Other answers

I do not know of a specific extension that does this but you could export your products into excel and do an excel macro that would apply a category to certain products based on keywords in the title and description of the product and reupload the products categories via the magento excel import feature in the admin panel.

Isaiah Bollinger

I think there is no extension as you told the scenario. But you can do one thing that write a script and you can get title of product and assign a category based on keywords. I know its not the easy but its very easy instead of manual assigning categories to 1000+ products.

Naveed Ramzan

Hi, as the other replies already mentioned I also do not think there is a ready-made extension that does this. But a custom Magento Extension that contains all assignment logic could easily be created. An alternative would be a solution like http://www.mash2.com/cobby-die-integrierte-magento-losung-mit-excel/ that enables you to use Excel for this use case. I hope this helps. Best regards, Chris

Christoph Massmann

I also do not know of an extension. However, I think that having this type of automation may speed up creation, but it also can cause issues.  You want to create a title or short description that best suits the product.  But when you start reserving words for assigning catagories it may impact your ability to best describe product.  Second, you may inadvertently use a keyword that causes a product to be miscategorized. I think you are better off using some of the tools recommended by others than overly automating assigning categories.

Kevin Kogler

Whatever the obstacles are this is easy and doable either by excel/csv , API, SQL or extension. If there are no suitable extensions, I would play with  microsoft excel conditional fonctions/etc. In fact export the products into a csv format and open it with MS Excel then play  with the settings, conditions, formulas or functions( google excel formulas/ functions etc). In the mean time check this magento extension out : http://www.magentocommerce.com/magento-connect/procategory-managing-products.html

Luc Walter iBata

There are two ways to facilitate the same: Option 1:  Use related modules and then customize. - http://www.magentocommerce.com/magento-connect/dynamic-category-products-automated-category-products-shop-by-brands-shop-by-any-attribute.html Option 2:  Create complete new module from the scratch. - Magento support event based features. - catalog_product_save_after - Put your business logic inside this event. Workflow for this solution:  + Event fired when product is saved magento  + Get product attribute data or description or any other fields which have information regarding category.  + Then manually (using code) MAP the categories with those information  + Cheers. Products are MAPPED to the category.Incase you need any further specific assistance feel free to contact me: Magento Development at CMARIX Hire skilled Magento Certified Developers 20+ Magento experts with 4+ years of experience Expertise into Magento Enterprise & Community Edition Fluent English, Pro-active Inputs, Complete transparency Great experience of implement Magento Multi store Handson experience of implementing Magento Multi-vendor Magento Integration with SAP Magento implementation with call centers 76+ Diverse API integration in Magento Extensive customization experience Magento Performance & security optimization UPS Address verification system implementation Magento CRON debugging and optimization Data Migration services in Magento To know more about us, please visit: http://www.CMARIX.com

Sunny Patel

Yes, there is. Dynamic Category Products: http://www.magentocommerce.com/magento-connect/dynamic-category-products-automated-category-products-shop-by-brands-shop-by-any-attribute.html The extension will be able to deal with all your wanted rule requirements, and much much more.

Lucas van Staden

We can certainly build such feature. But this will be available only for shops which are on board with us at http://www.netmystore.com. At Net My Store, you can have - Unlimited SKUs and categories. Integrated Payment Gateways. Free Themes. Business emails by Zoho mail. and much more ... To know more, Call our Sales Team @ +91 810.935.8989 Thanks!

Ajeet Singh Pawar

The Easy Categories Magento module displays your store’s product  categories so customers can rapidly find what they want. Best of all,  you can place your category listings wherever you’d like — your store’s  home page, a special category page or another CMS page. http://www.invortex.com

John Smith

Load more

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.