JDBC Driver for BigCommerce

Build 22.0.8462

Customers

Returns data from Customers table.

Columns

Name Type ReadOnly 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 True

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462