Skip to content
0431 872 791|hello@melissafreeman.com.au
Melissa Freeman Logo
  • About
  • Troubleshooting
    • WordPress
    • JavaScript
    • Maps
    • Sheets
  • About
  • Troubleshooting
    • WordPress
    • JavaScript
    • Maps
    • Sheets

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|6 Comments
Read More

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|15 Comments
Read More

Recent Posts

  • GA/GTM – How to track “return visit” with cookies
  • MAMP – MySQL won’t restart after Windows crash
  • HTTP error when uploading images to WordPress on MAMP/XAMP
  • WordPress – get_posts with a custom post type and taxonomy or category page
  • Installing Behat 3 / Mink / Selenium for Browser Testing – Windows – Part 2

Tags

add to cart analytics attribute avada behat bulk import configurable products css grunt gtm image quality import jquery magento magmi mail malware mink search selenium settings sql super products testing WooCommerce wordpress wpallimport

Quick Links

  • Contact Melissa
  • About Melissa
  • LinkedIn
Copyright 2020 - Melissa Freeman - Sydney, Blue Mountains, Australia
Websites - Blogs - Stores - WordPress - PHP - CSS - HTML - Responsive Design
linkedin