More Products in ” ALL” then “PUBLISHED” Products

Hi, @crowds90!

Please go to “Woocommerce > Status > tools” and click the following buttons, to see if that helps:

Cheers!

Hi,

Thanks for the response. I did all 3 and didn’t seem to work.

Hi there,

The fact that you have more products in All than in Published sounds like a normal behavior.

Some products that are not yet published might be increasing the number in All:

https://cld.wthms.co/uQ7DDo

Hi,

But you have a product that is scheduled. I don’t have that https://ibb.co/escEvz.

Plus if I am in my published products area and I delete my last page of products (so for instance page 720 in the link) when the page reloads it will keep page 720 displaying no products and show my last page at like 1400. Then if I went to page 719 the pages >719 would go away again.

So I personally don’t think it has to do with not being published. To me it’s more like they are deleted but still showing.

Hi there,

It sounds like you might need a database cleanup then.

These articles explain some of your options:

https://wisdmlabs.com/guide/woocommerce-optimization/database/

https://wpsites.net/wordpress-tips/cleaning-up-left-over-plugin-database-tables/

I’d strongly recommend backing up your database before proceeding.

If plugins like WP-DBManager or WP Clean-up won’t do the trick for you – the database can be cleaned up manually using a plugin such as ARI Adminer

Hi there,

We haven’t heard from you in a while so I’ll be marking this thread as resolved.

Feel free to open a new thread and link to this one if you have further questions though.

Have a wonderful day ahead!