If it is the same information for each products (identical information table), I can help you do that with a snippet -let me know. If it is not identical, then you will need to use a bulk import plugin such as the the popular WP ALL IMPORT.
During the import, you would need to set the following meta data for each product:
- Meta KEY b2bking_show_information_table must have the VALUE yes
- Meta KEY b2bking_product_customrows_group_b2c will have the VALUE in the format Info:Value;Info:Value;
( for example Shipping Time:3 days;Countries available:USA, UK; )
I am using WP All Import / All Export Pro plugin, but I am not seeing the fields b2bking_show_information_table, b2bking_product_customrows_group_b2c in the product export CSV.
I don't see any b2b related fields export out, you can refer to the csv (I have cleared all my products data).
I opened your CSV file - from what I can see, only preconfigured WP / WC fields are being shown there, but not all metadata.
I tested now with WP ALL Export to see how it would work. It seems that when you configure the export, you need to add the fields from the Custom Fields tab. I checked and I can find the fields there.
I have tried with WP All Import to make the changes, but it unable to update into the B2BKings info table. The fields will go blank after that.
I am trying to use another plugin WP Sheet Editor to edit the Woocommerce product field. It is like an excel table format. I updated the info into the field in WPSheetEditor, same thing happen. The changes are unable to "stick" to the product and it goes empty after refresh.
On the other way round, if I update the field on the product, it will show up in the WPSheetEditor. Refer to the 2 screenshot.
Please help us to find out the root cause of it. I need to bulk edit 4700 products.
I can tell you that there is no special method / save function to update the table. For example it can simply be edited directly in the wp_postmeta table and it will work. There is no cache or anything like that. Simply editing the database is enough.
If it's not working with the sheet editor plugin, it means the sheet plugin is not changing the value in the database.
Hi,
I want to bulk edit custom information table for each product, how can I do that? We have more than 4700+ products.
Hi Brian,
If it is the same information for each products (identical information table), I can help you do that with a snippet -let me know. If it is not identical, then you will need to use a bulk import plugin such as the the popular WP ALL IMPORT.
During the import, you would need to set the following meta data for each product:
- Meta KEY b2bking_show_information_table must have the VALUE yes
- Meta KEY b2bking_product_customrows_group_b2c will have the VALUE in the format Info:Value;Info:Value;
( for example Shipping Time:3 days;Countries available:USA, UK; )
This is for the regular info table.
Kind regards,
Stefan
Hi,
I am using WP All Import / All Export Pro plugin, but I am not seeing the fields b2bking_show_information_table, b2bking_product_customrows_group_b2c in the product export CSV.
I don't see any b2b related fields export out, you can refer to the csv (I have cleared all my products data).
Hi Brian,
I opened your CSV file - from what I can see, only preconfigured WP / WC fields are being shown there, but not all metadata.
I tested now with WP ALL Export to see how it would work. It seems that when you configure the export, you need to add the fields from the Custom Fields tab. I checked and I can find the fields there.
Hi,
I have tried with WP All Import to make the changes, but it unable to update into the B2BKings info table. The fields will go blank after that.
I am trying to use another plugin WP Sheet Editor to edit the Woocommerce product field. It is like an excel table format. I updated the info into the field in WPSheetEditor, same thing happen. The changes are unable to "stick" to the product and it goes empty after refresh.
On the other way round, if I update the field on the product, it will show up in the WPSheetEditor. Refer to the 2 screenshot.
Please help us to find out the root cause of it. I need to bulk edit 4700 products.
Hi Brian,
Regarding WP ALL Import, you can try to enable this checkbox:
https://woocommerce-b2b-plugin.com/docs/wp-all-import-issues/ (it's explained here) It may fix the issue.
I can tell you that there is no special method / save function to update the table. For example it can simply be edited directly in the wp_postmeta table and it will work. There is no cache or anything like that. Simply editing the database is enough.
If it's not working with the sheet editor plugin, it means the sheet plugin is not changing the value in the database.
Hi,
I have tested the wp all import setting is working when my csv file is having 1 product.
When I update for 4000+ products, none are updated.
Correction on my statements. Some are updated. Mostly no.
I changed the process for each iteration from 20 records to 10 records. I managed to update all now. TQ