Hi David,
Thanks for your response.
Only reason is that shipping estimates are in two slabs. 0-2000 have
various blocks (e.g 0-100, 100-250 etc) and each of them have a fixed
rate . second block is from 2001 gm to 10000 gm and shipping price
increments £1 for every 1000 gm.
I tried to set the weight UOM in the shipping estimate to WT_kg.
However, it would calculate shipping estimate very high (like £ 4000+
for 4000 gms.). It looks it is due the fact that the product weight uom
id is gm and it adds £ 1 for each gram.
I can not change weight UOM id of the product to kg as there are other
quantity breaks (e.g 0-100, 100-250 etc) and they need the weight UOM to
be grams.
Thanks,
Raj
David E Jones wrote:
Is there a reason you can't set it up as one pound per kilogram?
-David
On May 16, 2008, at 11:38 PM, Raj Saini wrote:
Hi,
I have a situation where shipping prices for weight breaks increments
£1 per 1000 gm i.e. £ .001 per gram. (gram is UOM for the said
product). Field type for weightUnitPrice is defined as
currency-amount and in PostgreSQL it is mapped as numeric(18, 2).
Due to this, shipment cost estimate entry I create truncates the
price to 0 instead of .001.
I believe this is a common scenario for weight breaks where price
increments can be very small for a UOM like gram. I have been
thinking of using the fieldType currency-precision instead of
currency-amount. Currency precision is mapped as numeric(18,3) in
PostgreSQL. Is this the right thing to do or there are better
alternatives?
Thanks,
Raj
