Magento get coupon description

Magento get coupon description

August 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento get coupon description

Retrieving Magento Coupon Descriptions for Validation Rules

As a senior developer working with Magento e-commerce platforms, I often receive queries about retrieving coupon details for validation purposes. In this post, we’ll explore how to load a coupon price rule using the coupon code and retrieve its associated description text effectively.

Understanding Magento Coupon Structure

In Magento, coupons are stored in the salesrule table where the rule_id is the primary key. The actual coupon rules are defined by other tables like salesrule_coupon for the coupon codes themselves. The description for each coupon can be found in the salesrule_description table.

Loading a Magento Coupon Rule

To load a coupon rule using its code, we can use the following steps:

  1. First, ensure you have an active connection to your Magento database.
  2. Write a SQL query to fetch the rule_id of the desired coupon based on its code.
  3. Use this rule_id to retrieve the actual rule details from the salesrule table.

Here’s a simple example using PHP and the PDO extension:

<?php
$host = 'localhost';
$db   = 'magento_database_name';
$user = 'your_username';
$pass = 'your_password';
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

$pdo = new PDO($dsn, $user, $pass, $opt);

// Fetch rule ID
$query = "SELECT `rule_id` FROM `salesrule_coupon` WHERE `code` = :coupon_code";
$stmt = $pdo->prepare($query);
$stmt->execute(['coupon_code' => 'COUPON123']);
$result = $stmt->fetch();

if ($result) {
    $ruleId = $result['rule_id'];

    // Fetch rule details
    $ruleQuery = "SELECT * FROM `salesrule` WHERE `rule_id` = :rule_id";
    $ruleStmt = $pdo->prepare($ruleQuery);
    $ruleStmt->execute(['rule_id' => $ruleId]);
    $ruleDetails = $ruleStmt->fetch();

    // The 'rule_details' array now contains all the details of the coupon rule
}
?>

Retrieving the Coupon Description

To fetch the description associated with a specific coupon, we need to join the salesrule_description table:

// Fetch description for the loaded rule
$descriptionQuery = "SELECT `description` FROM `salesrule_description`
                     WHERE `rule_id` = :rule_id AND `store_id` = 0";
$descStmt = $pdo->prepare($descriptionQuery);
$descStmt->execute(['rule_id' => $ruleId]);
$descriptionResult = $descStmt->fetch();

if ($descriptionResult) {
    echo "Coupon Description: " . $descriptionResult['description'];
}

Conclusion

Retrieving coupon descriptions in Magento involves a simple yet structured approach. By using SQL queries to fetch the rule_id based on the coupon code and then joining the relevant description tables, you can easily access the required information for validation rules or other purposes.

Remember that this is a basic example; production code should include error handling, input sanitization, and use of proper database abstraction layers for better security and maintainability.

For more advanced techniques in Magento development, I recommend exploring our guide on Magento 2 Web APIs to learn about efficient data fetching methods.

Database Extensions Pricing Errors

Our network