The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #11  
Old 01-21-2013, 12:16 PM
michelaerts's Avatar
michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default


Matvey; I tried to correct the space splitting the code; and I tried to use an affiliate link, nothing. You are welcome to rewrite the correct code. If you want to test the link, here is one: http://www.affiliated2health.com/7.html . This link will take you to our shop, and you can make a purchase using as you want the check option or the phone order option. In this case, when it is a check, I am wondering if ECWID has to wait we manually validate the payment in order to trigger the 'sale tracking pixel". To my knowledge, at this stage, in our affiliate software, we "see" that a customer was on our site, but the sale itself is not validated for a commission. Please, check yourself inside the thank you page: i tried an hour ago, and, yes, customers do get to this thank you page (it says thank you for your order, you will receive a confrmation by mail etc..). I don't see what, on the side of our site, could prevent this action; Specifically, what is strange, is our affiliation software (Idevaffiliate 7) tracks sucessfully visitors on the site, but not sales. Our site was build with BASEKIT SITEBUILDER, is there an issue with this ? Let me know, I am really in trouble with my boss who do not understand we have a paying affiliation software and a paying cart and none can communicate. Thanks a lot. Michel AERTS
  #12  
Old 01-21-2013, 02:39 PM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Quote:
Originally Posted by michelaerts View Post
Matvey; I tried to correct the space splitting the code; and I tried to use an affiliate link, nothing. You are welcome to rewrite the correct code. If you want to test the link, here is one: http://www.affiliated2health.com/7.html . This link will take you to our shop, and you can make a purchase using as you want the check option or the phone order option. In this case, when it is a check, I am wondering if ECWID has to wait we manually validate the payment in order to trigger the 'sale tracking pixel". To my knowledge, at this stage, in our affiliate software, we "see" that a customer was on our site, but the sale itself is not validated for a commission. Please, check yourself inside the thank you page: i tried an hour ago, and, yes, customers do get to this thank you page (it says thank you for your order, you will receive a confrmation by mail etc..). I don't see what, on the side of our site, could prevent this action; Specifically, what is strange, is our affiliation software (Idevaffiliate 7) tracks sucessfully visitors on the site, but not sales. Our site was build with BASEKIT SITEBUILDER, is there an issue with this ? Let me know, I am really in trouble with my boss who do not understand we have a paying affiliation software and a paying cart and none can communicate. Thanks a lot. Michel AERTS
Michel,

Thank you for the details.

I've inspected your tracking code again and as far as I can see, it has been completely changed. Now it looks as follows:
Code:
<script language="JavaScript" type="text/javascript" src="http://www.affiliated2health.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_ordernum=XXX"></script>
At the moment, it doesn't load any image, but rather contains only <script> calling. Is it how it supposed to look? What do iDev documents/help say regarding this?

Also, as you see, the code contains 'XXX' values for idev_saleamt and idev_ordernum parameters. I am sure it is not correct. I guess the order total and the order number should be set there instead of XXX .

The script 'http://www.affiliated2health.com/idevaffiliate/sale.php' that is called from this code is apparently created by iDev system and hosted on your site. I only can make assumptions regarding what variable should it receive via GET parameters. The script creators should know it more precisely. I'd recommend contacting them since they know their system best. As soon as you get the proper code, please let me know and I'll help you verifying it in your store.

Please don't get me wrong - I don't say that something is broken on iDev side or on our side. The thing is you should make sure you use the correct tracking code, otherwise our investigation will not make sense.
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
  #13  
Old 01-21-2013, 02:52 PM
michelaerts's Avatar
michelaerts michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default codes

sorry, since removing the space was not working, I tried to try another way; now, I do have sales being tracked, except it is missing the amount.
So, I will stop messing up, and here is precisely what is the affiliation software instruction for ECWID. Next I will copy and paste what IDEV suggests for general tracking pixel. I let you make testings, change codes and I dont touch anything. I was just "trying to see if another way was working.
The exact instructions is : if you want to integrate ECWID,
Ecwid
In your iDevAffiliate admin center, enable the Generic Tracking Pixel in the shopping cart integration wizard.
Admin Center: Cart Integration (menu at top) > Shopping Cart Integration Wizard
- Click the ENABLE GENERIC TRACKING PIXEL button near the bottom.
Now stop and use the following instructions to integrate with Ecwid.
1. Login to your Ecwid Control Panel and go to System Settings -> General -> Cart.
2. Enable the Tracking code on "Thank you for your order" page feature.
3. In the window that appears, place the following code.
<script type="text/javascript">
var image;
image = window.document.createElement('img');
img.src =
"http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_salesmt=%order_total%& idev_ordernum=%order_id
%";
window.document.body.appendChild(image);
</script>
Change "site.com/idevaffiliate" to match your iDevAffiliate installation URL.

