When I add a cart and checkout, then come back to the website the pricing table of that product changes. Example below.

I buy a product for 28.00 and check out.
When I come back to the website the product has changed to 2,800.00. Then in the pricing table it goes from the quantity price range so
27.00 turns to 2,700.00 and 26.00 turns to 2,600.00 and so on.

Is this a known bug? and how do you fix it.

CommentFileSizeAuthor
#10 Screen Shot 2011-10-29 at 7.52.30 AM.png80.09 KBscottcarlton
#2 Screen Shot 2011-10-26 at 3.09.11 PM.png26.05 KBscottcarlton
#2 Screen Shot 2011-10-26 at 3.14.34 PM.png23.24 KBscottcarlton

Comments

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Status: Active » Postponed (maintainer needs more info)

Hi,

How do you reproduce this? what's exactly the "When I come back" trigger that makes the prices break? I'm not sure how to reproduce this.

scottcarlton’s picture

scottcarlton commented
StatusFileSize
new Screen Shot 2011-10-26 at 3.14.34 PM.png23.24 KB
new Screen Shot 2011-10-26 at 3.09.11 PM.png26.05 KB

Not sure how to reproduce this. After I check out with the correct price at 28.00 and the order is complete the pricing table price gets move over two decimal points to 2,800.00 as show in the images below. I have tried both the dev version and the 1.0 version. Also check my reports but nothing was show that the price was changed, but still happens. Will continue to test.

scottcarlton’s picture

scottcarlton commented

I disable the "Override price with price table" rule and checked out with not issue to the price upon return to the products page. If "Override price with price table" is enabled the price after checkout again gets set two decimals to the right again. So it seems that it has something to do with the Price Table module. Something assumes raw prices are in major units instead of minor.

scottcarlton’s picture

scottcarlton commented
Status: Postponed (maintainer needs more info) » Active
pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Priority: Major » Normal
Status: Active » Postponed (maintainer needs more info)

I'll answer the same as in #1274830: Price changes on (some) checkout, I have made all kind of tests here and I'm still not able to reproduce this behavior, so there's something missing and I need a lot more information to check what can be wrong.

Is this happening for every product with price table?
Is there something "special" about the product/product types? Can you try with a simple product type, no attributes, just price table in a clean install?
This happens while the product is in a cart or checkout process? what's the exact moment when the price is spoiled? is it permanent?

Note that if I can't reproduce it, I won't be able to solve it.

scottcarlton’s picture

scottcarlton commented

I will run some test this weekend on basic product, install clean version and some other suggestions I got. Will update you. Ya it's wired, but it happens with all products that have pricing tables. It doesn't happen until after checkout, Once the order is complete. You have to go back into your pricing tables to change the price back for each table, if not, the price will continue to get larger each time that product goes through checkout. So a product that originally was 28.00 will go to 2,800.00 dollars after checkout and then to 280,000.00 then next checkout if the price isn't corrected manually in the tables. Hopefully we will get this solved.

scottcarlton’s picture

scottcarlton commented
Status: Postponed (maintainer needs more info) » Fixed

Ok, I started over. Fresh Drupal install, fresh commerce install, fresh modules the whole works and it has seemed to fix the issue. Just have to pull all my info back into it, but worked! Thanks for the help!

scottcarlton’s picture

scottcarlton commented

Nope I was wrong....still doing it. Well I'll just have to disable this module for now.

scottcarlton’s picture

scottcarlton commented
Status: Fixed » Closed (cannot reproduce)
scottcarlton’s picture

scottcarlton commented
Status: Closed (cannot reproduce) » Needs review
StatusFileSize
new Screen Shot 2011-10-29 at 7.52.30 AM.png80.09 KB

Below is a list of the modules that are installed:

Chaos tools 7.x-1.0-rc1
Commerce 7.x-1.0
Authorize.Net 7.x-1.x-dev
Commerce price table 7.x-1.0
Commerce Stock 7.x-1.0-rc1
Physical Product 7.x-1.x-dev
Shipping 7.x-2.x-dev
UPS 7.x-1.x-dev
Address Field 7.x-1.0-beta2
Physical Fields 7.x-1.x-dev
AES 7.x-1.5
Entity 7.x-1.0-beta11
Rules 7.x-2.0
Views 7.x-3.0-rc1

Then I also supplied a picture of how my product type fields are set up below. Hopefully this will help. This still occurred on a clean install of drupal and all modules.

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Status: Needs review » Postponed (maintainer needs more info)

I'm confused then, did this happen with a clean install and NO other module installed but the "required ones"?

So, if you install this config, you can consistently reproduce the problem, is that right?

Chaos tools 7.x-1.0-rc1
Commerce 7.x-1.0
Commerce price table 7.x-1.0
Address Field 7.x-1.0-beta2
Entity 7.x-1.0-beta11
Rules 7.x-2.0
Views 7.x-3.0-rc1

Have you tried if this happens using -dev version of commerce? You're using versions of entity and rules way ahead of the recommended ones for commerce 1.0.

scottcarlton’s picture

scottcarlton commented

pcambra thanks for responding so quickly. Sorry to be such a PITA. I'll give this set-up a try on a different dev site with a clean install.
This does happen even with the -dev version of Commerce.

scottcarlton’s picture

scottcarlton commented

All right we are making headway here. Everything went great and found the conflicting module. Commerce Stock once add to the module changes the table pricing for some reason. Going to head over there and see if we can figure this out.

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Status: Postponed (maintainer needs more info) » Active

Oh, finally a clue! thanks for the tracking of this, I'll give it a try combined with commerce stock module.

guy_schneerson’s picture

guy_schneerson commented

subscribing

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented

#15 please use follow button instead of suscribing: http://drupal.org/node/1306444

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented

Issue #1326102: Commerce Stock & Commerce Price Table Conflict crossposted in Commece Stock module

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Status: Active » Fixed

Crossposting in both projects so everyone knows what was happening here.

I've just committed a fix (http://drupalcode.org/project/commerce_price_table.git/commit/361233a) for this in commerce price table project.

It seems that at some point Commerce stopped converting the amounts from integet to decimal for prices in field_presave function and started doing it at widget validation level, this caused that all prices for price table got converted twice on product save in rules (that is the commerce stock approach for decrementing stock).

Thanks scottcarlon, guy_schneerson & 1kenthomas for reporting this and helping me to reproduce it and get the fix in the right direction.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.