Post by andywoodrow » Sun Nov 15, 2015 7:25 am

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

New member

Posts

Joined
Mon Nov 02, 2015 5:48 pm

Post by Johnathan » Mon Nov 16, 2015 1:18 am

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.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by andywoodrow » Fri Nov 20, 2015 6:26 am

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

New member

Posts

Joined
Mon Nov 02, 2015 5:48 pm

Post by Johnathan » Fri Nov 20, 2015 11:23 pm

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.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by andywoodrow » Mon Dec 21, 2015 9:34 pm

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 :-)

New member

Posts

Joined
Mon Nov 02, 2015 5:48 pm
Who is online

Users browsing this forum: No registered users and 0 guests