This is what I did initially. Then, you told me the code was broken because of a space: I changed it, removed the space, and still, nothing. Since there was no answer from you following this, I just tried to use this code:
<script language="JavaScript" type="text/javascript" src="http://www.affiliated2health.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_order num=XXX"></script>................. and for the first time commissions were ringing on my control panel but with a processing error.
I was just exploring. If we come back to the initial code recommanded by IDEVAFFILIATE, we are back to "no reactions". I will put it back and let you look at it. But you know now: using his instructions gives no results.
  #14  
Old 01-21-2013, 03:18 PM
michelaerts's Avatar
michelaerts michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default idevaffiliate integration

I have sent you IDEVAFFILIATE code for ECWID, and I paste it again here. But below this, you will find another instruction called: Integration of Idevaffiliate for Cart Provider. I dont know if it will help you as well. First: for ecwid:
Ecwid
In your iDevAffiliate admin center, enable the Generic Tracking Pixel in the shopping cart integration wizard.
Admin Center: Cart Integration (menu at top) > Shopping Cart Integration Wizard
- Click the ENABLE GENERIC TRACKING PIXEL button near the bottom.
Now stop and use the following instructions to integrate with Ecwid.
1. Login to your Ecwid Control Panel and go to System Settings -> General -> Cart.
2. Enable the Tracking code on "Thank you for your order" page feature.
3. In the window that appears, place the following code.
<script type="text/javascript">
var image;
image = window.document.createElement('img');
img.src =
"http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_salesmt=%order_total%& idev_ordernum=%order_id
%";
window.document.body.appendChild(image);
</script>
Change "site.com/idevaffiliate" to match your iDevAffiliate installation URL.
our site is: www.affiliated2health.com/idevaffiliate
one affiliate link: http://www.affiliated2health.com/5.html
Below, are instructions for Cart Providers, if usefull to you.

