Comments 4Jose Veiga started the conversationFebruary 8, 2023 at 3:04pmHi, 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,218WebWizards repliedFebruary 9, 2023 at 1:16amHi 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://woocommerce-b2b-plugin.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_GROUPIDb2bking_sale_product_price_group_GROUPID Kind regards,Stefan Sign in to reply ...
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
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://woocommerce-b2b-plugin.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