All 37 Bulk Editor answers

See every answer

Answer

Can prices end in .99?

Updated Bulk Editor 1.7.0Tested with WordPress 7.1

Yes. In Calculate (or Sale price from regular price), set Rounding to End in…, pick the ending (0.99, 0.95, 0.90, 0.00, or Other for your own) and the direction. Up to the next never lowers a price: 21.57 becomes 21.99. Nearest takes the closest one, above or below: 22.10 becomes 21.95. A price that already ends that way stays as it is. Round to a step rounds to 0.05, 0.10, 0.50 or 1 instead, so 12.52 becomes 12.50. Both start from the price as your store shows it: 13.88 plus 8% shows as 14.99, which already ends in .99, so it stays 14.99. A price of 0 stays 0, so free products stay free, and a price above 0 is never rounded to 0: 0.30 to the nearest .00 becomes 1.00. On a store that prices without decimals the endings are 9, 90 and 99 (1234 up to 90 is 1290). The line under the fields shows the first selected row's new price before you apply, and Apply to: All N records in this list does the whole filtered list with one Undo.

Still stuck? Ask the developers who wrote it. We aim to reply within one business day.

Bulk Editor for WooCommerce

Edit WooCommerce products, orders, coupons and reviews in one spreadsheet, paste supplier lists by SKU, undo your edits.

From $19 a year · every feature · 30-day refund

Buy Bulk Editor for WooCommerceSee the plugin

The Products editor of Bulk Editor in WordPress admin. A toolbar with Filters (one active), Display, Views, Custom fields, Taxonomies, History and Bulk tools sits above a spreadsheet of twelve products with columns for ID, name, type, image thumbnail, SKU, regular price, sale price, stock, stock status, status and categories.