UnirgyWiki

User Tools

Site Tools

You are here: start » storelocator » import
Trace:
storelocator:import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
storelocator:import [2012/05/29 16:56]
jamby77 		storelocator:import [2014/06/20 19:11] (current)
jamby77
Line 1: Line 1:
 +===== Importing locations =====
 +Locations data can be imported to magento using csv files. Import is done by uploading a file in [[storelocator:main-config|main configuration]] (13).
  
 +File format has to be similar to example bellow. Most compatible and comfortable way for editing CSV files is using [[http://www.openoffice.org/product/calc.html|OpenOffice Calc]] application.
 +<file csv locations.csv>
 +"title","address","latitude","longitude","address_display","notes","website_url","phone","product_types","udropship_vendor","country","stores","icon","use_label","is_featured","zoom"
 +"1 Clermont Supercenter Store #5299 ","550 Us Highway 27, Clermont, FL 34714","28,3544277","-81,6765845","Clermont 
 +Supercenter Store #5299",,"http://www.walmart.com","(352) 536-2750","wholesale",,"US",1,"/storelocator/locations/icons/toys.png",0,1,10
 +"Clermont Supercenter Store #2695","1450 Johns Lake Rd, Clermont, FL 34711","28,531204","-81,732663","Clermont 
 +Supercenter Store #2695",,"http://www.walmart.com","(352) 243-6151","wholesale,electronics",,"US",1,"/storelocator/locations/icons/uicon.png",0,0,15
 +"12 Lakeland Supercenter Store #1245 ","5800 Us Highway 98 N,Lakeland, FL 33809","28,118823","-81,97638","12 Lakeland 
 +Supercenter Store #1245 ",,"http://www.example.com","(863) 859-3626","wholesale,toys",,,1,"/storelocator/locations/icons/Koala-500w.png",0,1,18
 +</file>
 +
 +===== IMPORTANT =====
 +
 +When importing locations which have 0 for coordinates, an attempt will be made to fill in these coordinates from Google. There is however a limit of about 20 geo location lookups per second from same origin (exact number is not stated).
 +This means that bigger files with empty location coordinates will start to fail to fetch them from Google at some point. Solution is to split imported data on smaller files and import intervals.
 +We work on solution about this, but it will involve some delay between requests, and this will too delay import process, but at least it will be in one go.
 +
 +===== Exporting =====
 +
 +To export locations go to '' System > Configuration > Store Locations '', open General settings if they are not open and click "Export Locations" button.
 +
 +{{:storelocator:main-config:sl_settings_export.gif |}}
storelocator/import.1338310580.txt.bz2 · by jamby77

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki