In Zapiet - Pickup + Delivery, you can import locations using a CSV file. We recommend using this if you have to create or update a lot of locations.
If you have existing locations, we recommend exporting a copy of your locations first.
Requirements
You need to be on the Pro plan or higher with Zapiet - Pickup + Delivery.
Export locations
If you have existing locations, we recommend exporting them first. This will give you a backup copy of your locations, or you can edit your locations and see all of the available fields.
Within Zapiet - Pickup + Delivery, click Locations.
Tick the locations you wish to export.
If you want to select all locations, tick the square above the location names.
Click Export locations.
This will start a download in your browser for a CSV file with your location information.
You may wish to export your locations twice, or duplicate the file, so you have a backup copy of your locations and a version that you can edit.
CSV format
The first line of the CSV should have field names, separated by a comma. Every next line should have information about your location in the same order. You can use our CSV file template as a reference.
You need to fill in the required fields to upload the file, and there are optional fields as well. You can use our CSV file template as a reference.
Special characters will cause a parsing error when trying to import locations. Avoid using special characters, or add them back in after importing the locations.
Required fields
Field | Example |
company_name | Zapiet Florist |
address_line_1 | 10 Buckingham Palace |
city | London |
postal_code | SW1A 1AA |
country | United Kingdom |
latitude | 51.501009 |
longitude | 0.141588 |
timezone | Europe/London |
Optional fields
You can export your locations to get a full list of all optional fields, and explore the example values and notes about each field below.
Any fields you exclude from the CSV will automatically be disabled or set to default.
General location settings
Field | Values | Notes |
id |
| This the location ID in Zapiet - Pickup + Delivery. Leave blank for new locations, or fill in this field with an existing location ID to update that location. |
address_line_2 |
|
|
region |
| Only fill in if your country has this field. |
region_code |
| Only fill in if your country has this field. |
external_id |
| If you have imported a location from Shopify, the external ID will be the same as the Shopify location ID. You do not need to fill in this field. |
shopify_location_id |
| When using Shopify inventory integration, this value will be the Shopify location ID. This requires the Pro plan. |
custom_attribute_1 |
|
|
custom_attribute_2 |
|
|
custom_attribute_3 |
|
|
override_latlng | 0,1 | 0 = Override latitude and longitude is disabled 1 = Override latitude and longitude is enabled |
Pickup settings
Field | Values | Notes |
pickup_enabled | 0, 1 | 1 = pickup is enabled 0 = pickup is disabled |
pickup_inventory_type | all_products, specific_products, specific_collections | If setting to specific products/collections, you will need to edit which are available within the app. Read more in our Pickup product availability guide. |
pickup_notification_email |
| Emails that should receive this location’s internal pickup notifications. Read more in our Pickup notifications guide. |
pickup_tags |
| Automated location-specific pickup order tags. Read more in our Pickup tags guide. |
sort_order |
| You can export the sort order, but you cannot change the values. |
Pickup date and time slot settings
This example uses Monday, but the format is the same for all days. All time values must be in 24-hour format.
To learn more about configuring your pickup availability, take a look at our Configuring pickup days guide and our Configuring pickup slots guide.
Field | Values | Notes |
pickup_date_picker_enabled | 0, 1 | 1 = enabled 0 = disabled |
pickup_time_picker_enabled | 0, 1 | 1 = enabled 0 = disabled |
pickup_availability | all_week, specific_week, specific_year | Every day of the week Specific days of the week Specific dates of the year |
monday_location_closed | 0, 1 | Only fill in if pickup availability is Specific days of the week. 0 = Store pickup is available on Monday 1 = Store pickup is not available on Monday |
pickup_all_days_same_time | 0, 1 | 0 = Different pickup times each day of the week 1 = Same pickup time slots every day of the week |
pickup_time_slots | 15,20,30,60 | Pickup time slot frequency |
monday_opening_time |
| Store opening time |
monday_closing_time |
| Store closing time |
Pickup order limits
To use this feature you need to be on the Advanced plan or above. For more information, take a look at our Pickup order limits guide.
Field | Value | Notes |
pickup_slot_limits_enabled | time, daily | time = Limit number of pickup orders per time slot is enabled |
pickup_time_slot_limit |
| If Limit number of pickup orders per time slot is enabled, add value of orders per time slot here. |
pickup_slot_limit_monday |
| If Limit number of pickup orders per day is enabled, add value of orders per day here. |
Pickup future orders
For more information, take a look at our Restrict future orders for pickup guide.
Field | Value | Notes |
pickup_max_date_enabled | 0, 1 | 0 = Restrict future orders is disabled 1 = Restrict future orders is enabled |
pickup_max_date_value |
| Restrict future orders value |
pickup_max_date_metric | days, weeks, months | Restrict future orders metric. |
Pickup preparation time
This example uses Monday, but the format is the same for all days. All time values must be in 24-hour format.
For more information and examples, take a look at our Pickup preparation time guide.
If you are using preparation time in minutes, the preparation time can only have one of these values: 5,10,15,20,30,60,90.
Field | Values | Notes |
pickup_advance_notice_enabled | 0,1 | 0 = pickup preparation time disabled 1 = pickup preparation time enabled |
monday_pickup_before_offset |
| Preparation time before the cut-off time |
monday_pickup_before_offset_format | minutes, hours, days | Preparation time before cut-off time format |
monday_pickup_use_breakpoint |
| 0 = cut-off time is disabled 1 = cut-off time is enabled |
monday_pickup_breakpoint |
| Cut-off time for Monday |
monday_pickup_after_offset |
| Preparation time after the cut-off time |
monday_pickup_after_offset_format | minutes, hours, days | Preparation time after cut-off time format |
override_pickup_preparation_time | 0, 1 | If using Product-specific preparation time: 0 = Override longer general preparation time is disabled 1 = Override longer general preparation time is enabled |
Delivery settings
Field | Values | Notes |
delivery_enabled | 0, 1 | 1 = delivery is enabled 0 = delivery is disabled |
delivery_inventory_type | all_products, specific_products, specific_collections | If setting to specific products/collections, you will need to edit which are available within the app. Read more in our Delivery product availability guide. |
delivery_notification_email |
| Emails that should receive this location’s internal delivery notifications. Read more in our Delivery notifications guide. |
delivery_tags |
| Automated location-specific delivery order tags. Read more in our Delivery tags guide. |
Delivery availability and time slots
To learn more about configuring your delivery availability, take a look at our Delivery availability guide and our Delivery time slots guide.
You cannot import or export delivery time slots.
Field | Values | Notes |
delivery_availability | all_week, specific_week, specific_year | Every day of the week Specific days of the week Specific dates of the year |
delivery_all_days_same_time | 0, 1 | 0 = different delivery time slots every day 1 = same delivery time slots every day |
Delivery order limits
To use this feature you need to be on the Advanced plan or above. For more information, take a look at our Delivery order limits guide.
Field | Values | Notes |
delivery_slot_limits_enabled | time, daily | time = Limit number of delivery orders per time slot is enabled. Only available if the time picker is enabled
daily = Limit number of delivery orders per day is enabled. Only available if the time picker is disabled |
delivery_slot_limit_monday |
| If Limit number of delivery orders per day is enabled, add value here. |
Restrict future orders
For more information, take a look at our Restrict future orders for delivery guide.
Field | Values | Notes |
delivery_max_date_enabled | 0, 1 | 0 = Restrict future orders is disabled 1 = Restrict future orders is enabled |
delivery_max_date_value |
| Restrict future orders value |
delivery_max_date_metric | days, weeks, months | Restrict future orders metric |
Delivery preparation time
This example uses Monday, but the format is the same for all days. All time values must be in 24-hour format.
For more information and examples, take a look at our Local delivery preparation time guide.
If you are using preparation time in minutes, the preparation time can only have one of these values: 5,10,15,20,30,60,90.
Field | Values | Notes |
delivery_advance_notice_enabled | 0,1 | 0 = delivery preparation time is disabled 1 = delivery preparation time is enabled |
monday_delivery_before_offset |
| Preparation time before the cut-off time |
monday_delivery_before_offset_format | minutes, hours, days | Preparation time before cut-off time format |
monday_delivery_use_breakpoint |
| 0 = cut-off time is disabled 1 = cut-off time is enabled |
monday_delivery_breakpoint |
| Cut-off time for Monday |
monday_delivery_after_offset |
| Preparation time after the cut-off time |
monday_delivery_after_offset_format | minutes, hours, days | Preparation time after cut-off time format |
override_delivery_preparation_time | 0, 1 | If using Product-specific preparation time. 0 = Override longer general preparation time is disabled 1 = Override longer general preparation time is enabled |
Delivery validation
To change your delivery validation method, or learn more about the different options, take a look at our Delivery validation guide.
Field | Values | Notes |
delivery_max_distance |
| For delivery validation by maximum radius/maximum driving radius |
delivery_max_distance_format | kilometers, miles | This needs to match your setting in Settings > Standards and formats. |
valid_delivery_postal_codes |
| For delivery validation by exact/partial postcode matching |
Import locations
To create new locations, leave the "id" field blank. To update a location, fill in the "id" field with an existing location ID.
Within Zapiet - Pickup + Delivery, click Locations.
Click Import locations.
Upload your CSV.
If needed, match the fields from your file to the respective field in Zapiet - Pickup + Delivery.
Click Import locations.
Your file has now been uploaded. Depending on the number of locations you are importing or updating, it may take up to 15 minutes—you will receive an email when the import is complete.
Notes
If you want to update your store locations, we recommend exporting the locations first so you can easily edit the fields. You can then upload the updated file.
The examples use Monday, but the format is the same for all days—you can replace "monday" with any other day of the week.
All time values must be in 24-hour format.
You cannot import all location settings. These settings will need to be manually configured after importing the CSV location file:
Blackout dates
Product date restrictions
Product specific preparation times
If using product availability > specific products or specific collections, you cannot add the products or the collections via CSV import
Delivery time slots
If you're using either Product Availability > Specific Products or Specific Collections, you can import the settings but you'll need to manually add the products or collection to each location.
You can only import CSV files. Anything else will trigger the error message "The file you are uploading must be a CSV."
For example, if you are using Excel, do not save the file as a .xlsx file, save it as a .csv file instead.
You can easily verify the file type by going to http://mime.ritey.com/ and uploading your CSV. The response mime.ritey.com returns must be either
text/csv
,text/plain
orapplication/vnd.ms-excel
.