Public Ticket #3227047

Prices B2B

Closed
Comments
4 Tickets 4
Jose Veiga started the conversation 4 years ago on February 8, 2023 at 3:04pm

Hi,

I need to increment a percentage to all B2B prices at once.

I don't want to do this in dynamic rules as it's a one-off situation.

Is there any way to do this easily?

What is the table in the database where the B2B prices are stored?

If you can help, I really appreciate it.

Thanks.

Best regards,

Jose Veiga

2,762
KingsPlugins replied 4 years ago on February 9, 2023 at 1:16am

Hi Jose,

If you're looking to modify the prices directly, I think the easiest way would be with the price import / export feature. I'd advise to please see: https://b2bkingplugin.com/docs/how-to-bulk-import-export-product-prices/

It can be done with our built-in importer, or with the WooCommerce importer for large numbers of products.

In the database, our plugin stores the prices as post meta data, in the wp_postmeta table. These are the keys used for each product for each group:

b2bking_regular_product_price_group_GROUPID
b2bking_sale_product_price_group_GROUPID  

Kind regards,

Stefan

Sign In