How to allow only one voucher per order

[Gowtham]

Hi Friends,

 

I have a problem in my store. I added 100 different vouchers which is valid for one user. But the users started combining the vouchers which old vouchers and i face a critical situation as it will make loss for my side. I tried changing all vouchers to uncombined while creating a voucher. But is there a default way that i can have all the vouchers as uncombined in default? Basically I don't want my Customers to use more than one Voucher in a single Order.

 

Thanks in Advance,

 

Gowtham.

[vekia]

you can do it with one easy sql query now:

 

update ps_cart_rule set cart_rule_restriction=1

[Gowtham]

Thanks Vekia,

 

But the values are already set to 1 in my DB. Is there some other method, i can do this ??

 

Thanks,

Gowtham

[vekia]

hello,

 

all of them (vouchers) in database have got "1" value for cart_rule_restriction ?

if so, can you check please ps_cart_rule_product_rule_value table?

this table should be empty

[Gowtham]

Yes, All the vouchers has got 1 value for cart rule restriction and the ps_cart_rule_product_rule_value is empty.

 

 

thanks,

Gowtham

[subwayside]

I'm confused how to do that and please anyone help to slove this step by step.

 

Do i need to change this whole code   SELECT * FROM `ps_cart_rule` WHERE 1

or i need to update values in table list.

 

please anyone explane this in video or step by step.

 

Thanks for support

Edited October 31, 2014 by subwayside (see edit history)

[ender666]

Another problem is, that all vouchers created by Loyalty module are combinable.. So I can manually disable combination, but when customer transform loyalty points to voucher, this voucher is combinable! Best solution would be disable ALL combinations and allow only one voucher per order.

 

Any solution??

[vekia]

in this case it's necessary to alter module .php code, 

 

open file: modules/loyalty/controllers/front/default.php

 

and change code:

$cart_rule->add();

to:

$cart_ruke->cart_rule_restriction=1;
$cart_rule->add();

after that all coupons generated with loylaty module will be uncombinable with other coupons.

[engineerHopf]

in this case it's necessary to alter module .php code, 

 

open file: modules/loyalty/controllers/front/default.php

 

and change code:

$cart_rule->add();

to:

$cart_ruke->cart_rule_restriction=1;
$cart_rule->add();

after that all coupons generated with loylaty module will be uncombinable with other coupons.

 

thank about it!. And how should be with referral program?

[vijaykryadav24]

Hi Subwayside,

 

follow this , go to admin panel and navigate to PRICE RULE->Cart Rules . open your voucher settings page, then "actions" tab

 

click in 'Compatibility with other cart rules' checkbox, and remove cart rule from 'Combinable cart rules'  then Save the changes

 

I think this will help to solve your problems

Edited May 25, 2015 by vijaykryadav24 (see edit history)

[chirag_0110]

HI,

I am using Prestashop 1.7.2.2. And want to select all cart rule in an Uncombinable select box instead of a combinable select box while adding new cart rule. 

Is it possible to do so?

I changed in prestashop/admin928iq35ay/themes/default/template/controllers/cart_rules/form.tpl line number 482 & 483

$('#cart_rule_select_1').jscroll().data('jscrollapi').load_scroll(baseHref+'&type=unselected&search=');
$('#cart_rule_select_2').jscroll().data('jscrollapi').load_scroll(baseHref+'&type=selected&search=');

to 

$('#cart_rule_select_1').jscroll().data('jscrollapi').load_scroll(baseHref+'&type=selected&search=');
$('#cart_rule_select_2').jscroll().data('jscrollapi').load_scroll(baseHref+'&type=unselected&search=');

 

It select all cart rule in an Uncombinable select box. But, after saving it will in a Combinable box.

[Evan MTL]

Hi 

Did someone fix this issue?

Thank you in advance