The current products are plants and postage is calculated on the sub-total of the cart, as follows:
For spend up to £10.00 - Postage and packing £7.00
For spend up to £50.00 - Postage and packing £13.00
I don't think your suggestion of a shipping cost column would, therefore, work because the postage isn't calculated on a 'per product' basis.
The other products are stationery (notebooks, calendars, cards etc) and my client has come up with a completely seperate postage scale for those, as follows:
For spend up to £16.00 - Postage and packing £5.50
For spend up to £32.00 - Postage and packing £7.50
At the moment, problems will arise because the cart has no way of distinguishing if a product in the cart is a plant or stationery.
I, therefore, think creating a product category field, in our product database, would be the best way to go but I'm confused by your "subtotal is multiplied by the shipping percentage" suggestion.
Can you clarify?
Really appreciate the help, as ever. Thank you.