Page 1 of 3
Integration of iDevAffiliate for Cart Providers
Table of Contents
1. Generic Tracking Pixel
2. Creating an API Call
3. Recurring Commissions
4. Lifetime Commissions
5. Profile Explanations & General Notes
Section 1: Generic Tracking Pixel
The most common method for integration is to use a tracking pixel in the sale confirmation / online invoice page of the
cart system.**Doing this would require the iDevAffiliate user to login to their admin center and enable the “Generic
Tracking Pixel” method.**This module will provide them with a tracking pixel that looks similar to this.
<img border="0" src="http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_order num=YYY" width="1" height="1">
When placing this pixel into the sale confirmation / online invoice page, simply alter the following items.
‐ XXX needs replaced with the actual variable that contains the sub/total amount.
‐ YYY needs replaced with the actual variable that contains the order number.
Two examples in one: idev_saleamt=<?PHP echo $_POST[‘sub_total’]; ?>&idev_ordernum={$order_number}
Note: The actual variable names and structure will more than likely be different in your system.
Final output in a browser should look something like this: idev_saleamt=99.99&idev_ordernum=test
Section 2: Creating an API Call
If you would prefer to call our commission processing file from an API file or backend processing file of some sort, you
can do so using a CURL snippet.**The only difference is you will also need to pass in the customer’s IP address.
<?PHP
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,
"http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_order num=YYY&ip_address=IPA");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_exec($ch);
curl_close($ch);
?>
As you can see, the URL being called is constructed the same as a generic tracking pixel only we’re adding the ip_address
variable as well.**Replace the following in this string.
‐ XXX needs replaced with the actual variable that contains the sub/total amount.
‐ YYY needs replaced with the actual variable that contains the order number.
‐ IPA needs replaced with the customer’s IP address.Page 2 of 3
Section 3: Recurring Commissions
To automatically generate a commission each time the customer is billed, simply call the above CURL code when the
customer is charged and continue passing in the same IP address each time.**It’s important to use the same IP address
because that is the IP address iDevAffiliate has stored for tracking.
This is the standard way of performing this task.**The alternative way to handle this task is described below in section 4.**
It's more reliable but also requires a little bit of custom coding preferably by an experienced developer.**
Section 4: Lifetime Commissions
Using the API snippet in section 2 you can modify it to handle lifetime commissions.**Rather than posting the customer's
IP address (IPA) you can instead pass the affiliate's ID number to ensure the affiliate gets the credit anytime the
customer makes a purchase or is re‐billed each month in a recurring subscription.
The example in section 2 showed you showed us this URL call:
"http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_order num=YYY&ip_address=IPA"
What we're going to do here is instead of passing the IP address we'll pass the affiliate ID, like this:
"http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_order num=YYY&affiliate_id=AID");
‐ AID needs replaced with the referring affiliate's ID number.
To know the affiliate ID you'll need to pass it to the landing page as affiliate links are clicked. This setup is here:
Admin Center: Setup & Tools > Advanced Developer Tools > Custom Functions > Pass Variables To Incoming Traffic Page
This will add the referring affiliate's ID to the landing page when the customer clicks on an affiliate link.**Example:
Incoming URL Setting:
http://www.yoursite.com/index.php
The customer will actually land like this:
http://www.yoursite.com/index.php?idev_id=123 where 123 is the affiliate's ID number.
Now what most people do is write a script to pull that ID from the URL. Set that ID in a cookie then when the customer
makes the purchase pull that ID from the cookie and set it into your own customer database. Now each time that
customer is billed go to the database and look for the affiliate ID associated with it. If it exists, call the tracking pixel and
pass affiliate_id= in the tracking pixel URL (shown above). That will tell iDevAffiliate to override all tracking logs and
simply give that affiliate a commission.
Section 5: Profile Explanations & General Notes
As you can see in the above examples, we have profile=72198 set in each URL call.**This is because we’re using the
“Generic Tracking Pixel”.**This number will never change, please do not adjust it.**72198 happens to be the profile
number associated with this integration.
Once you have this integration working with your cart system, please feel free to forward us the integration instructions
and we’ll be sure to add you to the automated drop‐down list found inside our admin center.**Once added, our mutual
users will pick your cart from the list to integrate with and we’ll provide them with the detailed step‐by‐step instructionsPage 3 of 3
needed to implement iDevAffiliate with your cart system.**Once added, the profile number will change as your cart
system will be provided with its own unique ID number.**For instance, your cart system might be assigned number 87 in
which case the code would change from profile=72198 to profile=87.
Why do the cart systems have profiles?**iDevAffiliate allows for 3 different optional variables to be passed into the
commission record and each cart system can have its own defined variables.**We pass in the profile number so we know
which cart system delivered the commission thereby allowing us to display the correct optional variable tags.**Optional
variables help customers further identify and cross‐reference the commission record to the actual purchase made in
your cart system by having the ability to add things to the commission record such as a customer name, email, etc.
To submit your cart integration instructions, please send them to jim@idevdirect.com.
  #15  
Old 01-21-2013, 03:21 PM
michelaerts's Avatar
michelaerts michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default email idevaffiliate software

To submit your cart integration instructions, please send them to jim@idevdirect.com.
  #16  
Old 01-21-2013, 03:52 PM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Quote:
Originally Posted by michelaerts View Post
sorry, since removing the space was not working, I tried to try another way; now, I do have sales being tracked, except it is missing the amount.
So, I will stop messing up, and here is precisely what is the affiliation software instruction for ECWID. Next I will copy and paste what IDEV suggests for general tracking pixel. I let you make testings, change codes and I dont touch anything. I was just "trying to see if another way was working.
The exact instructions is : if you want to integrate ECWID,
Ecwid
In your iDevAffiliate admin center, enable the Generic Tracking Pixel in the shopping cart integration wizard.
Admin Center: Cart Integration (menu at top) > Shopping Cart Integration Wizard
- Click the ENABLE GENERIC TRACKING PIXEL button near the bottom.
Now stop and use the following instructions to integrate with Ecwid.
1. Login to your Ecwid Control Panel and go to System Settings -> General -> Cart.
2. Enable the Tracking code on "Thank you for your order" page feature.
3. In the window that appears, place the following code.
<script type="text/javascript">
var image;
image = window.document.createElement('img');
img.src =
"http://www.site.com/idevaffiliate/sale.php?profile=72198&idev_salesmt=%order_total%& idev_ordernum=%order_id
%";
window.document.body.appendChild(image);
</script>
Change "site.com/idevaffiliate" to match your iDevAffiliate installation URL.

