Customers

Returns data from Customers table.

Table Specific Information

Select

The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

Id supports the = and IN comparisons.
Company supports the = and IN comparisons.
Email supports the = and IN comparisons.
DateCreated supports the =, <, >, <=, and >= comparisons.
DateModified supports the =, <, >, <=, and >= comparisons.
CustomerGroup supports the = and IN comparisons.
StoreCreditAmounts supports the = comparison.
RegistrationIpAddress supports the = and IN comparisons.

The rest of the filter is executed client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM Customers WHERE Id = 1 

SELECT * FROM Customers WHERE Company = 'DemoFirst'

SELECT * FROM Customers WHERE Email = '[email protected]'

SELECT * FROM Customers WHERE DateCreated > '2021-09-01 11:25:37.0' 

SELECT * FROM Customers WHERE DateModified <= '2023-10-12 02:05:43.0'

Insert

To insert a customer, specify at least the following columns: FirstName, LastName, and Email.

INSERT INTO Customers (FirstName, LastName, Email) VALUES ('Testing4321', 'Test', '[email protected]')

Update

UPDATE Customers SET FirstName = 'testing345' WHERE Id = 5075

Delete

DELETE FROM Customers WHERE Id = 16

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Unique numeric ID of this customer.
Company	String	False		The name of the company for which the customer works.
FirstName	String	False		First name of the customer.
LastName	String	False		Last name of the customer.
Email	String	False		Email address of the customer.
Phone	String	False		Phone number of the customer.
DateCreated	Datetime	True		Date on which the customer registered from the storefront or was created in the control panel.
DateModified	Datetime	True		The date on which the customer was modified.
CustomerGroup	Integer	False		The group to which the customer belongs.
Notes	String	False		Store Owner notes on the customer.
TaxExemptCategory	String	False		Used to identify customers who fall into special sales-tax categories.
StoreCreditAmounts	Decimal	False		Amount of Store Credit
RegistrationIpAddress	String	False		The IP address from which this customer was registered.
AcceptsProductReviewAbandonedCartEmails	Boolean	False		Determines if the customer is signed up to receive either product review or abandoned cart emails or receive both emails.
ForcePasswordReset	Boolean	True		If true,this customer will be forced to change password on next login.
ChannelIds	String	False		Array of channel ids the Customer has access to.
FullName	String	False		Full name of the customer, combination of the first and last names