Woocommerce categories won't display on admin side

Where do you mean they don’t show? On the add product page?

on the products >> categories “Product Categories’ page on the back end. I see no categories.

on a product admin page itself, I don’t see the list of categories in the category box on the right side.

website: oneterrainc.com

you can see in the footer, the test widget showing all categories:
https://oneterrainc.com/shop/

Did you import these somehow..?

I can add categories with the admin backend, but the submitted categories just won’t DISPLAY in the backend.

If I had to guess, I’d say you’re missing the term meta database table we use to add meta data to categories. Checked the database?

in system status, I see this;

woocommerce_attribute_taxonomies Table does not exist
woocommerce_termmeta Table does not exist
woocommerce_downloadable_product_permissions Table does not exist

woocommerce_order_itemmeta Table does not exist
woocommerce_tax_rates Table does not exist

how can I add those?

try de-activating and re-activating wc.

I did that. I reinstalled twice. doing again…

is there some sql code I can use?

Maybe check if there are errors with your host – they should install for you.

the woo commerce tables above didn’t get installed using the woo commerce plugin. how can I get those tables added?

My host installed wordpress only.

I mean, either you or the host should check server error logs. See WHY they are not installing. It may be the DB user associated with the site.

just those tables as opposed to the other woo commerce tables being installed? those tables could be a permissions issue?

would this work?

— ——————————————————–

—
— Table structure for table wp_woocommerce_attribute_taxonomies
—

CREATE TABLE IF NOT EXISTS wp_woocommerce_attribute_taxonomies (
attribute_id bigint(20) NOT NULL auto_increment,
attribute_name varchar(200) NOT NULL,
attribute_label longtext,
attribute_type varchar(200) NOT NULL,
attribute_orderby varchar(200) NOT NULL,
attribute_public int(1) NOT NULL default ‘1’,
PRIMARY KEY (attribute_id),
KEY attribute_name (attribute_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–

—
— Table structure for table wp_woocommerce_downloadable_product_permissions
—

CREATE TABLE IF NOT EXISTS wp_woocommerce_downloadable_product_permissions (
permission_id bigint(20) NOT NULL auto_increment,
download_id varchar(32) NOT NULL,
product_id bigint(20) NOT NULL,
order_id bigint(20) NOT NULL default ‘0’,
order_key varchar(200) NOT NULL,
user_email varchar(200) NOT NULL,
user_id bigint(20) default NULL,
downloads_remaining varchar(9) default NULL,
access_granted datetime NOT NULL default ‘0000-00-00 00:00:00’,
access_expires datetime default NULL,
download_count bigint(20) NOT NULL default ‘0’,
PRIMARY KEY (permission_id),
KEY download_order_key_product (product_id,order_id,order_key,download_id),
KEY download_order_product (download_id,order_id,product_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–

—
— Table structure for table wp_woocommerce_order_itemmeta
—

CREATE TABLE IF NOT EXISTS wp_woocommerce_order_itemmeta (
meta_id bigint(20) NOT NULL auto_increment,
order_item_id bigint(20) NOT NULL,
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (meta_id),
KEY order_item_id (order_item_id),
KEY meta_key (meta_key)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=658 ;

— ——————————————————–

—
— Table structure for table wp_woocommerce_tax_rates
—

CREATE TABLE IF NOT EXISTS wp_woocommerce_tax_rates (
tax_rate_id bigint(20) NOT NULL auto_increment,
tax_rate_country varchar(200) NOT NULL default ”,
tax_rate_state varchar(200) NOT NULL default ”,
tax_rate varchar(200) NOT NULL default ”,
tax_rate_name varchar(200) NOT NULL default ”,
tax_rate_priority bigint(20) NOT NULL,
tax_rate_compound int(1) NOT NULL default ‘0’,
tax_rate_shipping int(1) NOT NULL default ‘1’,
tax_rate_order bigint(20) NOT NULL,
tax_rate_class varchar(200) NOT NULL default ”,
PRIMARY KEY (tax_rate_id),
KEY tax_rate_country (tax_rate_country),
KEY tax_rate_state (tax_rate_state),
KEY tax_rate_class (tax_rate_class),
KEY tax_rate_priority (tax_rate_priority)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–

—
— Table structure for table wp_woocommerce_termmeta
—

CREATE TABLE IF NOT EXISTS wp_woocommerce_termmeta (
meta_id bigint(20) NOT NULL auto_increment,
woocommerce_term_id bigint(20) NOT NULL,
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (meta_id),
KEY woocommerce_term_id (woocommerce_term_id),
KEY meta_key (meta_key)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;