This is what I did initially. Then, you told me the code was broken because of a space: I changed it, removed the space, and still, nothing. Since there was no answer from you following this, I just tried to use this code:
<script language="JavaScript" type="text/javascript" src="http://www.affiliated2health.com/idevaffiliate/sale.php?profile=72198&idev_saleamt=XXX&idev_order num=XXX"></script>................. and for the first time commissions were ringing on my control panel but with a processing error.
I was just exploring. If we come back to the initial code recommanded by IDEVAFFILIATE, we are back to "no reactions". I will put it back and let you look at it. But you know now: using his instructions gives no results.
Thank you.

I've made corrections in the code and placed two test orders (#52 and #53). Please feel free to remove them. Here is the results of test:

1) The code wasn't contain the correct path to the sale.php file. It was 'http://www.site.com/idevaffiliate/sale.php', but it should be in your case 'http://www.affiliated2health.com/idevaffiliate/sale.php' . I suppose you just left it as is since you wanted me to check it myself. Anyway, I've edited that.

2) The extra line break again appeared in the code. I suppose it is so in the iDev instructions so I think their code needs to be corrected in that line. I've corrected it in your store myself.

3) I've placed the first order (#52) and debugged the code using the browser Developer tools. As soon as I placed the order, the Javascript error appeared:
Quote:
"img is not defined"
This error referred to the affiliate tracking code. I looked into it once again and now I see that it indeed contained the syntax error. The thing is this line of the code
Quote:
img.src = ...
refers to the variable 'img', which is not defined. I think it should be 'image' not 'img'. This error is actually the bug that prevents the data from being send from your store to iDev affiliate scripts. iDev engineers need to fix it.

4) I've modified that line a bit and placed the second order (#53). As far as I can see, all the data was properly sent. Here is the screenshot:
http://d.pr/i/gv2I

As you see in the screenshot, the corresponding <img> element has been added to the page content, which means the code works properly now. Please check whether the sale data was registered.

Please also contact iDev engineers on the matter and quote this post in your message to them. We can also do it for you. Please let us know their contact details so we can report the bug to them. Thank you.
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
The Following User Says Thank You to Matt Ecwid For This Useful Post:
michelaerts (01-21-2013)
  #17  
Old 01-21-2013, 10:40 PM
michelaerts's Avatar
michelaerts michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default

You are GOOD NEWS ! Fantastic ! I thought I would never get through. I will immediatly report to IDEVAFFILIATE engineers your excellent job ! Thanks A LOT ! Michel
  #18  
Old 01-21-2013, 11:17 PM
michelaerts's Avatar
michelaerts michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default

I Tried, (did not touch anything in the codes). Since for testing, my only way is to use either check or phone orders (I cannot keep on buying items with my credit card), of course the sale is validated but stays on hold, pending for payment, until, I suppose, we manually clear it to say "this check was cleared or this phone order is valid). It is not a direct payment: anyway, all my tests show a commission but with a Processing error: the message states: Check Your Cart Integration - The commission amount was less than 1 penny or the sale amount was not received. Do you think this happens since we are using the check or phone order, or is this an issue related to "catching the sale amount" ? Jim WEBSTER, support at Idev (support@idevsupport.com ) says so: "It's the call is being made now but the processing error means the sale amount isn't coming through correctly. So whatever variable is being used for the sale amount is wrong. I am still in trouble... can you check on this ?

Hi, you did a great job yesterday, but it seems it is half finished: I still can't track sales because the sale amount does not show. Idevaffiliate support person mentioned there must be a variable missused. Could you take a look at it: all my commissions show with a "Processing error, sale amount should be more than a penny... etc. Have you read Jim Webster (Idev support) quotes ? Thanks . Michel

