How do I replace all existing store locations with a new CSV file?
To replace your current store locations with a new CSV file, you need to first remove the existing locations and then proceed to import the new data. Below are detailed, step-by-step instructions to guide you through this process.
Overview
Replacing store locations involves two key steps: Additionally, you can choose to update existing locations instead of replacing them entirely. This involves modifying current records by matching them with IDs in your CSV file.
Deleting all existing store locations from your store locator.
Importing the new store location data via a CSV file.
Both steps need to be followed carefully to ensure a smooth update.
Step 1: Deleting Existing Store Locations
Depending on your preference or the number of locations you are managing, you can choose between the following methods to delete existing data: Consider enabling the "Do not import duplicates" option during the import process to avoid creating duplicate entries.
Method 1: Bulk Deletion
This is the recommended option for deleting multiple locations at once:
Navigate to your store locations list.
Select multiple locations that you want to delete by using your selection tool.
Click on the Delete option to remove the selected locations.
Click Publish to apply these deletions to your storefront.
Method 2: Page-by-Page Deletion
If bulk deletion is not feasible, you can delete locations in smaller batches:
Open your store locations list in the backend.
Select the desired locations on the current page (typically limited to a certain number of items per page).
Delete these selections manually, page by page.
Note: The ability to delete locations multiple at a time may differ depending on the interface. If unsure, consult your system documentation.
Step 2: Importing a New CSV File
Once all old locations are deleted, follow these steps to import your new data:
Go to Store Locations > Import from your dashboard.
Upload your new CSV file containing the updated location data.
Map the columns in your CSV file to the appropriate fields in the store locator. For example, associate columns like "Store Name" and "Address" correctly to the designated fields.
Review your mappings and finalize the import process to update your storefront with the new locations. Additionally, you can use IDs in your CSV file to match existing records for updates. If you wish to replace all locations, ensure your CSV file has blank ID fields and delete all existing locations beforehand to avoid conflicts.
Tips for a Smooth Process
Troubleshooting Tips
Duplicate Entries: Use the "Do not import duplicates" option to prevent duplicate records.
Mapping Errors: Double-check that all columns in your CSV are correctly mapped to the system fields.
Incomplete Deletions: Ensure all locations are deleted before importing a new CSV to avoid conflicts.
Ensure your CSV file is formatted correctly before importing. Refer to your specific CSV template guidelines if available.
Once new locations are imported, verify the storefront display to ensure accuracy.
Related Topics
Best Practices for Store Locator Management
By following these steps, you can seamlessly replace all existing store locations with updated data to ensure your store information remains accurate and up-to-date.