Excel Add-In for BigCommerce

Build 23.0.8839


Returns data from Customers table.

Table Specific Information


The 本製品 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 本製品.

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 = 'new@gmail.com'

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

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


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','testing123@gmail.com')


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


DELETE FROM Customers WHERE Id = 16


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839