Store Locator Plus for WordPress › Forums › Store Locator Plus › Does importing remove stores if they are not on the new import
This topic contains 3 replies, has 2 voices, and was last updated by Cici 1 week, 1 day ago.
- AuthorPosts
- February 6, 2019 at 5:00 PM #58638
I was provided with a CSV file and asked to update the dealers in SLP, it has about 2800 listings on it. There are many new ones and there are also many that are no longer dealers that need to be removed.
I have not used the import function and I cannot find out whether importing a new csv will wipe the data that is there or update it. If updating, will it remove those listings that are not in the new CSV? If not is there a way to remove the old database and then import the new one?
Thanks
KevinFebruary 7, 2019 at 5:41 PM #58648Importing does not “remove stores” There is a function under locations bulk actions called delete permanently.
You should make sure you have a back up of your site.
You can export your locations download to a csv file. (Some docs, about large exports configuration etc and export to csv file)
You can them delete. You do not show us your plugin environment so I do not know if you have the Power add-on. You need the Power add-on to export/import
You can make changes and under the import function choose how to handle duplicate . Review the notes on the sl_id column. You should not use that header on reimports unless you are using exact same sl_id in the locations datainfo)
here is the documentation about Duplicate handling.
February 8, 2019 at 9:50 AM #58660Thanks for reply.
The site does have the Power Plugin. Since I do not know what locations would need to be deleted I ended up having to delete all locations with the Bulk Delete function and then re-importing the new CSV. It wasn’t as painful as I feared.
Thanks
KevinFebruary 8, 2019 at 2:19 PM #58666Glad it worked out for you
- AuthorPosts
You must be logged in to reply to this topic.