Tables

The add-in models the data in BigCommerce as a list of tables in a relational database that can be queried using standard SQL statements.

CData Excel Add-In for BigCommerce Tables


Name	Description
Blogposts	Returns blog posts, including title, body, and publishing details.
Brands	Gets the collection of brands.
CartCustomItems	Returns and manages the custom, non-catalog items in a cart. Custom items cannot be updated after being added; delete and re-add the item instead.
CartGiftCertificates	Returns and manages the gift certificate line items in a cart. Gift certificates cannot be updated after being added; delete and re-add the item instead.
CartMetafields	Returns a list of Cart Metafields.
CartPhysicalItems	Returns and manages the physical catalog items in a cart.
Carts	Creates, retrieves, updates, and deletes a BigCommerce server-side cart.
Categories	Returns Product Categories.
CategoryTrees	Returns a list of category trees.
ChannelListings	Returns a list of all Channel Listings for a specific channel.
ChannelMetafields	Returns a list of Channel Metafields.
Channels	Manages and lists BigCommerce sales channels, supporting SELECT, INSERT, and UPDATE channel records.
CouponCodes	Creates, retrieves, and deletes coupon codes for a promotion.
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.
CustomerAttributes	Returns a list of Customer Attribute.
CustomerGroups	Returns customer groups, including category access and discount rule details.
CustomerMetafields	Returns a list of Customer Metafields.
Customers	Returns customer records, including contact, group, and account details.
CustomerSegments	Returns a list of Customer Segments.
CustomsInformation	Retrieves and manages customs information for products.
InventoryItemLocations	Returns and updates the inventory settings for catalog items at each location.
InventoryLocations	Returns a list of Inventory Locations.
Locales	Retrieves a list of locales for the store.
OrderItems	Returns Items ordered for every order.
Orders	Returns order records, including billing, payment, and shipping details.
OrderShipments	Returns shipments and their corresponding orders.
Pages	Returns pages, including content, metadata, and visibility details.
Pickup	Retrieves and updates in-store order pickups.
PickupMethods	Returns a list of Pickup Methods.
PriceListRecords	Returns a collection of price list records.
PriceLists	Returns a collection of price records.
ProductBasicInformationLocales	Overrides the basic information for the product in a channel locale.
ProductBulkPricingRules	Returns bulk pricing rules applied to a product, including quantity thresholds and discount details.
ProductCustomFieldsLocales	List of product custom fields with locale overrides.
ProductImageLocales	List of product images overrides.
ProductImages	Returns images registered for products.
ProductMetafields	Returns a list of Product Metafields.
ProductModifierOptionsLocales	List of product modifiers with locale overrides.
ProductOptions	Returns data from Products table.
ProductOptionValues	Returns option values for a product option, including label, display order, and value data details.
ProductPreOrderSettingsLocales	Overrides for the product in a channel locale.
ProductReviews	Returns reviews registered for products.
ProductRules	Returns rules that modify the properties of a product, such as weight, price, and product image.
Products	Returns product records, including pricing, inventory, and media details.
ProductSeoInformationLocales	Overrides for the product in a channel locale.
ProductStoreFrontLocales	Overrides for the product in a channel locale.
ProductTaxProperties	Retrieves and manages tax properties associated with products.
ProductUrlLocales	Overrides for the product in a channel locale.
ProductVariants	Returns data from Products table.
Promotions	Creates, retrieves, updates, and deletes promotions.
Redirects	Returns storefront URL redirects, including source path, destination type, and destination URL details.
Scripts	Creates, retrieves, updates, and deletes scripts injected into the storefront.
SharedProductModifierOptionsLocale	List of shared product modifiers with locale overrides.
ShippingMethods	Lists all shipping methods.
ShippingZones	Lists all shipping zones.
SiteRoutes	Creates, retrieves, updates, and deletes routes that link a headless storefront site to pages.
Sites	Creates, retrieves, updates, and deletes sites that link headless storefronts to sales channels.
StoreMetaFields	Returns a list of Store Metafields.
Subscribers	Creates, retrieves, updates, and deletes newsletter subscribers.
TaxClasses	Returns tax classes, including name and date details.
TaxCustomers	Retrieves a list of customer tax data.
TaxProperties	Returns a list of Tax Properties.
TaxRates	Returns a list of Tax Rates.
TaxZones	Returns a list of Tax Zones.
Wishlists	Creates, retrieves, updates, and deletes customer wishlists.