How to Round Bulk Prices
Ablestar Bulk Product Editor allows a consistent and reliable method to round prices for your products in bulk.
Rounding Options
Once your product set is filtered, when you are editing the Price field from the 'Configure modifications' view, there are three methods to rounding prices:
If you wish to round just the decimal of existing prices without making any other change to the whole number, you can set the percentage change to zero and then select your preferred rounding option. This will apply the rounding without altering the original price.
Guidelines
Rounding is not mandatory. You can default the setting to 'Don't round the value'.
If you choose to round, you will also have to specify where to round to. Many users round to the nearest 10 whole number or an exact decimal like .95 or .99.
From the 'Configure modifications' view, you have nine options to round your prices:
1. Don't round the value
This will work if you want to keep the exact calculated change, without modification
2. Round Decimals:
The logic includes:
- Less than .50: If you specify a digit less than .50 (like .05 or .02) your calculated price will round to the nearest multiplier of that number. (Exception: The number 9 is noted below)
- Greater than .50: If you specify a digit great than .51 (like .95 or .99) your calculated price will round to the exact digit.
- Exact number .09: If you specify .09 we will always round to the nearest exact ninth digit.
Examples:
| Specified .05 | Calculated price $12.22 | rounds to multiplier $12.20 |
| Specified .10 | Calculated price $12.52 | rounds to multiplier $12.50 |
| Specified .95 | Calculated price $12.22 | rounds to exact $12.95 |
| Specified .09 | Calculated price $12.22 | rounds to exact $12.19 |
3. Round to nearest multiple
This rounds the decimal digit (up or down) to the nearest denomination specified:
| Specified 5 | Calculated price $77 | Rounds to nearest (5) $80.00 |
| Specified 5 | Calculated price $72 | Rounds to nearest (5) $70.00 |
| Specified 5 | Calculated price $84 | Rounds to nearest (5) $85.00 |
4. Round to nearest multiple, rounding up
This rounds the decimal digit (up only) to the nearest denomination specified:
| Specified 5 | Calculated price $77 | Rounds to nearest (5) $80.00 |
| Specified 5 | Calculated price $72 | Rounds to nearest (5) $75.00 |
| Specified 5 | Calculated price $84 | Rounds to nearest (5) $90.00 |
5. Replace last digit(s)
This replaces the last (whole number) digit to the closest specified number:
| Specified 2 | Calculated price $77.15 | Replaces with (2) = $82.00 |
| Specified 2 | Calculated price $74.00 | Rounds to nearest (2) $82.00 |
| Specified 2 | Calculated price $86.15 | Rounds to nearest (2) $92.00 |
6. Replace last digit(s), rounding up
This replaces the last (whole number) digit to the specified number, only rounding up:
| Specified 2 | Calculated price $77.15 | Replaces with (2) = $82.00 |
| Specified 2 | Calculated price $74.00 | Rounds to nearest (2) $82.00 |
| Specified 2 | Calculated price $84.15 | Rounds to nearest (2) $92.00 |
7. Round Whole Number [deprecated]
This option is still being used by some repeating, but was replaced by options 3-6 above and will be archived.
8. Round Whole Number Up
This rounds your number (up) to the nearest specified denomination:
| Specified 2 | Calculated price $100 | Rounds to $102 |
| Specified 7 | Calculated price $100 | Rounds to $107 |
| Specified 10 | Calculated price $100 | Rounds to $110 |
| Specified 20 | Calculated price $100 | Rounds to $120 |
9. Keep decimals, rounding down
This strips the third decimal so $25.297 to become $25.29
✅ Tips and Troubleshooting
- Start your first bulk price edit with this procedure
- Learn about all editing options available for number fields
(07.221)