Maximum number of coupons in Adobe Commerce

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

Best practices

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.

Related reading

Coupon codes in our user guide.