Attribute pricing problem

Hi,

I have a product that has a special price (15% off)

I have an attribute that uses onetime_price_factor (20%)

When I view the product detail page, it calculates everything correctly. When I add the product to the cart, it then calculates the attribute off the regular price of the product, not the special price

Any ideas here?

Did you accidentally turn on the Price by Attribute when it is not needed?

Ajeh:

Did you accidentally turn on the Price by Attribute when it is not needed?

Product Priced By Attributes is set to NO in the product screen.. Is that what you were referring to?

Check that you have applied all of the Known Bug Fixes at:
http://www.zen-cart.com/forum/showthread.php?t=82619

This is also a good time to review the Security Patches and Updates at:
http://www.zen-cart.com/forum/showthread.php?t=131115

Also, check your Quantity Discounts and make sure that you have it set to the Special vs the Price ...

Most likely this is related to post #24 on the Known Bugfixes but note all are important ...

Ajeh:

Check that you have applied all of the Known Bug Fixes at:
http://www.zen-cart.com/forum/showthread.php?t=82619

This is also a good time to review the Security Patches and Updates at:
http://www.zen-cart.com/forum/showthread.php?t=131115

Also, check your Quantity Discounts and make sure that you have it set to the Special vs the Price ...

Most likely this is related to post #24 on the Known Bugfixes but note all are important ...

Thanks - where is the Quantity Discounts setting located?

I am assuming the Discount that you are using are on the Catalog ... Products Price Manager ...

Yes.. Everything looks right, see screen shot

You are not using the Discount Quantities on this Product, you just have a Special ...

Have you tried the Known Bug Fixes to resolve this problem?

Ajeh:

You are not using the Discount Quantities on this Product, you just have a Special ...
Not sure I follow... Where/What is this setting?
Ajeh:

Have you tried the Known Bug Fixes to resolve this problem?
Yes, I did #24 like you suggested, didn't solve the problem

I added a product to the products_discount_quantity table (it was empty) and then added it to my cart, same thing - On the detail page, shows the correct pricing for the product and attributes, when added to the cart, it gives me a different total, and the attribute is priced differently (percentage based off retail price, not special price)

Could you post the exact settings on one of the Attributes that is not working?

Sure, see attached ZIP file with CSV

Thanks!

Could you perhaps make life easier on me and also supply an image of the Attributes Controller if you EDIT the Attribute that you are testing? :smile:

Sure, no problem.. Will these work?

http://i48.tinypic.com/2uix2za.jpg
http://i46.tinypic.com/4ktvle.jpg

Congratulations ... you found a bug! :clap:

Unfortunately, you found a bug ... :blink:

Good news ... I may already have a fix for you ... :flex:

Try a test, and edit the files:
/includes/functions/functions_prices.php
/admin/includes/functions_prices.php

find the function zen_get_attributes_price_factor ... and make the following change:

////
// return attributes_price_factor
  function zen_get_attributes_price_factor($price, $special, $factor, $offset) {
//    if (ATTRIBUTES_PRICE_FACTOR_FROM_SPECIAL =='1' and $special) {
    if ($special) {
      // calculate from specials_new_products_price
      $calculated_price = $special * ($factor - $offset);
    } else {
      // calculate from products_price
      $calculated_price = $price * ($factor - $offset);
    }
//    return '$price ' . $price . ' $special ' . $special . ' $factor ' . $factor . ' $offset ' . $offset;
    return $calculated_price;
  }

Does this magically fix the problem?

Carefully test this as I have not fully tested this yet ... and let us know if this fixes the One Time Factor on your attributes when using a Special on the Product ...

I <3 YOU!

That fixed it!

Thank you so much for taking the time to help solve the problem!!

I have one other problem you might be able to help me with?

If I set my attribute percentage in "attributes_price_factor_onetime" - it displays the correct dollar amount for the attribute on the product detail page. However, when I go to complete checkout, I get an error (see my other threads)

If I set my attribute percentage in "attributes_price_factor" - it displays the wrong dollar amount for the attribute on the product detail page. However, when you add to cart it is the correct dollar amount, and when you complete checkout you get no errors.

So, basically, I need to figure out how to display the correct dollar amount for the attribute, using "attributes_price_factor", so that everything works

Any ideas?

It could be here? /includes/modules/attributes.php

                    // collect price information if it exists
                    if ($products_options->fields['attributes_discounted'] == 0 && $products_options->fields['options_values_price'] == '0.0000') {
                      // apply product discount to attributes if discount is on
                      //              $new_attributes_price = $products_options->fields['options_values_price'];
                      $new_attributes_price = zen_get_attributes_price_final($products_options->fields["products_attributes_id"], 1, '', 'false');
                      $new_attributes_price = zen_get_discount_calc((int)$_GET['products_id'], true, $new_attributes_price);
                    } else {
                      // discount is off do not apply
                      $new_attributes_price = $products_options->fields['options_values_price'];
                    }

A Bazzillion people and you want me to find which of your other threads relates to the problem ... work with me here and tell me which thread(s) refer to this new issue? :smile:

Ajeh:

A Bazzillion people and you want me to find which of your other threads relates to the problem ... work with me here and tell me which thread(s) refer to this new issue? :smile:

lol, sorry :blink:

http://www.zen-cart.com/forum/showthread.php?t=145749

Right now, everything works on the cart - when I add the product with attribute, it correctly adds in the cart, and checkout works without issue. I think I just need to figure out how to properly calculate the attribute cost on the detail page, because the only problem is it just displays the wrong price

I have two attributes though, to note, one is a flat charge ($350 for example) and the one that I'm having trouble with is the second attribute which calculates as a percentage of the cost of the product

If you look at this product detail page, look in the attribute drop down, you'll notice those two dollar values are not 20% and 40% as they should be

http://tinyurl.com/yf5zhwh