---
title: How to integrate BigCommerce with ProfitMetrics using Zapier
description: Follow the steps below to integrate BigCommerce with ProfitMetrics via Zapier
---
[Skip to content](https://knowledge.profitmetrics.io/how-to-integrate-with-bigcommerce-using-zapier#main-content)
[](https://knowledge.profitmetrics.io/?hsLang=en)
Open main navigation
Close main navigation
- [Contact Support](https://knowledge.profitmetrics.io/kb-ticket/new)
[Contact Support](https://knowledge.profitmetrics.io/kb-ticket/new?hsLang=en)
How can we help you?
- There are no suggestions because the search field is empty.
1. [Knowledge base](https://knowledge.profitmetrics.io/?hsLang=en)
2. [E-commerce Platforms](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en)
3. [BigCommerce](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#bigcommerce)
# How to integrate BigCommerce with ProfitMetrics using Zapier
## Follow the steps below to integrate BigCommerce with ProfitMetrics via Zapier
[Part 1: Create a trigger](https://knowledge.profitmetrics.io/how-to-integrate-with-bigcommerce-using-zapier#part1)
[Part 2: Create a "Code by Zapier" action](https://knowledge.profitmetrics.io/how-to-integrate-with-bigcommerce-using-zapier#part2)
[Part 3: Insert the ProfitMetrics tracking](https://knowledge.profitmetrics.io/how-to-integrate-with-bigcommerce-using-zapier#part3)
---
### **Part 1: Create a trigger**
1. Log in to [**https://zapier.com**](https://zapier.com) or create an account if you do not have one.
(Up to 100 tasks per month can be created using the free Zapier account.)
2. Click"**Create**"
****
3. Click "**New Zap**"
****
4. Click the "**Pen icon**" in the top left corner to edit the name
****
5. Type (or copy/paste):
```
ProfitMetrics - Serverside Hybrid Universal Integration
```
Click anywhere to save
6. Click **"1. Trigger"**
7. Search for "**BigCommerce**" and click it.
***NOTE**: If this is the first time connecting to BigCommerce you will need to follow the steps to complete the connection*
**Please note that only account owners can create the new API Account that will be required to proceed!**
8. Click the "**Event (required)**", search for "**Order**" and select "**Order Created"**
9. Click "**Continue**", "**Continue**" and "**Continue**" again.
****
10. Click "**Test trigger**"
11. Click "**Continue with the selected record**"
*[back to top](https://knowledge.profitmetrics.io/how-to-integrate-with-bigcommerce-using-zapier#top)*
### Part 2: Create a "Code by Zapier" action
1. Search for "**Code**" and click "**Code by Zapier**"****
2. Click "**Event**" and select "**Run Javascript**".png?width=670&height=374&name=How%20to%20Create%20a%20Zap%20on%20Zapier%20-%20Step%2023%20(1).png)
3. Click "**Continue**"
4. Click the field named "**Input Data**" and type "**pid**" 
5. Click the field next to it and insert your **"Public ID" [(How to find your Public ID)](https://knowledge.profitmetrics.io/how-to-find-your-public-id?hsLang=en)**
6. Click the **"+ icon"** to add a new field
7. Type **"id"** (lowercase) in the first field.
8. Click **"Enter text or insert data..."** to add a value
9. Select "**Id**" from the dropdown list of options
10. **Repeat steps 6-9** and add the following pairs of Input Data and Value.
You can copy/paste the values from the list below.
*NOTE: Use the image below for reference*
| **Input Data** | **Value** |
| --- | --- |
| pid | ProfitMetrics Public ID |
| id | ID |
| dateCreated | Date Created |
| orderEmail | Shipping Addresses Email |
| customerPhone | Shipping Addresses Phone |
| shippingMethod | Shipping Addresses Shipping Method |
| shippingCountry | Shipping Addresses Country Iso 2 |
| shippingState | Shipping Address state (full state name or standard US state code) |
| shippingAddressesZip | Shipping Addresses Zip |
| paymentMethod | Payment Method |
| currencyCode | Currency Code |
| couponsCode | Coupons |
| priceShippingExVat | Shipping Addresses Cost Ex Tax |
| priceTotalExVat | Total Ex Tax |
| priceTotalInclVat | Total Inc Tax |
| productId | products Variant Id |
| | OR products Product Id |
| | OR products SKU |
| | ***IMPORTANT: Please verify which field is to use based on the ID currently used in your product feed as "id:" or "g:id"*** |
| productQuantity | Products Quantity |
| productPriceExVat | Products Price Ex Tax |
| productWeight | Products Weight |
11. Copy this script and paste it into the "Code (required)" field. Make sure to delete the existing content first.
```
// Convert date to unixfunction convertToUnixTime(dateString) { const date = new Date(dateString); return date.getTime() / 1000;}const unixTime = convertToUnixTime(inputData['dateCreated']);console.log('Unix Time:', unixTime);// Calculate sum of product weight considering quantityfunction sumProductWeights(productId, productQuantity, productWeight) { const idArray = productId ? productId.split(',') : []; const quantityArray = productQuantity ? productQuantity.split(',') : []; const weightArray = productWeight ? productWeight.split(',') : []; let totalWeight = 0; for (let i = 0; i < idArray.length; i++) { const qty = Number(quantityArray[i]); const weight = Number(weightArray[i]); if (!isNaN(qty) && !isNaN(weight)) { totalWeight += qty * weight; } } return totalWeight; // unknown unit}const shippingWeightSum = sumProductWeights(inputData['productId'], inputData['productQuantity'], inputData['productWeight']);console.log('Shipping Weight Sum (including product quantity):', shippingWeightSum);// Create product arrayconst productId = inputData['productId'];const productQuantity = inputData['productQuantity'];const productPriceExVat = inputData['productPriceExVat'];const products = [];const idArray = productId ? productId.split(',') : [];const quantityArray = productQuantity ? productQuantity.split(',') : [];const priceArray = productPriceExVat ? productPriceExVat.split(',') : [];for (let i = 0; i < idArray.length; i++) { products.push({ "sku": idArray[i], "qty": Number(quantityArray[i]), "priceExVat": Number(priceArray[i]) });}// Remove '+' sign from the phone numberconst cleanedPhoneNumber = inputData['customerPhone'] ? inputData['customerPhone'].replace(/\+/g, '') : '';console.log('Cleaned Phone Number:', cleanedPhoneNumber);// Create JSON object with omitted undefined valuesconst data = { "id": inputData['id'], "ts": unixTime, "orderEmail": inputData['orderEmail'], "customerPhone": cleanedPhoneNumber, "shippingMethod": inputData['shippingMethod'], "shippingCountry": inputData['shippingCountry'], "shippingState": inputData['shippingState'], "shippingZipcode": `${inputData['shippingAddressesZip']}`, "shippingWeight": Number(shippingWeightSum), "paymentMethod": inputData['paymentMethod'], "currency": inputData['currencyCode'], "voucherCode": inputData['couponsCode'], "priceShippingExVat": Number(inputData['priceShippingExVat']), "priceTotalExVat": Number(inputData['priceTotalExVat']), "priceTotalInclVat": Number(inputData['priceTotalInclVat']), "products": products};// Filter out undefined valuesconst filteredData = Object.fromEntries(Object.entries(data).filter(([_, v]) => v !== undefined));const jsonData = JSON.stringify(filteredData);console.log('JSON Data:', jsonData);const url = 'https://my.profitmetrics.io/l.php?v=3uh&pid=' + inputData['pid'] + '&o=' + encodeURIComponent(jsonData);await fetch(url) .then(response => response.text()) .then(result => console.log(result)) .catch(error => console.log('error', error));callback(null, { "URL": + url});
```
12. Click "**Continue**", "**Continue**" and "**Continue**"
13. Click "**Publish**"
*[back to top](https://knowledge.profitmetrics.io/how-to-integrate-with-bigcommerce-using-zapier#top)*
### Part 3: Insert the ProfitMetrics tracking in BigCommerce
**Create the default tracking script**
1. Log in to **[BigCommerce.com](https://www.bigcommerce.com/)**
2. Click '**Storefront'
.png?width=655&height=366&name=Installing%20ProfitMetrics%20Scripts%20on%20BigCommerce%20Store%20-%20Step%204%20(1).png)**
3. Click '**Scripts'
**
4. Click '**Create a script'
**
5. In Script name type '**ProfitMetrics - Script'**
6. Ensure Placement is set to '**Footer'
**
7. Under Location, select '**All pages'
**
8. Under script category, select '**Essential'
**
9. Under script type, select '**Script'
**
10. Paste in the following script and replace both instances of "PUBLIC\_ID" with your Public ID ([found here](https://my.profitmetrics.io/customer/websites.php))
```
```
11. Click **Save**
**Create the Marketing consent script**
1. Click **Create a script
**
2. In the Script name, type "**ProfitMetrics - Marketing Consent**"
3. Ensure Placement is set to **Footer**
4. Under Location, select **All pages
**
5. Under script category, select **Targeting/Advertising
**
6. Under script type, select **Script
**
7. Paste in the following script and replace "**PUBLIC\_ID**" with your Public ID
([found here](https://my.profitmetrics.io/customer/websites.php))
```
```
8. Click **Save**
**Create the Analytics consent script**
1. Click **Create a script
**
2. In the Script name type "**ProfitMetrics - Analytics Consent**"
3. Ensure Placement is set to **Footer**
4. Under Location, select **All pages
**
5. Under the script category, select **Analytics
**
6. Under script type, select **Script
**
7. .Paste in the following script and replace "**PUBLIC\_ID**" with your Public ID
([found here](https://my.profitmetrics.io/customer/websites.php))
8. ```
```
9. .Click **Save**
**Create a setEmail script**
1. Navigate to **Settings
**
2. Scroll down to "Advanced" and click **Data solutions
**
3. Find "Affiliate Conversion Tracking" and click **Connect
**
4. Insert the following script
```
```
5. Click **Save
**
**That's it.**
- [Getting Started](https://knowledge.profitmetrics.io/getting-started?hsLang=en#main-content)
- [Learn the Basics](https://knowledge.profitmetrics.io/getting-started?hsLang=en#learn-the-basics)
- [Prepare for Onboarding](https://knowledge.profitmetrics.io/getting-started?hsLang=en#prepare-for-onboarding)
- [Account Setup](https://knowledge.profitmetrics.io/getting-started?hsLang=en#account-setup)
- [E-commerce Platforms](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#main-content)
- [Shopify](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#shopify)
- [WooCommerce](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#woocommerce)
- [Magento](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#magento)
- [PrestaShop](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#prestashop)
- [BigCommerce](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#bigcommerce)
- [Shopware](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#shopware)
- [DanDomain & Related](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#dandomain-related)
- [Universal Integration (Clientside)](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#universal-integration-clientside)
- [Universal Integration (Server-side Hybrid)](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#universal-integration-server-side-hybrid)
- [Other Platforms](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#other-platforms)
- [Developer Documentation](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#developer-documentation)
- [Ad Channels](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#main-content)
- [Google Ads](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#google-ads)
- [Meta (Facebook/Instagram)](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#meta-facebook-instagram)
- [Microsoft Bing Ads](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#microsoft-bing-ads)
- [Google Analytics 4](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#google-analytics-4)
- [Partner-ads](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#partner-ads)
- [Other Channel Configuration](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#other-channel-configuration)
- [Tracking & Conversion Setup](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#main-content)
- [Overview](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#overview)
- [Conversion Booster for Google Ads](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#conversion-booster-for-google-ads)
- [Conversion Booster for Meta](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#conversion-booster-for-meta)
- [Conversion Booster Custom Pixels](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#conversion-booster-custom-pixels)
- [Enhanced Conversions](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#enhanced-conversions)
- [Shopping Booster](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#main-content)
- [Overview & Setup](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#overview-setup)
- [Supplemental Feeds](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#supplemental-feeds)
- [Campaigns & Labels](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#campaigns-labels)
- [Troubleshooting](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#troubleshooting)
- [Product Feed & Costs](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#main-content)
- [Product Feed](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#product-feed)
- [Shipping & Payment Costs](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#shipping-payment-costs)
- [Expenses](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#expenses)
- [Dashboard, Orders & Reporting](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#main-content)
- [Dashboard & Orders](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#dashboard-orders)
- [Looker Studio](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#looker-studio)
- [Google BigQuery](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#google-bigquery)
- [Account & Billing](https://knowledge.profitmetrics.io/account-billing?hsLang=en#main-content)
- [Users & Access](https://knowledge.profitmetrics.io/account-billing?hsLang=en#users-access)
- [Billing & Invoices](https://knowledge.profitmetrics.io/account-billing?hsLang=en#billing-invoices)
- [Privacy & Consent](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#main-content)
- [GDPR](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#gdpr)
- [Consent Management Platforms](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#consent-management-platforms)
- [Google Consent Mode](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#google-consent-mode)
- [For Agencies](https://knowledge.profitmetrics.io/for-agencies?hsLang=en#main-content)
- [Getting Started as an Agency](https://knowledge.profitmetrics.io/for-agencies?hsLang=en#getting-started-as-an-agency)
- [Agency Certification](https://knowledge.profitmetrics.io/for-agencies?hsLang=en#agency-certification)
- [Shopify](https://knowledge.profitmetrics.io/shopify?hsLang=en)
- [PrestaShop](https://knowledge.profitmetrics.io/prestashop?hsLang=en)
- [Google Ads](https://knowledge.profitmetrics.io/google-ads?hsLang=en#main-content)
- [troubleshoot](https://knowledge.profitmetrics.io/google-ads?hsLang=en#troubleshoot)
- [Meta (Facebook / Instagram)](https://knowledge.profitmetrics.io/meta-facebook-instagram?hsLang=en)
- [Uncategorized](https://knowledge.profitmetrics.io/uncategorized?hsLang=en)
- [Billing](https://knowledge.profitmetrics.io/billing?hsLang=en)
- [Google Sheets](https://knowledge.profitmetrics.io/google-sheets?hsLang=en)
- [Account](https://knowledge.profitmetrics.io/account?hsLang=en)
- [Ideal Shop](https://knowledge.profitmetrics.io/ideal-shop?hsLang=en)
[](https://profitmetrics.io)
[mailto:support@profitmetrics.io](mailto:support@profitmetrics.io)
Copyright © 2026, ProfitMetrics ApS