G-Olly

So to clarify for any users wanting to upload a csv list –

1). Get a CSV list of stores/stockists and make sure the addresses can be mapped properly by google maps.
2). Copy your list into https://www.findlatitudeandlongitude.com/batch-geocode/ to get the lat and lng results.
3). Import the correctly fielded CSV into the the wp_wpsl_stores table through “phpmyadmin” and voila!!!

I did read your previous answer to a similar question so I have already used “phpmyadmin CSV import” in conjunction with Batch Geocode to get the results. Thanks for an amazing plugin!!!

Thanks for letting me know Frank.

Ahh, once again I have managed to sort it out. All I had to do was recreate a new maintenance page – save it – and then turn it off.

Ahhh, silly me I forgot to regenerate the secure .htaccess. This is now all sorted. Sorry for being an idiot. Cheers, Olly

Hi Frizzo, there are probably a few, but for best results use the Woocomerce CSV import suite. Or you might be able to do it via database tables but I am no MySQL expert.

Yes, install a woocommerece export plugin such as WooCommerce – Store Exporter onto your old site. Make sure your version of woocom is compatable. Then install Woocommerece into your new site and then import the export file. Done.

Yep all good, thanks for your help.

Thanks AIT, I am in contact with the WPML guys. As you say this looks like a re-occurring issue. I hope I can get a solution before to long.

Thanks again,
Olly

After playing around with publishing posts and updating etc. I have come to the root of the problem. It seems that it’s a problem with WPML not BPS in anyway. Thanks for replying. I will keep you posted as to my progress.

Many thanks,
Olly

Brilliant Mr Visser! Chuffed to bits, this will make the export and integration of the CSV really easy for me now. I will try and get a donation over to you when I get the chance. Keep up the good work.:)

Great! Look forward to it. ??

In fact, I can see they are ordered alphabetically but my query still remains.

If you cannot login to disable the plugin, you can do it manually using one of these methods – https://www.wpbeginner.com/plugins/how-to-deactivate-all-plugins-when-not-able-to-access-wp-admin/

Mine is also returning a 500 error. My disk space usage is also going up very rapidly about a gig a day. Any suggestions would be very helpful.