Seller University

Setting up Staff Discount Prices in TREX

Home » Learning Resources - Intermediate » Module 6: Promotions » Setting up Staff Discount Prices in TREX

This tutorial explains how to create and manage Staff Discount Promotions in TREX using the Marketing Centre. You can set up promotions individually or in bulk using the upload template.

📝 Note: Please ensure that the GST settings have been configured correctly and all prices such as Retail Price, Discount Price and Staff Discount Price entered are before GST.

Create a new staff discount promotion

Pick from List

  1. Marketing Centre ➡️ Promotions ➡️ Create New
  2. Promotion Name: For backend reference only to identify and manage promotion. 150 characters max. e.g., July 2025 – 15% off Brand X products.
  3. Customer Type: Select the customer type that the promotion applies to e.g., All, Arrival, Departure or Non-Traveller. You may only select 1 option from the drop-down.
    📝 Note:
    Arrival includes Arrival and TR Home Delivery customers.
    Non-Travellers includes NT Home Delivery and Landside Collection customers.
  4. Promotion Period (Start): Date and time that the promotion will start.
    📝 Note: If there were no inputs, the promotion will begin +15mins from Promotion Creation Time. e.g., T+15mins
    Click on the 📅 icon to select the Start Date and Time.
  5. Promotion Period (End): Date and time that the promotion will end.
    📝 Note: If there were no inputs, the promotion will run indefinitely.
    Click on the 📅 icon to select the End Date and Time.
  6. Click on + Add Products
    💡 A pop-up window will appear. Available Search Parameters: Product Name, SKU Number, Category, Brands.

    Example: Searching with the Product Name.
    Example: Searching with the SKU Number.
    Example: Searching with the Product Category.
    Example: Searching with the Brand.
    You will be able to view and select up to 100 products per page.
    Select the applicable products by clicking on the checkbox on the left of Product Details.
    Click on Confirm Products.
  7. (For Bulk Setting) Discount Value: Discount value of the promotion. Input numerical values only.
  8. (If Applicable) Select the most appropriate option for Committed Stock Limit.
  9. (If Applicable) Input the Max Quantity. This should not exceed the Stock Quantity of the products.
  10. Select the applicable products (either Selected Products or Select All Products) by clicking on the checkbox ➡️ Apply Selected.
    💡 The Discounted Value will be applied and automatically reflected on the Discounted Price.
  11. (For Individual Products) Discounted Price: Input the discount price of the product before GST. GST may apply depending on the GST settings configured on product level. Input numerical values only including decimal place.
    💡 The Discount Value will change accordingly.
  12. Click Confirm to publish the promotion.