Last edited by Makfruit; 01-22-2013 at 05:57 PM.
  #19  
Old 01-22-2013, 06:00 PM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Quote:
Originally Posted by michelaerts View Post
I Tried, (did not touch anything in the codes). Since for testing, my only way is to use either check or phone orders (I cannot keep on buying items with my credit card), of course the sale is validated but stays on hold, pending for payment, until, I suppose, we manually clear it to say "this check was cleared or this phone order is valid). It is not a direct payment: anyway, all my tests show a commission but with a Processing error: the message states: Check Your Cart Integration - The commission amount was less than 1 penny or the sale amount was not received. Do you think this happens since we are using the check or phone order, or is this an issue related to "catching the sale amount" ? Jim WEBSTER, support at Idev (support@idevsupport.com ) says so: "It's the call is being made now but the processing error means the sale amount isn't coming through correctly. So whatever variable is being used for the sale amount is wrong. I am still in trouble... can you check on this ?

Hi, you did a great job yesterday, but it seems it is half finished: I still can't track sales because the sale amount does not show. Idevaffiliate support person mentioned there must be a variable missused. Could you take a look at it: all my commissions show with a "Processing error, sale amount should be more than a penny... etc. Have you read Jim Webster (Idev support) quotes ? Thanks . Michel
Michel,

Sorry for the delay.

Thank you for the provided details. I've examined them.

First of all, I'd like to point out one thing. As I mentioned above in this thread, the 'Tracking code on thank you page' feature works in very simple manner: it puts the code you provide to the order confirmation page. That's all. The code is than executed by a visitor's browser. What exactly happens in the code is the thing that the creator of that code knows. Ecwid just doesn't have anything to do with that code.

In your case, the code your placed there is provided by iDevAffiliate software. It sends the data to another script that is also created by iDevAffiliate engineers ('sale.php'). So, engineers from iDevAffiliate are exactly people who are responsible for this functionality and they have all necessary tools for troubleshooting the issue. Thus I encourage you to ask them to investigate and fix the issue.

Please don't get me wrong: I will be more than happy to help you with this. I'm doing it now. But everything I can do is to make assumptions what is wrong with their code and what can be done in order to fix it. On the other hand, they can see both the codes and the data transferring between them so they can easily find and fix the route cause of the troubles you face.

As to the "sales amount" errors, here is what I think. The screenshot I posted in my previous message (http://d.pr/i/gv2I) highlight this code:
Code:
<img src="http://www.affiliated2health.com/idevaffiliate/sale.php?profile=72198&idev_salesmt=46.00&idev_ordernum=53">
The code, being placed on the page, actually does the following: it makes a request to the URL that is set in the src field. When such a request is done, the script sale.php on your server gets the request details:
profile=72198
idev_salesmt=46.00
idev_ordernum=53

It is hardly possible to say from outside how the sale.php script processes those details, but as far as I can see the amount data presents there. So, I think, possible reasons here are:
a) Maybe, the sale amount parameter name is invalid (for example the sale.php script listens to 'idev_salesamt' but receives 'idev_salesmt')
b) Maybe, the sale amount value needs to be formatted in another manner (for example, it probably needs to be '46,00' instead of '46.00')

Again, I cannot know for sure what is the reason. It would be the best to ask an iDevAffiliate engineer to look into this. Maybe, Jim Webster would be able to join our conversation here - hopefully, we would be able to get through it with his help.
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
  #20  
Old 01-22-2013, 06:34 PM
michelaerts's Avatar
michelaerts michelaerts is offline
Member
 
Join Date: Jan 2013
Posts: 33
Default

Hi dear, I read your answer, and, not being a programmer, I nevertheless think you make sense: since the sale amount appears in the code, it must be the way IDEV interpret it that must be messing up things. For instance, here is the answer from Jim Webster:I have no heard from anyone at ECWID. I understand you're stuck right now but only they are going to be able to help in that it's the ECWID system not producing the variables correctly.

Sincerely,
Jim Webster
iDevAffiliate Technical Support

Last edited by Makfruit; 01-22-2013 at 06:46 PM.
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
affiliation code

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:13 AM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.