Promotion Importer

Promotion Importer

🌐 Backend — EQuipWebRetail ModeData Importer & Exporter

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.

Prerequisites

  • User must have appropriate role permissions (see Access & Permissions above)

Promotion Importer

📝 General Description

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.

10.4.1 Template Columns

ColumnRequiredDescription
PromotionName✅ YesMust match an existing promotion scheme name
ItemNo✅ YesProduct item number to add to the promotion
DiscountTypeNoPercentage or Amount
DiscountValueNoThe discount rate (%) or amount ($)
MinQtyNoMinimum quantity to qualify for the promotion
MaxQtyNoMaximum quantity eligible per transaction
StartDateNoPromotion start date (DD/MM/YYYY)
EndDateNoPromotion end date (DD/MM/YYYY)

Sample Template

PromotionNameItemNoDiscountTypeDiscountValueMinQty
Summer Sale 2026I0001Percentage201
Summer Sale 2026I0002Percentage201
Buy 2 Get 10% OffI0050Percentage102

Use Importer to manage and configure this feature in your EQuipWeb system.

10.4.2 How to Import Promotion Items

  1. Navigate to Data Importer → Promotion Importer.

2. Click Download Template to get the CSV template.

3. Open in Excel and fill in:

  • PromotionName: Must exactly match an existing promotion.
  • ItemNo: Product codes to add to the promotion.
  • DiscountType / DiscountValue: The specific discount for each product.
  1. Save as CSV.
  2. Click Browse → Select your CSV file.

6. Click Upload to process.

  1. Review results — verify promoted products appear in the promotion's item list.

Use Importer to manage and configure this feature in your EQuipWeb system.

10.4.3 Validation Rules

RuleDescription
PromotionName must existMust match a promotion created in Promotion Setup
ItemNo must existMust be a valid product in the system
DiscountValue must be positiveCannot have negative discounts
Dates must be within promotion periodItem dates cannot exceed the parent promotion's date range

Use Importer to manage and configure this feature in your EQuipWeb system.

10.4.4 Prerequisites

Before using the Promotion Importer:

  1. ✅ Create the promotion scheme first via Promotion Setup (Section 1.9).
  2. ✅ Ensure all products exist in the system (add via Product List or Product Importer first).
  3. ✅ Know the exact PromotionName — it is case-sensitive.

Use Importer to manage and configure this feature in your EQuipWeb system.

💡 Example

Scenario: A retailer runs a "Clearance Sale" with 30% off on 200 products.

Steps:

  1. Create the promotion "Clearance Sale" in Promotion Setup with type = Any X at Discount.

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.

Access & Permissions

RoleViewCreateEditDelete
AdminYesYesYesYes
SupervisorYesYesYesNo
CashierNo 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.

How to Import Data

  1. Navigate to Data Importer & Exporter → Promotion Importer from the sidebar menu.

  1. Click Download Template to get the Excel template with correct column headers.

  2. Open the template and fill in your data according to the column headers.

  1. Save the completed Excel file.
  2. Click Choose File and select your completed template.
  3. Click Import to upload and process the file.
  4. Review the validation results — fix any errors and re-upload if needed.
  5. Click Confirm Import to finalize.

Expected Result: Data is imported and available in the system.


FAQ

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.

Troubleshooting

IssuePossible CauseSolution
Upload fails with errorFile format is not .xlsx or file is corruptedDownload a fresh template, re-enter data, and try again
Validation errors on rowsMissing required fields or invalid data formatCheck the error details column for specific row issues
"Duplicate record" warningData already exists in the systemCheck if the record exists and decide whether to update or skip
Import shows 0 records processedFile is empty or wrong template versionVerify the file has data rows and uses the latest template
Error 404 on uploadFile too large or server timeoutSplit the file into smaller batches (max 500 rows recommended)
Data imported but not visibleFilters hiding the new recordsClear all filters and search for the imported records

Use Importer to manage and configure this feature in your EQuipWeb system.

  • Product Setup > Product List — imported product destination
  • Membership Setup > Membership List — imported member destination
  • Master Data > Supplier Setup — supplier data reference

Use Importer to manage and configure this feature in your EQuipWeb system.

Open Questions / Confirmation Needed

[!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 Reference

FieldRequiredDescription
Name / TitleYesThe display name for this record
Status / ActiveWhether this record is active in the system
Created DateAutoSystem-generated creation timestamp
Modified DateAutoSystem-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.

    • Related Articles

    • Promotion Setup

      ? Backend — EQuipWebRetail ModeProduct Setup Chapter 2: Product Setup — 2.9 Promotion Setup Use Promotion Setup to create special offers for your customers — Buy 1 Get 1, bundle deals, spend-based rewards, and more. Once a promotion is set up and ...
    • Virtual Stock Importer

      ? Backend — EQuipWebRetail ModeData Importer & Exporter Chapter 11: Data Importer & Exporter — 11.8 Virtual Stock Importer Use the Virtual Stock Importer to set daily quantity limits for many products at once. If you prepare fresh items each day and ...
    • Membership Importer

      ? Backend — EQuipWebRetail ModeData Importer & Exporter Chapter 10: Data Importer — 10.3 Membership Importer Use Importer to manage and configure this feature in your EQuipWeb system. Use the Membership Importer to add many members at once from a ...
    • Material Importer

      ? Backend — EQuipWebRetail ModeData Importer & Exporter Chapter 11: Data Importer & Exporter — 11.6 Material Importer Use Importer to manage and configure this feature in your EQuipWeb system. Use the Material Importer to upload raw material and ...
    • Product Importer

      ? Backend — EQuipWebRetail ModeData Importer & Exporter Data Importer & Exporter — 11.1 Step-by-step guide to bulk importing products, download template, import modal controls, and troubleshooting import errors Use Importer to manage and configure ...