SaleMaker issue for item that contains multiple sub-options/prices

Hi all. I'm running Zencart v150 and am currently using SaleMaker to run a store-wide 10% sale. All is good, except for ONE item, which just so happens to be the only item that has sub-options/pricing. So of course, I assume the problem lies somewhere in the setup of this one item.

You can see the item in question here:

http://cultivatedr e e f.com/index.php?main_page=product_info&cPath=19_2&products_id=453 (spaces added to URL to prevent search engine indexing)

The price currently displays as $0, although the item's actual price adds to your cart if you try to add it (not the discounted sale price, but the regular price). The sale price was previously displaying here (though the non-sale price was still adding to the cart) but I tried running this command under the SQL Query Executor to get the actual sale price to add to the cart: "SET products_priced_by_attribute = 0;" and that's when it changed the display price to $0 (as you can now see)... again, thankfully, the item doesn't add to the cart as $0.

I also tried going into tools > store manager, and resetting "ALL Products Master Categories ID" followed by updating "ALL Products Price Sorter".. still didn't do the trick.

Maybe something in the attributes controller? Thanks in advance.

now for some reason it adds to the cart at $65.. strange.. poking around and can't seem to figure out why

If you look at your Attributes ... most likely, all of them are marked to Not be included in the Base Price ...

If you want the price to show everywhere as $35.00, then set that attribute to be included in the Base Price ...

If you want the price to show everywhere as $65.00, then set that attribute to be included in the Base Price ...

If you want the price to show everywhere as $90.00, then set that attribute to be included in the Base Price ...

If you just want it to show the lowest of the Attributes, then you can set ALL of them to be included in the Base Price and the one that is the lowest price will be the displayed price, as Products that are set to Priced by Attribute will take the lowest price of the Option Name groups of Option Values and combine them to make the lowest price that you can buy the Product ...

Thanks for the reply. The item in question was already selected as "Yes" for the "Include in Base Price when Priced by Attributes" option so unfortunately this isn't it. Here are the rest of the flags for the item in question:

• Used For Display Purposes Only: No
• Attribute is Free: When Product is Free: Yes
• Default Attribute to be Marked Selected: No
• Apply Discounts Used by Product Special/Sale: Yes
• Include in Base Price When Priced by Attributes: Yes
• Attribute Required for Text: No

You say that this is v1.5, but I am not seeing in the source the in the header the:

<link rel="canonical" blah blah blah ...

Are you are sure that the master_categories_id matches the categories_id that SaleMaker is using?

Could you switch to the Classic Template for a minute and see if this corrects the problem?

i didn't install it previously, but in the top-right corner of the zencart admin it says: (You are presently using: v1.5.0)

Are you are sure that the master_categories_id matches the categories_id that SaleMaker is using?

this is a good question - i didn't set up the items (or anything in the store for that matter) but is there an easy way to check on this?

i also have just switched over to the classic theme... it wrecks the site so badly that it's difficult to test if this is the issue! i'll have to change it back quickly as this is a live store, but maybe that will shed some light.

thanks!

Your template is stopping the:

<link rel="canonical" blah blah blah ...

from being in the header ...

The Price is still wrong ...

To check the master_categories_id you can edit the Product ... and see what it reads for:

Product Master Category:

Product Master Category for this particular item reads as: ID# 2 LPS

Do you use Linked Products on your site?

If so, is this a Linked Product?

Nope, all of the stores items only appear in one category

If you edit this Product ... what is the setting on:

Product Priced by Attributes: Yes No

If not set to YES, change it to YES ...

okay, i switched this and now the display price looks good, but still, when you add it to your cart, it adds the non-sale price of $35 (instead of sale price of $31.50). see here:

http://cultivatedreef.com/index.php?main_page=product_info&cPath=19_2&products_id=453

the price variables ("frag size" in this case) don't display the sale price either, which isn't a huge deal to me, so long as the correct price adds to the cart. any ideas?

If you look in your Zen Cart Admin ... at the Attributes Controller for this Product ... what prices do you see on the listing for the Attributes?

here's a screenshot after i click "display" on the item in question under the "attributes controller".. seems like they're input properly here ($35, $60, and $90)

http://i589.photobucket.com/albums/ss336/ryanpatrickoconnor/screenshot1.jpg

and then if you click on "edit" (under the "action" field at the end) under one of the variables ("frag sizes"), it brings up this screen:

http://i589.photobucket.com/albums/ss336/ryanpatrickoconnor/screenshot2-1.jpg

the example above is from the first price ("one head" for the frag size variable... $35)

thanks

i can show an example of an item that's displaying the sale properly too, if necessary..

Something is wrong with your site ...

If that Product is in the Category that is on Sale with SaleMaker, then you should see both prices in your Admin on the Attributes Controller as well as on the store ...

I would really check your site and see that ALL files in both your /your_secret_admin_dir and your main files are all current and up to date or merged with your files ...

It strikes me that you do not have files up to date or you have bad data ...

gotcha.. sounds like a lot of work for ONE problematic item, argggh. was hoping it would just be something stupid/simple... seems really bizarre that this is the one item that has variables in the store and just so happens to be the problematic one. either way, thanks for your help.

Makes me think that this could be a sign of other problems lurking out there ...

Better to catch them now than to discover them later ...

true.. knocking on wood! i'm gonna leave this one alone for now (unless anyone else has any ideas?) and move on to the next issue i'm having. thanks Ajeh!

update: figured this out and can't believe it was previously overlooked. there's an option in Sale Maker called "If a product is a Special" and i simply changed it to "Apply sales deduction to specials price - Otherwise apply to price". It was previously set on an "Ignore" option, for whatever reason. Problem solved.. feels good to have this fixed, so I'll choose to forget about the number of hours I put in poking around the admin trying to tell what's what :P