4 replies to this topic

[nicola]

Hi. We are wanting to use this plugin to process a larger number of groupon vouchers with specific rules. I have read a lot the creation kills the backend operating speeds due to database pressures. Can you please advise on this and if there is anyway around this? We run a lot of Groupon deals with each deal requiring 500-1500 vouchers to be uploaded. Probably running 20 deals at any one time (20 x 1500) Also can i confirm we can set a specific rules (product based) before bulk upload?

[Milosz]

Hi. We are wanting to use this plugin to process a larger number of groupon vouchers with specific rules. I have read a lot the creation kills the backend operating speeds due to database pressures. Can you please advise on this and if there is anyway around this? We run a lot of Groupon deals with each deal requiring 500-1500 vouchers to be uploaded. Probably running 20 deals at any one time (20 x 1500) Also can i confirm we can set a specific rules (product based) before bulk upload?

 

Hello,
So you want to have something about 30 000 codes in shop's database with active condition(s) related to products. In my opinion it's not a large number of codes. 
The main problem with large number of codes is in front office (back office is not affected) on cart page. When customer access to cart page prestashop checks all the voucher codes in database to verify if there are some codes to add to cart automatically or to display them (highlight option of voucher code). If voucher codes will have some active conditions (like product condition you expect) it will check also product associations. This can slow down cart, but it can be fixed easily. Its just enough to disable feature (code modification) to automatically add vouchers to cart / highlight them.

our module gives possibility to import voucher codes with active conditons.
during import process you define "pattern" of voucher code where you can activate "product" condition (as well as other conditons). Screenshot for reference: 

imported voucher codes will have these conditions active.

if you want to import many different voucher codes you will need to split import process and process the import for each group of codes (for different groupon deals) individually.

best regards
milos

[nicola]

Thanks for the quick reply.

Is there a way to bulk remove coupons from the system based on the import group for when the Groupon deals finished? To avoid the database continually growing? 

Also is there a way to export a record of used vouchers over specific time frames?

Also can you please advise what you mean exactly from the below. 

Thanks 

 

 

 

This can slow down cart, but it can be fixed easily. Its just enough to disable feature (code modification) to automatically add vouchers to cart / highlight them.

 

[Milosz]

Hello,
Prestashop has feature to "highlight" voucher code in cart. This is the "highlight" option: 

Highlight. If enabled, PrestaShop will let the user know that a voucher corresponding to the items in the cart is available and can be added.

When visitors will open cart page in your shop, prestashop will check all voucher codes in database to verify if "highlight" option is active for some of them.
This means that if you will have 30000 codes, prestashop will verify each code one by one to verify if there is any code to "highlight" in cart. This can slow down cart, especially if you have thousands of codes.

To avoid problem, it is possible to exclude "highlight" feature verification during checkout. It is possible to remove the feature from prestashop core,
so in effect prestashop will not check these codes. This can help in problem with performance if shop has many voucher codes.

how to do this?
this depends on prestashop version.
usually it's a matter of modification of static function CartRule::getCustomerHighlightedDiscounts() or CartRule::getCustomerCartRules()

this method has pros and cons
pros: cart performance will not be affected
cons: you will loose "highlight" feature, it will be deactivated at all so you will not be able to use it

[Milosz]

i missed one question, about bulk remove process of codes

in prestashop you can remove 1000 codes at once: