Update a customer
Updates an existing customer record in the Customers table. This example shows how to modify multiple fields, including contact and shipping information, for a specific customer identified by their Id.
UPDATE Customers
SET Name='Cust1-Updated'
, Email='a-updated@b.com'
, Phone='+1 800-123-2345'
, Description='Desc-updated'
, AddressLine1='Line-1-upd'
, AddressLine2='Line-2-upd'
, AddressCity='SomeCity'
, AddressState='NY'
, AddressCountry='USA'
, AddressPostalCode='112233'
, ShippingPhone='+1 800-123-2345'
, ShippingName='SHName-upd'
, ShippingAddressLine1='Line-1-upd'
, ShippingAddressLine2='Line-2-upd'
, ShippingAddressCity='SomeCity'
, ShippingAddressState='NY'
, ShippingAddressCountry='USA'
, ShippingAddressPostalCode='112233'
, Balance=100
WHERE Id='cus_IcUG2lD69ZHuol'