• Hi Lee Willis,

    I’m trying to figure out a solution for one particular product in my online store, but I reached a dead end. It requires a minimum order of 3 items, which will have a shipping rate for a particular region as a bundle of 3 items. Subsequently, the shipping rate will increase for every 3 items (e.g., 6, 9, etc.).

    All other products are working well with the “Sum of quotes for individual items” option. Sadly, it is this particular product that needs some special attention. Any ideas around this mess?

    Please advise. Thank you in advance.

    Regards,
    Jason

    http://wordpress.org/extend/plugins/wp-e-commerce-weightregion-shipping/

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Lee Willis

    (@leewillis77)

    For a product whose rate changes every 3 products I’d say you just set the weight of the product to x, and then set your weight bands at intervals of 3 * x.

    However I’m guessing you have “real” weight bands that apply to everything else?

    In which case you’re probably looking for a custom development I’m afraid…

    Thread Starter Jason Wong

    (@eljkmw)

    All other products’ weight bands are at 1kg.
    This small product is about 350g, and 3 items of this will be 1,050g (or 1.05kg). Anything 1kg or more will have a standard rate per region. Moreover, I’m using the “Sum of quotes for individual items” option with your plugin.

    Any thoughts? Thank you.

    Plugin Author Lee Willis

    (@leewillis77)

    “Sum of quotes for individual items” will work out a shipping price for each item if shipped on its own, and then will add up all of the costs, ie – it doesn’t add up the total weight, and then look that up.

    You can find a description of the various methods here:

    http://wordpress.org/extend/plugins/wp-e-commerce-weightregion-shipping/faq/

    As I said earlier – what you’re looking to do is to treat these products differently to everything else in your store, so you probably need a custom shipping module.

    Thread Starter Jason Wong

    (@eljkmw)

    I think I’m looking for an option that would add up the total weight for individual items, and then reference the total weight to the weight band for the chosen region. In the end, the option will “Sum of quotes for individual items’ total weight”.

    Will this feature be simple enough to customise?

    Plugin Author Lee Willis

    (@leewillis77)

    Thread Starter Jason Wong

    (@eljkmw)

    I’ve tried the “Sum of quotes for consolidated items” option last night, but it appeared to behave strangely. As mentioned in your link above:

    Sum of quotes for consolidated items : Assumes that each item will be shipped in bundles. For each item in the cart, the consolidated weight is calculated for that product (According to the quantity being purchased), and that consolidated weight is used to check against your configured weight bands. All of the prices are summed up to give the final customer cost.

    If a customer added more than 1 of the same item, the final shipping cost doesn’t add up. For example, 1kg of A item costs $18 to deliver to B, but when 3 * 1kg of A item is added to the Shopping Cart, the costs should total 3 * $18 to deliver to B. This works with the “Sum of quotes for individual items”, but not “Sum of quotes for consolidated items”.

    Where could I have gone wrong? Please advise.

    Cheers,
    Jason

    Plugin Author Lee Willis

    (@leewillis77)

    Say for example you had a product weighing 1lb, and you had the following weight bands set up:

    0lbs and above = $5
    2lbs and above = $7
    3lbs and above = $9

    Now say that the user buys 3 of the same item at 1lb each:

    “Sum of quotes for individual items” will look up each item in the weight table, and sum up the cost for each item. So – it will look up 1lb in the weight table, and get a quote of $5. Same for the second item, and same for the third. Then it will sum them up ($5+$5+$5) and spit out a quote of $15.

    “Sum of quotes for consolidated items” will calculate the total weight for each line item on the order according to the quantity purchased (ie 3 * 1lb = 3lbs). It will then look up that *total* weight, and return the quote accordingly. ie in this case 3lbs = $9.

    The third option is the same as the second, except it calculates the total weight of all products, not just each line item, before looking up the weight in the table.

    Hope that helps explain.

    Hi Lee,

    I have a similar issue. I have two product types, Wraps and Prints.

    I have weighted the Wraps in 100’s and the Prints in 1’s

    I then have 3 bands for each, so

    300 – £10
    200 – £7
    100 – £5
    3 – £8
    2 – £6
    1 – £4

    The problem begins when a customer orders both products.

    So 1 wrap and 2 Prints. The weight comes to 102 so it charges £5 but I need to charge to be £7 (£5+£2). Is this doable without dev work?

    Thanks

    Andy

    Plugin Author Lee Willis

    (@leewillis77)

    Sure. Just set up the intermediate bands as well:

    303 – £18 (10+8)
    302 – £16 (10+6)
    301 – £14 (10+4)
    300 – £10
    203 – £15 (7+8)
    202 – £13 (7+6)
    201 – £11 (7+4)
    200 – £7
    103 – £13 (5+8)
    102 – £11 (5+6)
    101 – £9 (5+4)
    100 – £5
    3 – £8
    2 – £6
    1 – £4

    Doh! Of course!

    I knew there would be an easy answer.

    Thanks Lee

    Andy

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘[Plugin: WP E-Commerce Weight & Destination Shipping Modules] Sum of quotes for individual items’ is closed to new replies.