How to integrate BigCommerce with ProfitMetrics using Zapier

Follow the steps below to integrate BigCommerce with ProfitMetrics via Zapier

1. Create a trigger
2. Create a "Code by Zapier" action
3. Insert the ProfitMetrics tracking

Part 1/3: Create a trigger

1. Log in to https://zapier.com or create an account if you do not have one.
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
   
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

Part 2/3: Create a "Code by Zapier" action

1. Search for "Code" and click "Code by Zapier"
2. Click "Event" and select "Run Javascript"
3. Click "Continue"
4. Click the field named "Input Data" and type "id"
5. Click the field next to it with the text "Enter text or insert date..."
   
6. Select "Id" from the dropdown list of options
   
7. Click the "+ icon" to add another item
   
8. Repeat the above steps 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
   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
   productQuantity	Products Quantity
   productPriceExVat	Products Price Ex Tax
   productWeight	Products Weight

   
9. Copy this script and paste it into the "Code (required)" field. Make sure to delete the existing content first.
   

   // Convert date to unix
   function 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 quantity
   function 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 array
   const 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 number
   const cleanedPhoneNumber = inputData['customerPhone'] ? inputData['customerPhone'].replace(/\+/g, '') : '';
   console.log('Cleaned Phone Number:', cleanedPhoneNumber);
   
   // Create JSON object with omitted undefined values
   const data = {
     "id": inputData['id'],
     "ts": unixTime,
     "orderEmail": inputData['orderEmail'],
     "customerPhone": cleanedPhoneNumber,
     "shippingMethod": inputData['shippingMethod'],
     "shippingCountry": inputData['shippingCountry'],
     "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 values
   const 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});

   
10. Click "Continue", "Continue" and "Continue"
    
    
11. Click "Publish"

back to top

Part 3/3: Insert the ProfitMetrics tracking in BigCommerce

Create the default tracking script

1. Log in to BigCommerce.com
2. Click Channel Manager
3. Click Scripts
4. Click Create a script
5. In Script name type "ProfitMetrics"
6. In Description type "Default ProfitMetrics script"
7. Under placement, select Footer
8. Under Location, select All pages
9. Under script category, select Essential
10. Under script type, select Script
11. .Paste in the following script and replace both instances of "PUBLIC_ID" with your Public ID (found here)
     

    <!-- ProfitMetrics snippet START-->
    
    <script>
    window.profitMetrics = {
    pid: 'PUBLIC_ID', // The ProfitMetrics website ID
    cookieMarketingConsent: false,
    cookieStatisticsConsent: false,
    }
    </script>
    
    <script src="https://cdn1.profitmetrics.io/PUBLIC_I/bundle.js"
    defer></script>
    <!-- ProfitMetrics snippet END-->

12. Click Save

Create the Marketing consent script

1. Click Create a script
2. In Script name type "ProfitMetrics - Marketing Consent"
3. In Description type "Set marketing consent for ProfitMetrics script"
4. Under placement, select Footer
5. Under Location, select All pages
6. Under script category, select Targeting/Advertising
   
7. Under script type, select Script
8. Paste in the following script and replace "PUBLIC_ID" with your Public ID
   (found here)

   <!-- ProfitMetrics snippet START-->
   <script>
   window.profitMetrics.cookieMarketingConsent = true;
   </script>
   <script src="https://cdn1.profitmetrics.io/PUBLIC_ID/bundle.js"
   defer>
   </script>
   <!-- ProfitMetrics snippet END-->

9. Click Save

Create the Analytics consent script

1. Click Create a script
2. In the Script name type "ProfitMetrics - Analytics Consent"
3. In the Description type "Set marketing consent for ProfitMetrics script"
4. Under placement, select Footer
5. Under Location, select All pages
6. Under the script category, select Analytics
   
7. Under script type, select Script
8. .Paste in the following script and replace "PUBLIC_ID" with your Public ID 
   (found here)

9. <!-- ProfitMetrics snippet START-->
   <script>
   window.profitMetrics.cookieStatisticsConsent = true;
   </script>
   <script src="https://cdn1.profitmetrics.io/PUBLIC_ID/bundle.js"
   defer>
   </script>
   <!-- ProfitMetrics snippet END-->

10. .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

   <!-- Start ProfitMetrics - setEmail -->
   <script>
   function _pm_tryemailorderconfirmation() {
   if( null != window.profitMetrics && null != window.profitMetrics.setEmail && typeof window.profitMetrics.setEmail === 'function' ) {
   window.profitMetrics.setEmail( '%%ORDER_EMAIL%%' );
   } else {
   setTimeout( _pm_tryemailorderconfirmation, 500 );
   }
   }
   _pm_tryemailorderconfirmation();
   </script>
   <!-- End ProfitMetrics - setEmail -->

5. Click Save