janzoudlik

@lorro

Works perfect…
thanks a lot for this

I have to say that it still loads reasonably fast…
…I nearly did not noticed difference and I do have truly 497 variations

I guess if each of them has special picture or lots of details, then it may slow it down considerably

hi there,

I do have same issue…
I do literally need the elimination of non possible options and I do have nearly 500 variations(with 5 different options).
Unfortunately link to snippet posted by @mikejolley is no longer working…
Any chance it can be posted directly here?

thanks
Regards
Jan

Hi there,

@7grafix
so at the end I decided to buy premium plugin(bulk update) in hope it will fix it…
Unfortunately it fixed in our case only about 30 procent of variables with missing prices…
Luckily this plugin will be useful in future so no waste…

And yes, I tried to disable most of the plugins with no luck in progressing anywhere…

@brightestspark
I am not that confident in developers as I have bad experience in any software developers – saying that, having a ticket opened for nearly a year with no or very little progress just proves it…

Anyway, as I said I am lucky that I don’t have to update anything very often…
I just get some admin to go through all products not showing price one by one and hit update…

Thanks everyone for their inputs…

If somebody comes with some other idea or some fix, please post it here…

Thanks
Jan

ok… had a look into database… as it is stored in I would say XML format, there is no way to edit this with SQL query…

@7grafix

further to this, I do have too disagree with you that it is just cosmetic…
Well saying that it depends from what angle you looking at it…
In case you don’t know anything about databases, then probably yes, it looks just cosmetic, but truly speaking, it isn’t.

Root cause behind it is in very lame term that during import it won’t populate certain cell(field or column, whatever you like to call that) within database.

I do agree with you that it is not necessary import tool fault. This may well be caused by some plugin or it is actual bug within woocommerce, if importing reasonably big amount of data. I am not experienced enough to troubleshoot this so can’t really say…

Anyway, I found out that it has to be database related as I create duplicate website of my store for further testing and found that already updated variable products show prices, however all the rest won’t. As all these data are stored within database, there has to be something what is causing it…

Anyway as bulk edit, did not work for me I am looking into actual database, if I can come up with some simple SQL query which would repopulate what needs to be populated for price to work.

If I manage to get something done, I’ll post it here.

Unfortunately I am not experienced with PHP at all as it would be probably a lot easier to write it in PHP as a function and dump it into functions.php(as one of fix)
something like: WC_Product_Variable::sync(all);

@7grafix

I am afraid I don’t have same plugin installed(WooCommerce Stock Manager)…
And in my case bulk operation did not help…

May I ask what is exact name of bulk update plugin you used?
I have used PW WooCommerce Bulk Edit, which have not done what I need, I am afraid…

Honestly speaking I would not mind if issue just hide itself as I will change products once a year with full reload so…

Hi there,

I do have basically same kind of issue.
Simple products will show price fine.
Variable will not after using csv import suite.
I do have instock value even against parent SKU so unfortunately this will not fix it in my case.

However I discovered that if I add product to shopping cart, price will show…
Further to that I discovered that if I go into the product and literally open it and hit update, price will show fine.

I did some basic testing and found that if I import few products, all works fine, however if I import full list(1750 parent SKU, 6650 variations), price will not show.

Any chance to either advise how to fix…
I would be happy even for simple work around fix > script which updates all product so it shows prices.

Any response will be more than welcome.

Thanks

Regards
Jan