I had a customer purchase $3000 worth of a product but was almost shipped $300 worth of it. I caught the error in time but it is very reproduceable for this particular product.

The product has 3 variants, measured in bag size. 3.75, 16.5 and 33 lbs.

No matter which one I choose, the ProductSku field always uses the 3.75 variant. That productSku is loaded into cart database table, which is then loaded into the order details table.

The crazy thing is the Price, Bag Size, Order Email to the customer is correct. But since I use the ProductSku from the OrderDetail table to email the distributor so they know what to ship, this is a HUGE problem. They had already loaded the 10 smaller bags but luckily I caught it and got it fixed.

This doesn't happen for any other product. I have verified via the GUI and the database that the variants are set up correctly.

Any ideas what could be causing this?

I tried to replicate it on our test site, but was unable to do so, would you mind configuring the test site the way your site is set up and trying to reproduce it?

If deleting the variables and re-adding them fixed the problem, it could of been that something got out of sync in the database, during an upgrade or something like that.

If you need login information to the test site, please email me @ christian@smith-consulting.com

Thanks,

Christian