Convert Numbers works on built-in numeric fields (price, cost, weight, dimensions, stock) and your custom numeric attributes. To run math on a custom numeric attribute on its own, Numeric Operations is the more focused tool.
Convert numbers
Select products
Check the products you want to update, or use filters and select all matching results.
Open Bulk Edit and choose Convert Numbers
Click Bulk Edit, then search for “Convert Numbers” or find it under Attributes & Custom Fields.
Pick the numeric fields
Choose one or more fields to convert: price, special price, cost, weight, length, width, height, stock quantity, low stock threshold, or a custom numeric attribute.
Choose an operation
Pick how to transform the values, then enter any decimals or amount the operation needs.
Operations
| Operation | What it does |
|---|---|
| Round to N decimals | Standard rounding (half up) to the number of decimals you set |
| Round up (ceiling) | Always rounds away from zero |
| Round down (floor) | Always rounds toward zero |
| Truncate decimals | Drops digits without rounding |
| Multiply by | Multiplies each value by your factor |
| Divide by | Divides each value by your factor |
| Add | Adds a fixed amount |
| Subtract | Subtracts a fixed amount |
| Increase by % | Adds a percentage (10 means +10%) |
| Decrease by % | Removes a percentage (10 means -10%) |
| Absolute value | Turns negative numbers positive |
Options
| Option | What it does | Default |
|---|---|---|
| Target numeric fields | The built-in or custom numeric fields to convert | None |
| Decimals | How many decimals to keep, for the rounding operations (0 to 6) | 0 |
| Skip products with zero or empty values | Leaves empty values alone and avoids dividing by zero | On |
When to use it
- Clean up imported decimals. A feed that brings in prices like 19.9900 can be rounded to two decimals in one pass.
- Rescale a field. Multiply or divide to convert grams to kilograms, or to adjust values that came in at the wrong scale.
- Tidy stock numbers. Round odd stock values to whole units across the catalog.
Related
Numeric Operations
Run math on a single custom numeric attribute.
Change Price
Adjust prices by percentage or fixed amount with price guards.
Change Unit of Measure
Switch units with the conversion factor worked out for you.
All bulk actions
Browse every bulk editing action by category.