Skip to main content

Country Code Support & Country Validation for CSV Imports

Improved Country Code support and country validation during CSV imports. This update fixes common issues where imported locations don’t appear on the map

Updated over 2 months ago

RP Promap Knowledgebase: Country Code Support & Country Validation for CSV Imports

Last updated: 2026-01-24
App: RP Promap (Shopify)
Feature: Location Import via CSV
Audience: Merchants / End Users


Overview

RP Promap now includes improved Country Code support and country validation during CSV imports.

This update fixes common issues where imported locations don’t appear on the map due to inconsistent country formats (example: USA vs United States vs US).

With the new update, RP Promap can accept multiple country formats and automatically normalizes them into a standard value during import.


What’s New

✅ 1) Country Alias Support (Automatic Normalization)

RP Promap now accepts different versions of the same country, including:

  • 2-letter codes (ISO2): US, CA, GB

  • 3-letter codes (ISO3): USA, CAN, GBR

  • Full country names: United States, United States of America

All of these will be normalized into the correct standardized country value.

Example:

Imported Value

Normalized Result

US

USA

USA

USA

United States

USA

United States of America

USA


✅ 2) Configuration-Based Country Mapping (250+ Countries)

RP Promap now uses a configuration-based list of supported countries, including 250+ countries with aliases.

This includes countries like:

US, PR, VN, CA, FR, DE, GB, RU, CN, JP, KR, KP
…and many more.

This ensures imports work reliably for merchants importing international store lists.


✅ 3) Improved Import Consistency (No More Hardcoded Country Logic)

Previously, some imports depended on limited hardcoded conversions (example: forcing United States → USA).

Now, imports apply the same country normalization rules consistently across all imported records.


How Country Validation Works During Import

When importing your CSV:

Step 1 — RP Promap reads your country field

RP Promap checks your CSV for a mapped country field such as:

  • country

  • country_code

Step 2 — RP Promap normalizes the country value

If your CSV includes any valid alias (code or name), RP Promap automatically converts it to the correct standardized value.

Step 3 — RP Promap saves standardized country values

This ensures all imported locations match the system’s expected country format.


Why This Matters (Stores Not Showing on the Map)

If a location was imported with a country format the system didn’t recognize, it could cause the store to be saved incorrectly and not render properly on the map.

With normalization enabled, imported stores now have standardized country values that should allow them to display correctly.

Note: This update improves the import data quality. Map display behavior itself was not changed in this release, but correct country values are a required prerequisite for accurate map rendering.


CSV Import Tips (Best Practices)

To avoid import issues:

✅ Use one country format consistently
✅ Recommended: use ISO 2-letter country codes (US, CA, GB)
✅ Make sure every row has a valid country value (especially for global store lists)


Examples of Supported Country Formats

Here are a few examples RP Promap can now accept:

United States

  • US

  • USA

  • United States

  • United States of America

Canada

  • CA

  • CAN

  • Canada

Vietnam

  • VN

  • VNM

  • Vietnam

United Kingdom

  • GB

  • UK (if included as alias)

  • United Kingdom


Related Improvements Included in This Update

This release also includes improvements to support consistent country selection and import behavior across the app:

  • Improved country handling during import (server-side)

  • Updated country selection data in forms

  • Removed incorrect country entries to prevent selection/import mismatches


Troubleshooting

My stores still don’t show after import

Try these checks:

  1. Confirm your CSV country values are valid (codes or names)

  2. Re-import after normalization support is enabled

  3. Check if the address is complete enough to geocode (street + city + country)

  4. Confirm your map is enabled and visible on the storefront

If you still need help, contact support with:

  • Your CSV file (or a sample of 5 rows)

  • The country formats you used

  • The store(s) that are missing on the map


Summary

RP Promap CSV imports now support:

✅ Multiple country formats (codes + full names)
✅ Automatic country normalization
✅ A configuration-based system supporting 250+ countries
✅ Improved import consistency for international location lists

This reduces import failures and improves map display accuracy for global merchants.

Did this answer your question?