Importing Discounts
You can import discounts into Fuze Store POS to set up or update your discount rules in bulk. This works for adding new promotions or migrating discount data from another system.
Step-by-Step Guide
- Open the app drawer.
- Go to Configurations.
- Under Data Management, tap Import.
- Choose the matching data type on the type grid.
- Optionally tap Download template for a CSV starter (your live export).
- Upload a CSV, XLS, or XLSX file, review the preview, then confirm Import.
Field Reference
Here are the columns in the Discounts import file:
| Field | Description | Required | Possible Values | Example |
|---|---|---|---|---|
| id | UUID identifier for the discount. Leave empty to create a new entry. | 123e4567-e89b-12d3-a456-426614174000 | ||
| code | Short code for internal use. Also serves as an identifier — an existing code updates the matching discount. | Yes | pwd-discount | |
| name | Name of the discount. | Yes | PWD Discount | |
| description | A short note about the discount. | Discount for Persons with Disabilities | ||
| rate | The discount rate value. For PERCENTAGE this is a percent; for FIXED it is an amount in your store currency. | Yes | 20 | |
| rate_type | Whether the rate is a percentage or a fixed amount. | Yes | FIXED, PERCENTAGE | PERCENTAGE |
| is_active | Whether the discount is active. Defaults to YES if empty. | YES, NO | YES | |
| duration_from | Start date for the discount (ISO 8601 format). | ISO 8601 date | 2023-01-01 | |
| duration_to | End date for the discount (ISO 8601 format). | ISO 8601 date | 2023-12-31 | |
| max_uses | Total number of times the discount may be used. Leave empty for unlimited. | Whole number | 100 | |
| max_uses_per_customer | How many times a single customer may use it. Leave empty for unlimited. | Whole number | 2 | |
| current_uses | How many times it has already been used. Export only — the import never changes a live usage count. | Whole number | 0 | |
| minimum_order_amount | Smallest order total the discount applies to. | Any number | 500 | |
| scope | What the discount applies to. Defaults to order if empty. | order | order | |
| is_public | Whether the discount is offered publicly. Defaults to NO if empty. | YES, NO | NO |
Tips
- Review your data before importing to avoid errors.
- Download a sample export file first if you are unsure about formatting.
- Use clear, descriptive names for your discounts.
- Set start and end dates to control when discounts are valid.
Edge cases
- All or nothing. Every row is checked before anything is saved. One bad row stops the whole import and nothing is saved. The app lists each problem as Row 2: … and names the column.
- How a row is matched. A row matches an existing record by its id first, then by its code. A row that matches is updated, and every other row is added. A row with none of these is always added, so running a hand-made file twice makes duplicates. Export first and edit that file to update safely.
- Spreadsheet formats. You can upload .csv, .xls, or .xlsx. The file is read by what it really is, so a damaged or unreadable spreadsheet is refused as a bad format. A CSV with a single column has no separators and is refused as not being a spreadsheet, so add a second column or save it as .xlsx.
- Headers matter, not order. Extra columns are ignored. YES/NO and other fixed values accept any letter case, and blank cells fall back to the default for that column.
- Starter and up. Import is not on the free Basic plan. It needs Store Settings · Import, and Download template also needs Store Settings · Export.
- Usage counts are export-only. current_uses is never changed by an import, so re-importing your own export cannot reset how many times a discount was used.
Works with
| Add-on or plan | What changes |
|---|---|
| Basic plan | Import and export are locked. |
| Starter and up | Import is available. Basic discounts, including Senior and PWD, work on every plan. |