FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

Using Zen Cart v1.3.7 full-fileset 12302006

The problem I have is, I have to work with FIXED Muliple Quantities at FIXED Prices per Multiple Quantity from a manufacturers list.

I've tried this in the ' Products Price Manager' page using the 'Discount Qty Applies to Mixed Attributes' section in various settings, but the end price just will not tally with the price list I have to work with, by either rounding up or down to the nearest price, but not the exact price I have to work with.

I've tried altering all instances in the database figures for 'prices' from
(15,4) NOT NULL default '0.0000',
(15,9) NOT NULL default '0.000000000',
Hoping that the increase in decimal places will correct the price, calculating the individuaul price of an item from the quantity, but it seems to make no difference

What other areas in the database need to be reset to calculate down to more decimal places?

Just from working with one of many price lists
20 items = 66.45
30 items = 76.40
40 items = 86.35
50 items = 96.30
60 items = 106.25
70 items = 116.20
and so on

Is there an easier or different way of doing this.

What settings are you using on the Discounts?

Hi Linda

Working from one fixed price list to quantities and prices, as supplied to me.
20 items = 25.50
30 items = 33.15
40 items = 40.80
50 items = 48.45
60 items = 54.40
70 items = 60.35
80 items = 66.30
90 items = 72.25
100 items = 78.20

Settings used (But have tried all variations) in Products Price Manager

Tax Class --none--

Product Price Info: 00.00

Qty Min:20
Qty Units:10

Product is Free:No
Call for Price:No
Priced by Attributes:No (but have also tried with Yes)

Discount Type: Actual Price
Discount Priced from: Price

To work out the Discount Value to use, I have to divide the quantity by the price to get a price for each individual item for each specific quantity.
But because the database only seems to calculate to 2 decimal places, the final price to the list price is not the same end result.

20 items = 25.60 but should be 25.50
30 items = 33.30 but should be 33.15
40 items = 40.80 This one Correct
50 items = 48.50 but should be 48.45
60 items = 54.60 but should be 54.40
70 items = 60.20 but should be 60.35
80 items = 66.40 but should be 66.30
90 items = 72.00 but should be 72.25
100 items = 78.00 but should be 78.20

Could do with something similar to the 'Discount Qty Applies to Mixed Attributes' module but simplified so that instead of 'Minimum Qty' just 'Quantity' and instead of 'Discount Value' just 'Fixed Price' for each quantity, with the ability of adding extra fields for extra quantities.

Have you an URL to this Product?

NOTE: Discount Quantity Prices is for Products with a Price ... You may need to use the Attribute Quantity Discounts if you are not using a Product Price ...

I don't have a URL for the specific products on my own site as yet, as I am only testing the cart to get the hang of it. The main product is for invitations, but working as an agent, I have to work with Fixed Quantities at Fixed Prices. Starting off at a minimum quantity, as in this case 20 and going up in 10's

You mention the 'Attribute Quantity Discounts' I've been trying this and cannot get anywhere near the correct end price.

20 items = 25.50
30 items = 33.15
40 items = 40.80
50 items = 48.45
60 items = 54.40
70 items = 60.35
80 items = 66.30
90 items = 72.25
100 items = 78.20
and so on

or adding the difference to the first price

20 items = 25.50
30 items + 7.65 = 33.15
40 items + 15.30 = 40.80
50 items + 22.95 = 48.45
60 items + 28.90 = 54.40
70 items + 34.85 = 60.35
80 items + 40.80 = 66.30
90 items + 46.75 = 72.25
100 items + 52.70 = 78.20
and so on

So when a customer picks 60 items, the price will show and add to the cart 54.40, or if they decide to change the quantity, the correct price will show to the quantity they want.

Surely there must be a way of doing this as the cart does just about every other function I need. Is there anyway of getting the database to recognise more than 2 decimal places as this would probably cure the problem, or is there any modification that can be made to the Quantity Price Breaks to default to fixed prices at fixed quantities.

I'm facing a similar situation with a cart that I'm building. I've noted the same issue - that due to the cart only computing with two decimals the pricing is off on certain items.

Is there an answer to this?