All Collections
Advanced
Managing locations using CSV
Managing locations using CSV

Import, export and update your locations with CSV files

Clemency Farmer avatar
Written by Clemency Farmer
Updated over a week ago

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.

  1. Within Zapiet - Pickup + Delivery, click Locations.

  2. Tick the locations you wish to export.
    If you want to select all locations, tick the square above the location names.

  3. 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.

If your locations contain special characters, ensure any programs you use to edit the CSV file can support those characters.


If you experience any parsing issues when importing files, then remove all special characters from the CSV file and try again.

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
daily = Limit number of pickup orders per day 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.

  1. Within Zapiet - Pickup + Delivery, click Locations.

  2. Click Import locations.

  3. Upload your CSV.

  4. If needed, match the fields from your file to the respective field in Zapiet - Pickup + Delivery.

  5. 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.


Supported CSV import time zone formats

When importing values from a CSV file, you will need to use a certain time zone format. Find your time zone below, and add it to your “timezone” value.

Africa/Abidjan
Africa/Accra
Africa/Addis_Ababa
Africa/Algiers
Africa/Asmara
Africa/Bamako
Africa/Bangui
Africa/Banjul
Africa/Bissau
Africa/Blantyre
Africa/Brazzaville
Africa/Bujumbura
Africa/Cairo
Africa/Casablanca
Africa/Ceuta
Africa/Conakry
Africa/Dakar
Africa/Dar_es_Salaam
Africa/Djibouti
Africa/Douala
Africa/El_Aaiun
Africa/Freetown
Africa/Gaborone
Africa/Harare
Africa/Johannesburg
Africa/Juba
Africa/Kampala
Africa/Khartoum
Africa/Kigali
Africa/Kinshasa
Africa/Lagos
Africa/Libreville
Africa/Lome
Africa/Luanda
Africa/Lubumbashi
Africa/Lusaka
Africa/Malabo
Africa/Maputo
Africa/Maseru
Africa/Mbabane
Africa/Mogadishu
Africa/Monrovia
Africa/Nairobi
Africa/Ndjamena
Africa/Niamey
Africa/Nouakchott
Africa/Ouagadougou
Africa/Porto-Novo
Africa/Sao_Tome
Africa/Tripoli
Africa/Tunis
Africa/Windhoek
America/Adak
America/Anchorage
America/Anguilla
America/Antigua
America/Araguaina
America/Argentina/Buenos_Aires
America/Argentina/Catamarca
America/Argentina/Cordoba
America/Argentina/Jujuy
America/Argentina/La_Rioja
America/Argentina/Mendoza
America/Argentina/Rio_Gallegos
America/Argentina/Salta
America/Argentina/San_Juan
America/Argentina/San_Luis
America/Argentina/Tucuman
America/Argentina/Ushuaia
America/Aruba
America/Asuncion
America/Atikokan
America/Bahia
America/Bahia_Banderas
America/Barbados
America/Belem
America/Belize
America/Blanc-Sablon
America/Boa_Vista
America/Bogota
America/Boise
America/Cambridge_Bay
America/Campo_Grande
America/Cancun
America/Caracas
America/Cayenne
America/Cayman
America/Chicago
America/Chihuahua
America/Costa_Rica
America/Creston
America/Cuiaba
America/Curacao
America/Danmarkshavn
America/Dawson
America/Dawson_Creek
America/Denver
America/Detroit
America/Dominica
America/Edmonton
America/Eirunepe
America/El_Salvador
America/Fort_Nelson
America/Fortaleza
America/Glace_Bay
America/Godthab
America/Goose_Bay
America/Grand_Turk
America/Grenada
America/Guadeloupe
America/Guatemala
America/Guayaquil
America/Guyana
America/Halifax
America/Havana
America/Hermosillo
America/Indiana/Indianapolis
America/Indiana/Knox
America/Indiana/Marengo
America/Indiana/Petersburg
America/Indiana/Tell_City
America/Indiana/Vevay
America/Indiana/Vincennes
America/Indiana/Winamac
America/Inuvik
America/Iqaluit
America/Jamaica
America/Juneau
America/Kentucky/Louisville
America/Kentucky/Monticello
America/Kralendijk
America/La_Paz
America/Lima
America/Los_Angeles
America/Lower_Princes
America/Maceio
America/Managua
America/Manaus
America/Marigot
America/Martinique
America/Matamoros
America/Mazatlan
America/Menominee
America/Merida
America/Metlakatla
America/Mexico_City
America/Miquelon
America/Moncton
America/Monterrey
America/Montevideo
America/Montserrat
America/Nassau
America/New_York
America/Nipigon
America/Nome
America/Noronha
America/North_Dakota/Beulah
America/North_Dakota/Center
America/North_Dakota/New_Salem
America/Ojinaga
America/Panama
America/Pangnirtung
America/Paramaribo
America/Phoenix
America/Port-au-Prince
America/Port_of_Spain
America/Porto_Velho
America/Puerto_Rico
America/Punta_Arenas
America/Rainy_River
America/Rankin_Inlet
America/Recife
America/Regina
America/Resolute
America/Rio_Branco
America/Santarem
America/Santiago
America/Santo_Domingo
America/Sao_Paulo
America/Scoresbysund
America/Sitka
America/St_Barthelemy
America/St_Johns
America/St_Kitts
America/St_Lucia
America/St_Thomas
America/St_Vincent
America/Swift_Current
America/Tegucigalpa
America/Thule
America/Thunder_Bay
America/Tijuana
America/Toronto
America/Tortola
America/Vancouver
America/Whitehorse
America/Winnipeg
America/Yakutat
America/Yellowknife
Antarctica/Casey
Antarctica/Davis
Antarctica/DumontDUrville
Antarctica/Macquarie
Antarctica/Mawson
Antarctica/McMurdo
Antarctica/Palmer
Antarctica/Rothera
Antarctica/Syowa
Antarctica/Troll
Antarctica/Vostok
Arctic/Longyearbyen
Asia/Aden
Asia/Almaty
Asia/Amman
Asia/Anadyr
Asia/Aqtau
Asia/Aqtobe
Asia/Ashgabat
Asia/Atyrau
Asia/Baghdad
Asia/Bahrain
Asia/Baku
Asia/Bangkok
Asia/Barnaul
Asia/Beirut
Asia/Bishkek
Asia/Brunei
Asia/Chita
Asia/Choibalsan
Asia/Colombo
Asia/Damascus
Asia/Dhaka
Asia/Dili
Asia/Dubai
Asia/Dushanbe
Asia/Famagusta
Asia/Gaza
Asia/Hebron
Asia/Ho_Chi_Minh
Asia/Hong_Kong
Asia/Hovd
Asia/Irkutsk
Asia/Jakarta
Asia/Jayapura
Asia/Jerusalem
Asia/Kabul
Asia/Kamchatka
Asia/Karachi
Asia/Kathmandu
Asia/Khandyga
Asia/Kolkata
Asia/Krasnoyarsk
Asia/Kuala_Lumpur
Asia/Kuching
Asia/Kuwait
Asia/Macau
Asia/Magadan
Asia/Makassar
Asia/Manila
Asia/Muscat
Asia/Nicosia
Asia/Novokuznetsk
Asia/Novosibirsk
Asia/Omsk
Asia/Oral
Asia/Phnom_Penh
Asia/Pontianak
Asia/Pyongyang
Asia/Qatar
Asia/Qyzylorda
Asia/Riyadh
Asia/Sakhalin
Asia/Samarkand
Asia/Seoul
Asia/Shanghai
Asia/Singapore
Asia/Srednekolymsk
Asia/Taipei
Asia/Tashkent
Asia/Tbilisi
Asia/Tehran
Asia/Thimphu
Asia/Tokyo
Asia/Tomsk
Asia/Ulaanbaatar
Asia/Urumqi
Asia/Ust-Nera
Asia/Vientiane
Asia/Vladivostok
Asia/Yakutsk
Asia/Yangon
Asia/Yekaterinburg
Asia/Yerevan
Atlantic/Azores
Atlantic/Bermuda
Atlantic/Canary
Atlantic/Cape_Verde
Atlantic/Faroe
Atlantic/Madeira
Atlantic/Reykjavik
Atlantic/South_Georgia
Atlantic/St_Helena
Atlantic/Stanley
Australia/Adelaide
Australia/Brisbane
Australia/Broken_Hill
Australia/Currie
Australia/Darwin
Australia/Eucla
Australia/Hobart
Australia/Lindeman
Australia/Lord_Howe
Australia/Melbourne
Australia/Perth
Australia/Sydney
Europe/Amsterdam
Europe/Andorra
Europe/Astrakhan
Europe/Athens
Europe/Belgrade
Europe/Berlin
Europe/Bratislava
Europe/Brussels
Europe/Bucharest
Europe/Budapest
Europe/Busingen
Europe/Chisinau
Europe/Copenhagen
Europe/Dublin
Europe/Gibraltar
Europe/Guernsey
Europe/Helsinki
Europe/Isle_of_Man
Europe/Istanbul
Europe/Jersey
Europe/Kaliningrad
Europe/Kiev
Europe/Kirov
Europe/Lisbon
Europe/Ljubljana
Europe/London
Europe/Luxembourg
Europe/Madrid
Europe/Malta
Europe/Mariehamn
Europe/Minsk
Europe/Monaco
Europe/Moscow
Europe/Oslo
Europe/Paris
Europe/Podgorica
Europe/Prague
Europe/Riga
Europe/Rome
Europe/Samara
Europe/San_Marino
Europe/Sarajevo
Europe/Saratov
Europe/Simferopol
Europe/Skopje
Europe/Sofia
Europe/Stockholm
Europe/Tallinn
Europe/Tirane
Europe/Ulyanovsk
Europe/Uzhgorod
Europe/Vaduz
Europe/Vatican
Europe/Vienna
Europe/Vilnius
Europe/Volgograd
Europe/Warsaw
Europe/Zagreb
Europe/Zaporozhye
Europe/Zurich
Indian/Antananarivo
Indian/Chagos
Indian/Christmas
Indian/Cocos
Indian/Comoro
Indian/Kerguelen
Indian/Mahe
Indian/Maldives
Indian/Mauritius
Indian/Mayotte
Indian/Reunion
Pacific/Apia
Pacific/Auckland
Pacific/Bougainville
Pacific/Chatham
Pacific/Chuuk
Pacific/Easter
Pacific/Efate
Pacific/Enderbury
Pacific/Fakaofo
Pacific/Fiji
Pacific/Funafuti
Pacific/Galapagos
Pacific/Gambier
Pacific/Guadalcanal
Pacific/Guam
Pacific/Honolulu
Pacific/Kiritimati
Pacific/Kosrae
Pacific/Kwajalein
Pacific/Majuro
Pacific/Marquesas
Pacific/Midway
Pacific/Nauru
Pacific/Niue
Pacific/Norfolk
Pacific/Noumea
Pacific/Pago_Pago
Pacific/Palau
Pacific/Pitcairn
Pacific/Pohnpei
Pacific/Port_Moresby
Pacific/Rarotonga
Pacific/Saipan
Pacific/Tahiti
Pacific/Tarawa
Pacific/Tongatapu
Pacific/Wake
Pacific/Wallis

UTC


Notes

  • If your locations contain special characters, ensure any programs you use to edit the CSV file can support those characters.
    If you experience any parsing issues when importing files, then remove all special characters from the CSV file and try again.

  • 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 or application/vnd.ms-excel.


Did this answer your question?