Page 1 of 1

Shipping based on categories, locations and multi discount

Posted: Sun Nov 15, 2015 7:25 am
by andywoodrow
Hi,

I'm using 2.1.0.1 and new to OpenCart, so bear with me :-)

I have a customer that has various product categories, to which I need to apply to each category it's own P&P rate. However, on top of this, the rate needs to change depending on the posting area AND I need to apply a multi product discount across all categories per order.

For UK based orders:
Product A: FREE delivery (regardless to amount ordered)
Product B: £10 for the first, then £5 for each additional
Product C: £20 for the first, then £10 for each additional .. and so on...

Examples:
1. Customer buys 4 x Product A - Total P&P = FREE
2. Customer buys 2 x Product B - Total P&P = £15
3. Customer buys 1 x Product C, 2 product B and 3 product A - Total P&P = £30 (£20 for Product C (most expensive), then £5 each for product B, then FREE for product A)

Europe, North America and Rest of the World will all have slightly higher fees separately, but there will be a slight change to Product A for these areas: For example, Product A for Europe would attract a P&P of £3 for the first 6 products, then £5 for 6+ products.

I hope this all makes sense.

I'm looking for a suitable shipping module that would easily cater for this if anyone can recommend one for me?!

Thankyou!
Woody

Re: Shipping based on categories, locations and multi discou

Posted: Mon Nov 16, 2015 1:18 am
by Johnathan
You can do this using Category & Product-Based Shipping, though if you have a lot of products, it can get complicated to set up. For your example, you'd set it up like this:
  • ------------------------------------------------------------------------------
    CHARGE #1
    Title: Shipping
    Group: A
    Charge Type: Flat Charge
    Charge Field: 5.00
    Rule: Product is Product B
    Rule: Geo Zone is UK

    CHARGE #2
    Title: Shipping
    Group: A
    Charge Type: Flat Charge
    Charge Field: 10.00
    Rule: Product is Product C
    Rule: Geo Zone is UK

    CHARGE #3
    Title: Shipping
    Group: B
    Charge Type: Flat Charge
    Charge Field: 0.00
    Rule: Product is Product A
    Rule: Geo Zone is UK

    CHARGE #4
    Title: Shipping
    Group: B
    Charge Type: Quantity
    Charge Field: 0-99999 = 5.00 / 1
    Rule: Product is Product B
    Rule: Geo Zone is UK

    CHARGE #5
    Title: Shipping
    Group: B
    Charge Type: Quantity
    Charge Field: 0-99999 = 10.00 / 1
    Rule: Product is Product C
    Rule: Geo Zone is UK

    ETC. FOR YOUR OTHER PRODUCTS
    ------------------------------------------------------------------------------
    CHARGE COMBINATION #1
    Sort Order: 1
    Title Combination: Single Title
    Formula: SUM(MAX(A), B)
    ------------------------------------------------------------------------------
If you have a lot of products, then you might want to get Ultimate Shipping. That would allow you to use an empty product data field for some of the data (like the quantity costs set up in Charges #3 - #5).

Feel free to take a look at the screenshots and demo site, and if you're interested let me know at www.getclearthinking.com/contact if you have any further questions.

Re: Shipping based on categories, locations and multi discou

Posted: Fri Nov 20, 2015 6:26 am
by andywoodrow
Hi Jonathan,

We will have quite a few products and we are adding more shortly. I'd like to be able to apply this to a 'category' really instead of a single product. For example, 1 of our categories is 'greetings cards' which gets a free delivery to UK regardless of the volume bought, but for Europe, for example, we would apply a £3 postage fee for up to 6 and over 6 would be £8. USA and Worldwide, postage fees would increase slightly. Inside this category, we would then have sub-categories like "Birthday Cards, Blank Cards, Occasion Cards", etc.etc.), but the postage fees would not change.

Another category is "Small Illustrations" which would have a £10 postage for UK, but if you bought 2, the second would only be £5, so that's £15 in total. For Europe, this would go upto £15, and £7.50 or the second, so 2 would be £22.50 and so on.

This mutli-discount needs to apply cross categories. We would charge the highest rate first, then 50% off for the cheaper one:

1 x Small Illustration - £10
1 x Big Illustration - £20
Multi discount - £5 (50% off cheapest product)
TOTAL = £25

2 x Small Illustrations - £20
Multi discount - £5 (50% off 2nd product)
TOTAL = £15

Do you think "Ultimate Shipping" would be a cost effective and quicker way for us to apply these?

I've tonight finished creating 4 geo-locations for UK, Europe, USA and Worldwide with all the relevant countries added to each geo-location. (Phew!) ;-)

Cheers,
Andy

Re: Shipping based on categories, locations and multi discou

Posted: Fri Nov 20, 2015 11:23 pm
by Johnathan
If you want to apply the charges to categories, just use Category rules in place of the Product rules. They work similarly, so it should give you the effect you want. I don't think Ultimate Shipping would be necessary in that case, since you don't really need the additional rules it offers.

Feel free to try it out in the demo, and if you see issues after that, please contact me at www.getclearthinking.com/contact to discuss this further. I can take a look at the setup and how it's not working, to see if I have any further suggestions.

Re: Shipping based on categories, locations and multi discou

Posted: Mon Dec 21, 2015 9:34 pm
by andywoodrow
RESOLVED!

Just an update to this to say I've used the Category and Product Based Shipping Method and it works an absolute treat! Thanks :-)