jmarjano
Sep '18

Hello,

I need help how to properly set up my shipping rules for
ordering multiple tangible items according to the following conditions:

PRODUCT PRICES (tangible goods):

Product A (weight 350 grams) = 10 $ (value)

Product B (weight 550 grams) = 15 $ (value)

SHIPPING PRICES (depend on weight):

Shipping rule #1 = from 251 – 500 grams = 7.5 $ (flat rate)

Shipping rule #2 = from 501 – 1,000 grams = 15 $ (flat rate)

Shipping rule #3 = from 1001 – 2,000 grams = 25 $ (flat rate)

I can ship max. 2,000 grams per parcel (regular envelope).

I can ship max. 2 items per parcel (regular envelope).

I can let buyers change quantity.

So, if a buyer chooses to order multiple items, for example:

Product A x2 = 10$ x2 = 20$ (total 700g)

Product B x3 = 15$ x3 = 45$ (total 1,650g)

The calculation for this whole ORDER should look like this:

FIRST parcel
Product A x2 = 10$ x2 = 20$ (total w. 700g) + shipping #2 15$ = 35$ TOTAL

SECOND parcel
Product B x2 = 15$ x2 = 30$ (total w. 1,100g) + shipping #3 25$ = 55$ TOTAL

THIRD parcel
Product B x1 = 15$ (total w. 550g) + shipping #2 15$ = 30$ TOTAL

So, the shopping cart should calculate this order like this:
items total cost = 65$ (for 2 of Product A and 3 of Product B)
+
total shipping cost = 55$ (for 3 parcels)

TOTAL ORDER PRICE = 120$

Please, write me exact instructions how to set up my
shipping calculations, rules etc.

Thank you in advance.

  • created

    Sep '18

  • last reply

    Sep '18
  • 1

    reply

  • 1.2k

    views

  • 2

    users

E-junkie_MonsterSupport Monster
Sep '18
1

Unfortunately this specific calculation cannot be done. The limitations which prevent this are:

  • Shipping rules do not repeat (a rule that charges $25 for a 2000 gram order does not charge $50 for a 4000 gram order). Also they do not work on a per package basis. They assign a single rate to an overall order based on its conditions.

  • Only one package type can be assigned per item

Normally we can work around that, as it isn't always necessary to assign package types and shipping rules can typically handle most conditions. So your choices are to do one of the following:

1 - Create Shipping rules that scale up based on overall weight. We can do the exact three rules you mentioned, but if you expect to need to charge up to $55 or more on a common order you'll need more rules to handle orders that weigh over 2000 grams, such as a rule of $35 shipping for orders between 2001 and 3000 grams, etc. You can also make a rule which charges a flat rate for 3001 grams and up by setting the Max Weight to 0.

2 - Use packaging costs instead, which will always scale up based on the number of items ordered. It won't be an exact match for your costs since the packaging cost will stay consistent, but it would be the closest to your original plan.

If you want to use packaging costs don't worry about weight settings, since we'll actually be going by the combination of items ordered.

[I've edited my original post after testing the settings]

Set Product A and B to ship in a Regular Envelope with a Packaging Capacity of 2

On the shipping calculations screen (Manage Shopping Cart > Shipping Calculation) set all package weights and costs to 0.00, except Regular Envelope. Set that cost to $15.

Delete any Shipping Rules you have created or they will apply in addition to the package cost.

The end result for your example order would be $45 instead of $55, and single orders of Product A would cost $15 instead of $7.50, but this is about as close as we can get to your original plan.