The column definition for the price currently is INT UNSIGNED NOT NULL which is 4,294,967,295 and my current prices are below this numeral.
For example: (1) When I increased the price of the Kona::Half Pound - decaf - ground from $5.00 to $50.00 (added one 0). It is showing the correct result. $50.00 x 21 (qty) = $1,050.00.
(2) When I increased the price of Kona::1 lb. - caf - whole from $7.50 to $750.00. It is giving the correct answer. $750.00 x 2 = $1,500.00. BUT
(3) When I increased the price of Kona::1 lb. - caf - ground from $8.00 to $8,000.00. It is not giving the accurate answer.
(4) When the price of Kona::1 lb. - decaf - ground is increased from $8.50 to 8,500.00 and the quantity is increased from 1 to 2. It is showing $16.00 instead of $17,000.00.