This article details how to apply a storewide discount across all of your Stores / Outlets using the Mass Download / Mass Upload process.
Considerations when using this process:
- this process is only suitable if all of your Outlets use the Product Master pricing. products do NOT have Outlet specific pricing. For more detail on , please see: How to discount products en masse for an individual Outlet
- this process will apply a discount to all products downloaded - the selected discount will apply to any products not already discounted, AND it will also apply a further discount ON TOP OF any already discounted pricing.
- ensure to delete any Outlet/Store specific worksheets prior to Upload to avoid inventory quantities being overwritten
Step 1 - Perform a Mass Download
Perform a Mass Download for all product types, (or alternately just the product types you want to apply discount to). For assistance with Mass Download, please see: Edit Products via Mass Download
Step 2 - Edit the Mass Download file
2.1 - Open the Excel file
Open the Excel File generated by the Mass Download > click Enable Editing > ensure you are in the Product Master worksheet.
2.2 - Delete unrequired worksheets
Delete all other worksheets. The worksheets named as your Outlets / Stores contain live stock quantities which will potentially be overwritten if you do not delete them at this point.
Important - DELETE ALL WORKSHEETS EXCEPT FOR Product Master BEFORE CONTINUING
2.3 - Copy existing discount prices
Prior to applying the formula supplied below, copy all the prices for the products that already have a value in the DiscountPrice column. Paste these prices into either the WebPrice or RRP column - whichever is not currently being used.
2.4 - Apply the discount formula
Navigate to the DiscountPrice (column R) > in the first cell (R11) enter the below formula > press Enter.
Discount Formula = P11*0.#insert discount here#
Where ## is the fraction of the current price to be applied.
Example: for a discount of 30%, the calculation used would be '100% - 30% = 70%'. In this case the ## would be 0.70. Using the above formula, this will reduce the POS Price by 30% and input that new value into the cell.
The first DiscountPrice cell is now populated with the correct discounted figure.
Drag the formula down the entire DiscountPrice column for all Products. To do this: left-click and hold the bottom right-hand corner of the cell, drag down to the bottom of your product list and let go of the button once you are there
2.5 - Update products that already had a discount price
Enable Sorting and Filtering (per red arrow below)
Navigate to the column into which you previously pasted existing discount pricing - either WebPrice or RRP column. Click the Sort box (per purple arrow below), untick to NOT display Blanks (per green arrow).
Your display will now only include products that had discounts prior to this Mass Download.
Now enter a formula in the DiscountPrice column to say =### * 0.70 (Were ### is the first Cell of the Column where you pasted the original discount pricing)
Again, right-click and copy this down for all products listed.
2.6 - Enter a Discount End date
Navigate to column DiscountEnd (cell S11) > enter the required end date in the format of dd/mm/yyyy.
📋 Note: The discount date is inclusive. Only once the current date has moved past the Discount Date will discount pricing end.
📋 Note: Discount pricing is applied automatically and immediately at the time of performing the Mass Upload into Retail Express so no start date is required.
Step 3 - Save the Perform a Mass Upload
Save this file and perform a Mass upload. For assistance with Mass Upload, please see: Edit Products via Mass Download / Upload
Once the Mass Upload is complete, your pricing has been applied and is live.
Want more information? Find related articles here:
How to discount products en masse for an individual Outlet