How to bulk edit customer details for timezones

Question

Hi!I feel like we used to have all our customers with their individual timezones but maybe reimporting data in the past it got lost (?).Is there a way to reupload all their timezones based on country via an import? How would I go around that? Just send an ‘in recipients local time’ and it sent to Aus and US customers simultaneously.Thanks a lot!

DavidV · Accepted Answer

Hi@michaeljja,Thank you for your question!Depending on the ecommerce integration Klaviyo normally updates this based on the IP address or once an order has been placed, on the billing address.You can however manually import (CSV) the location data (City, State/Region, Country & ZIP code) and this will switch the timezone automatically. If you go down this route I would first export the list into CSVand select those fields, then re-import the data after you changed it in Excel/Google Sheets.This is especially helpful if the data is incorrect which we sometimes see happen when we migrate from another platform without the eCommerce integration being live first.More information about this can be found on the help centre here.Hope that helps!ThanksDavid

michaeljja · Answer

Thanks David!Don’t have some of that customer info because a lot came through just via Shopify to Klaviyo and don’t have the country map, so I just exported and reimported what info I do have.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials