ProductCart Shopping Cart Software Forums : Shopping.com ROI Tracker Implementation https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 03:41:33 +0000 Tue, 18 Nov 2014 01:45:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5301 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Shopping.com ROI Tracker Implementation : I wanted to bring this thread...]]> https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post22265.html#22265 Author: whizzinpc
Subject: 5301
Posted: 18-November-2014 at 1:45am

I wanted to bring this thread back to life. Can anyone help finish the code for the shopping.com ROI Tracker. Only thing not working is looping through all products in the order. The way the code is now only shows the last product in the order. So its reporting incorrectly.

            <!-- START Shopping.com ROI Tracking Code -->
            <script type="text/javascript">
            var _roi = _roi || [];
           
            // Step 1: add base order details
           
            _roi.push(['_setMerchantId', 'xxxxxx']); // required
            _roi.push(['_setOrderId', '<%=pOrderNumber%>']); // unique customer order ID
            _roi.push(['_setOrderAmount', '<%=pTotal%>']); // order total without tax and shipping
            _roi.push(['_setOrderNotes', '']); // notes on order, up to 50 characters
           
            // Step 2: add every item in the order
            // where your e-commerce engine loops through each item in the cart and prints out _addItem for each
            // please note that the order of the values must be followed to ensure reporting accuracy
           
            _roi.push(['_addItem',
            '<%=pIdProduct%>', // Merchant sku
            '<%=pdescription%>', // Product name
            '', // Category id
            '', // Category name
            '<%=punitPrice1%>', // Unit price
            '<%=pquantity%>' // Item quantity
            ]);
           
            // Step 3: submit transaction to ECN ROI tracker
           
            _roi.push(['_trackTrans']);
            </script>
            <script type="text/javascript" src="https://stat.dealtime.com/ROI/ROI2.js"></script>
            <!-- END Shopping.com ROI Tracking Code -->

]]> Tue, 18 Nov 2014 01:45:16 +0000 https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post22265.html#22265 <![CDATA[Shopping.com ROI Tracker Implementation : Ok. PC doesn&#039;t have a subtotal,...]]> https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20243.html#20243 Author: Guests
Subject: 5301
Posted: 03-October-2012 at 1:49pm

Ok. PC doesn't have a subtotal, so we have to do some math here. So for "Step 1" you'd want:
<%
dim lngSubtotal
lngSubtotal = ptotal - (ptaxAmount + serviceHandlingFee + Postage)
lngSubtotal = money(lngSubtotal)
%>
<script type="text/javascript">
var _roi = _roi || [];

// Step 1: add base order details

_roi.push(['_setMerchantId', 'xxxxxx']); // required
_roi.push(['_setOrderId', '<%=(pOrderNumber)%>']); // unique customer order ID
_roi.push(['_setOrderAmount', '<%=(lngSubtotal)%>']); // order total without tax and shipping
_roi.push(['_setOrderNotes', '<%=(left(pcomments,50))%>']); // notes on order, up to 50 characters

Generating the content for "Step 2" would require some work, though.
]]> Wed, 03 Oct 2012 13:49:06 +0000 https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20243.html#20243 <![CDATA[Shopping.com ROI Tracker Implementation : It would be the subtotal before...]]> https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20242.html#20242 Author: whizzinpc
Subject: 5301
Posted: 03-October-2012 at 1:27pm

It would be the subtotal before shipping, tax.]]> Wed, 03 Oct 2012 13:27:22 +0000 https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20242.html#20242 <![CDATA[Shopping.com ROI Tracker Implementation : Oh, one more question: For this,...]]> https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20241.html#20241 Author: Guests
Subject: 5301
Posted: 03-October-2012 at 1:18pm

Oh, one more question: For this, would you want to push the complete order total (including shipping, taxes, etc.) or the subtotal before all of that?]]> Wed, 03 Oct 2012 13:18:01 +0000 https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20241.html#20241 <![CDATA[Shopping.com ROI Tracker Implementation : Hi Art,For &#034;Step 1&#034;...]]> https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20240.html#20240 Author: Guests
Subject: 5301
Posted: 03-October-2012 at 1:11pm

Hi Art,

For "Step 1" you'd want:
// Step 1: add base order details

_roi.push(['_setMerchantId', 'xxxxxx']); // required
_roi.push(['_setOrderId', '<%=(pOrderNumber)%>']); // unique customer order ID
_roi.push(['_setOrderAmount', '<%=(ptotal)%>']); // order total without tax and shipping
_roi.push(['_setOrderNotes', '<%=(left(pcomments,50))%>']); // notes on order, up to 50 characters

For "Step 2", a modification to orderComplete.asp would be necessary. What you have there won't work at all, but even if corrected, at this point in the processing it would only pick up the values for the last item in the cart. To track the ROI at the item level, this bit of the script would need to be dynamically populated as orderComplete.asp loops through the items in the order, or (better) it could be generated straight off of pcCartArray.
]]> Wed, 03 Oct 2012 13:11:19 +0000 https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20240.html#20240 <![CDATA[Shopping.com ROI Tracker Implementation : Can someone let me know if this...]]> https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20239.html#20239 Author: whizzinpc
Subject: 5301
Posted: 03-October-2012 at 12:50pm

Can someone let me know if this code will work on the order complete page for Shopping.com's ROI Tracker. I think I have it right except i'm not sure about the OrderID. 

<script type="text/javascript">
var _roi = _roi || [];

// Step 1: add base order details

_roi.push(['_setMerchantId', 'xxxxxx']); // required
_roi.push(['_setOrderId', '<%=(int(pOID)+scpre)%>']); // unique customer order ID
_roi.push(['_setOrderAmount', 'ptotal']); // order total without tax and shipping
_roi.push(['_setOrderNotes', 'pcomments']); // notes on order, up to 50 characters

// Step 2: add every item in the order
// where your e-commerce engine loops through each item in the cart and prints out _addItem for each
// please note that the order of the values must be followed to ensure reporting accuracy

_roi.push(['_addItem',
'psku', // Merchant sku
'pdescription', // Product name
'', // Category id
'', // Category name
'punitPrice', // Unit price
'pquantity' // Item quantity
]);

// Step 3: submit transaction to SDC ROI tracker

_roi.push(['_trackTrans']);
</script>
<script type="text/javascript" src="https://stat.dealtime.com/ROI/ROI2.js"></script>

]]> Wed, 03 Oct 2012 12:50:50 +0000 https://forum.productcart.com/shopping-com-roi-tracker-implementation_topic5301_post20239.html#20239