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

[dulux]

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

My sale maker gives me an all product sale option and category sale option, but not by manufacturer... how can I do this?

[Ajeh]

SaleMaker is based on the master_categories_id of the Product ...

If you were able to make a Category for something like:
Manufacturer

then subcategories for each of your Manufacturers you could make those categories the master_categories_id after Linking your Products to those Manufacturers Categories and setting them as the Master Category for each of your Products ...

Now setup your SaleMaker sales based on the Manufacturers Categories you want on Sale ...

You might try this on a test work site for your shop and see how this works and if it has the desired affect ...

[dulux]

thanks a lot

[dulux]

[QUOTE=Ajeh;1212063
then subcategories for each of your Manufacturers you could make those categories the master_categories_id after Linking your Products to those Manufacturers Categories and setting them as the Master Category for each of your Products ...

.[/QUOTE]

Hi again, do you know how to make a quick update (or module) for several products from one manufacturer to add the new master manufacturer category?????

one by one is so slowlyyyyyyyy!!!!!!

[mc12345678]

Hi again, do you know how to make a quick update (or module) for several products from one manufacturer to add the new master manufacturer category?????

one by one is so slowlyyyyyyyy!!!!!!

I don't know the exact statement(s) that would be required; however, sql would be a way to make that type of update quickly. Otherwise, a version of ez populate may be able to help if that version supports sale maker for sale.

[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!