Implementing Refund and After‑Sale Service Management in a PHP E‑Commerce Platform

In a complete e‑commerce platform, refund and after‑sale service management are essential for providing a smooth shopping experience. This article shows PHP developers how to design and implement these features.

1. Create Database Tables

First, create tables to store order information, refund records, and after‑sale applications.

CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `refund_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `refund_amount` decimal(10,2) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`order_id`) REFERENCES `orders`(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `aftersale_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`order_id`) REFERENCES `orders`(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. Process Refund Requests

When a user submits a refund request, the backend records the request and updates the order status.

<?php
require 'config.php';

$order_id = $_POST['order_id'];
$refund_amount = $_POST['refund_amount'];
$reason = $_POST['reason'];

// Save refund record
$sql = "INSERT INTO refund_records (order_id, refund_amount, reason) VALUES ('$order_id', '$refund_amount', '$reason')";
$result = $mysqli->query($sql);

if ($result) {
    // Update order status to "Refunding"
    $sql = "UPDATE orders SET status = 'Refunding' WHERE id = '$order_id'";
    $mysqli->query($sql);
    echo json_encode(['success' => true, 'message' => '退款请求已提交成功']);
} else {
    echo json_encode(['success' => false, 'message' => '退款请求提交失败，请稍后再试']);
}
?>

3. Process After‑Sale Service Applications

For issues such as product quality or delivery delays, users can submit an after‑sale application.

<?php
require 'config.php';

$order_id = $_POST['order_id'];
$type = $_POST['type'];
$description = $_POST['description'];

// Save after‑sale application
$sql = "INSERT INTO aftersale_applications (order_id, type, description) VALUES ('$order_id', '$type', '$description')";
$result = $mysqli->query($sql);

if ($result) {
    echo json_encode(['success' => true, 'message' => '售后服务申请已提交成功']);
} else {
    echo json_encode(['success' => false, 'message' => '售后服务申请提交失败，请稍后再试']);
}
?>

4. Display Refund and After‑Sale Records

Provide a user interface to view refund and after‑sale records.

<?php
require 'config.php';

$order_id = $_GET['order_id'];

// Query refund records
$sql = "SELECT * FROM refund_records WHERE order_id = '$order_id'";
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
    echo '退款金额：' . $row['refund_amount'] . '<br>';
    echo '退款原因：' . $row['reason'] . '<br>';
    echo '申请时间：' . $row['created_at'] . '<br><br>';
}

// Query after‑sale records
$sql = "SELECT * FROM aftersale_applications WHERE order_id = '$order_id'";
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
    echo '售后类型：' . $row['type'] . '<br>';
    echo '描述：' . $row['description'] . '<br>';
    echo '申请时间：' . $row['created_at'] . '<br><br>';
}
?&gt;

The code snippets above are simple examples; real projects require further refinement and optimization to ensure robustness and security.