Shipping per product but not same for all products

-- HikaShop version -- :2.2.2
-- Joomla version -- : 3.15

I have a requirement for a winery who want to charge a flat rate of shipping per "case" (12 bottles) or part case. Products are sold by bottle or by case. eg. If the rate is $6 per case and a customer orders 2 products by case and 3 other individual bottles the number of cases would be 3 (2 cases of 12 and 1 case of 3) How can this be configured in Hikashop?

Hi,
I think that you'll be able to do it by using the "price per product" option of your shipping configuration page, then you'll have to set a shipping price for each products through the "price" tab of your product configuration page.

Just got back to this problem. Price per product won't work because the shipping is per case or part case. So if a customer orders 3 cases of one product plus 4 bottles of assorted products they must be charged for 4 cases. I can resolve this by allocating a nominal weight or volume per product and charge a rate based on weight greater than X and Less than Y for each zone. As you can imagine this is going to be a very big table of rates as we set probably a dozen different weight ranges and at least that number of zones. Is there any way to import this from a spreadsheet?

Hi,

You have to set the "shipping price" for the bottles too.
In the shipping plugin you can set the default "shipping price" for products but you can override this values for every products (in the product page itself).
It requires an HikaShop plugin (named "HikaShop Shipping manual - Prices per product plugin") to work good. Please check that this plugin is published if you don't see the special box in the product page (at the bottom right).

Regards,

Hi Jerome,

Sorry but I'm struggling to understand how to convert the "price per bottle" to a price per case per zone. A case holds up to 12 bottles but the delivery will be the same for a given zone for 1 bottle or twelve bottles. It then doubles for 13 bottles because this requires a second case. Putting a price per bottle doesn't make sense to me because that price would never be used. Remember these bottles are all individual products, not multiples of the same product.

Hi,

It does not change that the shipping price per product can have a specific price per product.
It can be a single bottle, a pack of bottles. HikaShop just set a specific shipping price for a specific product, whatever it is in reality.

Regards,

But this is not a price per product.

If a customer orders product A by the crate that will work but they can also buy up to 12 individual products (bottles of different wines) and that would also make up a crate. As indicated, the price of shipping is per crate per zone with a maximum of 12 bottles in a crate so if they order 1 bottle they are charged the shipping for a crate. If they buy 1 bottle of each of 8 products they still pay shipping for 1 crate. If they order 13 bottles of individual products they pay shipping on 2 crates because only 12 bottles will fit in a crate. Please read my second post again.

Hi,

In your case, the best solution will probably be to use 2 products (bottles and crate of wine) and set a price per product for these two products, you'll also be able to do that by :
- Creating a characteristic 'format' which will have 2 values (bottles and crate of wine)
- Using this characteristic through your product configuration page
- Setting different price per product for these two product's variants.

Ok, I have to apologise because either I am not explaining myself or I don't understand how shipping works at all. I'll give it one more try.

Shipping will be charged based on the total weight of an order (lets presume all bottles weigh 1kg each and a crate weighs 12kg so we can focus on the weight instead of numbers of bottles in each unit of measure). For each zone there is a shipping rate that applies to each 12kg (12 bottles) or part thereof. eg. If 1 kg costs $10 for a particular zone, 12kgs will also cost $10 but 13kg goes to the next weight range which is $20. Up to 24 kgs can be shipped for $20 then it goes to the next level.

The problem is the number of combinations. There are currently 19 zones each with their own rate and customers buy anything from 1 crate to 12 crates so using the shipping by max/min weight model does that mean we have to create at least 19 x 12 = 228 instances of the shipping plugin? If that is not needed, where can we find a tutorial on shipping to see how it really works?

rodfarrell wrote: Shipping will be charged based on the total weight of an order (lets presume all bottles weigh 1kg each and a crate weighs 12kg so we can focus on the weight instead of numbers of bottles in each unit of measure). For each zone there is a shipping rate that applies to each 12kg (12 bottles) or part thereof. eg. If 1 kg costs $10 for a particular zone, 12kgs will also cost $10 but 13kg goes to the next weight range which is $20. Up to 24 kgs can be shipped for $20 then it goes to the next level.

The problem is the number of combinations. There are currently 19 zones each with their own rate and customers buy anything from 1 crate to 12 crates so using the shipping by max/min weight model does that mean we have to create at least 19 x 12 = 228 instances of the shipping plugin? If that is not needed, where can we find a tutorial on shipping to see how it really works?

Ok, so you can:
- Create your 19 shipping methods regarding the zone of your customers shipping address
- Go to your product page and set different price per products through the "shipping price" tab regarding the product quantity :

Are you saying that I have to create over 228 shipping lines for every product? We are talking about thousands of products. That's insane and I still don't believe it will combine quantities of different products as required. At least with calculating shipping by combined weight I only have to create the 228+ entries once but even that is impractical.

Are you able to recommend someone who can create a custom shipping plugin? All we need is to be able to enter for each postcode range a rate and a weight multiplier. eg. pcode 4000 to 4055 Rate: $10 Rate Multiplier: 12kg (calculates $10 for every 12kg or part thereof based on the total order weight.) It can't be that hard.

Hi,

We have a "commercial jobs" section in the forum for such custom development request.
I know that PolishedGeek do such development, if you want to contact them directly.

Regards,