Bulk Upload Template

  1. Marketing Centre ➡️ Promotions ➡️ Create New
  2. Promotion Name: For backend reference only to identify and manage promotion. 150 characters max. e.g., Aug 2025 – Brand X $/% Promotion
  3. Customer Type: Select the customer type that the promotion applies to e.g., All, Arrival, Departure or Non-Traveller. You may only select 1 option from the drop-down. 📝 Note: Arrival includes Arrival and TR Home Delivery customers. Non-Travellers includes NT Home Delivery and Landside Collection customers.
  4. Promotion Period (Start): Date and time that the promotion will start. 📝 Note: If there were no inputs, the promotion will begin +15mins from Promotion Creation Time. e.g., T+15mins
  5. Promotion Period (End): Date and time that the promotion will end. 📝 Note: If there were no inputs, the promotion will run indefinitely. Click on the 📅 icon to select the End Date and Time.
  6. Click on + Add Products💡 A pop-up window will appear ➡️ Click on the Bulk Upload tab ➡️ Download Template
  7. This is an example of the template. You will be able to see the Product Name, Brand, Category, SKU Number, Offer SKU Code, Stock Quantity, Retail Price, Promotion Applied, Discounted Price, Discount Value fields. ⚠️ Only the Discounted Price and Discount Value fields are editable.
  8. Delete the rows/products that are not applicable for the promotion that you are creating. ⚠️ If these rows are not deleted and the Discount Value or Discount Price field/columns are left blank, you will face an error upon uploading the file.
  9. Input either the Discounted Price or Discount Value. ⚠️ You cannot enter both.
    For Discounted Price, input the discount price of the product before GST. GST may apply depending on the GST settings configured on product level. Input numerical values only including decimal place.
    For Discount Value, please not input any symbols (e.g., %, $) or decimals. 
  10. (If Applicable) Input the Committed Stock Limit.
  11. (If Applicable) Input the Max Quantity.
  12. Save the file ➡️ In the TREX window, Click to upload ➡️ Confirm. You will be redirected to the Promotions page! Please click on the Promotion Name to verify if the Promotion has been uploaded successfully.
  13. 📝 Note: To check if the upload was successful, click into the Promotion and you should be able to see all your products with the corresponding discounts.
    If there is an error message such as “One or more entries failed to upload. Click to download the error report”, please Click to download the error report to view the affected products and the error message. You will need to edit the affected products in the original file that was uploaded. Once you have made the amendments, repeat step 10 and ensure that there is no error with the next upload.
  14. To publish the promotion, click on the pencil icon to edit. Scroll down to view the products and check if the Discount Value has been set correctly. Example: If you had set the Discounted Price directly, check the Discounted Price column to check if the values are correct. If utilised, check the Quantity Limit and the Max Quantity set.💡 (Optional) If you would like to edit details such as e.g., changing the Discounted Price or Discount Value, you may continue to do so. Simply click into the field and edit the value. You will notice that the corresponding value will adjust as well.
  15. Click Confirm to publish the promotion. The promotion status will now change from Draft to Upcoming. 

Check your staff promotion in the Products page

  1. Products ➡️ My Products
  2. You will be able to see a Promotions under the Price column for products with a Staff Promotion. If you hover your cursor over the label, a pop-up box will appear with the promotion details.
  3. In the pop-up box, only 1 Ongoing Staff Price will be displayed at any point in time. If there is more than 1 ongoing promotion, the lowest price will be displayed.
  4. If you click on the View More button, you will be redirected to the Promotions page where you will be able to see all Ongoing promotions associated with the product.

Common Errors

1. If using the Committed Stock feature, please ensure that stock quantity indicated under Max Quantity is less than the Stock quantity. The system will not allow you to save your inputs until you rectify this error.

Frequently Asked Questions

Can you edit a Promotion?

Yes, you can edit the price promotion when the status is “Draft” or “Upcoming”.

Can I change the Start Time?

If you would like to change the promotion to the current time, you may either delete the current time or input the current time + 15minutes e.g., T+15minutes. The promotion will be activated at T+15minutes. Note: This can only be done when the Promotion is in Draft or Upcoming status.

You may remove the date if you would like the promotion to start as soon as possible.

What if I need to edit/remove a discount when it is in Ongoing status?

You will need to duplicate the current promotion and then make the changes to the duplicated one. Once the duplicated promotion is live, you may deactivate the previous promotion.

What if there are two promotions on a SKU with overlapping periods?

The system will display the lower Discount Price set.

In the bulk template, if I only indicate the value for Discount Value or Discount Price fields for the products applicable for the promotion and leave the remaining rows blank, will the Promotion only get created for those rows with inputs?

Yes, the promotion will be created for rows with inputs. Please do check if there are any errors. If both the Discount Value or Discount Price fields were left blank for the remaining rows, this will appear in the error report.
Example: If the template has 100 products and a discount value or price was indicated for 50, you will need to remove/delete the other 50 products without any inputs before uploading the template into the system.

If I duplicate the promotion, how come the Start Time is 15 minutes from the current time?

The duplicated promotion will not follow the old date therefore it will behave like a new promotion.

Can I set a Discount Price via the Products Module?

All Discount Price and Staff Price Promotions can only be set via the Marketing Centre/Promotions module in TREX. It can not be set up within the Products Module.

Related Topics

ArrivalDepartureDispatchDropshipDropship CAG3PLDropship DM3PLHome DeliveryLandsideNameOrderOrder ProcessingProductsPromotionsTRTrex Category