petebm

Hi

Sorry to trespass on someone else’s thread, (& to ask for another addition so soon after the last one!) but I too would like to be able to filter the meta fields that are exported. The reason for this is that we use a UM form to register new users, and the results of that mean that the export csv columns are likely to change, so I cannot filter out the results I want easily with a macro.

Therefore being able to only export the fimeta fields I need would be a great bonus.

Pete

Fair enough!

Thanks again for the plugin & the help

Pete

Good grief – that must be the quickest support reply ever!

Thanks for letting me know – do you have any idea roughly how long in the future? Weeks? Months? Years?

Pete

And like the traditional bad penny turning up, the problem’s back. Whether it ever entirely went away, I’m not sure – I may have just been ‘lucky’ in the products I checked. Either way, exactly the same thing is happening – the correct price for a product can be found everywhere except, crucially, in the overall product listing and the details page.

If anyone out there has any ideas – bright or otherwise, I’ll try ’em all – please let me know.

Thanks

That’s great, Daniel – I look forward to your having time to implement this.

Many thanks again
Pete

Crossing my fingers seems to have had the desired effect, though not in the expected way.

Checking the issue again today, I found that all the prices now match; the displayed price is now the same as that in the product properties. How, why or when this happened I have, unfortunately, no idea – but I’ll take it.

Ah well.

Hi again

Any more suggestions for this? The problem’s still happening, and after that seemingly perfect answer from @riaanknoetze (thanks), everyone’s gone very quiet . . .

Fingers crossed!

Pete

Hi

Thanks for the incredibly quick response. You got my hopes up there, as I hadn’t thought of those tools, but I’ve now run through them all (deleted transients, updated the database, regenerated lookup tables) & still get the same.

Sorry
Pete

Oh, good grief! What a typo!

WooCommerce is on 4.2.0! I do try to keep it up to date . . .

Hi @jlundie

Many thanks again for your continued help – & patience! As you will have gathered, I’m not exactly the world’s best WP/WC problem-solver!

I’ve now managed to sort out a routine for unscrambling the issues generated by the Zoho sync, which involves deleting affected products, re-importing them from a pre-sync backup, re-syncing, then marking the appropriate products hidden.

To answer your questions, WoooCommerce is on 2.4.0, and the plugin that I am finding very useful is https://www.ads-software.com/plugins/pw-bulk-edit/; the tax:product_visibility setting came from https://www.ads-software.com/plugins/product-import-export-for-woo/, though I’m not using it any more as the bulk edit now does seem to be working for setting the hidden status. I’d thoroughly recommend both – and WooCommerce, of course!

I’ll try & leave you in peace for a while now.

Pete

Hi @jlundie

Many thanks for the suggestion; I’m afraid I don’t know what the image was in your last post as the link times out, but I used a bulk edit plugin to make the change – & I now have all the products showing!

Great, thanks.

Now for a follow-up question, if I may? Product visibility: I’m sure I’ve set that in the past by just setting the Visibility option on the standard WC import routine to visible or hidden, but when I last tried this it had no effect, and I found I had to change the tax:product_visibility setting shown by a differet export plugin to exclude-from-catalog|exclude-from-search.

Any ideas why this might be?

Hi

An update on this. Thanks to the efforts of the support people at YummyWP, who I contacted about a slightly different issue which I thought was to do with their Smart Woocommerce Search, it’s been shown that the problem lies in a confusion over In stock & Out of stock in the database. This itself derives from an issue with integration with Zoho Inventory.

The cure seems to be to mark a missing product as Out of stock (they all currently show as In stock in a product export), update it, then mark it as In stock and update it. It then magically appears in the product category page as it should.

Hooray!

However (aargh!) the problem I now have is that I don’t seem able to achieve the same effect by exporting a product, changing the Stock setting, re-importing, then changing it back in the csv & re-importing again, which I would have assumed would do the same. It doesn’t, which would mean that I’d have to do every ‘missing’ product individually.

Any suggestions for enabling a bulk solution, please?

Thanks

• This reply was modified 4 years, 10 months ago by petebm. Reason: Edited to point out that there was no issue with the Search plugin!
• This reply was modified 4 years, 10 months ago by Yui.

Hi again

Many thanks for solving the problem! It was nothing to do with your plugin, but being caused by a clash in the values for instock and outofstock in the WooCommerce database, due to errors in Zoho integration.

Original 5 star review edited to include praise for support!

Cheers
Pete

Hi again

Many thanks – done!

Pete

Hi (@jlundie)

Many thanks for your suggestion; apologies for the time to reply . . .

I ran the Regenerate tool, and got the message ‘Lookup tables are regenerating’, so left it doing that for, well, hours in the end, as it said it might take some time. However, I then looked at ‘Scheduled actions’ and found that it had in fact completed in a minute or so! Or at least there were 12 completed actions at the time I started it.
However, that didn’t seem to cure the problem, so I read around a bit & found a suggestion elsewhere to run the other tools, including updating the database, which it said was scheduled to run in the background, but which I can’t see any sign of in the ‘Scheduled actions’ tab.

The final upshot, though, is that the problem seems to still be there.
Sorry!

Pete