Bulk edit of currency switcher products meta data fields

Fixed per-currency prices are stored as product meta, one field per currency. Setting them one product at a time is fine for ten products and impossible for a thousand.

Which fields to edit

FOX writes the fixed price of a product into meta keys named after the currency code:

• _woocs_regular_price_XXX — the fixed regular price in currency XXX
• _woocs_sale_price_XXX — the fixed sale price in currency XXX

where XXX is the three-letter code, for example _woocs_regular_price_EUR. Any tool that can write post meta in bulk can therefore set fixed prices across the catalogue.

Doing it in bulk

A bulk editor is the usual route — it shows those meta fields as columns and lets you fill them for a filtered set of products, which is exactly the shape of the task. BEAR is ours and handles WooCommerce meta directly, but any editor that exposes custom meta fields will do the same job.

An importer works too. If products already arrive through a CSV or an XML feed, add the per-currency columns to it and the prices land with the products — see setting a fixed price programmatically for the code-level version.

Two things to have switched on before any of this: multi currency mode, and individual fixed prices in the plugin settings. Without them the meta is written but never read.