wpallimport Posts – Melissa Freeman

WordPress – SQL query to output post_title, categories and tags

I needed to export a table of all posts with their categories and tags for the team to update ready to import back into WordPress with WP All Import. This is the query I used. I ran it in phpMyAdmin and then used phpMyAdmin to export the result to CSV. SELECT ID, post_title, (SELECT group_concat(wp_terms.name [...]

By Melissa Freeman|2019-12-17T06:24:02+10:00March 25th, 2017|WordPress|5 Comments

WordPress – Bulk remove WooCommerce products or attributes with SQL commands

Here are two handy SQL commands that are probably most helpful if you are doing bulk imports. I am using WP All Import, and sometimes I find that my Layered Nav disappears after an import. The only fix I have found is to remove all attributes (!) and then run the import again. Deleting attributes [...]

By Melissa Freeman|2019-12-17T06:25:01+10:00February 13th, 2015|WordPress|14 Comments