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 JDBC Driver for BigCommerce Tables


Name	Description
Brands	Gets the collection of brands.
Categories	Returns Product Categories.
CategoryTrees	Returns a list of category trees.
ChannelListings	Returns a list of all channel listings for a specific channel.
Channels	Manages and lists BigCommerce sales channels, supporting SELECT, INSERT, and UPDATE channel records.
Coupons	test 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 the 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.
ProductMetafields	Returns a list of Product Metafields.
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.