Tracking Cross Sale

As far as I know, PC doesn't track this information related to sales.

You could run the Export Sales Data report and see which orders have multiple products. Then compare those products to see if they were related in cross sells.

That's the only option I can see right now.

thrion wrote: Although not a function of the cart, many analytics packages will tell you how many clicks you receive on any given page on your site, so you could get a report through your analytics package to at least see how many people are clicking on your cross selling items.

I like the idea, but how do I differentiate between cross sale clicks and direct views of that product?

What I would do is edit the pcs_CrossSellingAccessories code to include an extra query string.. something like crossSellClick=1.  At which point in viewPrd.asp you can check to see if the query string exists, and increment a counter in the Products table in the database.  You would, of course, need to add an additional field to the Products table.  All you'd really need to do is something like:
(make sure you put this code in an area where the rs object isn't being used)

If QueryString("crossSellClick")=1 Then
    Query="UPDATE products SET crossSellClicks=crossSellClicks+1 WHERE idProduct=" & pIdProduct
    set rs=server.CreateObject("ADODB.RecordSet")
    set rs=conntemp.execute(query)
End If

This wouldn't give you how many sales you make through the feature, but it would show you how many times the product has been viewed specifically by clicking a link from the accessories area of cross selling.  At which point I believe you're back at square one with regard to probability of purchase (unless you're using discounted bundles [which if you are, you'd need to duplicate the above code in pcs_CrossSellingDiscounts]).

Then from the admin panel you could edit the export area to add this field.. I can't give you any specifics on that, but the above would be the first step.

If you wanted to track the actual sales, you could forward the crossSellClick value to the cart array or something similar.



Edited by NWilliams - 15-March-2007 at 5:49pm