Price by weight and item

I have been asked to look at building a site for a grocery store that delivers it's goods.

The sell organic goods, and they sell juices by the bottle or carton, and they also sell fruit and veg. The juices will have a per item price, and the veg will be sold by weight which determines the price.

I know how to do the price by item, but how do I also tackle the price by weight in the same cart?

I have the latest eCart (but have never used it) and I also have the PowerStore 2. Could I take the PowerStore and modify it with eCart to suit my needs.

Any advice on this is appreciated.

Also, I need to make a delivery booking system... is that another thread?

Thanks.

you will need to have a cart column to determine if the item is sold by weight or not. in this itemType column, set the value to 1 for items that are sold by weight and 2 for item that use the regular price.

Then in the eCart object create a new calculation called real price.

the calculation should be:
(([itemType] == 1)?[Price] * [Weight]:[Price])

This basicly says:
Is the value in the itemType column 1?
Yes: set the price to Price * Weight
No: Set the price to Price


you will also need to change the Total price calculation from:
[Price] * [Quantity]

to:
(([itemType] == 1)?[Price] * [Weight]:[Price]) * [Quantity]

In the cart display, you will need to change it from showing the Price column to showing the realPrice calcualtion.

You will also need to modify the checkout behaviors to pass the realPrice calculation to the gateway instead of the Price calculation.


Yes, please start a new thread for the delivery booking issue.