Nearmio
Import any stockist spreadsheet into Nearmio with Shopify Sidekick
October 2026
The spreadsheet of your stockists already exists. It is the export from your wholesale platform, the sheet your sales rep keeps, or the list your distributor sent over. What it is not is a file in the layout a store-locator app wants: the columns have different names, the city and state share a cell, half the rows have no country because everyone knew it was Australia.
That used to mean twenty minutes of renaming headers and splitting columns before you could even see whether the import would work. Now you can hand the file to Shopify Sidekick, the AI assistant built into your Shopify admin, and let it do the mapping.
What Sidekick knows about Nearmio
Nearmio gives Sidekick a read-only tool that describes exactly what the import accepts: the columns, every alternative header name it understands, what a row needs before a pin can be placed, how tags are written, and how many locations your plan has room for. Sidekick reads a file you attach in chat, calls that tool, and compares the two.
Nothing is written back. Sidekick cannot add, change or delete locations in Nearmio, and it asks your permission the first time it wants to use a Nearmio tool in a conversation.
How to do it
- Open Sidekick in your Shopify admin and attach your spreadsheet (CSV works best).
- Ask: "Check this file against what Nearmio needs to import my stores."
- Read the report. Sidekick tells you which of your columns map to which Nearmio column, which it could not place, and which rows are missing something, with row numbers.
- Fix anything it flagged, or ask: "Write the rows out in Nearmio's layout." Sidekick gives you the rows as CSV in the template's column order. Paste them into a file.
- Open Locations ▸ Import from CSV in Nearmio, upload the file, and check the preview. Every row is shown as new, update, duplicate or invalid before anything is committed.
What a mapping looks like
A typical export from a wholesale platform comes back from Sidekick like this:
- Retailer →
name - Ship to address →
address_line1 - Suburb →
city - State →
region(an accepted alias, no rename needed) - Post code →
postcode - Country → missing. Rows 1 to 38 have no country, so none of them can be placed on the map yet. Add a country column, or tell Sidekick the country and ask it to fill it in.
- Order total, Last order date → not used; Nearmio ignores unknown columns, so they can stay.
The gaps are the point. Nearmio's own preview would reject those 38 rows as invalid, but it would do so after you had uploaded the file. Sidekick tells you before, in plain words, and can write the corrected rows for you.
What Sidekick does not do
- It does not import. You upload the file and press Commit import; the preview on that page is the final word.
- It does not place pins. Geocoding happens in Nearmio after you commit, and any pin that lands wrong goes to the fix queue as usual.
- It does not see your shoppers. The tool returns your location list and the import rules, nothing else.
Sidekick can also tell you whether a particular store is on your map, which pins need fixing, and answer questions from Nearmio's help center. The full list is in Asking Shopify Sidekick about your locations.