Member Coupon

Member Coupon
#OpenCart 3.0 Member Coupon Module Usage Instructions

##Function Overview

This module is a complete membership coupon system developed for OpenCart 3.0, supporting multiple coupon distribution methods and usage scenarios.

##Main functions

###Backend management function

1. Coupon Management**
-Create, edit, and delete coupons
-Supports both percentage and fixed amount discount types
-Set minimum consumption amount
-Support free shipping function
-Support product and category restrictions
-Set expiration time
-Support overlay usage

2. * * Coupon distribution**
-Separate distribution to designated members
-Distribute to user groups
-Distribute to all members
-Login automatic gift

3. * * Statistical report**
-Coupon usage statistics
-Distribution quantity statistics
-Exchange quantity statistics
-Usage analysis

###Front end user functions

1. * * Coupon List**
-Available coupons
-Coupon already used
-Expired coupons

2. * * Coupon redemption**
-Enter coupon code to redeem
-Can control whether to enable the redemption function

3. * * Checkout application**
-Apply coupons on the checkout page
-Automatically calculate discounts
-Support free shipping

##Installation steps

1. Visit your Opencart administrator and go to Extensions ->Installer to upload the module
2. Extensions ->Modifications Refresh in the upper right corner
3. Extensions->Extensions->Modules->Member Coupon Install
4. System->User->User Groups->Administrator Select permission to save
5. Extensions->Extensions->Order Totals->Member Coupon Install Set the status to enabled
6. Management method: Marketing->Coupon(OCXD)

##Database Table Structure

###Oc_cember_compton (Coupon Table)
-Coupon-ID: Coupon ID
-Name: Coupon Name
-Code: Coupon Code
-Type: Type (P=percentage, F=fixed amount)
-Discount: discount amount
-Total: minimum consumption amount
-Logid_gift: Is it a login gift
-Free_Shipping: Is there free shipping
-Product_ids: Restrict product IDs
-Category_ids: restrict category IDs
-Date_dend: End date
-Hide_ofter_epire: whether to hide after expiration
-Stackable: Can it be stacked
-Status: Status

###Oc_cember_compan_ history (distribution record form)
-History_id: Record ID
-Coupon-ID: Coupon ID
-Customer ID: Customer ID
-Send_type: Distribution type
-Date added: Distribution time

###Oc_cCustomer Coupon (User Coupon Table)
-Customer Coupon ID: User Coupon ID
-Customer ID: Customer ID
-Coupon-ID: Coupon ID
-Order_id: Order ID
-Date added: Get time
-Date_used: usage time
-Status: Status

###Oc_compan-exchange (Exchange Record Form)
-Exchange ID: Exchange ID
-Customer ID: Customer ID
-Coupon-code: Coupon code
-Coupon-ID: Coupon ID
-Date added: Exchange time

###Oc_order_coupon (order coupon table)
-Order_compan_id: Order coupon ID
-Order_id: Order ID
-Coupon-ID: Coupon ID
-Customer ID: Customer ID
-Discounting amount: discount amount
-Dateadded: Usage time

##Instructions for use

###Create Coupons

1. Go to the backend ->Marketing ->Coupon (OCXD) ->Member Coupon Manage
2. Click the "Add" button
3. Fill in coupon information:
-Coupon Name
-Coupon code (automatically generated)
-Type (percentage/fixed amount)
-Discount amount
-Minimum consumption amount
-Other settings

###Distribute coupons

1. Go to the backend ->Marketing ->Coupon (OCXD) ->Member Coupon Send
2. Select the coupon to be issued
3. Choose the distribution method:
-* * Multiple customer distribution * *: You can search and select multiple specific customers
-* * User Group Distribution * *: Select a customer group and distribute to all customers in that group
-* * Issued to All * *: Issued to all customers

####Multi customer distribution function
-Enter the customer name in the customer input box to search
-Select the customer from the search results, and the customer will be displayed in the list below
-You can continue searching and add more customers
-Click the "X" next to the customer to remove the selected customer
-Support simultaneous distribution to multiple customers

###Front desk use

1. After the customer logs in, visit the coupon page
2. View available coupons
3. Apply coupons on the checkout page
4. Redeem coupon code (if enabled)

##Configuration Options

###Module settings
-Enable/disable module
-Enable/disable redemption function

###Coupon Settings
-Login gift: automatically obtained when customers log in
-Free shipping: Free shipping when using coupons
-Overlay use: can be used together with other coupons
-Expired Hide: Not displayed in the foreground after expiration

##Precautions

1. Ensure that OpenCart version is 3.0. x
2. Please backup the database before installation
3. Uninstalling the module will delete all relevant data
4. It is recommended to try it out in the testing environment first

##Technical support

https://www.ocxd.cn

##Update log

### v1.0.0
-Initial version release
-Support basic coupon functions
-Support multiple distribution methods
-Support front-end redemption and application


I tested it on my end and found that 3.0.3.8 is normal, but 3.0.3.6 cannot be displayed in the account
If the member center cannot be accessed, can I use a connection to access/index. php? route=extension/module/member_coupon

# OpenCart 3.0 会员优惠券模块使用说明

## 功能概述

本模块为OpenCart 3.0开发的一个完整的会员优惠券系统,支持多种优惠券发放方式和使用场景。

## 主要功能

### 后台管理功能

1. **优惠券管理**
- 创建、编辑、删除优惠券
- 支持百分比和固定金额两种折扣类型
- 设置最低消费金额
- 支持免运费功能
- 支持商品和分类限制
- 设置过期时间
- 支持叠加使用

2. **优惠券发放**
- 单独发放给指定会员
- 发放给用户组
- 发放给全体会员
- 登录自动赠送

3. **统计报表**
- 优惠券使用统计
- 发放数量统计
- 兑换数量统计
- 使用率分析

### 前台用户功能

1. **优惠券列表**
- 可用优惠券
- 已使用优惠券
- 过期优惠券

2. **优惠券兑换**
- 输入优惠券代码兑换
- 可控制是否启用兑换功能

3. **结账应用**
- 在结账页面应用优惠券
- 自动计算折扣
- 支持免运费

## 安装步骤

1. 访问您的Opencart管理员并转到 Extensions->Installer,upload上传模块
2. Extensions->Modifications 右上角 Refresh
3. Extensions->Extensions->Modules->Member Coupon Install
4. System->User->User Groups->Administrator Select permission to save
5. Extensions->Extensions->Order Totals->Member Coupon Install Set the status to enabled
6. Management method: Marketing->Coupon(OCXD)

## 数据库表结构

### oc_member_coupon (优惠券表)
- coupon_id: 优惠券ID
- name: 优惠券名称
- code: 优惠券代码
- type: 类型 (P=百分比, F=固定金额)
- discount: 折扣金额
- total: 最低消费金额
- login_gift: 是否登录赠送
- free_shipping: 是否免运费
- product_ids: 限制商品ID
- category_ids: 限制分类ID
- date_end: 结束日期
- hide_after_expire: 过期后是否隐藏
- stackable: 是否可叠加
- status: 状态

### oc_member_coupon_history (发放记录表)
- history_id: 记录ID
- coupon_id: 优惠券ID
- customer_id: 客户ID
- send_type: 发放类型
- date_added: 发放时间

### oc_customer_coupon (用户优惠券表)
- customer_coupon_id: 用户优惠券ID
- customer_id: 客户ID
- coupon_id: 优惠券ID
- order_id: 订单ID
- date_added: 获得时间
- date_used: 使用时间
- status: 状态

### oc_coupon_exchange (兑换记录表)
- exchange_id: 兑换ID
- customer_id: 客户ID
- coupon_code: 优惠券代码
- coupon_id: 优惠券ID
- date_added: 兑换时间

### oc_order_coupon (订单优惠券表)
- order_coupon_id: 订单优惠券ID
- order_id: 订单ID
- coupon_id: 优惠券ID
- customer_id: 客户ID
- discount_amount: 折扣金额
- date_added: 使用时间

## 使用说明

### 创建优惠券

1. 进入后台 -> Marketing->Coupon(OCXD) -> Member Coupon Manage
2. 点击"添加"按钮
3. 填写优惠券信息:
- 优惠券名称
- 优惠券代码(自动生成)
- 类型(百分比/固定金额)
- 折扣金额
- 最低消费金额
- 其他设置

### 发放优惠券

1. 进入后台 -> Marketing->Coupon(OCXD) -> Member Coupon Send
2. 选择要发放的优惠券
3. 选择发放方式:
- **多客户发放**:可以搜索并选择多个特定客户
- **用户组发放**:选择客户组,发放给该组所有客户
- **全体发放**:发放给所有客户

#### 多客户发放功能
- 在客户输入框中输入客户姓名进行搜索
- 从搜索结果中选择客户,客户会显示在下方列表中
- 可以继续搜索并添加更多客户
- 点击客户旁边的"×"可以移除已选择的客户
- 支持同时发放给多个客户

### 前台使用

1. 客户登录后访问优惠券页面
2. 查看可用优惠券
3. 在结账页面应用优惠券
4. 兑换优惠券代码(如果启用)

## 配置选项

### 模块设置
- 启用/禁用模块
- 启用/禁用兑换功能

### 优惠券设置
- 登录赠送:客户登录时自动获得
- 免运费:使用优惠券时免运费
- 叠加使用:可与其他优惠券同时使用
- 过期隐藏:过期后不在前台显示

## 注意事项

1. 确保OpenCart版本为3.0.x
2. 安装前请备份数据库
3. 卸载模块会删除所有相关数据
4. 建议在测试环境先试用

## 技术支持

https://www.ocxd.cn

## 更新日志

### v1.0.0
- 初始版本发布
- 支持基本的优惠券功能
- 支持多种发放方式
- 支持前台兑换和应用


我这边测试,在3.0.3.8是正常 但是3.0.3.6无法显示在account中
会员中心如果访问不了,可以用连接来访问 /index.php?route=extension/module/member_coupon




Download
  • Developed by OpenCart Community
  • 12 Months Free Support
  • Documentation Included

Rating

Compatibility
3.0.2.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8, 3.x.x.x, 3.0.3.9, 3.0.4.0

Last Update
27 Sep 2025

Created
27 Sep 2025
0 Downloads
0 Comments
ocxd
ocxd
Member since: 28 Mar 2017

View all extensions Get Support