BigCommerce Data Dictionary

Panoply uses the BigCommerce API to collect your data into the data warehouse. The following endpoints of the API are available to be collected.

Catalog

Brands

Returns a list of *Brands *within the catalog.

BigCommerce Brands Data Dictionary

Brand Metafields

Returns a list of Brand Metafields.

BigCommerce Brand Metafields Data Dictionary

Category

Returns a list of Categories within the catalog.

BigCommerce Categories Data Dictionary.

Category Metafields

Returns a list of Metafields on a Category. 

BigCommerce Category Metafields Data Dictionary

Products

Returns a list of Products within the catalog.

BigCommerce Products Data Dictionary

Bulk Pricing Rules

Returns a list of Bulk Pricing Rules.

BigCommerce Bulk Pricing Rules Data Dictionary

Complex Rules

Returns a list of all product Complex Rules.

BigCommerce Complex Rules Data Dictionary

Custom Fields

Returns a list of product Custom Fields. 

BigCommerce Custom Fields Data Dictionary

Product Metafields

Returns a list of Product Metafields. 

BigCommerce Product Metafields Data Dictionary

Product Modifiers

Returns a list of all Product Modifiers.

BigCommerce Product Modifiers Data Dictionary

Product Reviews

Returns a list of all Product Reviews.

BigCommerce Product Reviews Data Dictionary

Product Variants Metafields

Returns a list of product Variants. 

BigCommerce Product Variants Metafields Data Dictionary

Product Videos

Returns a list of Product Videos. 

BigCommerce Product Videos Data Dictionary

Summary

Returns a lightweight inventory summary from the BigCommerce Catalog.

The inventory summary includes:

• “inventory_count”
• “variant_count”
• “inventory_value”
• “highest_variant_price”
• “average_variant_price”
• “lowest_variant_price”
• “oldest_variant_date”
• “newest_variant_date”
• “primary_category_id”
• “primary_category_name”

BigCommerce Summary Data Dictionary

Channels

Channels

Will always return the default BigCommerce storefront with an ID of 1. This storefront is created by default when you provision a BigCommerce store.

BigCommerce Channels Data Dictionary

Channel Currency Assignments

Returns a list of currency assignments for all channels.

BigCommerce Channel Currency Assignments Data Dictionary

Channel Listings

Returns a list of all Channel Listings for a specific channel.
BigCommerce Channel Listings Data Dictionary

Channel Site

Returns site data for given channel.

BigCommerce Channel Site Data Dictionary

Currencies

Currencies

Returns a list of all store Currency.

BigCommerce Currencies Data Dictionary

Customers

Customers

Returns a list of all Customers. 

BigCommerce Customers Data Dictionary

Customer Addresses

Returns a list of Customer Addresses. Returns the addresses belonging to a customer. 

BigCommerce Customer Addresses Data Dictionary

Customer Attributes

Returns a list of Customer Attributes. 

BigCommerce Customer Attributes Data Dictionary

Customer Attribute Values

Returns a list of Customer Attribute Values. 

BigCommerce Customer Attribute Values Data Dictionary

Customer Form Field Values

Returns a list of Form Field Values for the Customer or Customer Address object.

BigCommerce Customer Form Field Values Data Dictionary

Geography

Countries

Get a list of all countries available. A country or territory, identifiable by an ISO 3166 country code.

BigCommerce Countries Data Dictionary

States

Returns a list of States belonging to a Country.

A state or province, identifiable by an ISO 3166 subdivision code.

BigCommerce States Data Dictionary

Marketing

Banners

Returns a list of Banners. Default sorting is by banner id.

BigCommerce Banners Data Dictionary

Coupons

Returns a list of Coupons. 

BigCommerce Coupons Data Dictionary

Gift Certificates

Returns a single Gift Certificate.

BigCommerce Gift Certificates Data Dictionary

Orders

Orders

Gets a list of orders using the filter query.  

BigCommerce Orders Data Dictionary

Order Coupons

