Emergency - SaleMaker is not working

[beyre]

www.theironhorseman.com

It works on some products but not on others ....

Edited: Seems to only work on those products that have NO options.
I can understand a glitch if an option was an additional price (ex. X-large +$2.00), but it's not working on those options that are no additional cost.

It shows the 15% discount ... but it's not being transferred to the cart.

When I set up the sale, I tested and tested and every product I added to the cart showed just fine. But now that we are getting orders for the sale, the prices are not reflecting the sales price.

This is a basic sale: 15% off ... site-wide, all products.

What is wrong ???

None of the 3 conditions (If a product is a special) apply as none of our products ARE specials ... so I have it set on the first one (Ignore specials price) ... since it's the only one that allows for the display of the sale price next to the product. That whole drop down is so unclear.

[Ajeh]

Check the setting on the Attributes for:

Apply Discounts Used
by Product Special/Sale:
No Yes

Also if you use Linked Products be sure to check the Known Bug Fixes for v1.3.8 ...
http://www.zen-cart.com/forum/showthread.php?p=697924

[beyre]

I think I found the answer ...

ON the page where you create your product ....

I have it set to YES for Product Priced by Attributes.

I figured it was supposed to be set to this because there are many options that cost additional $.

But if I turn this to NO ... then the salemaker sale works.

Now, can I turn this to NO (off) in the database so I don't have to edit over 3500 products manually?

If I can do this in the database ... what am I looking for?

[beyre]

Where are these settings you're talking about ???

EDITED: Found it, very bottom of Attributes Controller ....It is set to YES

Check the setting on the Attributes for:


Also if you use Linked Products be sure to check the Known Bug Fixes for v1.3.8 ...
http://www.zen-cart.com/forum/showthread.php?p=697924

[Ajeh]

Priced by Attributes is for Products where the Product price is 0.00 and the attribues make up the full price ...

Most products are NOT Priced by Attributes ... they just happen to be Products with attributes that may or may not have attributes that may or may not add/subtract an amount ...

To set all products to NOT be set to Priced by Attribute:

1 backup your database

2 make sure you followed step 1

3 run the following command in the Tools ... Install SQL Patches ...

UPDATE products SET products_priced_by_attribute = 0;

[Ajeh]

Where are these settings you're talking about ???

There a individual settings per Attribute where you can turn OFF the Special/Sale being applied to the Attribute in the Attributes Controller ...

Your issue does sound like you have your products set to Priced by Attribute and they are not ...

[beyre]

Linda,

You're a Godsend - doing that database fix did the trick.

Now, no matter what product I add to the cart (selecting random options ... some with and some without additional cost) the correct sales price is being displayed in the cart.

I wonder why that Products are priced by Attributes is YES be default ... since it's rare to have products at $0.00, and to be priced by their attributes only ... you would think the default would be NO. Since it was YES by default, I assumed it was set correctly for the typical shopping cart.

Now to do that fix in the other carts ....

[Ajeh]

By default, Product is Priced by Attribute is NO ... perhaps you have something changed in the code?

[beyre]

Sorry to take so long to respond.

I have no clue what have changed it from No to Yes on these carts.
Unless I'm doing something under Configuration that I'm thinking is one thing, but ends up being associated with this.

The only mods I have installed are:

Google checkout
Google analytics
Supertracker
monthly sales reports
image handler
blank sidebox
checkout without account (on 2 of the 4 carts)

[Ajeh]

Could you check the file. on the server, for:
/admin/includes/modules/collect_info.php

and search for:
products_priced_by_attribute

what does that whole array, approximately lines 12-42, for the $paramaters read?

Note: I am assuming you are using normal Product General product type ...