All 37 Bulk Editor answers

See every answer

Answer

How do I set prices from the cost plus a margin?

Updated Bulk Editor 1.7.0Tested with WordPress 7.1

You need a cost column on screen first. WooCommerce's cost of goods feature adds one: it is off by default and switched on under WooCommerce → Settings → Advanced → Features. If your costs are kept in a custom field instead, switch that field on as a Number column in Custom fields. Show the Cost of goods column, select the Regular price cells, open Calculate…, set Start from to Cost of goods, choose Increase by, type 60, pick percent and apply. Each regular price becomes the cost plus 60%, rounded to your store's decimals; products with no cost are left alone. Use Apply to: All N records in this list to do the whole filtered list, and Undo on the message to put it all back. The same works for a sale price 20% below the regular price: Start from Regular price, Decrease by 20 percent. Any number column that is showing can be the starting point, including a numeric custom field.

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.