Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 5 of 5

Thread: ShareASale Help

  1. #1
    jasoncbarlow@gmail.com is offline Junior Member
    Join Date
    Sep 2009
    Posts
    12

    Default ShareASale Help

    I am adding the code provided by shareasale and it is working but the amount it is sending to them is incorrect. Currently it is sending the order total and we want to calculate our commission based on the subtotal. Here is the current code I have placed in the google tracking line.

    <img src="https://shareasale.com/sale.cfm?amount=(!ORDERTOTAL!)&tracking=(!ORDERNUM BER!)&transtype=sale&merchantID=XXXX" width="1"
    height="1" />

    I have replaced the XXX with our id and I have tried to replace !ORDERTOTAL! with !ORDERSUBTOTAL! can someone please help... This is driving me to drink....

    Thanks in advance

    Jason

  2. #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    You'll have to do a SQL lookup on the orderconfirmation page (before where the Google topic is added to the page) to make the order subtotal available, then just do a replace the way we do for ORDERTOTAL.

  3. #3
    jasoncbarlow@gmail.com is offline Junior Member
    Join Date
    Sep 2009
    Posts
    12

    Default

    Can I just do a db.get data(select statement here). And set that equal to the subtotal? Also I am trying not to overwrite the !order total! Can I just reference the new value as !order subtotal!

    I am by far not an asp.net guru but just double checking this would be in the .cs file correct?

  4. #4
    jasoncbarlow@gmail.com is offline Junior Member
    Join Date
    Sep 2009
    Posts
    12

    Default

    Scott thank you for your reply I am hoping to get this working soon

  5. #5
    jasoncbarlow@gmail.com is offline Junior Member
    Join Date
    Sep 2009
    Posts
    12

    Default

    In your post on the share a sale help request helped, what I ended up doing is changed the replace for order total from rs.total to rs.subtotal and it worked. Do you see any problem with this since this variable is not used on the confirmation page

    Thank you