Need an easy way to add “pa_” prefix to WooCommerce Custom Attributes

The page below is part of a test site.

I imported around 9,500 unique products from another non-WordPress MySQL database using CSV import, using a CSV export from the basic WordPress site as my template. However, it didn’t use the “pa_” prefix, so I didn’t add it to the data from the old DB and so none of the products were imported with the “pa_prefix”.

As a result, the Custom Attribute filters aren’t working, unless I manually edit them to add the “pa_” prefix. With 9.5K items, that’s a massive task. The plugin WooCommerce Show Attributes *is* showing attributes in the shop listings and individual projects.

I tried doing a find-and-replace in PHPmyAdmin, bulk swapping “Format” with “pa_format” but it just took away all of the custom attributes.

Is there any way to achieve this without another CSV import? The last one took weeks because the only way I could do it was 100 rows at a time.

• This topic was modified 7 years, 2 months ago by maxormark.
• This topic was modified 7 years, 2 months ago by maxormark.

The page I need help with: [log in to see the link]