Tables
The driver models the data in BigCommerce as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC Driver for BigCommerce Tables
| Name | Description |
| Brands | Gets the collection of brands. |
| Categories | Returns Product Categories. |
| ChannelListings | Returns a list of all Channel Listings for a specific channel |
| Channels | GET,CREATE,UPDATE Channels |
| Coupons | Create,list,update or delete coupons. |
| Currencies | Returns data from Currencies table. |
| CustomerAddresses | Returns a list of Customer Addresses. Returns the addresses belonging to a customer. |
| Customers | Returns data from Customers table. |
| OrderItems | Returns Items ordered for every order. |
| Orders | Returns data from Orders table. |
| OrderShipments | Returns shipments and their corresponding orders. |
| PriceListRecords | Returns a collection of price List records |
| PriceLists | Returns a collection of price records |
| ProductImages | Returns images registered for products. |
| ProductOptions | Returns data from Products table. |
| ProductOptionValues | Returns data from Products table. |
| ProductReviews | Returns reviews registered for products. |
| Products | Returns data from products table. |
| ProductVariants | Returns data from Products table. |
| ShippingMethods | Lists all shipping methods. |
| ShippingZones | Lists all shipping zones. |