Use Distil.ai's BigCommerce integration to pull in Customer, Product and Purchase history datasets. Customise your customer data integration with Distil.ai.

BigCommerce Integration

Create differentiated commerce experiences on the industry’s most versatile enterprise solution. Meet the platform leading a new era of e-commerce for enterprise brands. A highly-extensible SaaS solution that takes the onus of security and scalability to fast-track your growth

The BigCommerce integration brings in Customer, Product and Purchase history datasets. The standard set of attributes that are brought for this integration are shown in the table below. If you have made any customisations to your BigCommerce setup then bringing these in can be discussed during Supported Onboarding.

Customer Attributes

Distil.ai AttributeMapped BigCommerce AttributeBigCommerce Attribute Description
Customer Id/customers.idThe unique numeric ID of the customer.
First Name/customers.first_nameThe first name of the customer.
Last Name/customers.last_nameThe last name of the customer.
Email Address/customers.emailThe email of the customer. Must be unique.
Mobile Phone Number/customers.phoneThe phone number of the customer.
GDPR Status – Marketing Subscribed
GDPR Status – Right of Access Requested
GDPR Status – Anonymise Data
Facebook Slug
Twitter Handle
Instagram Handle
LinkedIn Slug
Postal Address Line 1/customers/addresses.address1The address 1 line.
Postal Address Line 2/customers/addresses.address2The address 1 line.
Postal Address Town/customers/addresses.cityThe city of the customer address.
Postal Address Region/customers/addresses.state_or_provinceThe state or province name.
Postal Address Country/customers/addresses.countryThe country name of the customer address.
Postal Address Postcode/customers/addresses.postal_codeThe postal code of the customer address.
Billing Address Line 1/orders/billing_addresses.street_1The customer’s street address, line 1.
Billing Address Line 2/orders/billing_addresses.street_2The customer’s street address, line 2.
Billing Address Town/orders/billing_addresses.cityThe customer’s city/town/suburb.
Billing Address Region/orders/billing_addresses.stateThe customer’s state/province.
Billing Address Country/orders/billing_addresses.countryThe customer’s country. Must be the full country name.
Billing Address Postcode/orders/billing_addresses.zipThe customer’s ZIP or postal code.

Additional Customer Attributes available from BigCommerce can be found here. These may added as Custom Attributes into the Distil.ai Customer dataset.

Product Attributes

Distil.ai AttributeMapped BigCommerce AttributeBigCommerce Attribute Description
Product Id/catalog/products.skuUser defined product code/stock keeping unit (SKU).
Product Name/catalog/products.nameThe product name.
Precis/catalog/products.descriptionThe product description, which can include HTML formatting.
Thumbnail URL/catalog/products/images.url_thumbnailThe thumbnail URL for this image. By default, this is the image size used on the category page and in side panels.
Image URL/catalog/products/images.image_urlMust be a fully qualified URL path, including protocol. Limit of 8MB per file.
Shop URL/catalog/products/custom_url.urlCategory URL on the storefront.
Available/catalog/products.availabilityAvailability of the product. Availability options are: available – the product can be purchased on the storefront; disabled – the product is listed in the storefront, but cannot be purchased; preorder – the product is listed for pre-orders.
List Price – Excluding Tax/catalog/products.priceThe price of the product. The price should include or exclude tax, based on the store settings.
List Price – Including Tax/catalog/products.priceThe price of the product. The price should include or exclude tax, based on the store settings.
Price Breaks Description/catalog/products.bulk-pricing-rulesReturns a list of Bulk Pricing Rules. Optional parameters can be passed in.
Category/catalog/products.categoriesAn array of IDs for the categories to which this product belongs. When updating a product, if an array of categories is supplied, all product categories will be overwritten. Does not accept more than 1,000 ID values.

Additional Product Attributes available from BigCommerce can be found here. These may added as Custom Attributes into the Distil.ai Product dataset.

Purchase History Attributes

Distil.ai AttributeMapped BigCommerce AttributeBigCommerce Attribute Description
Id/orders/products.idNumeric ID of this product within this order.
Customer Id/orders.customer_idThe ID of the customer placing the order; or 0 if it was a guest order.
Order Id/orders/products.order_idNumeric ID of the associated order.
Product Id/orders/products.product_idNumeric ID of the product.
Order Timestamp UTC/orders.date_createdThe date this order was created. If not specified, will default to the current time. 
Quantity/orders/products.quantityQuantity of the product ordered.
Line Value Excluding Tax/orders/products.price_ex_taxThe product’s price excluding tax.
Line Value Including Tax/orders/products.price_inc_taxThe product’s price including tax.
Payment method/orders.payment_methodThe payment method for this order. Can be one of the following: Manual, Credit Card, cash, Test Payment Gateway, etc.
Currency/orders.currency_codeThe currency code of the currency being used in this transaction.
Postal Address Line 1/orders/shipping_addresses.street_1Street address (first line).
Postal Address Line 2/orders/shipping_addresses.street_2Street address (second line).
Postal Address Town/orders/shipping_addresses.cityAddressee city.
Postal Address Region/orders/shipping_addresses.stateThe name of the state or province. Should be spelled out in full.
Postal Address Country/orders/shipping_addresses.countryAddressee’s country.
Postal Address Postcode/orders/shipping_addresses.zipZIP or postal code, as a string.
Billing Address Line 1/orders/billing_addresses.street_1The customer’s street address, line 1.
Billing Address Line 2/orders/billing_addresses.street_2The customer’s street address, line 2.
Billing Address Town/orders/billing_addresses.cityThe customer’s city/town/suburb.
Billing Address Region/orders/billing_addresses.stateThe customer’s state/province.
Billing Address Country/orders/billing_addresses.countryThe customer’s country. Must be the full country name.
Billing Address Postcode/orders/billing_addresses.zipThe customer’s ZIP or postal code.

Additional Purchase History Attributes available from BigCommerce can be found here. These may added as Custom Attributes into the Distil.ai Purchase History dataset.