Salemaker Not applying to all products

Ajeh:

If you look at your database at the products table via phpMyAdmin ...

Do all of your products have set both the:
products_type
master_categories_id

If not, do you use Linked Products?

If not, you can fix the master_categories_id with the Tools ... Store Manager ...

click Reset ...

Then, fix the products_price_sorter from the Tools ... Store Manager ...

click Update ...

The Products Price Sorter cannot be fixed until after the master_categories_id is set ...

WARNING: before attempting anything ... backup your database

NOTE: if you do not have products_type set on your products, this should be fixed before doing anything ...

i was having the same problem with sub catagories not going on sale. this worked beautifuly. thank you :)

Thank you so much Ajeh! This worked wonderfully for me too!

Thanks for the update that this was able to correct your price issues ... :smile:

Sorry if this is a duplicate response, but don't have time to read them all.

I applied Salemaker to my whole catalog, but had some random products that were not applying to. No other products had any other specials, sales or anything.

But, after performing the following (non-logical) procedures, the sale applied to each one. (happened by chance)

I edited the product and cancelled. Then I clicked on the Products Price Manager (round green icon with white dollar sign), then (without making any changes) clicked the Back browser button. Then I edited the product and cancelled again. And walla! The Sale applied! Yay! :clap:

I had this problem also with sale price applying to some products and not others (seemingly randomly). As Ajeh has said a number of times through this thread, it turned out the problem was caused because some products had no master category id. Not sure why, perhaps something to do with an easy populate upload.

For me, the easiest way to fix was to go to the multiple category link manager (where you can link a product to more than one category - accessed when you copy a product). Right at the bottom of this screen is an option to reset the master category id for all products in that category. Once I did this for each category that I wanted to put on sale, problem solved.

cheers
Leah

Ajeh:

If you look at your database at the products table via phpMyAdmin ...

Do all of your products have set both the:
products_type
master_categories_id

If not, do you use Linked Products?

If not, you can fix the master_categories_id with the Tools ... Store Manager ...

click Reset ...

Then, fix the products_price_sorter from the Tools ... Store Manager ...

click Update ...

The Products Price Sorter cannot be fixed until after the master_categories_id is set ...

WARNING: before attempting anything ... backup your database

NOTE: if you do not have products_type set on your products, this should be fixed before doing anything ...

Thanks Linda this worked for me also!!!!:clap:

Thanks for the update that you were able to fix this ... :smile:

This worked for me as well. (reset master categories).

Specifically our problem related to creating new products via Easy Populate. When this was done, the new products were ignored via Sale Maker. Resetting the master category solved this and now the sale is on all products in the category.

Thanks for the update ... :smile:

Sale Maker needs that master_categories_id to verify the Sale of a Product for those Category settings ...

How does product linking affect this?

All products are in one category and then copied to other categories. Placing one category on sale - not the master category - seems to have no effect.

Hey, I had the same issue and it worked for me fine - thanks

K, I've read through all this, I'm having the same problem and I still can't get it to work. I have each designer/manufacturer set up as a master category ID. Then we have just regular categories that all products are linked to one or more of. All of our products have one of the designers as their master category. I'm trying to set up a sale on a specific category (digital kits) on sale and it isn't showing up. All products in the digital kits category are linked to a master id of whoever the designer/manufacturer is.

SaleMaker uses the master_categories_id for the Sales ... since the master_categories_id of your products belong to your Designers when you try to put a Mixed Category on Sale, none of the Products use it as the master_categories_id ...

So, the Sale is never applied ...

so, how do I fix it?

You would have to either re-write how SaleMaker works ... or set those Products to use the Sale Category as the master_categories_id ...

hmmm, I know at the other store I sell at, the designers are the master category ID there, but the storewide sales there work.

You might check the other store and see if there are customizations to the code that allow for that ...

So then, I guess I'm confused at why all the other categories show up under sale maker if checking them doesn't do anything. She said she didn't do any customization at the other store and I've verified that my folder tree for categories is set up the same as hers.

What versions of Zen Cart are you using on the sites?

mine is 1.3.9
hers is 1.3.8