Lists all order coupons. 

BigCommerce Order Coupons Data Dictionary

Order Products

Lists all order products on an order using order_id. 

BigCommerce Order Products Data Dictionary

Order Taxes

Gets all order taxes using  order_id. Each tax applied to an order. 

BigCommerce Order Taxes Data Dictionary

Order Status

Returns a Collection of All Order Statuses.

BigCommerce Order Status Data Dictionary

Order Shipments

Gets a list of all shipments on an order.

BigCommerce Order Shipments Data Dictionary

Order Shipping Addresses

Get all shipping addresses on an order using the order_id.

BigCommerce Order Shipping Addresses Data Dictionary

Order Messages

Gets the messages associated with an order.

BigCommerce Order Messages Data Dictionary

Order Shipping Addresses Quotes

Gets all shipping quotes associated to an order.

BigCommerce Order Shipping Addresses Quote Data Dictionary

Metafields

Gets a Metafield object list, by order id.

BigCommerce Orders Metafields Data Dictionary

Order Refunds

Returns a list of refunds ordered by refund ID in ascending order.

Requires at least one of the following scopes:

• store_v2_transactions_read_only
• store_v2_transactions
• store_v2_orders_read_only
• store_v2_orders

BigCommerce Order Refunds Data Dictionary

Order Transactions

Returns an order’s transactions.

Usage Notes

• Depending on the payment method, different information will be available (not all payment gateways return full card or fraud detail).
• Transactions are not created for the following payment methods:
  • Test Payment Gateway
  • PayPal Express
  • Amazon Pay

Requires at least one of the following scopes:

• store_v2_transactions_read_only
• store_v2_transactions

BigCommerce Order Transactions Data Dictionary

Payment Methods

Payment Methods

Gets the list of enabled payment methods. 

BigCommerce Payment Methods Data Dictionary

Payment Processing

Accepted Methods

Returns a list of accepted payment methods based on the order_id.

BigCommerce Accepted Methods Data Dictionary

Price Lists

Price Lists

Returns a list of Price Lists. 

BigCommerce Price LIsts Data Dictionary

Price List Assignments

Fetches an array of Price List Assignments matching a particular Customer Group and Price List and Channel.

BigCommerce Price List Assignments Data Dictionary

Price List Records

Returns a list of Price List Records associated with a Price List.

BigCommerce Price List Records Data Dictionary

Shipping

Shipping Methods

Returns a list of Shipping Methods in a zone. 

BigCommerce Shipping Methods Data Dictionary

Shipping Zones

Returns a list of all Shipping Zones.

BigCommerce Shipping Zones Data Dictionary

Shipping Products Customs

Get customs information for products.

BigCommerce Shipping Products Customs Data Dictionary

Sites

Sites

Get sites linked to a headless storefront sales channels.

BigCommerce Sites Data Dictionary

Sites Routes

Get a site’s routes.

BigCommerce Sites Routes Data Dictionary

Store Content

Blog Posts

Returns all Blog Posts. Default sorting is by published_date, beginning with the most recent post.

BigCommerce Blog Posts Data Dictionary

Blog Tags

Returns a list of Blog Tags.

BigCommerce Blog Tags Data Dictionary

Store Information

Store Information

Returns metadata about a store.

BigCommerce Store Information Data Dictionary

Subscribers

Subscribers

Returns a list of Subscribers.

BigCommerce Subscribers Data Dictionary

Tax Classes

Taxes

Returns a list of all Tax Classes in a store.

BigCommerce Taxes Data Dictionary

Widgets

Widget

Returns a list of Widgets. 

BigCommerce Widget Data Dictionary

Placement

Returns a list of Placements. 

BigCommerce Placement Data Dictionary

Wishlists

Wishlists

Returns a list of wishlists. 

BigCommerce Wishlists Data Dictionary

Metadata

Panoply adds the following metadata fields to each table collected from BigCommerce.

• __resource: The selected resource
• __store: The BigCommerce account associated with the record