Boxes of tiles. Price per sqare metre

My client sells boxes of tiles which are priced per metre.

The simple answer would be to put a price per box and sell by the box but the industry doesn't work that way!

I need to be able to show, for example:
Blue tiles, 3sq metres per box at £10 per square metre.

If a customer orders 10 sq metres the order should show 4 boxes (because they can't buy part boxes) cost 4 x 3sq metres x £10 = £120

How do I set this up?

Thanks for any advice.

Andy

You will need some custom coding as Zen Cart does not do calculations in that manner.

Thinking some more about this, all I really need to do is display a different price to the one used.

In the product description we can specify "each box contains 3sq metres".

Then when the customer enters a quantity, it is the quantity of boxes at £30 each.

BUT we don't want to display the price as £30 per box, we want to display the price as £10 per square metre.

Is there a way of doing this?

Not at this time, the price calculations do not allow it at this time.

I'm nearly there.

I can do what is required by using an attribute, "Square metres per box" and a price factor of 3 with an offset of 1.

So the price is shown as £10 - which is the price per square metre - and when the customer adds 1 box to his cart he is charged £30. This is exactly what I wanted.

My problem now is that the attribute is displayed under the product info as, "Square metres per pack 3.00 (+£20)"

Is there any way to switch off the display of the extra price? It will just confuse people.

Andy

andyheer:

Is there any way to switch off the display of the extra price? It will just confuse people.

If your never going to use attributes, I would simply create a template file for tpl_product_info.php & comment out the attributes display, this would simply not show the attributes on the products page at all