BigCommerce: Import Users & Activity Data
Importing your BigCommerce customers and their order activity data into Lytics enables you to run personalized marketing campaigns for your BigCommerce customers.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: REST API.
- Frequency: Batch.
- Resulting data: User profiles and raw event data.
This integration utilizes the BigCommerce API to import user and activity data. Once the import is started, the job will:
- From the start-date, import new customers from your BigCommerce account into the
bicommerce_usersstream. - From the start-date, import new orders and related product activity from your BigCommerce account into the
bigcommerce_ordersstream. - Continue to import any new customers and activity on an hourly basis.
Fields
The following fields are included in the default mapping of the bigcommerce_users stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| accepts_product_review_abandoned_cart_emails | bigcommerce_accepts_marketing | BigCommerce Accepts Marketing | bool |
| company | bigcommerce_company | Company | string |
| customer_group_id | bigcommerce_customer_group_id | BigCommerce Customer Group ID | int |
| date_created | bigcommerce_created_ts | BigCommerce Customer Created Time | date |
| date_modified | bigcommerce_modified_ts | BigCommerce Customer Modified Time | date |
| email(email) | email unique id | string | |
| first_name | first_name | First Name | string |
| id | bigcommerce_customer_id unique id | BigCommerce Customer Id | string |
| last_name | last_name | Last Name | string |
| phone | phone | Phone Number | string |
| registration_ip_address | bigcommerce_ip | BigCommerce Registration IP address | string |
set(addresses.address1) | bigcommerce_address_1s | BigCommerce Customer Address 1 | []string |
set(addresses.address2) | bigcommerce_address_2s | BigCommerce Customer Address 2 | []string |
set(addresses.address\_type) | bigcommerce_address_types | BigCommerce Customer Address Type | []string |
set(addresses.city) | bigcommerce_cities | BigCommerce Customer City | []string |
set(addresses.country\_code) | bigcommerce_country_codes | BigCommerce Customer Country Code | []string |
set(addresses.country) | bigcommerce_countries | BigCommerce Customer Country | []string |
set(addresses.id) | bigcommerce_address_ids | BigCommerce Customer Address ID | []string |
set(addresses.postal\_code) | bigcommerce_postal_codes | BigCommerce Customer Zip | []string |
set(addresses.state\_or\_province) | bigcommerce_states | BigCommerce Customer State | []string |
set(attributes.attribute\_id) | bigcommerce_attr_id | BigCommerce Attribute ID | []string |
set(attributes.attribute\_value) | bigcommerce_attr_value | BigCommerce Attribute Value | []string |
set(attributes.date\_created) | bigcommerce_attr_created_ts | BigCommerce Attribute Created Time | []string |
set(attributes.date\_modified) | bigcommerce_attr_modified_ts | BigCommerce Attribute Modified Time | []string |
set(form\_fields.name) | bigcommerce_field_name | BigCommerce Form Field Name | []string |
set(form\_fields.value) | bigcommerce_field_value | BigCommerce Form Field Value | []string |
| set(store_credit_amounts.amount) | bigcommerce_credit_amounts | BigCommerce Store Credit Amounts | []string |
| tax_exempt_category | bigcommerce_tax_exempt | BigCommerce Tax Exempt | string |
The following fields are included in the default mapping of the bigcommerce_orders stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| base_handling_cost | bigcommerce_base_handling_cost | BigCommerce Base Handling Cost | number |
| base_shipping_cost | bigcommerce_base_shipping_cost | BigCommerce Base Shipping Cost | number |
| coupon_discount | bigcommerce_coupon_discount | BigCommerce Coupon Discount | number |
| customer_id | bigcommerce_customer_id unique id | BigCommerce Customer Id | string |
| discount_amount | bigcommerce_discount_amount | BigCommerce Discount Amount | number |
| gift_certificate_amount | bigcommerce_gift_certificate_amount | BigCommerce Gift Certificate Amount | number |
| is_email_opt_in | bigcommerce_is_email_opt_in | BigCommerce Customer Selected Email Opt-In | bool |
| items_shipped | bigcommerce_items_shipped | BigCommerce Number of Items Shipped | number |
| items_total | bigcommerce_items_total | BigCommerce Total Items in the Order | number |
| max(todate(date_created)) | last_purchase_ts | Most Recent Order Time | date |
| min(todate(date_created)) | bitcommerce_first_order_ts | First Order Time | date |
| payment_method | bigcommerce_payment_method | BigCommerce payment method | string |
| refunded_amount | bigcommerce_refund_amount | BigCommerce Transaction Refund Amount | number |
| set(id) | bigcommerce_order_product_ids | BigCommerce Product ID within Order | []string |
| set(name_customer) | bigcommerce_name_customers | BigCommerce Product Name Shown to Customer | []string |
| set(name_merchant) | bigcommerce_name_merchants | BigCommerce Product Name Shown to Merchant | []string |
| set(order_id) | bigcommerce_order_ids | BigCommerce Order IDs | []string |
| set(product_id) | bigcommerce_product_ids | BigCommerce Product ID | []string |
| store_credit_amount | bigcommerce_store_credit_amount | BigCommerce Store Credit Amount | number |
Configuration
Follow these steps to set up and configure an import job for BigCommerce in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select BigCommerce from the list of providers.
- Select the Import Users & Activity Data from the list.
- Select the Authorization you would like to use or create a new one.
- Enter a Label to identify this job you are creating in Lytics.
- (Optional) Enter a Description for further context on your job.
- Complete the configuration steps for your job.
- (Optional) From the Additional Customer Fields input, select additional customer fields to import.
- (Optional) Select the Skip importing customer profiles checkbox to skip importing customer profiles.
- (Optional) Select the Skip importing customer order data checkbox to skip importing customer orders.
- (Optional) In the Start Date text box, enter a date to start your import from. If no date is selected, all users and activity data will be imported. Please use the format
yyyy-mm-dd, e.g.2021-01-25. - (Optional) Select the Keep Updated checkbox to continuously import data.
- Click Start Import.
