Preparing the .csv file for upload
Follow the instructions below to ensure the file is correctly populated and formatted for use.
We also have a template file that you can use as an example.
General Guidelines
- File Format: Save the completed file as a .csv (Comma-Separated Values) file before submission.
- Required Fields: Fields marked with an asterisk (*) are mandatory and must not be left blank.
- Data Accuracy: Ensure all data entries are accurate and consistent with the expected format for each column.
Column Instructions
1. Name*
- Description: The name of the store, organization, or entity.
- Format: Text.
- Example: GreenLeaf Nursery, FitZone Gym.
2. Status
- Description: Indicates whether the store is active.
- Format: Enter True for active or False for inactive.
- Example: true or false.
3. Address*
- Description: The complete address of the store.
- Format: Text enclosed in quotation marks for proper formatting.
- Example: "321 Pine Road, Springfield".
- Note: Ensure accuracy, including city and state or country.
4. Latitude
- Description: The latitude coordinate of the store location.
- Format: Decimal value.
- Example: 42.101483.
- Note: Leave blank if not available but ensure longitude is blank as well.
5. Longitude
- Description: The longitude coordinate of the store location.
- Format: Decimal value.
- Example: -72.589811.
- Note: Leave blank if not available but ensure latitude is blank as well.
6. Phone
- Description: Contact phone number for the store.
- Format: Standard phone format, including area code.
- Example: 555-678-9012, +34-93-654-3210.
7. Email
- Description: The email address for customer or internal communication.
- Format: Valid email format.
- Example: [email protected].
8. Website
- Description: The URL of the store's official website.
- Format: Full URL starting with https://.
- Example: https://www.greenleaf.com.
9. Store Description
- Description: A brief description of the store.
- Format: Text.
- Example: Nursery specializing in indoor plants.
10. Google Place ID
- Description: Google place ID, used for syncing reviews and business hours from Google Maps
- Format: Text
11. Internal Notes
- Description: Notes for internal purposes, not visible to customers.
- Format: Text.
- Example: Launching new plant kits soon.
12. Filters
- Description: Categorization tags for filtering stores.
- Format: Text tags separated by commas, wrapped in quotation marks.
- Example: "Store, Art"
13. Custom Marker Image URL
- Description: The URL to a custom marker image for the store on the map. The URL must be publicly accessible.
- Format: Full URL.
- Example: https://example.com/images/marker.png.
- Note: Leave blank if not applicable.
Final Checklist
- Verify that all required fields (*) are filled out.
- Check for formatting errors or invalid data.
- Save the file as .csv format before submitting.
