Missing Product Categories on a multisite

  • kpobococ

    (@kpobococ)


    9 years, 6 months ago

    I have a multisite installation. I created a subsite by cloning an existing one with the plugin. It did copy everything, including products, but not product categories. I’ve found a related question and figured out there is no order created for my product categories. I tried removing and adding the categories again manually. I tried restarting MySQL. Nothing helps, it seems.

Viewing 4 replies - 1 through 4 (of 4 total)
  • D Smith a11n

    (@dsmithweb)

    Automattic Happiness Engineer

    9 years, 6 months ago

    Hi there!

    To be clear, when you add new categories manually, do they not save? That is, can you create categories at all?

    Thread Starter kpobococ

    (@kpobococ)

    9 years, 6 months ago

    They do save. They don’t get displayed unless I sort by name or description or anything other than order. Because there is no order meta value created for them. I can create them, but I can’t use them, because everywhere else they are sorted by order, so nothing is displayed.

    Thread Starter kpobococ

    (@kpobococ)

    9 years, 6 months ago

    Ok, so I’ve figured it out. Turns out, the plugin I used to clone an existing site on a multisite configuration, did not copy wp_woocommerce_termmeta table. Just copy its structure as wp_2_woocommerce_termmeta (replace 2 with your actual site id) and it will work as expected.

    chrishilldevsolutions

    (@chrishilldevsolutions)

    9 years, 3 months ago

    kpobococ,

    I just wanted to say Thank You! Thank you for sharing the resolution to the problem – i have been tearing my hair out over this problem for days.

    I used All in One WP Migration to copy my site from one host to another and had the same problem – i copied the wp_termmeta table from my new site db to the old site db and all is now working.

    FYI – for anyone looking here, WooCommerce version 4.6 and later use the wp_termmeta table rather than wp_commerce_termmeta table.

    Thanks again kpobococ!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Missing Product Categories on a multisite’ is closed to new replies.