Chapter 10: Data Importer — 10.4 Promotion Importer
Use Importer to manage and configure this feature in your EQuipWeb system.
Use the Promotion Importer to create or update many promotions at once from a spreadsheet. If you have a large number of promotional offers to set up — like seasonal pricing for hundreds of items — this saves hours of manual work.
When to use this: When you need to create or update many promotions at once using a spreadsheet.

This importer links products to promotion schemes in bulk. The promotion schemes themselves must already exist (created via Promotion Setup — Section 1.9). The importer maps products (by ItemNo) to promotions and configures the specific parameters (discount amount, qualifying quantity, etc.).
Use Importer to manage and configure this feature in your EQuipWeb system.
| Column | Required | Description |
|---|---|---|
| PromotionName | ✅ Yes | Must match an existing promotion scheme name |
| ItemNo | ✅ Yes | Product item number to add to the promotion |
| DiscountType | No | Percentage or Amount |
| DiscountValue | No | The discount rate (%) or amount ($) |
| MinQty | No | Minimum quantity to qualify for the promotion |
| MaxQty | No | Maximum quantity eligible per transaction |
| StartDate | No | Promotion start date (DD/MM/YYYY) |
| EndDate | No | Promotion end date (DD/MM/YYYY) |
| PromotionName | ItemNo | DiscountType | DiscountValue | MinQty |
|---|---|---|---|---|
| Summer Sale 2026 | I0001 | Percentage | 20 | 1 |
| Summer Sale 2026 | I0002 | Percentage | 20 | 1 |
| Buy 2 Get 10% Off | I0050 | Percentage | 10 | 2 |
Use Importer to manage and configure this feature in your EQuipWeb system.
2. Click Download Template to get the CSV template.
3. Open in Excel and fill in:

6. Click Upload to process.

Use Importer to manage and configure this feature in your EQuipWeb system.
| Rule | Description |
|---|---|
| PromotionName must exist | Must match a promotion created in Promotion Setup |
| ItemNo must exist | Must be a valid product in the system |
| DiscountValue must be positive | Cannot have negative discounts |
| Dates must be within promotion period | Item dates cannot exceed the parent promotion's date range |
Use Importer to manage and configure this feature in your EQuipWeb system.
Before using the Promotion Importer:
Use Importer to manage and configure this feature in your EQuipWeb system.
Scenario: A retailer runs a "Clearance Sale" with 30% off on 200 products.
Steps:
2. Export the product list via Data Exporter.
3. Filter to the 200 clearance products and format into the promotion template.
4. Set DiscountType = Percentage, DiscountValue = 30 for all rows.
5. Import via Promotion Importer.
6. All 200 products now have the 30% discount applied through the "Clearance Sale" promotion.
[!TIP] For seasonal promotions with many products, the Promotion Importer saves hours compared to adding products one by one through the UI.
Use Importer to manage and configure this feature in your EQuipWeb system.
| Role | View | Create | Edit | Delete |
|---|---|---|---|---|
| Admin | Yes | Yes | Yes | Yes |
| Supervisor | Yes | Yes | Yes | No |
| Cashier | No backend access | — | — | — |
[!NOTE] Exact permissions depend on the Privileges Setup configured for each role. Contact your administrator if you cannot access this page.
Use Importer to manage and configure this feature in your EQuipWeb system.

Click Download Template to get the Excel template with correct column headers.
Open the template and fill in your data according to the column headers.

✅ Expected Result: Data is imported and available in the system.
Q: What file format should I use for import? A: Use .xlsx (Excel) format. Download the blank template from the importer page to ensure correct column structure.
Q: Can I undo an import? A: No. Imports cannot be automatically reversed. You would need to manually correct or delete the imported records.
Q: Why does my import show validation errors? A: Check the error details for each row. Common issues include: missing required fields, duplicate codes, invalid date formats, or referencing categories/departments that don't exist yet.
Use Importer to manage and configure this feature in your EQuipWeb system.
| Issue | Possible Cause | Solution |
|---|---|---|
| Upload fails with error | File format is not .xlsx or file is corrupted | Download a fresh template, re-enter data, and try again |
| Validation errors on rows | Missing required fields or invalid data format | Check the error details column for specific row issues |
| "Duplicate record" warning | Data already exists in the system | Check if the record exists and decide whether to update or skip |
| Import shows 0 records processed | File is empty or wrong template version | Verify the file has data rows and uses the latest template |
| Error 404 on upload | File too large or server timeout | Split the file into smaller batches (max 500 rows recommended) |
| Data imported but not visible | Filters hiding the new records | Clear all filters and search for the imported records |
Use Importer to manage and configure this feature in your EQuipWeb system.
Use Importer to manage and configure this feature in your EQuipWeb system.
[!NOTE] The following items may vary depending on your system version and configuration:
- Exact permission settings depend on your Privileges Setup configuration
- Sync timing to POS terminals depends on network conditions and sync schedule
- Some features may require additional licensing or module activation
- Field behavior may differ between EQuip versions
If you encounter behavior not described in this manual, contact your system administrator or EQuip support team.
Expected Result: Changes are saved successfully and reflected across the system after the next POS sync.
| Field | Required | Description |
|---|---|---|
| Name / Title | Yes | The display name for this record |
| Status / Active | — | Whether this record is active in the system |
| Created Date | Auto | System-generated creation timestamp |
| Modified Date | Auto | System-generated last modification timestamp |
[!NOTE] Additional fields specific to this page are documented in the sections above. The table above shows common fields present across most pages.