Customers
Last updated
Last updated
Customers is an auto generated table
The Customers table supports server-side processing for all columns in the WHERE clause. Most of these columns support server-side processing for the >, >=, <, <=, =, IN, NOT IN and LIKE operators.
The following examples show the types of queries processed server side.
Retrieve all customers from your Magento server.\
Retrieve a single customer:\
Filter by status:\
Filter by created date:\
Example query with multiple filters:\
You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to any other columns will cause an error.
To add a Customer, the FirstName, LastName, and Email fields are required.\
Magento allows updates for the FirstName, LastName, MiddleName, Suffix, Email, GroupId, Prefix, DisableAutoGroupChange, and Taxvat columns. WebsiteId is a required value.\
Customers can be deleted by providing the Id of the Customer and issuing a DELETE statement.\
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.