WooCommerce Hidden Categories? 4 Categories Shown “18 items” shown on Categories page

I am having a weird issue with WooCommerce… When viewing my product categories, It shows that I have 18 total, but it only shows 4 of them.

The other categories show up when I go to create a product, I can see and select those categories on that page. But I have no items in those categories, no attributes attached to them, no tags, etc. I just cannot seem to remove them, or understand what is keeping them around.

Any ideas would be helpful. I am using the LUSION theme, with the elementor builder.

4 Total Categories, with 18 Items shown

enter image description here

Categorisation advice for SEO in order to rank categories [closed]

This is sort of long but probably an easy question for you all. Don’t let the text scare you, it’s an easy read.

I’m a webmaster who’s trying to set up a music store webpage. Reading about different SEO concepts and tips, and most importantly John Mueller’s famous quote on page juice, I’m currently contemplating how I may set up a long-term SEO plan for the shops webpage. Since user experience, ease of navigation and backlinks are extremely important, I have decided to implement the following for causes that will be later stated:

STEP ONE: Set up the webpage so that different categories are set up for each instrument, except an instrument of selection

STEP TWO: The page that will be getting the backlinks will be something by the line of musical instruments, which is going to be set as a category. The instrument of selection will be set as a subcategory of musical instruments, which will also be receiving lots of backlinks in itself.

STEP THREE: As the shop takes on more visitors, other instrument categories will be added to the "musical instruments" category, which will be receiving backlinks from then on. This process is repeated until most categories are taken under the umbrella of musical instruments, from which point on, the category musical instruments will be redirected to the homepage, and the instrument subcategories under it made into categories of the homepage, thus just categories in themselves.


The rationale is as follows:

Backlink building will be most focused on the main keyword, which is quite a long process, given the seo competition being very harsh where I live at, I found it would be the best of my interest to start popping up different categories ranks up one by one. I wish to gradually work my way up to the main keyword while still earning from the specific instrument categories which are easier to rank for.

Moving this way will allow me to rank for these instruments on the way to building up the main keyword backlink profile, as category pages will generate seo for subcategories and increasing subcategory numbers one by one would make it so that the umbrella term which is musical instruments isn’t too spread over the place


My issues comes into play here: How effective will this strategy be? Given that people want to view musical instruments and not "pianos" per se when they view musical instruments, I can see why people would gravitate towards the homepage, lowering screentime on page (Analysis shows "musical instruments" pages are where most people spend time and money) and thus ranks, which I PRESUME WILL LOWER RANKS FOR SUBCATEGORIES (keep in my mind early game plan is profiting from specific instruments, since ranking for musical instruments is hard in the first place). However, categorising each instrument under musical instruments would be beneficiary for the the m. inst. rank.

QUESTIONS:

  1. Is there any fallicious logic behind what is written above
  2. Would screentime play part in ranking for subcategories/links that take place at the page
  3. Would category seo even help subcategories at all, does google take the websites word for what the backlink profile popularity of the page is going to affect or simply care about where users are directed towards when they visit the webpage? 4.What alternative strategies would you recommend given I want to rank for instruments as I’m gradually building up for the main keyword

Thanks!!

How to list all categories and their IDs using SQL query?

I am looking for a SQL Query that can give the list of all categories created in WordPress Site along with it’s category IDs. Please advise a query to get it as category/term relationship is quite complex in WordPress.

I got this but didn’t work –

SELECT ID,post_title FROM wp_posts INNER JOIN wp_term_relationships ON wp_term_relationships.object_id=wp_posts.ID INNER JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id=wp_term_relationships.term_taxonomy_id INNER JOIN wp_terms ON wp_terms.term_id=wp_term_taxonomy.term_id WHERE name='category' 

How to display the categories on page using shortcode?

I am trying to display the categories name on my page but it’s not displaying. I am using the below code and I added the shortcode gridCategories on my page. I am getting only array

function createGridCategories(){ $  categories = get_categories( array(     'taxonomy'   => 'category',     'orderby'    => 'name',     'parent'     => 0,     'hide_empty' => 0, // change to 1 to hide categores not having a single post ) ); var_dump($  categories); return $  categories; } add_shortcode( 'gridCategories', 'createGridCategories'); 

I tried this also

$  categories = get_the_category(); var_dump($  categories); 

I added a shortcode like this in textblock

enter image description here But still, I am not getting any output on my page. Is there any issue with my code?

How to target all woocommerce categories that don’t have any subcategories in them?

I want to target all pages (product categories) that are displaying the products themselves.

My woocommerce settings set to show only categories/subcategories (unless there are none) and then by default the products grid is displayed on the page.

is_product_category() function doesn’t help since it also targets the parent categories which don’t have direct products in them.

Most of my categories that don’t any subcategories in them are grandchildren categories if it matters for the answer.

How can I achieve it and to use it in woocommerce hooks?