Urgent – Shop and Categories Not Showing Variable Pricing

In your case, how were said variations imported, and in what version?

Hello there,

Import/merge was made via CSV Import Suite plugin, running current version of woocommerce.

Do you guys know of a way to automatically mimic ‘manual update’ in order to fix this issue.

Any input is appreciated.

Sorry about the initial rant, seriously, I was irritated at the time… I know that doesn’t help any issue ??

Thanks in advance.

I think it may be that the import was done with incorrect price keys. If you go to tools > export and export your product variations for me, I can check.

Correction, I’m talking about a different site with variation issues…

The site in question didn’t have the import done to it.

Variations were already existing.

Only the woocommerce plugin was updated from 2.3.2 to current version, thus making variation prices invisible on all archive/shop/category pages.

Prices show on product pages, but not the latter.

Same here!

Updated yesterday to 2.4.10 > 642 products with variations are broken. Cannot select the variations anymore, in some cases cannot even correct them manually.

@wtf-mate Still could use the export. And when you updated, did you click the ‘upgrade database’ link? Old data is updated when this is ran.

Hi Mike,

Yeah I did ‘upgrade database’ when I saw it.

Though I’m not certain if the variation prices/glitch not showing on the shop page occurred before or after that.

What are you suggesting as a fix?

Right now, the only option we have for this client is go in and manually update products which will take weeks.

This is the second time that this happens to this clients site with woocommerce.

Contemplating a change to a simple products which would be silly considering the nature of the product line.

Solution time?

How do we automate/simulate the action of logging in and clicking update?

That is the only fix that we have found, and I have been scouring the internet for days.

Fingers crossed and hopeful…

WTF-Mate I need to see the data or I can’t suggest a solution. Or do it yourself if you don’t want to share; export it before and after saving a product and compare.

To recap…

Variations were already present on this site.

The update created the issue.

Everthing worked fine, then update = variations issue

Let me know which column of the export you’d like to see.

Client doesn’t want site or associated info in public.

Tools > Export. You need to look at the ‘meta’ data for each post. Specifically _regular_price , _price, and _sale_price. I suspect price is not set.

Tools > Export > ?

Products or variations?

Products export via ‘Tools > Export >’ fails since there’s more than 7000 of them.

Having said that:

* CSV Import Suite Export Products with Hidden Meta doesn’t show:
_price.

* CSV Import Suite Export Products with Hidden Meta Does show:
_regular_price and _sale_price are there yes.

I’ve exported products and variations with hidden meta via CSV Import suite.

I’ve done the export before the ‘Manual Log In and Click Update Product’ fix.
+
I’ve done the export after the ‘Manual Log In and Click Update Product’ fix.

When comparing all info, every single field is still 100% identical with no changes whatsoever.

Yet, manually updated now shows price “From:$100-$200”
vs
Not manually updated products which still do not show the latter.

I understand what you mean now. I thought you were referring to the prices of each variation being missing, but I see now you simply meant the display at variable product level.

So export Products, not variations. See if price is empty for your variable product.

That would hit this line and return an empty result: https://github.com/woothemes/woocommerce/blob/2.4.10/includes/class-wc-product-variable.php#L354

Hi Mike,

I can only export via csv import suite.

So with the csv open, is there something in there that I’m looking for?

Variable products ‘regular_price’ column?

Otherwise, when trying to export via Tools > Export… = Fail for me, too many products I’m guessing, I only get this after awhile:

The webpage at https://sitename.com/wp-admin/export.php?download=true&cat=0&post_author=0&post_start_date=0&post_end_date=0&post_status=0&page_author=0&page_start_date=0&page_end_date=0&page_status=0&content=product&submit=Download+Export+File might be temporarily down or it may have moved permanently to a new web address.

Not code savvy, so :)…

This was in functions.php

https://support.woothemes.com/hc/communities/public/questions/202794676-Showing-only-1-price-for-variable-product

SOB that was the culprit rendering all variable prices invisible on the shop/cateogories since the update.

Sheesh.

Thanks for your patience.

Is there a way to disable product range on variable products and just show the minimum price?

With code along those lines yes. There are filters – the code you were using uses outdated functions however.