Group discount based on manufacturer

[time111]

Hi,

I need to know is there a way where I can issue standard flat 5% or 10% etc., discount to all items on one or more particular manufacturer.

thanking you in advance.

~ Time

[AATECH]

Yeah.. I Also would like to know... Anyone?

Thanks.

[Ajeh]

If you have added the Known Bug Fixes for v1.3.8a ... specifically the ones on #28 about the Sale Maker bug ...
http://www.zen-cart.com/forum/showth...707#post696707

You can create Categories for each of the manufacturers_id that you have and make that the Products Master Category ...

Then, you can place the Master Category with a specific Sale for that Manufacturer ...

I usually make a Category called Manufacturer (or something like that) and then add SubCategories for each manufacture ...

Then, you can add the Products as Linked Products to those new categories and then set as the Master Categories ...

[time111]

Hi,

I already have around 4000+ items with running site in above 10 categories and 50+ sub-categories. So redoing entire thing is not possible. Any idea how can I go around to implement your formula.

~ Time

[AATECH]

Wow that was a quick reply... Thank you.

I fixed the bug fix as you mentioned... But I'm having a hard time understanding the rest of the steps?

You can create Categories for each of the manufacturers_id that you have and make that the Products Master Category ...

Then, you can place the Master Category with a specific Sale for that Manufacturer ...

I usually make a Category called Manufacturer (or something like that) and then add SubCategories for each manufacture ...

Then, you can add the Products as Linked Products to those new categories and then set as the Master Categories ...

Can you Elaborate a bit more.

Thank You So Much.

[Ajeh]

Add a Category called:
Manufacturers

Now make subcategories in that for each Manufacturer ...

Next, you can Copy the Products as Linked Products to those New Categories ...

Once you have at least 1 Product in each of the New Categories, you might look at the Multiple Categories Links Manager that is at the bottom of the right panel when you hit C for Copy ...

It has some handy methods to link Products to other Categories and change which category is the master_categories_id ...

NOTE: be sure to backup all


If you have MySQL 4.1 (or newer) I think it is ...

there is a neat way to say add all products_id from the products table to the products_to_categories table where manufacturers_id = 3 and set the categories_id to 27 for the NEW Categoryand NOT add it if it is already there for categories_id 27 ...

Where 3 is the manufactuers_id ...
Where 27 in the new categories_id ...

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

Afterwards, you need to set this as the master_categories_id on the Products, and that can be done in the Multiple Categories Links Manager and at the bottom you can pick a Category to be the master_categories_id ...

Again ... Always Always Always Backup your database before trying these ...


And thank DrByte for helping me work through this fancy insert ...

[AATECH]

I have too many categories and products to do this. But lets say I do this, is there any way to hide that category (and all subcategories and products under it) called manufacturer that is now added to the list of categories in the front-end of the website?

Thanks Again...

[Ajeh]

Make the Manufacturers Category and set it to status off ...

Then make your other Categories ...

Now you can use the command after you make each Category to load the Products for the Manufacturer into it as Linked Products ...