RP Knowledgebase: CSV Import Logic & Restrictions (RP Promap for Shopify)
Last updated: 2026-01-05
App: RP Promap (Shopify)
Feature: Store Import (CSV Upload)
Audience: Merchants / End Users
Overview
RP Promap lets you import store locations using a CSV file. During import, RP Promap automatically converts addresses into map coordinates (latitude/longitude) using Google Geocoding.
To keep imports fast and stable, RP Promap uses a 2,000-row threshold that determines how geocoding is processed:
✅ Import Logic (2,000 Row Threshold)
2,000 rows or less → Geocoding runs in your browser (client-side)
More than 2,000 rows → Geocoding runs on our servers (server-side)
Because these two methods work differently, Google API key restrictions can affect them in different ways.
How the Import Works (Simple Explanation)
When you upload a CSV, RP Promap will:
Upload your CSV file
Read and validate the data
Count the number of rows
Convert each store address into map coordinates
Save stores into your RP Promap locations list
CSV File Requirements
Your import file must meet these requirements:
✅ File type: .csv only
✅ Max file size: 10MB
✅ Must contain store data rows (not empty)
✅ Must include required fields like:
Store Name
Store Address
Common Import Errors (and What They Mean)
1) File Upload Errors
Issue | What it means | What to do |
Incorrect format | You uploaded a non-CSV file | Upload a |
File too large | File is over 10MB | Reduce the file size or split it |
Empty file | No store rows found | Add store rows and try again |
Invalid file | CSV formatting is broken | Re-export the CSV (UTF-8 recommended) |
2) Missing Required Fields
Issue | What it means | What to do |
Required fields missing | Missing Store Name or Address mapping | Map the correct CSV columns |
Missing values | Some rows have blank name/address | Fix the missing row data |
Google Maps API Key Requirements
To import stores successfully, RP Promap requires a Google Maps API key.
You must have:
✅ A valid Google API key
✅ Billing enabled in Google Cloud
✅ These APIs enabled:
Maps JavaScript API
Geocoding API
Important: API Key Restrictions (This Is the #1 Cause of Import Issues)
Google allows you to “restrict” API keys for security (recommended), but restrictions must match how RP Promap imports your stores.
If your import is ≤ 2,000 rows
Geocoding runs in the browser, so Google checks Website restrictions (HTTP Referrers).
✔️ Works if your API key allows the RP Promap domain
❌ Fails if your API key blocks our app domain
Error you may see:
“Import stopped: Google Maps key restrictions blocked the process…”
✅ Fix: Add RP Promap domain to your allowed referrers (see below)
If your import is > 2,000 rows
Geocoding runs on our servers, so Google cannot use “website referrers”.
✔️ Works best with an unrestricted key
❌ Often fails if your key has any restriction enabled
Common cause: API key has referrer restriction or IP restriction enabled.
How to Fix “Blocked by Restrictions” Errors
Fix A: Small Imports (≤ 2,000 rows) — Add Allowed Referrers
If your key uses HTTP Referrer restrictions, you must allow the RP Promap domain.
Steps:
Open Google Cloud Console
Go to APIs & Services → Credentials
Click your API Key
Under Application restrictions → HTTP referrers
Add:
https://sl.roseperl.com/*or wildcard:
https://*.roseperl.com/*
Then retry the import.
Fix B: Large Imports (> 2,000 rows) — Use an Unrestricted Key (Recommended)
For imports larger than 2,000 rows, the best approach is:
✅ Create a separate Google API key for RP Promap imports
✅ Leave it unrestricted (or configure properly with advanced settings)
Alternative workaround:
Split your CSV into multiple files of 2,000 rows or less
Other Import Limitations You May See
Plan Limit Reached
If your store count exceeds your current plan limit, the import will stop.
✅ Solution: Upgrade your plan or reduce the number of imported stores.
Import Already Running
If another import is still processing, you may need to wait until it finishes.
✅ Solution: Wait a few minutes and try again.
Operating Hours Format Errors (If You Import Hours)
If your CSV includes operating hours, the import may fail if:
Time format is invalid
End time is earlier than start time
✅ Solution: Correct the time format and retry.
Quick Troubleshooting Checklist
Before importing again, confirm:
✅ Your file is .csv
✅ Under 10MB
✅ Store Name + Store Address are mapped correctly
✅ Your Google API key is added in RP Promap settings
✅ Maps JavaScript API + Geocoding API are enabled
✅ Restrictions match your import size (≤2000 vs >2000)
Need Help?
If your import still fails, send our support team:
Your theme name
Your CSV row count
A screenshot of the error
Whether your Google API key is restricted (referrer/IP)
We’ll help you configure it correctly and get your import working.