Discount calculator
Find the sale price, the percentage off or the original price, with VAT and price rounding.
Bulk sale price file generator for Salla and Zid
Paste your products and enter the discount, and the preview shows up here.
Products ready in the file
Rejected rowsLeft out of the file
Duplicate IDsWe keep the last row for each ID
| Line | product ID | Current price | New price | Status |
|---|
Upload the file to PopAutomate
The file uses PopAutomate's bulk schedule format: upload it to a new schedule, set the start and end date, and PopAutomate applies the prices on time and restores them when the offer ends.
File format and price rules
The tool builds the same CSV file that PopAutomate's bulk scheduling reads: two columns only, a first row with the column names exactly as shown, then one product per row. The file is UTF-8 encoded, so it opens in Excel without garbled characters.
| Platform | Discount schedule | Price change schedule |
|---|---|---|
| Salla | product_id,sale_price | product_id,new_price |
| Zid | sku,sale_price | sku,new_price |
- Product ID: the product ID (product_id) on Salla, the SKU on Zid. A row without one is rejected.
- Price: a number above zero with no more than two decimals. The tool writes every price with two decimals (like 79.99).
- Sale price: in a discount schedule, it can't be higher than the product's original price in your store.
- Duplicate IDs: if an ID appears more than once, we keep its last row, just like PopAutomate does when you upload.
- Limits: 50,000 products and 10 MB per file. If you have more products, split them across two files.
How the new price is calculated
- Percentage off: new price = current price × (1 − percentage ÷ 100)
- Fixed amount off: new price = current price − amount
- Increase (price change schedules only): new price = current price × (1 + percentage ÷ 100), or current price + amount
- Rounding: always down (159.99 instead of 160.00), so the discount is never smaller than the one you chose.
A discount schedule in PopAutomate sets the sale price at the start time and restores the original price at the end. A price change schedule changes the base price itself. To price a single product quickly, use the discount calculator, and to check whether the percentage is profitable, try the discount profit calculator.
How to use it in 3 steps
-
Copy your products
From your product export in Salla or Zid, copy the product ID column (Salla) or the SKU column (Zid) and the current price column, or upload a CSV that has both.
-
Choose the discount
A percentage or a fixed amount, with optional rounding. The table shows every price before and after, and flags rejected prices and duplicate IDs.
-
Download and schedule
Download the CSV with PopAutomate's columns, upload it to a new schedule in PopAutomate, and set the start and end date.
Worked examples
20% off, rounded to .99
A product at 199: 199 × 0.8 = 159.20, and rounding down gives 158.99 in the sale_price column.
A fixed 25 off
A product at 149.99 becomes 124.99. A product at 20 is rejected, because its new price would go below zero.
Raising prices 5% on Zid
In a price change schedule, choose "Increase": a product at 80 becomes 84 in the new_price column, next to its SKU.
What the file looks like
product_id,sale_price
123456789,158.99
123456790,119.99
Frequently asked questions
How do I change the prices of all my products at once on Salla?
Salla has a bulk price edit in its dashboard. If you want the change to start at a set time and the prices to go back after the offer, use this tool to build a CSV with each product's ID and new price, then upload it to PopAutomate with a start and end date.
How do I discount a whole category on Zid?
Copy the SKUs and prices of the category's products (from the product export in your Zid dashboard, for example), paste them into the tool, choose the discount, then download the file and upload it to PopAutomate. If every product in the category gets the same percentage, you can also pick the category directly in PopAutomate, with no file.
Why are some prices rejected?
Every price must be a number above zero with no more than two decimals (10.123 is rejected), every row needs a product ID or SKU, and a sale price cannot be higher than the original price. The tool flags these problems before you download, and rounds every price to two decimals.
Can I schedule the file for a specific time?
Yes, in PopAutomate: upload the file to a new schedule and set the start and end date. PopAutomate applies the prices at the start and puts them back when the offer ends. A discount schedule from a file needs an end date.
Is my data uploaded to a server?
No. The tool reads your numbers and builds the file inside your browser, and none of your product data is sent to our servers.
More free tools
Discount profit calculator
See your profit after a discount, and how many more sales you need to make up for it.
Saudi sales season calendar
Countdowns to White Friday, Ramadan, Founding Day and National Day for stores selling in Saudi Arabia, and when to start preparing your offers.
The next season is close. Get its offers ready now
Install PopAutomate and let your offers run on time while you rest.
Not sure? Message us on WhatsApp (opens in a new tab)