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?

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 :)

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 ...

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

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 ...

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 ...

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 ...

Worked beautifully!

Thank you!!!!

Corinne:D

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.

Helped me too thanks.

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 ?

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?

Ajeh:

Look in your database at the products table and find products_id 1139
Ok.. got it...

Ajeh:

What is the master_categories_id set to?
Well it's at value 67

Ajeh:

What version of Zen Cart are you running?
Moderated modifyed version of a fresh installed 1.3.5

Ajeh:

Clean install or an upgrade? If an upgrade from what version and how did you do the upgrade?
It was a clean installed version.

I try to update any bugs as frequently as possible, but since this is a modifyed version i must do all of these bug update "modifications" manually..

By the way.. sorry abt my late reply.. (was out of town for a few days)

What is the categories_id of the Category you put on Sale? Is it 67?

Ajeh:

What is the categories_id of the Category you put on Sale? Is it 67?

Yep.. right on! :cry:

What are the exact settings in Sale Maker that you are using?

What happens if you switch to Classic?

What happens if you turn off the SEO stuff?

Are all the Products in categories_id 67 setup with that Category as the master_categories_id

Does this mean you did a full upgrade to something?

Moderated modifyed version of a fresh installed 1.3.5

Have you installed any add-ons?

Ajeh:

What are the exact settings in Sale Maker that you are using?
Here you go..

Ajeh:

What happens if you switch to Classic?
What do you mean by classic ? Classic template? If so.. same thing happens.. :(

Ajeh:

What happens if you turn off the SEO stuff?
Sorry... same thing. Tested it just now.

Ajeh:

Are all the Products in categories_id 67 setup with that Category as the master_categories_id
Yeah.. checked one by one!

Ajeh:

Does this mean you did a full upgrade to something?
No.. it means that it was a fresh installation! I also meant that it was initially done by a fresh installation of wich i have also modifyed it in a moderate way (not heavy modifyed and not light modifyed... just moderated)

Ajeh:

Have you installed any add-ons?
Yes.. sure.. quite a few. Image Handler 2, Google Sitemaps, email exporter, easy populate, newsbox, link manager, printable price list, cross sell,etc

If you look up products_id 1083 Capa para maços de tabaco - Flores in the Admin ... what price does it show on the list of Products for categories_id 67? and in the Preview if you edit it?

Ajeh:

If you look up products_id 1083 Capa para maços de tabaco - Flores in the Admin ... what price does it show on the list of Products for categories_id 67? and in the Preview if you edit it?
Here you go...

Hope it helps

Just above the Product Name when you edit the product you should see:

Product Master Category: ID#

What is next to it?

Sorry about my late reply .. once again. i was out of town.

As requested.. here it goes :

"Product Master Category: ID# 67 Brindes"

I am thinking that a good test might be to create a new database and load a copy of your database into it ...

Then load a clean copy of Zen Cart v1.3.7 into a subdirectory such as:
/test_shop

Then copy your 2 configure.php files
/includes/configure.php
/admin/includes/configure.php

Change the paths and database name, username and password to match this new directory and new database ...

Login to the Admin and change to Classic Template ... and turn off the setting for SEO as it is not in this code ...

And see what the Sale Prices do ...

Something appears off on your site and I don't know if there is code out of date, an add-on or what affecting things as this isn't making logical sense based on what you have said so far ...