Buying one item from a list of products, allows you to buy any other product from that brand at a %discount

[♥bruyndoncx]

Hello everyone,

 

I'm trying to get my head around a year-end promo that runs in the store and that I would like to offer online too.

 

Buying one item from a list of products, allows you to buy any other product from that brand at a %discount.

 

So Alessi has a flyer with about 200 products when you buy one of these you can buy another products of the same or lesser value with a 50% discount. We have about 700 alessi products to choose from so it is not feasible to setup a xsell at the individual product level.

 

Currently, the products are all in their proper different categories, if needed, I could link them to a second category just holding these promo items.

 

Do you know of a contribution that allows for a setup with an order total module that would calculate the discount correctly.

 

Ideally during the shopping process when a product from the gift flyer is choosen, it would allow the shopper interactively to select a second product at a discount, but I'm afraid that would be rather complicated.

 

Any brilliant ideas on how to work this into oscommerce ?

[♥joli1811]

Hi Carine

 

Just reading this bit complicated for my brain but was thinking if it could be done for a complete extra category

 

well anyhow makes for interesting reading

 

http://addons.oscommerce.com/info/6733

 

Regards

Joli

[♥bruyndoncx]

exactly what I'm currently doing - I'm not familiar with that contribution, quite a long readme ...

[♥joli1811]

exactly what I'm currently doing - I'm not familiar with that contribution, quite a long readme ...

Well know from the past the guy as gained a lot of respect for good coding

[♥mattjt83]

@@bruyndoncx

@@joli1811

 

His coding is excellent. This was the addon I thought of when I read the first post. If it doesn't do exactly what you need, Scott can alter it to your needs.

[♥bruyndoncx]

I emailed @@swguy as described on his site yesterday eve for advise on using better together or big chooser.

I haven't had a response back yet.

In the meantime I installed better together to see how it works and could generate pretty much what I need, but somehow the actual calculation with taxes messes things up. I'll have another look tomorrow to see if I made a silly copy/paste/adapt mistake.

[swguy]

Thanks for the mention, @@burt! Yes @@bruyndoncx, Better Together is a good place to start.

[♥bruyndoncx]

@@swguy

the function get_tax_rate_from_desc is causing the problem.

I have several tax groups defined (for the integration with our accounts so that different product groups are distinguished and booked differently in the backoffice). So I have a lot of entries with the same tax description.

I solved it by adding a 'distinct' to the sql clause

    $tax_query_str = "SELECT distinct tax_rate
				  FROM " . TABLE_TAX_RATES . "
				  WHERE tax_description = '" . $tax_desc . "'";

Now, the basic setup add_prod_to_prod works fine for me.

 

Back to work on the the add_cat_to_man case ...

[♥bruyndoncx]

I've progressed with better together and extended the logic to support category to manufacturer and article to manufacturer.

It is still a work in progress, not clean yet, but it does seem to do what I need right now.

The calculated discounts are correct which is the most important, only now I need to figure out how to promote this nicely in the shop.

 

the big discount module does almost what is needed, but not quite yet.

It is however usefull for other kinds of discounts like buy 1 get 10%, buy 2 get 20% buy 3 get 25%

 

it has been a steep learning curve and short nights of sleep but well worth the effort :thumbsup: all thanks to @@swguy !

[swguy]

@@bruyndoncx you are a champion coder! I went ahead and integrated this feature into Big Chooser so it's more generic - I think people will like it. Thanks for the positive feedback.