Import & Export
Bulk import stores from spreadsheets or export your data for backup and analysis.
Exporting Stores
Export your store data for backup, editing in a spreadsheet, or migrating to another system.
Export Formats
| Format | Best For |
|---|---|
| CSV | Editing in Excel, Google Sheets, or re-importing |
| JSON | Complete backup with all fields and relationships |
How to Export
- Go to Import/Export in the admin dashboard
- Click Download CSV or Download JSON
- The file downloads automatically
Importing Stores
Import stores from a CSV file to add new locations or update existing ones.
Getting Started
- Download the CSV template from the Import/Export page
- Fill in your store data in the spreadsheet
- Save as CSV format
- Upload the file
Required Columns
| Column | Description |
|---|---|
name | Store name (used to identify existing stores) |
address | Street address |
city | City name |
state | State or province |
zip_code | Postal code |
Optional Columns
| Column | Description |
|---|---|
country | Country (defaults to USA) |
phone | Store phone number |
email | Store email address |
website | Store website URL |
hours | Operating hours |
description | Store description |
image_url | Store image URL |
amenities | Comma-separated amenities |
tags | Comma-separated tag names |
is_active | true/false (defaults to true) |
is_featured | true/false (defaults to false) |
Import Behavior
New vs Existing Stores
The import process automatically detects whether each row is a new store or an update:
- New stores: Created with all provided data, coordinates are geocoded
- Existing stores: Matched by name + address, then updated with new data
Tags
Include tag names in the tags column, separated by commas:
"Flagship,Open 24 Hours,Wheelchair Access"Tags that don't exist will be created automatically with default colors.
Custom Fields
Include custom field values using the field name prefixed with cf_:
cf_Facebook,cf_Instagram,cf_FaxProducts
You can assign products to stores during import using either:
product_ids- Comma-separated Shopify product IDsproduct_titles- Comma-separated product titles (matched by name)
Import Preview
Before the import runs, you'll see a preview showing:
- Number of new stores to be created
- Number of existing stores to be updated
- Any validation errors or warnings
Review the preview carefully before clicking Start Import.
Import Results
After the import completes, you'll see a detailed breakdown:
| Result | Description |
|---|---|
| Imported | New stores successfully created and activated |
| Updated | Existing stores that were updated with new data |
| Inactive | Stores imported but set as inactive due to plan limits |
| Failed | Rows that couldn't be processed due to errors |
Plan Limits & Inactive Stores
Each pricing plan has a maximum number of active stores:
- Starter: 150 active stores
- Growth: 750 active stores
- Pro: 2,500 active stores
How It Works
When importing stores that exceed your plan limit:
- All valid stores are imported into your database
- Stores are activated in order until the plan limit is reached
- Remaining stores are saved as Inactive
- The import results show how many stores are inactive
Activating Inactive Stores
To activate inactive stores, you can:
- Upgrade your plan: Inactive stores are automatically activated when you upgrade to a plan with higher limits
- Deactivate other stores: Manually deactivate stores you no longer need, then activate the ones you want
- Edit individual stores: Open a store and toggle its Active status
Troubleshooting
Common Issues
- Missing required fields: Ensure name, address, city, state, and zip_code are filled
- Invalid email format: Check email addresses are properly formatted
- Invalid URL: Ensure website URLs include http:// or https://
- Geocoding failed: Address couldn't be found - check for typos