How do I round my price values to a decimal or whole number? (BPE)

By using BPE, you are able to round the value of the price and compared price of your products to either a whole number or a decimal number. 

Round a price or compare price value in your store

To round a price or a compared price value, navigate to the "Price" or "Compared Price" page by selecting the title either in the dashboard or the left panel under Bulk Product Edit mode of the BPE app. After choosing the desired products and variants using the filters on Steps 1 and 2 as well as the optional step, choose "round price (or compared-at-price) on numbers before (or after) the decimal point" options to start creating a task to round price or compared price values. 

The option values to choose for rounding price values and compared price values. 

Round to a whole number

If "rounding on numbers before decimal point" is selected, the value will be rounded to a whole number. The whole number you want to round to should be one or more digits, like 0, 5, 9, 00, 50, 95, 99, 000, 999... You will also be able to choose if you wish to round the price value to the lower, nearest or upper whole number of your choice. For example:

• To round 123.00 to upper 9, the result will be 129.00; to round 123.00 to nearest 9, the result will be 119.00. 
• To round 1234.00 to nearest 99, the result will be 1299.00; to round 1285.00 to nearest 00, the result will be 1300.00. 
• To round 1234.00 to nearest 999, the result will be 999.00; To round 1234.00 to upper 000, the result will be 2000.00. 

Please note that numbers after decimal point will be erased. For example, if you round 123.31 to nearest 9, the result will be 119.00. 

Round to a decimal number

If "rounding on numbers after decimal point" is selected, the value will be rounded to a decimal number. The whole number you want to round to should be exactly 2 digits, like 00, 50, 99... You will also be able to choose if you wish to round the price value to the lower, nearest or upper decimal number of your choice. For example:

• To round 123.31 to upper 99, the result will be 123.99; To round 123.31 to nearest 99, the result will be 122.99.

Round a fixed price or fixed compared price in your market

Similar rounding capabilities are also provided in Region-based Pricing mode of the BPE app. When you bulk assign fixed prices or fixed compared price using the BPE app, either by manipulating existing values or converting from the prices from your home market, you will be offered the option to round the calculated result to a decimal or whole number of your choice. 

The options to round the calculated values in Region-based Pricing Edit. 

The way to provide your desired rounding number is slightly different from rounding functions in Bulk Product Edit. To be specific, 

• To round the calculated value to a whole number, input one or more number digits without any decimal points. For example, select "lower" and type "00" to round the calculated price value to the lower 00 before the decimal point. 
• To round the calculated value to a decimal number, input exactly 2 number digits lead by a decimal point. For example, select "nearest" and type ".99" to round the calculated price value to the nearest 99 after the decimal point. 

When your Region-based Pricing Edit task is created, the rounding functionality will work in exactly the same pattern as introduced earlier in this article.