Endpoint Update a Customer

Name

put_customer

Description

Updates an existing customer. [API reference]

Related Tables

Customers

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Shopify Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the Customers table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update a customer:

API Destination - Shopify

Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.

Shopify

Customers

Update

There are no parameters to configure.

ODBC application

Use these SQL queries in your ODBC application data source:

Update an existing customer record

UPDATE Customers SET
  Email = 'john.doe2@gmail.com',
  Phone = '7705553445',
  Note= 'This is a new note that needed to be added later.'
  WHERE Id=1111111111111

Update a customer using raw JSON body

<p>Updates a customer by supplying the entire JSON body in the special <code>_rawdoc_</code> column. This allows updating attributes not exposed as standard columns.</p>

UPDATE Customers
SET _rawdoc_='{"customer":{"first_name":"John_new","last_name":"Doe_new","email":"a_new.doe@gmail.com","phone":"7705553111"}}'
WHERE Id=1111111111111

Bulk update customers using SQL Server data

<p>Bulk updates customers by reading data from an external SQL Server database. The source query must return the <code>Id</code> of the customer to update along with the fields to change (e.g. <code>Email</code>, <code>Note</code>).</p>

UPDATE Customers
SOURCE('MSSQL'
 ,'Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true'
 ,'select 111 as Id, ''a@a.com''Email , ''SOLD'' as Note,0 as [$$ContineOn404Error]
  UNION
  select 222 as Id, ''b@b.com''Email , ''SOLD'' as Note,0 as [$$ContineOn404Error]
  '
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Update an existing customer record

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Customers SET
  Email = ''john.doe2@gmail.com'',
  Phone = ''7705553445'',
  Note= ''This is a new note that needed to be added later.''
  WHERE Id=1111111111111';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Update a customer using raw JSON body

<p>Updates a customer by supplying the entire JSON body in the special <code>_rawdoc_</code> column. This allows updating attributes not exposed as standard columns.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Customers
SET _rawdoc_=''{"customer":{"first_name":"John_new","last_name":"Doe_new","email":"a_new.doe@gmail.com","phone":"7705553111"}}''
WHERE Id=1111111111111';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Bulk update customers using SQL Server data

<p>Bulk updates customers by reading data from an external SQL Server database. The source query must return the <code>Id</code> of the customer to update along with the fields to change (e.g. <code>Email</code>, <code>Note</code>).</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Customers
SOURCE(''MSSQL''
 ,''Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true''
 ,''select 111 as Id, ''''a@a.com''''Email , ''''SOLD'''' as Note,0 as [$$ContineOn404Error]
  UNION
  select 222 as Id, ''''b@b.com''''Email , ''''SOLD'''' as Note,0 as [$$ContineOn404Error]
  ''
)';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];