Forums / General Questions / How to bulk unlik products?

How to bulk unlik products?

Results 1 to 3 of 3

27 Apr 2011, 9:28 AM

wirefram

New Zenner

Join Date:: Apr 2011
Posts:: 95
Plugin Contributions:: 0

How to bulk unlik products?

Hello everyone

I am using Zencart version 1.3.9h.

I am building a new Zencart shop and I have to clean an old database exported from OScommerce.

In this database all products are linked all across the base in multiple categories, i am trying to unlink those products so they belong to 1 category only but it's taking for ever as i am doing this one by one and there are over 3500 products!

Is there a way to bulk unlink those products?

Thanks

Pat
:blink:

27 Apr 2011, 11:32 AM

kuroi

Totally Zenned

Join Date:: Apr 2006
Location:: London, UK
Posts:: 10,475
Plugin Contributions:: 11

Re: How to bulk unlik products?

If you know SQL you could unlink them by running queries against the products_to_categories tables where these links are kept. But if you don't know SQL this would be dangerous.

27 Apr 2011, 12:42 PM

wirefram

New Zenner

Join Date:: Apr 2011
Posts:: 95
Plugin Contributions:: 0

Re: How to bulk unlik products?

Thanks, I found out how to di this faster with the module Multiple Categories Link Manager-Sorted v1.0.