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' comparison.
Email supports the '=, and IN' comparison.
DateCreated supports the '=,<,>,<=,>=' comparison.
DateModified supports the '=,<,>,<=,>=' comparison.
CustomerGroup supports the '=, and IN' comparison.
StoreCreditAmounts supports the '=' comparison.
RegistrationIpAddress supports the '=, and IN' comparison.

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 new Coupon, you need to specify at least the following columns: FirstName,LastName,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	String	False		Amount of Store Credit
RegistrationIpAddress	String	False		The IP address from which this customer was registered.
AcceptsProductReviewAbandonedCartEmails	Boolean	False		Whether the customer is signed up to receive product review emails, abandoned cart emails, or both. True if the customer is signed up for any of these.
ForcePasswordReset	Boolean	True		If true, this customer will be forced to change their password on their next login.
ChannelIds	String	False		Array of channel ids the Customer has access to.