Starting at:$Wrong - Priced by Attributes/Option Values Issue

Hello Everyone,

I'm getting a random issue the 'Starting at:' being calculated incorrectly. All of of my products are set to 'Priced by Attributes' with numerous options and options values all set to be "included in the base price" . My understanding is that Zen Cart should take the lowest price for of each option and add them up to calculate the 'Starting at:' price. Most of my products work exactly this way, however some just don't, an example is found here:

http://www.kcbgraphics.com/index.php?main_page=product_info&cPath=17_208_213&products_id=2060

The lowest price for this should be 'Starting at:$6.56' but instead it includes a $25.00 charge included under 'Is Design Required' for price of $31.56. If I set this option value to 'Not Included in Base Price' in the Attributes Controller it calculates correctly. If I compare this product to others that function correctly there appears to be no difference between their settings.

What's the best way to correct this glitch/anomaly?
Any help or comment would be appreciated. Thank you.

Actually, it appears to be adding in the two $15.00 prices to the $6.56 ...

Check that all of the Attributes are marked as:
Include in Base Price
When Priced by Attributes YES

Ajeh:

Actually, it appears to be adding in the two $15.00 prices to the $6.56 ...

Check that all of the Attributes are marked as:
Include in Base Price
When Priced by Attributes YES

Hi Linda,

Thank you for the reply.

If it was adding the $15.00 prices x 2 + 6.56 that would be $36.56, I'm seeing $31.56.

All of the attributes associated with this product look like this:

And I've got them set as 'Priced by Attributes' as shown here:

Any other thought on what might cause it?
Thanks Linda.

Paul

More coffee ... that's the ticket ... :lookaroun

You have the Option Names:

Is Design Required:

Choose your Proof:

Choose your Production Time:

What are the settings on those Attributes ... you only showed some of them ...

Hi Linda,

They're all the same as shown here:

Just for giggles and grins ... can you edit this Product and make sure that its Product Price is set to 0.00 ...

Ajeh:

Just for giggles and grins ... can you edit this Product and make sure that its Product Price is set to 0.00 ...

Sure no problem....Done, but no change to the price.

I really am not seeing the problem with this ...

Is this a Clean v1.5 or an Upgraded version?

If you switch to Classic Template, does anything change?

What are your Attribute settings on:
Holiday Wine Bag products_id 2048

What are your Attribute settings on:
Neoprene Bottle Cooler products_id 647

Ajeh:

I really am not seeing the problem with this ...

Is this a Clean v1.5 or an Upgraded version?

If you switch to Classic Template, does anything change?

I upgraded from 1.39h to 1.50 5 days ago....

Ajeh:

What are your Attribute settings on:
Holiday Wine Bag products_id 2048

What are your Attribute settings on:
Neoprene Bottle Cooler products_id 647

They're the same...as shown here.

If I switch 'Is Design Required: Yes $25.00' to NOT included in the Base price the problem is solved.

Hi Linda,

If I delete the option 'Is Design Required' and add it again the problem is gone. I just did it with product 2048 here:

http://www.kcbgraphics.com/index.php?main_page=product_info&cPath=17_208_213&products_id=2048

While that will work ... it makes no sense that you have to do that ...

So far, I cannot reproduce this issue in v1.3.9 nor in v1.5 ...

Find another one that is bad ... and rather than delete the Attribute, edit and update the Product ...

Ajeh:

Find another one that is bad ... and rather than delete the Attribute, edit and update the Product ...
Thanks for the help on this Linda.

I tried that and still no change... but while doing that I noticed a small difference in the 'Is Design Required:Yes (Type & Graphics)' option value, there's no + sign for the price prefix and shipping weight prefix as seen here:

If I click edit there is this � showing instead of + and if I change it to + it corrects the pricing problem. On other products with the same problem if I click edit there will be a + sign showing and I click save the + sign disappears, click edit again I see �.

This problem only seems to occur with 'Is Design Required:Yes (Type & Graphics)' and no other. I guess theoretically I can export the data using Apsona and try replacing that symbol.

Puzzling :blink::blink:

When I get some time, I will try that and see if I can reproduce it ...

If you look at the structure of your database tables, such as the table:
products_attributes

what do you see on the collation for the Prefix field?

If you look in your configure.php files for:
/includes/configure.php
/your_secret_admin/includes/configure.php

what is set for:
define('DB_CHARSET', 'utf8');

Ajeh:

If you look at the structure of your database tables, such as the table:
products_attributes

what do you see on the collation for the Prefix field?

If you look in your configure.php files for:
/includes/configure.php
/your_secret_admin/includes/configure.php

what is set for:
define('DB_CHARSET', 'utf8');

Hi Linda,

My apologies for the delay in responding.

Several weeks ago I converted my database and the required php files to UTF-8 from ISO-8859-1. I believe this was the source of these problems... and I see you were also looking to this area as the source. The problems seemed to be isolated to just one product category which I was also having Easy Populate issues with in the summer. I've since exported the attributes using Apsona, corrected the necessary data to the correct + symbol, imported it back in using Apsona and the problem seems to be resolved.

Thank you for your input on this Linda & Happy New Year to you!