Hey, @freshwebno!
Thanks for trying!
I tried the shortcode you shared on the first post on my website and it worked correctly.
You mentioned you tried deactivating plugins and changing the theme, right? Just to make sure, you deactivates all plugins but WooCommerce and used the Storefront theme and still had the issue?
Can you please share the URL of the sales page so we can take a look?
You mentioned there’s 180 products on sale, correct? How many are showing with the original short code?
Are you able to find and similarities between the ones that are not showing?
Can you share with us the URL of some products that are not showing so we can take a look?
Furthermore, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:
System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Fatal error logs (if any) under WooCommerce > Status > Logs.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.
Looking forward to your reply.
Have a wonderful day!