We recently migrated from using YITH Cost of Goods to WooCommerce’s native Cost of Goods. We still use YITH Bulk Product Editor however. We entered in _cogs_total_value and attempted to bulk edit it but it doesn’t save. We reached out to YITH and they stated that this may be because the _cogs_total_value field is a calculated field. If this is true, is there a way we could still bulk edit these fields? Our product costs change often weekly and going into each product is far too time consuming to be able to effectively edit them. This will impact work flows for many stores who need to edit these fields.
We are also not editing order COGs at all – just product COGs with this tool if that provides any other details.
The page I need help with: [log in to see the link]
Thank you for reaching out and providing a detailed explanation of the issue. I completely understand how frustrating it can be to edit each item individually.
If you are using the plugin here: WooCommerce Cost of Goods, please create a support ticket through woocommerce.com, as this forum is intended for WooCommerce core issues and concerns.
Since Cost of Goods for WooCommerce is a premium plugin, support is handled directly through WooCommerce’s ticketing system.
We are not using a plugin. We are using the native cost of goods WooCommerce recently released as of version 10.3. We want to find a way to bulk edit the _cogs_total_value field using YITH’s Bulk Product Editor. That plugin allows for any custom field to be pulled in and edited. We can pull it in just fine but something else seems to be blocking the edit.
This reply was modified 7 months ago by adroofing08.
You can quickly edit individual products or bulk edit the Cost of Goods (COG) in WooCommerce. First, select the products you want to update, click Edit, and apply. Then, under Product Data, locate Cost and choose Change to. A field will appear where you can enter a value to bulk edit the COG, as shown below:
Unfortunately this is also too slow for our needs. Many of our products need to be updated at once. We have over 25k products and changing even a handful of those daily isn’t feasible. We want to know what the possible block is in the native cogs field that is preventing us from updating it via the mentioned YITH Bulk Editor. From what I can see its a normal field, but I’m not aware if there is anything in WooCommerce core that for some reason prevents other plugins editing the field?
For reference YITH Bulk Product Editor uses ajax to update the field assuming its based on just the field key. So if they use $product->update_meta('_cogs_total_value', $value) for example this does not get updated in the database. This isn’t really a custom code issue from my point of view but rather something core WooCommerce should allow. I am not seeing any conflicts between the two plugins so not sure what else could be causing it.
You’re right. The native Cost of Goods feature introduced in WooCommerce 10.3+ is still being progressively rolled out, and it works a bit differently from plugin-based COG solutions.
The _cogs_total_value field you’re referencing is a calculated value, automatically derived from product cost and order data. Because of that, WooCommerce doesn’t currently allow it to be updated directly via $product->update_meta() or third-party bulk editors; WooCommerce’s internal calculations would overwrite any manual change.
At this time, bulk-editing COG values through external tools like YITH Bulk Editor isn’t supported. However, this is great feedback, we’d recommend sharing it as a feature request here so our product team can review adding broader compatibility in future versions: https://woocommerce.com/feature-requests/woocommerce/
Thanks again for highlighting this, it’s super helpful as we continue expanding the native COGs functionality!
I’ll go ahead and close this thread for now, as the behavior appears expected. Please share your feedback on the support received here.
Understood, its a bit disappointing since this means we’ll either need to switch back or wait months in order to fix this issue. Thank you for the clarifications nevertheless. I’ve created a feature request as well:
Thanks for the update, and I completely understand your disappointment — waiting on a fix or switching back can definitely be frustrating.
I appreciate you taking the time to create a feature request as well; that’s really helpful for our development team to track and prioritize improvements.
In the meantime, if there’s anything else we can help you with or if you’d like to explore possible workarounds, please let us know — we’ll be happy to assist further.
Viewing 7 replies - 1 through 7 (of 7 total)
The topic ‘Bulk Edit WC Cogs’ is closed to new replies.
