This article provides recommendations on using coupons functionality in Adobe Commerce on-premises and Adobe Commerce on cloud infrastructure, aimed at avoiding performance issues.
Affected products and versions
- Adobe Commerce on-premises, all supported versions
- Adobe Commerce on cloud infrastructure, all supported versions
Creating many coupons could lead to performance issues. Adobe Commerce 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.
Coupon codes in our user guide.