Salemaker Not applying to all products
I seem to be having some technical difficulties with salemaker. I tried to set up a sale for specific products (paper and cardstock) in a select price range ($0.55 to $0.75) but instead of making all paper and cardstock on sale it seemed to pick and choose and only listed some of them on sale.
So I edited it and selected entire catalog (since paper and cardstock are the only items in that price range) figuring this would correct the problem but that didn't work either.
I then deleted the sale and created a new one trying both ways again and that didn't work.
I'm not sure what I'm doing wrong since the other sales are appearing fine. I've even rebooted my computer just in case it's something on my end. Any suggestions?
Re: Salemaker Not applying to all products
I think I figured out a way to work around the system. Found a post from Jstuff under the wishlist, so I just changed the Master category on all the products that needed to be on sale but salemaker wasn't putting them on sale. It's a temp fix but at least it'll work :)
Re: Salemaker Not applying to all products
If you are importing products ... most import programs do not manage the Master Categories ID correctly ...
The master_categories_id controls the pricing for things like Sale Maker ...
When a Product is Linked ... the master_categories_id needs to be the Category that "owns" the Product so when put on Sale, it will reflect the price properly regardless of where or how the Product is displayed ...
Re: Salemaker Not applying to all products
So, how do I fix it so that sale maker works with all my items?
For some reason it just adds the sale to the first item in each category that I selected.
I am new to zen cart. I just switched from osc last week and imported all my products. (I'm also fairly new with php and sql.)
Any help would be much appreciated.
Thanks,
Corinne
Re: Salemaker Not applying to all products
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 ...
Quote:
Reset ALL Products Master Categories ID
to be used for Linked Products and Pricing:
click Reset ...
Then, fix the products_price_sorter from the Tools ... Store Manager ...
Quote:
Update ALL Products Price Sorter
to be able to sort by displayed prices:
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 ...
Re: Salemaker Not applying to all products
Worked beautifully!
Thank you!!!!
Corinne:D
Re: Salemaker Not applying to all products
You are most welcome ... thanks for the update ... :smile:
Note: there are many differences in Zen Cart from osC ... be sure to test *everything* from start to finish to make sure that your database has been updated correctly for all of the new database tables, fields, features, etc.
Re: Salemaker Not applying to all products
Re: Salemaker Not applying to all products
Well.. this isn't working for me ..
Give it a check.. here : http://www.compra-a-mim.com/brindes-c-67.html
As you may see.. all products in this category are in fact on salemaker promotion but only a initially few do apear. I tryed fixing it as mentioned.. but the results are the same anyway... any idea ?
Re: Salemaker Not applying to all products
Look in your database at the products table and find products_id 1139
What is the master_categories_id set to?
What version of Zen Cart are you running?
Clean install or an upgrade? If an upgrade from what version and how did you do the upgrade?