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 store owners round to the nearest 10 whole number or an exact decimal like .95 or .99.
From the 'Configure modifications' view, you have five 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:
This will change the decimal (up or down) to the exact decimal specified. Example:
| Specified .10 | Calculated price $12.22 | rounds to $12.10 |
| Specified .10 | Calculated price $12.52 | rounds to $12.10 |
| Specified .90 | Calculated price $12.22 | rounds to $12.90 |
| Specified .95 | Calculated price $12.22 | rounds to $12.95 |
3. Round Whole Number
This rounds the whole number (up or down) to the nearest denomination specified:
| Specified 10 | Calculated price $77 | Rounds to nearest (10) $80.00 |
| Specified 10 | Calculated price $72 | Rounds to nearest (10) $70.00 |
| Specified 100 | Calculated price $77 | Rounds to nearest (100) $100.00 |
4. 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 |
5. Keep decimals, rounding down
This strips the third decimal so $25.297 will 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)