Title: Import into v2? Last modified: August 30, 2016 --- # Import into v2? * Resolved [YesThatAllen](https://wordpress.org/support/users/ahancock/) * (@ahancock) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/) * I just tried wp-store-locator 2.0 and it seems the import process doesn’t work as it used to? * The steps here: [https://wordpress.org/support/topic/bulk-import-or-csv-import?replies=4](https://wordpress.org/support/topic/bulk-import-or-csv-import?replies=4) * I’ve got my data laid out for v1.. is there a way to get it converted? * [https://wordpress.org/plugins/wp-store-locator/](https://wordpress.org/plugins/wp-store-locator/) Viewing 15 replies - 1 through 15 (of 36 total) 1 [2](https://wordpress.org/support/topic/import-into-v2/page/2/?output_format=md) [3](https://wordpress.org/support/topic/import-into-v2/page/3/?output_format=md) [→](https://wordpress.org/support/topic/import-into-v2/page/2/?output_format=md) * Plugin Author [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/) * (@tijmensmit) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521683) * No the phpMyadmin trick doesn’t work anymore with v2. There are no custom tables anymore, so phpMyadmin ( or any other sql tool ) isn’t capable of handling it. But I’m working on a CSV importer add-on that will be released soon ( I probably should have had this ready when I released the 2.0 update ). * The old table is still there though ( unless you uninstall it ), one way to hack around it is to delete the stores from 2.0 in the editor ( this will only remove the custom post types, but make a backup anyway ). * Open phpMyadmin, import the stores the way you used to in the old db table. Open the options table and set the value for the wpsl_version field to 1.8, reload the dashboard and it will ask you to convert the store locations in the old db to the 2.0 custom post types again. It’s not the most user friendly way, but until I release the CSV add-on, I think this is the only way. * Thread Starter [YesThatAllen](https://wordpress.org/support/users/ahancock/) * (@ahancock) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521694) * Aha! setting `wpsl_version` 1.8 was the thing I didn’t know… nice work! * I had to create the table `wp_wpsl_stores` and put the items in there, but the conversion was fast and pain-free. * Thanks so much! * Plugin Author [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/) * (@tijmensmit) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521704) * Good to hear it worked out! * A more user friendly option will be available soon 🙂 * [Gioweb](https://wordpress.org/support/users/gioweb/) * (@gioweb) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521833) * it worked in my case. * [Nora McDougall](https://wordpress.org/support/users/nora-mcdougall/) * (@nora-mcdougall) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521878) * I’m having a problem that is related to this situation, but not precisely the same: * 1. There is another store locator type plugin on a site that someone else built. This plugin is not up-to-date, so I’d like to switch it to this plugin. 2. This plugin was installed, but not activated. 3. The plugin files were from 9/14, so I updated them first. 4. I have an export of the locations, but the old plugin was never activated, so there are no tables in the database to import into. 5. I have the files from the old plugin, but the Dashboard does not recognize that they are there when I replace the new files with the old files. * Any thoughts? * Plugin Author [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/) * (@tijmensmit) * [10 years, 8 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521881) * [@nora](https://wordpress.org/support/users/nora/) McDougall Do you have a CSV export from the other store locator? If so, then you can import them into the db table from 1.2.25 with [phpMyAdmin](https://wordpress.org/support/topic/csv-upload-1?replies=16#post-5579764). You do have to make sure the headers in the CSV file match with the ones in the WPSL db. * After you imported them through phpMyAdmin, install the 2.0 version and the table from 1.2.25 is detected and the upgrade procedure will ask you to convert them to custom post types. * [darthsaschi](https://wordpress.org/support/users/darthsaschi/) * (@darthsaschi) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521895) * **Hi Tijmen.** * First of all thank you for this cool plugin. * I have a fresh V2 install without an old table – therefore I don´t know about the structure of the old table and how to export / reimport it. * EDIT: Whoops, just found the docu-link to the structure, sorry… * My real question is: will the CSV-option be part of the free plugin or will it be commercial? And do you have an idea when the option will be available? * Thank you and kind regards. * **Sascha** * Thread Starter [YesThatAllen](https://wordpress.org/support/users/ahancock/) * (@ahancock) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521896) * Hi Nora, * This is a sql command which should set up the old table * [https://gist.github.com/YesThatAllen/5d750f7ffeedc07d46fd](https://gist.github.com/YesThatAllen/5d750f7ffeedc07d46fd) * Tijmen – I look forward to seeing your plugin advance, it’s great, and we’ll be first in line to support a Pro version * [darthsaschi](https://wordpress.org/support/users/darthsaschi/) * (@darthsaschi) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521900) * **Hi everyone.** * OK, I managed to make an import to a fresh 2.0.2 thanks to your documentation and posts – thank you all for that! * Another question to Tijmen: will the CSV-Import support categories? * Thanks and kind regards. * **Sascha** * Plugin Author [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/) * (@tijmensmit) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521903) * [@darthsaschi](https://wordpress.org/support/users/darthsaschi/) it will be a paid add-on, and yes, it will support categories. I’m hoping it will be available in the coming weeks * [Nora McDougall](https://wordpress.org/support/users/nora-mcdougall/) * (@nora-mcdougall) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521908) * YesThatAllen, * Thanks a bunch for the SQL to create the table! You saved me a bunch of time digging it out of my archive backups! * [Nora McDougall](https://wordpress.org/support/users/nora-mcdougall/) * (@nora-mcdougall) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521909) * Now that I have a table structure and data, I have some questions. 1. Do the IDs start at 0 or 1? 2. The telephone numbers exported with no punctuation. Will it be added or is there a specific format? It looks like a plain text field, but is there a filter in the code? 3. States is a straight text field. I’m guessing the mapping is done strictly by lat/long, so the state could be altogether incorrect and the mapping would still function, ie. no error checking. * Data conversion is always such an adventure! * Thread Starter [YesThatAllen](https://wordpress.org/support/users/ahancock/) * (@ahancock) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521910) * Ha ha ha, yes, that’s why I pay good money for nice friendly converters. * Tijmen.. thanks for your work on this plugin, will be glad to be one of your first paid supporters. * [JLRuiz1717](https://wordpress.org/support/users/jlruiz1717/) * (@jlruiz1717) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521912) * Tijmen Smit, * Thanks of a great plugin. I like the idea of a bulk upload but at a decent cost. Others that I saw were like 250 dollars, and as a small company we cannot afford this. I have a fresh version 2 install so the tables that support the old version are not there. When will your update be out? * thanks! Jackie * [darthsaschi](https://wordpress.org/support/users/darthsaschi/) * (@darthsaschi) * [10 years, 7 months ago](https://wordpress.org/support/topic/import-into-v2/#post-6521933) * **Hi all.** * I have a problem with the import as described above. I just tried this for a multisite ID2 – so the import does not work. I can only import to ID1. Is there a way to get the locs to multisite ID>1? * Thank you all and kind regards. * **Sascha** * Edit: I tried a standard WP export / import and basically it works, but a lot of locs are skipped this way because they share the same name. Any help would be appreciated. Viewing 15 replies - 1 through 15 (of 36 total) 1 [2](https://wordpress.org/support/topic/import-into-v2/page/2/?output_format=md) [3](https://wordpress.org/support/topic/import-into-v2/page/3/?output_format=md) [→](https://wordpress.org/support/topic/import-into-v2/page/2/?output_format=md) The topic ‘Import into v2?’ is closed to new replies. * ![](https://ps.w.org/wp-store-locator/assets/icon-256x256.jpg?rev=1007784) * [WP Store Locator](https://wordpress.org/plugins/wp-store-locator/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-store-locator/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-store-locator/) * [Active Topics](https://wordpress.org/support/plugin/wp-store-locator/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-store-locator/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-store-locator/reviews/) * 36 replies * 13 participants * Last reply from: [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/) * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/import-into-v2/page/3/#post-6521993) * Status: resolved