Good evening
Is there a way in Shopify or an app that would allow me to restrict the type/qty of certain products that can be put in the cart based on the type of other products/qty of products that are already in the cart?
I am sure I am making this far more difficult than it needs to be but here is some background information first.
-We sell Frozen goods and Non frozen goods
-We sell both online and in 2 physical stores
-Our postal products go via DPD next day delivery and 98% of orders are frozen goods and must be packed into freezer boxes.
-The prices shown on our website for frozen postal goods already include P&P whereas dried goods purchased without frozen food have P&P added at checkout because they can go in a bag rather than a costly freezer box.
-Currently we let the customers buy whatever they want and then refund them for anything that we cannot fit into the boxes, relying on them to read the information on the product of what we can and cannot fit - very messy I know which is why I am starting over
-Our pickup items are much cheaper as they come in a different format, they do not require freezer boxes, so essentially the online price is the collection price with the P&P added already.
The obvious solution may be to put all the prices the same and add a delivery cost at checkout for postal items but we have done this in the past and sales decreased massively because the P&P is a large proportion of the total price so we found that including P&P in the price with no extra delivery costs worked much better as we are cheaper than most other suppliers even including delivery.
For example this is what I need to do
Product Type A = Box of FROZEN goods with room for a limited QTY of add on items
Product Type B = FROZEN goods with no room for ADD ON Items
ADD ON type F = FROZEN Add on item
ADD On type D = Dry Add on Items
If the customer has Product Type A in their basket, I want to allow them to add up to 2 x ADD ON type F per Product A. So if they have 2 x Product A then they can add 4 x ADD ON F, with 3 x Product A they can add 6 x ADD ON F and so on
However, if the customer has Product Type B in their basket, I want to prevent the customer from adding any ADD ON Type F because they will not fit in the box. There is no use implementing an
extra delivery charge because we cannot send any less than 8 x ADD ON F in a box and we already advertise this product with delivery already costed in so it is a product not an add on.
If customers add any more than 2kgs of ADD ON Type D (Dried Goods) per Product type A or any QTY of ADD ON Type D with Product type B then I want to implement a shipping charge for the extra box required for the surplus items.
I have no idea if that will make sense to anyone as it’s taken me half an hour to write it so it makes sense to me but if you can help me in any way please do before I go insane!
I managed to sort of make it do what I wanted by using the discount option whereby a customer can buy 2 of ADD ON F per each product type A but I don’t want to discount the price or mark it as free.
I feel I’m so close yet so far from the solution
.
