Is it possible to create a sale on all products by a manufacturer at 1.51?

[Ajeh]

Are you saying you are trying to get a single SQL that will build a Category with all the Products for one manufacturer?

[mc12345678]

Are you saying you are trying to get a single SQL that will build a Category with all the Products for one manufacturer?

Ajeh, I am not sure if the question is to me or to the OP; however, I would think that a solution that would end up working would be sufficient. :)

[Ajeh]

If you want to make a Category with ALL the Products that have a manufacturers_id of XX as Linked Products ...

1 Make a new Category and note the categories_id ... let's say it is 66

2 Get the manufacturers_id ... let's say it is 3

3 Backup your database in case you blow it ...

4 Run in phpMyAdmin the command:

insert into products_to_categories (products_id, categories_id) select products_id, 66 from products where manufacturers_id = 3 and products_id not in (select products_id from products_to_categories where categories_id = 66);

Now ALL Products with manufacturers_id 3 are Linked Products in categories_id 66

Now, let's say you want categories_id 66 to be the master_categories_id for all these products ...

Go to the Category categories_id 66 so that you can see the C for Copy on the Products and click it ... now click on Multiple Categories Linked Manager ...

Down at the bottom of the page you will see:

Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...
Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID Reset the Master Categories ID for All Products in Category:

Enter the categories_id of 66 and all Products will be changed to have categories_id 66 as their master_categories_id ...

[mc12345678]

If you want to make a Category with ALL the Products that have a manufacturers_id of XX as Linked Products ...

1 Make a new Category and note the categories_id ... let's say it is 66

2 Get the manufacturers_id ... let's say it is 3

3 Backup your database in case you blow it ...

4 Run in phpMyAdmin the command:

insert into products_to_categories (products_id, categories_id) select products_id, 66 from products where manufacturers_id = 3 and products_id not in (select products_id from products_to_categories where categories_id = 66);

Now ALL Products with manufacturers_id 3 are Linked Products in categories_id 66

Now, let's say you want categories_id 66 to be the master_categories_id for all these products ...

Go to the Category categories_id 66 so that you can see the C for Copy on the Products and click it ... now click on Multiple Categories Linked Manager ...

Down at the bottom of the page you will see:


Enter the categories_id of 66 and all Products will be changed to have categories_id 66 as their master_categories_id ...

And all I can say is, AND THAT'S WHY YOU AND THOSE AT ZC ROCK!!! Obviously know the inner workings/relationships of how the core of ZC works. I'm simply impressed, even if this isn't something I needed personally/professionally.

[Ajeh]

Just had to fool with the way to build this bad boy ... then tested it out and voila! The magic occurred ... I thought it was pretty cool too!

[fakeDecoy]

It sounds like that solution would work, but wouldn't it affect the breadcrumbs display for category browsing? When a visitor views that product, unless the cPath parameter is in the url, he would find himself browsing the Sale category instead of the category that makes sense. Technically it would still work, but that seems like a nasty tradeoff.

I want a 1-week sale for all products by one manufacturer, amounting to about 200 products. It seems that the most efficient way to do this without messing up my breadcrumb display is to create an SQL statement adding records to zen_specials.

[Ajeh]

You could try this attachment ...

It allows for the Adding/Removing by Category (master_categories_id) or Manufacturer (manufacturers_id) and see how that works for you ...

Be sure to backup your database before attempting to use this ...