Customer import (CSV)

CSV notes

• All fields are optional, rows without data will still create a new customer, they will not be skipped
• We will return all fields in the response with ID field filled in if it did not exist before, an extra column called errors will also be added
• If any row fails during creation the whole batch will fail

Limits

• Max 10,000 rows per CSV

Fields

• id: Glide customer ID (optional)
• company_name: The name of the Company (optional)
• first_name: The name of the Customer (optional)
• last_name: The last name of the Customer (optional)
• email: Email address (optional)
• phone: Phone Number including the country code. We do not accept phone numbers without a dialing code such as +1, +90. (optional)
• hreflang: The customer will receive notifications for the country and language specified. e.g. en-GB, de-CH, de-DE. (optional)
• external_id: Your ID (optional)
• external_source: An ID/hash/string of your integration, e.g. csv, MyAppImporter (optional)
• billing_address_first_name: (optional)
• billing_address_last_name: (optional)
• billing_address_company_name: (optional)
• billing_address_line_1: (optional)
• billing_address_line_2: (optional)
• billing_address_city: (optional)
• billing_address_state: (optional)
• billing_address_zip: (optional)
• billing_address_country_code: 2 letter, e.g. GB, UA, SG, DE (optional)
• billing_address_phone: (optional)
• billing_address_email: (optional)
• billing_address_address_type: business or residential (optional)
• shipping_address_first_name: (optional)
• shipping_address_last_name: (optional)
• shipping_address_company_name: (optional)
• shipping_address_line_1: (optional)
• shipping_address_line_2: (optional)
• shipping_address_city: (optional)
• shipping_address_state: (optional)
• shipping_address_zip: (optional)
• shipping_address_country_code: 2 letter, e.g. GB, UA, SG, DE (optional)
• shipping_address_phone: (optional)
• shipping_address_email: (optional)
• shipping_address_address_type: business or residential (optional)

Example 1: Add new customers​

Input CSV​

id,company_name,first_name,last_name,email,phone,hreflang,external_id,external_source
,,Joe,Bloggs,joe@example.com,+44121817501,en-gb,,
,e-Handel,Sven,Svensson,sven@svennis.com,+4673181750,se-SV,,

Output CSV​

id,company_name,first_name,last_name,email,phone,hreflang,external_id,external_source,errors
cu-cm0kt7m0j0000ncmezi16x79y,,Joe,Bloggs,joe@example.com,+44121817501,en-gb,,,
cu-cm0kt7m0j0001ncme9u7v5zhc,e-Handel,Sven,Svensson,sven@svennis.com,+4673181750,se-SV,,,

Example 2: Add new customers with addresses​

Input CSV​

id,company_name,first_name,last_name,email,phone,hreflang,external_id,external_source,billing_address_first_name,billing_address_last_name,billing_address_company_name,billing_address_line_1,billing_address_line_2,billing_address_city,billing_address_state,billing_address_zip,billing_address_country_code,billing_address_phone,billing_address_email,billing_address_address_type,shipping_address_first_name,shipping_address_last_name,shipping_address_company_name,shipping_address_line_1,shipping_address_line_2,shipping_address_city,shipping_address_state,shipping_address_zip,shipping_address_country_code,shipping_address_phone,shipping_address_email,shipping_address_address_type,errors
,,Joe,Bloggs,joe@example.com,+44121817501,en-gb,,,,,,,,,,,,,,,,,,,,,,,,,,,
,e-Handel,Sven,Svensson,sven@svennis.com,+4673181750,se-SV,,,Sven,Svensson,Svensson AB,Fornoborgvägen 1,,Ljusdal,Hälsingland,82151,SE,+461231514451,,residential,,,,,,,,,,,,residential,

Output CSV​

id,company_name,first_name,last_name,email,phone,hreflang,external_id,external_source,billing_address_first_name,billing_address_last_name,billing_address_company_name,billing_address_line_1,billing_address_line_2,billing_address_city,billing_address_state,billing_address_zip,billing_address_country_code,billing_address_phone,billing_address_email,billing_address_address_type,shipping_address_first_name,shipping_address_last_name,shipping_address_company_name,shipping_address_line_1,shipping_address_line_2,shipping_address_city,shipping_address_state,shipping_address_zip,shipping_address_country_code,shipping_address_phone,shipping_address_email,shipping_address_address_type,errors
gid://glide/Customer/cu-cm0m5kq7e0004gks1crqip6kr,,Joe,Bloggs,joe@example.com,+44121817501,en-gb,,,,,,,,,,,,,,residential,,,,,,,,,,,,residential,
gid://glide/Customer/cu-cm0m5kq7g0006gks1lsdmmunm,e-Handel,Sven,Svensson,sven@svennis.com,+4673181750,se-SV,,,Sven,Svensson,Svensson AB,Fornoborgvägen 1,,Ljusdal,Hälsingland,82151,SE,+461231514451,,residential,,,,,,,,,,,,residential,