This article provides recommendations on using coupons functionality in Magento Commerce and Magento Commerce Cloud, aimed at avoiding performance issues.
Affected products and versions
- Magento Commerce, all supported versions
- Magento Commerce Cloud, all supported versions
Best practices
Creating many coupons could lead to performance issues. Magento recommends keeping the number of coupons in your database (that is the number of records in the salesrule_coupon DB table) below around 250000.
Following approaches will help you in keeping the number of coupons within recommended limit:
- Remove coupons if they are not needed any more.
- Generate the exact number of coupons needed to meet the 'discount' campaign needs.
Related reading
Coupon codes in Magento User Guide.