ThriveCart Webhook versus Query String.
In this video, I'm going to cover what are the differences between the web hook and the query string data that ThriveCart sends over. Now, the web hooks sends more information and it occurs on all transactions on a purchase, on a refund, subscription failure, those all get sent from ThriveCart to typically your web server or Zapier.
On the other hand, a query string is good for verifying the order in real time, is it valid or not and it only occurs on purchase. The link, there is a spreadsheet that I put together that shows the data that gets sent over and then compares the two. So let's dive right in.
So to start with inside your ThriveCar account, one way to get your data is through the web hooks. So you want to go to ThriveCart settings, API and web hooks, web hooks and notifications, view settings, and I've got a couple setup. So I want to go here, and it's basically just sends information to a web hook that you specified.
In this case, it's on my account, in my web server, it could have been Zapier or something like that. And then you by default, get query string data if you send people to a custom URL, so let's go take a look at a product. And under fulfillment you're going to want to have send them to a URL and then tell them the success URL. And then check out success page needs to be redirect to your own custom page.
So I've gone ahead and I have already made a purchase. But let me just show you what I did here, it's going to be this product here, I'm going to copy that URL and basically, I did apply a coupon. I did take the box and I think I may have taken the upsell. But all that information gets passed over.
Now what it looks like when it gets received something like this, and I've kind of made it pretty. So it's a little bit of readable. But notice this is the web hook data that occurred at 15:35:09 and then about one second later, the query string data showed up on the thank you page and let me go briefly through this but the spreadsheet gives you a little bit more insight.
I'll just say it this, frankly, there's a lot more information in the web book than there is in the query string. So let me just point out a few things that are kind of important. You get timestamps in the web hook makes sense. The query string, the assumption is that time that it occurs is your timestamp. There's more identifiers for customers, products, things like that, I know these are all consistent, I think this might be unique.
Here's a good one to point out something this is TNC, terms and conditions and the one means that I tick the box if it was a zero, that would imply that I did not. But what's interesting is this doesn't necessarily show up for all products, because it may or may not exist. If it doesn't, it doesn't show up. So in other words, you can't count on that being there.
Even address, if you don't ask for it, it's not going to show up. Email, I'm sure is going to be on every single one. Checkbook confirmation, I don't think that shows up in the query string. One thing that's interesting is this is first underscore Name and Last underscore name in the query string, its first name, last name, no underscore.
Under order, it's a little bit more structured and I should point out, this is kind of an array of data. So the first, I don't know what level is this key value pair. So event is a key and order success is the value. Now notice this ID is underneath this customer. So it just kind of embeds itself.
Down here, we've got no tax and again, I don't think that gets passed over in the query string. Total versus total string. My preference is to use total, no decimal places and then if I want to do some math, I do at the very end.
And charges identifier, this is a little bit different here versus query screen, let me go down Oh, and I know this doesn't show up in the query string, payment plan ID and payment plan name, do not.
This product or purchase map flat doesn't show up in the query string, nor does coupon information. So if you need to use those, if you need that information, it only shows up in the webhook, not in the query string. And the purpose of the query string is to verify the transaction, ThriveCart sends over this array called ThriveCart, which with a bunch of information, and they also send over a ThriveCart hash, which you can use to verify if the order is actually valid.
And save information is there not as much and for instance, they've shortened things. So this is Type, this is ID, this is Name, this is Price, this is Quantity, and this is Purchase order. And then let's take a look here, I've got two pages here, ones, the web hook data, one's a query string with my comments. So anything highlighted over here on the right hand side, and yellow is not in the query string.
So event mode, mode_int whatever that is, your secret key, which of course, you really don't want to be sent over the query string. The invoice ID, the order date timestamp are not in there. This ID i thought was interesting. I did not find that. You know what, maybe I did that wrong. But let's go take a look.
Yeah, this is only in the web hook. Email, this information shows up, and what is his Terms and Conditions IP address doesn't get sent over? Name, which is interesting, right? It's first and last that doesn't get sent over. But first name last name does, but in slightly different format I'll show that in two minutes. Checkbook confirmation, did not check box, did not get sent over. Tax, tax type did not get thrown in the query string, total string Nope. Item identifier, I think they send it maybe a little bit differently send for instance 27 product that here they basically concatenate it together, they just done some work for you in the webhook.
Payment Plan ID payment plan name, not there. Timestamp, not there, that's fine. Really no idea what this is, is this the ThriveCart specific or is it like a stripe specific piece of information since I did purchase stripe, this is just a little more details that are in the query string and this information, definitely no coupon code ID. So here's the query string data.
Little bit simplified, if you will, I've highlighted the things that are same, this is Thrive so what I'm showing you over here in column F is what it's called in the web hook. So in the query string, it's called the account name. In the web hook, it's called ThriveCart account. First Name, Last Name is first underscore Name, Last underscore name and so this is orders and then immediately it's the first order, the second order but over in the web hook data, it's orders charges then zero than one.
And I've already spelled this out, you know, this is type, its type underscore ID in the web hook, ID is reference name is name, amount is price quantities quantity, payment plan ID you know, what did I do that right? Let's go check.
Purchase Order payment plan ID Okay, so that is over there. The payment plan ID does get passed, but the payment plan name does not. So this is item name, so this is the same except for instance, they have purchases zero 27. Web hook has purchases zero season. This is purchases, one bump, webhook as purchases one ddd, which is the name that I gave it, and then ThriveCart hash, which doesn't get passed in a webhook.
That's ThriveCart Webhook vs Query String.
Thrive cart one page.
In this video, we're going to cover how to create a video sales letter using a YouTube video that will display a thrive cart checkout after a certain number of seconds have gone by. Now, it's not WordPress, you can find it at integratepro.co/one page. So let's dive right in. There's only a few pieces of information you need to provide. The assumption is your YouTube video is yours. It's a video sales letter, my recommendation is you'd probably want to make it unlisted if you're going to use that. You need to provide the URL for that you also need provide the number of seconds into that video that you want to display your thrive cart checkout. And then finally, what's the embed code for your thrive cart checkout page, and then there's some more information you can provide like your business name and some tracking code.
So first thing is let's go to YouTube and get a URL. Now because this is just a demonstration, I'm not actually going to put a video sales letter in there, I'm just going to find a mountain biking one. And which one do we want to do today? Let's try this one. All right, good enough. Now all I need to do is copy the URL back to the one page, paste that in there. And then decide how many seconds into the video that I want the embed code from thrive cart to display the checkout now might be 5,10 minutes into their you have to do the math. So for instance, five minutes is 300 seconds. In this case, only I want to display pretty quickly 12 seconds so you can see it. Now we need the embed code from thrive cart. So inside your thrive cart count, you can go straight to get URL. But first, let me show you something about the checkout page, you're going to want to use the embeddable checkout for this to work. Once you've done that you've chosen that save and get URL, copy the embed code, come back to here, paste that in. And that's pretty much all you need.
I'm going to give it a business name. And I can put some tracking code in the head section or after the opening body tag or towards the closing body tag. And I do have some code in this case that I am going to add. And then I want to click on Submit.At this point, we've created the appropriate code put on your website into a PHP file. You can download it from here, you can copy the code and paste it into a file on your site. For me, I can see a preview. So let me show you what this looks like. I'm going to click on Preview. So after I believe 12 seconds, this video is going to play and sometimes it's designed to play automatically but sometimes that doesn't work, especially on mobile.
"We are writing once again here today in the Czech Republic. It has been rainy, rainy, rainy, so hopefully the trails aren't too bad, but I heard they're mostly made out of rock. So that's good."
So there is the thrive cart embed checkout that displays right below the video. One thing you'll note whenever you pause this black overlay with the white triangle cover over the video. That way they don't get distracted by related videos or anything like that. Also, at the very end of the video, it'll show a replay button again so that they can't see the related videos or anything like that the focus is on the video and the checkout.
So that's how you build the one page video sales letter with thrive cart.
Active Campaign thrivecart RFM.
RFM stands for recency, frequency and monetary value. What we want to do is when somebody purchases or refunds a thrivecart order, we want to update their ActiveCampaign profile with that information. Recency represents how recently did the customer purchase, that's a date. Frequency is how often do they purchase, quantity. Monetary value is how much do they spend, value.
Now, good old Wikipedia gives an explanation of exactly what this is. What's highlighted in red in the first box is what I just explained. The bottom box says that recency and frequency are basically in groups, you group them into sections, and you scale it from one to 10. So for instance, one month back to month back, etc. Frequency, recency with the that frequency is how many, but they cap it at a certain value.
I'm doing it a little bit different. My data is simply analog and it's exactly what's happened. Recency is the exact date they purchased and frequency is the exact number of purchases they've made and monetary represents simply the dollar amount. Now one thing to note about the way I'm going to show you how this is done is I keep track only of purchases not have refunds and the reason I do that is because thrive card allows you to refund partially.
So for instance, somebody could buy once, get refund partial, get another refund partial, get another refund partial, so you've got one order and three refunds, that would be negative two orders. That's not right. Instead, we always increment or decrement, the value the amount of money, we only count the number of purchases, and we only date the purchases. So let's dive right in.
We're going to install a script on your website. This is not for WordPress, you basically have to copy this, paste it in, make some changes. Let's go ahead and do that. So I'm going to copy this code starting right here at the top all the way down to this last closing brace, I need to log into my hosting Cpanel account, I've created a subdirectory called thrivecary and in there, I'm going to create a file called index.php, I'm gonna go ahead and create that new file and then what I want to do is edit the file, paste in the contents there.
And I do need to make some edits and I'm going to show you there's three things that need to be done here. When we want this to go live, we want this allow test to be set to NO but because I want to do some testing, I'm going to change that to YES for now. But do remember, you want to put it back to NO so that you don't catch test transactions. We also need our Active Campaign URL and API key.
So inside your Active Campaign account, I'm gonna go down to settings, developer and I want to underneath API access, I want to copy the URL back to the file, paste it in between those single quotes for URL. Now for API key, I go back here, copy the key back to index and I do this, paste that in and now I need to create some custom fields and I would recommend I've already typed in the values I expect you to do.
And I'm going to go ahead and do that in Active Campaign buthese are the values that we're going to use. So let me show you what to do here. We want to go to lists, manage fields and then I'm going to add three fields. The first one is RFM last date and you want to just leave it doesn't matter which group you want it to be a date field. So I'm going to go ahead and do that click add.
Second one is RFM quantity and that's going to be a text input and then the last one is RFM value and again, a text input. So all of these are available for any lists that somebody joins on your in your Active Campaign account. So we've got those, so that means I don't need to make any changes to this right here, if I called it something else and let me go right back there. Notice this is the personalization tag that we need.
So RFM underscore last underscore date, which I've already done here. So really, you shouldn't have to do anything. So now go ahead and save that. Now inside our thrivecart account, we want to send information over to this script. Whenever a purchase refund, basically anything occurs, I want to go into thrivecart, I want to go to settings, API and web hooks, bottom Right.
For web hook notifications, I want to go to View Settings, I want to click on add another web hook and I'm going to call it RFM and I want to give it the URL that it's located at to my thrivecart directory that I created and it's the index dot php. and actually you do not need to specify it but I would just do that for good measure. Click Save this web hook. Now I just want to point out that we've we're allowing test transactions to occur.
So I just want to make sure it works once it works and changes to NO. Now, next thing to do is make a test purchase. So I'm going to go ahead and do here I've got a product in test mode. So I'm gonna simply going to get the URL and I'm going to go ahead and make a test purchase. And just need to click order complete or complete order and one thing to note about thrivecart, they're going to send over information that says 9900.
So that's $99 and zero cents, we could do the math or take another value that gives you 99.00. I'm going to let you do that on your side. But it's going to show up as 9900. So I'm going to go ahead and complete the order. And I've got it wrong. Thank You page. But now what I want to do is I'm going to go search for that user and notice RFM last date is today June 1 2019, I've had one order, the total value is 9900 pennies, $99.
So there now if I went and made another purchase, and guess what, I'm simply going to buy the exact same product again. Now the date is going to stay the same, it would have update, updates, but it happens to be the same date quantity should increase by one and the value should double. So now I'm up to two transactions, total value is 19 hundred ninety eight dollars is what it is.
Now let's go back into thrivecart and refund part of that purchase. So here's something you might not know I want to see my test transactions. So in the URL at the top, I go to the very end and I put a dash test, and then go ahead and hit return and notice this goes into test mode and as you can tell I'm having a bad day over here for refund.
So I'm going to go down here I'm going to click on View and I've got today's date I've done a number already and I got two transactions I'm going to do a partial refund and let's see my feeling generous or not, let's do $40 go ahead and refund that. The dates not going to change the quantity is not going to change the RFM value should go down. So the value did decrease the quantity stayed the same, and the date has not changed.
So that's how you set up Active Campaign thrivecart RFM. And in the next video, I'll show you how to use that information.
Thrivecart Foreign Language.
Any this video we're going to cover how to handle accented characters. Now, this is kind of a unique use case. So for instance, the word Stephanie, I think in French has a little tick mark above the letter E.
And unfortunately, when that gets sent over for instance from Thrivecart Zapier, it gets changed a little bit. Now while the web understands that it doesn't look right, so we want to fix that up and to do so we need to have a Zapier account of course, and we're going to put in a script in between Thrivecart and Zapier, that will clean it up and then send it on to Zapier. So let's dive right in.
Now, to start with, um, we're going to have to create Zapp and I've already done so and we're going to use it inside Thrivecart, you want to set up a webhook, type, zap, you're going to want to Well, let's just look at it. So it's a webhook we want to catch a hook and the setup and they give you the URL. So you want to copy that and save that.
And then we're going to go to Edit options do nothing, just want to continue and then we want to get to test this step and I've already done a few times so I know what's going to happen. But the next step, once we have the webhook right here, is we want to go into thrivecart go to settings and we're not going to use the built-in capability that thrivecart provides. So I think down here this big you can get connected to Zapier.
We're not using that we want to go back here, go to API and webhooks, webhook and notifications, View Settings and we're just going to create once so I'm going to give it a I'm going to call it Zapier paste in that link, right so we're done on this side. And on Zapier side there waiting for us to send it over information. We go back to test this step and I've already done this I want to do it again and I need to basically make a test purchase.
So I've got a product in test mode. I've got it right here I've got the name. Notice the little character above the letter E and I'm going to go ahead and make a test purchase.The purchase has been completed.
Now I want to go back to Zapier and I want to go down here sometimes this takes a little bit of time. So I'm going to click on get more samples. I'm looking for something there it is pulled one second ago and I want to go look at it.
If I scroll down, and I'm looking for the name notice right there. The customer name is a little messed up. It's got this ampersand all the way to the semicolon we do not want that that's just not right if I'm going to push this into my email system from on the add a step that's not going to look right. So what we're going to do different is this so next step is we need to copy a script and modify so this location, you're going to want to copy this script here that's right here.
And you're going to want want to log into your hosting account. Typically your Cpanel account and create a file called webhook(dot)php. You can put it in a subdirectory, for instance, a subdirectory called thrivecart and then have a script. And there are a file called webhook(dot)php.
Now I've already set this up. And I'm going to go ahead and I've got a temp directory and I've got a script called webhook(dot)php. I'm going to paste that in there.
And if I go back up to the top, there are a few things I need to put in here. This one is required. These other two are optional. So the first thing is I want to get the webhook URL again.
So back to Zapier, go to set up a webhook copy that go back to your webhook(dot)php script in between the double quotes. I want to paste that in there. So that's all you have to do if you want to be a little more specific.
What I'd recommend is right here list of product IDs, what is the product ID you want to have this occur on. If you leave it empty, it will work for all products in your account. You may or may not want to do that.
So let's go find the product ID inside your thrive card account. When you're editing the product, if you come up here, you'll notice that the number at the end that is your product ID. I'm going to copy that this will be the only product idea once I'm going to do double quotes and then put the number in there.
If I wanted to do another one, I might do this and say 23, something like that. So those would be the only two but if I do this, only product ID 27 can occur. And then finally, what events do you want to have happen?
In my opinion, you probably only want to have it happen when there's an order success. You probably don't want to have it happen when somebody payment fails or somebody makes a payment or somebody cancels. So I am going to recommend the pudding. Yes, here. That's it. So this script is set up.
Now we need to know the location of it because we're going to go back into thrive cart and make a modification and back in thrivecart we want to edit this webhook and I'm actually just going to go ahead and delete it and I'm going to create a new one I'm going to call it test and I need to know the URL of where I put it. Click on Save this webhook. Okay, so I gave it the wrong URL.
Save this workbook. There we go. Now this time when I make a purchase a test purchase info information will be sent directly to my webhook on my web server and it will then take that information, clean it up, send it on to Zapier, so what we can do is go back here go to test the step in just a minute after we make a purchase will pull in the new one to double check.
So I'm going to go back I'm going to put in a different email address. Click on complete order. Okay, the orders completed. Now I can go back into Zapier to check so I'm going to click on get more samples.
There's one that was pulled just one second ago and there's the name. Notice it's correct it's formatted properly I think there's another account another version down there. Let's look for the name again there's the first name this comes in useful when you want to display a customer's name on a membership site for instance so you want to make sure displays right and this is how we cover Thrivecart Foreign Language Characters.
ThriveCart slack, I'm going show you how to send over information from ThriveCart to your Slack channel. And to do that we need to set up a slack web hook and channel will also need to create a web hooks script on your server. And then we'll set up aThriveCart web hook and finally test. So let's go ahead and dive right in.
So first thing to do is you're going to have to log into your slack account from here to set up a web hook. So let's look for slack Incoming webhook. I'm going to go here, doesn't matter how you get there, as long as you're logged in. So I'm going to go ahead and click on incoming webhook integration that's what I want to do. I'm already logged in and right now saying, Where do you want to post this to, and I haven't created any channel. So I'm going to go ahead and create a channel right here calledThriveCart and I'm going to go ahead and do that could make it private, but I'm just gonna leave it as is.
And then we want to go ahead and add incoming web hook. So the important part is simply this right here, we want to copy this web hook URL and save it for what we're going to do next. So next thing to do is create a script on your server and you can copy this and make modifications, I'm going to put in a subdirectory called API and it's going to be a file called index.php, I want to paste in that URL I just copied into here and then I want to provide a secret key. This is kind of a safety feature, I don't want any people anyone trying to visit this URL and posting information.
I'm just going to put something random like that for now, I want to allow test transactions, you probably want to put this to no and I also want to put it debug so error logs information, not a requirement but if there's any issues, it's useful, I'm actually going to turn off but I definitely want to do this set to Yes, for now. So next thing to do is going toThriveCart and set up a web hook.
So I need to know my secret key, I need to know that directory or the location and I'll show you what's next. So go into yourThriveCart account, you're going to go to settings, API and web hooks, web hook and notifications and you want to add another web hook or create the first one I'm going to call it slack and I want to go visit the URL just to make sure it doesn't right there.
So there and I also want to append my secret key secret equals go back to the script I want to copy that secret key now back to the browser. Now nothing should show up there, so let's go back toThriveCart and paste that link in there and I'm going to go ahead and click on save this web hook let's go take a look at slack so there's myThriveCart channel I'm going to go ahead and make a test purchase and I should have some information show up here shortly.
So let's go get a product and it's going to be in test mode so we're gonna go ahead and make a test purchase and they just heard the data from slack and there we go. We've got a new message it shows what happened on all the details of the customer the amount of money they spent everything so that's how you can connect ThriveCart with.
Thrive cart multiple success URLs.
We're going to show you how to redirect your customer to a specific URL based on what they purchase. So this is good if you're using your own custom success page, not the default thrive cart page and you have a bump offer and or an upsell or down cell, this could be useful. We're just going to show you the case where you have a bump offer.
This will require some custom code on your site. In other words, you have to start install a PHP script on your server and then make a change to the success page. So let's dive right in. So inside your thrive card account, you want to edit the product of interest. And let's just kind of walk through the default conditions. So you'll want to have a URL specified that people go to when they make a purchase. And additionally, under checkout success page you're not going to want to show the customizable, you want to redirect, but just for the purposes of education, let's start with that because what I want to do is show you what happens when you have a bump offer.
So I'm going to say this, and then I'm going to go back to fulfillment. Now watch how this is a little bit different. So I now have this link right here. I'm going to call this bump and if I'm using a custom customizable checkout page, I will see a link to both of these. But if I use the redirect my custom page, I'm only going to get this link. So let's just check out to make sure success page is customizable. Okay, let's do a test transaction.
So I am not going to worry about that. I will take the bump, actually, let's start by not taking the bump and show you what happens here. So there's the link and I'll just go to it should go to example /main does. Now if I go back and take the bump offer I'm going to get two links on that page. And so there's the one for the main page there it is right there. And here is the link for the bump and there it is right there but that's not really what we want to accomplish.
So to make this work we're going to have to make some changes. So we're going to leave check or actually going to modify check it success page to my redirect my custom page and then fulfillment we're gonna have to save these and I don't really need that and I do need to have this redirect to my own page and I've already set this up in here but I recommend having a folder called thrive cart and then in there you can set up this script so I want to have that I'm gonna go ahead and save that URL I guess I gotta put something there even though I don't really want to. I'm going to save that URL and this is the code I want to copy so copy this code create a folder in your server called thrive cart in that folder. Create a file called index.php in that file paste in this code. Then you want to change the URL main and URL bumped obviously you do want to go to example.com but put something appropriate based on their purchase. So let's show you what that looks like in action. So this time I'm going to first I will just take the normal offer and I'm not going to take the bumps so that should just take me to example.com/name and it does. And this time if I take the bump offer it should go to example.com/bumpand it does
So in thrive card that's how you handle multiple success URLs.
Thrive cart query string.
In this video we're going to cover how to use thrive cart customer information on your site that can be sent over, and to do so you're going to make the assumption that your thank you page is on a WordPress site and we're gonna want to use the URL parameter plugin however we need to make some modification so the link at the bottom is exactly what you need after you install the URL parameter plugin.
So let's dive right in. First things first, inside your thrive cart account, you can actually exclude the personal identifiable information from being sent over to query string. If you do that what I'm about to show you won't work but let's make sure we understand how it works. So under legal and compliance, you want to click on view you want to click on exclude pie in my case I'm not excluding it.
So if I take this box I can select what countries are all countries are only countries within the EU and I can also specify all products or certain particular products. So I am not going to turn this on because I don't want to exclude it.
Now you're going to want to download and install the URL parameter plugin. And then we'll make some modifications to it so that it works the way we want. And to do so you're going to want to come over to this link here which should be somewhere readily available. Copy this code starting from the top all the way to the bottom. And just for reference, let me show you what's been added this line here and then this function right here has been added. But really the the work is being done right here. So the information sent over in the query string. It's the thrive cart customer email, first name, last name is being returned. There's other pieces of information that you could add to this but those are the basics.
And then for instance on your thank you page that you're going to send a customer to you're going to want to add this to display for instance first name, this is last name and this is email and notice I'm in text mode when I'm doing this this is a little more challenging to do with page builder type themes, and so the plugin is right here so you go to Plugins editor, find the URL parameters and then replace what's in there with what I just showed you.
So let's go ahead and make a purchase, I'm going to go into here and I want to make sure I'm sending it to the right location so if I go to fulfillment. This is a success URL, that's the WP thank you page there's the WP thank you page with the thrive cart information embedded, and let's make sure the customized is set to redirect to your custom page.
I'm going to do a test transaction, and notice the query strings up here and we're printing out the first name last name and email address.
So that's how you use the thrive cart queries dream to display content on your site.
ThriveCart Geodetect. In this video I'm going to cover how to display different thrive cart checkout based on a visitor's locations, specifically their country location. Now for this to work, we're actually going to need a WordPress site. And there's a very specific plugin, there's multiple plugins you could use, we're going to use the geo IP detect plugin. And then at the very bottom is showing basically the the short code that you're going to need to embed on your page that you want to display the checkout. So let's dive right in.
Inside your thrive cart account, you basically need to have two products as it is right now, one for price in a certain country, and one for price in a different country. In this case, we're going to have a Canadian product. And then we're going to have everybody else who will then pay in US dollars. So all I'm going to do to start with is duplicate the current product. And I'll show you what I'm going to change.
And that's it. So I'm going to want to copy this code. But before I do that, let's go to WordPress and setup our plugin. So this is the WordPress plugin we're going to use, it's free. And for the purposes of what we're trying to accomplish, it does exactly what we want, so install that on your WordPress site. Now, one thing I would suggest is in the options for this plugin is you want to use the automatic don't download an update. And then you want to disable caching a page that has the short code because you don't want to display an old page, for instance from the US visitor versus a Canadian visitor. So you won't have those options enabled. And then on the page, you want to display the thrive cart checkout, you're going to use this code right here, or some variation of it. In this case, it's specific to Canada. So anything that fits in here will be for people that are from Canada. Anything that displays here will be for anybody that's not in Canada, notice the not underscore.
So for the US praise pricing, I'm going to put that code right in here. So I'll go back to thrive cart copy this code. I'm going to go in here, paste this code in. And one thing to note, I'm using the text editor, I'm not using anything beyond the Basic Editor in WordPress, this can be a little bit challenging with the page builder type themes that are available. It's doable, but it's a little more work. So this is the US pricing. Now I'm going to go back and I'm going to get the Canadian pricing. So I'm going to go ahead and copy the Canadian pricing and paste it right in here. So now I want to actually make sure it works.
So once for Canadian ones. For Non Canadian, I'm going to change it to US because that's where I'm based. I want to be able to make sure this works properly. So actually, I'm going to display the Canadian pricing here and the US pricing here. So watch what happens here. So the first time I'm going to go ahead and update it. Now I'm going to see and actually let's change this I'm going to put the US pricing where it should be for me. So I should see US based pricing because I'm in the US. So there it is. Now I'm gonna go to a proxy server and this is going to be in the Netherlands. So I'm going to go ahead and paste this in. So it's not US, right. So it should show the Canadian pricing, and there it is. That's how you can use geo detection with thrive.
IntegratePro ThriveCart MRR Install. In this video I'm going to show you how to install the integrated pro thrive cart monthly reoccurring revenue script you want to visit that link right there at the download link you're going to download zip file on your web server created database then you want to upload the zip file extracted to your web server and then run the installation script.
So let's dive right in. From the download page you want to click on Download integrate pro will be a zip file that gets downloaded. So the next thing you want to do is go to your web host provider and a lot of hosts have cpanel you want to go here and log in. Now go to databases, create a database if you don't already create a user. Now make sure you assign that user to that database and apply all privileges.
Okay, now you want to go back to cpanel click on File Manager or somehow you need to upload the zip file you just downloaded. So go ahead and extract that it will create an integrate pro folder. Now you want to go visit that folder on your site and run the install script.
First thing we'll do is check to make sure your servers configured properly instructions on what you need to do if for some reason the automatic to install doesn't work. It'll tell you what to do, which is basically edit a config.php file and include the credentials for your database so the database name goes here and then click Submit and then you're going to want to add your email address here. And there, it's installed and that's how you install the integrate pro thrivecart MRR script.
Thrivecart recurring revenue, let's talk about monthly recurring revenue. So I'm going to show you a script that will take all your ThriveCart data and normalize it to monthly results, doesn't matter if it's daily, weekly, every two weeks, monthly, quarterly, every six month, or annual subscription data it'll normalize it down to monthly recurring revenue. So rather than get into the theory let me just show you how it works let's dive right in.
The way the scripts works is, you wanna going to want to go into your thrivecart account to get started and click on Download CSV from your transactions, get all your history and then come back here upload it, submit and we'll put it into a database. If for some reason it's too large you're going to want to put that CSV file into the directory that this is installed it will find it and upload it from there. So after that's taken care of, you're going to set up a web hook inside thrive cart to call back to this script or send information in the scripts are automatically updates going forward.
Next step is products, you have to define which products you want to use by telling it which which has a subscription, or do you want to exclude it. So this product here, I don't recall, but I definitely want to exclude it from my results. If I scroll down to the bottom, these are down here are one time products, they are not subscriptions. So they get put at the bottom. There's nothing to do it. They're just there for reference.
So this is the product name. This is the product ID. This is the currency. I've also excluded this. This one right here is a monthly this one I haven't added. I think I've got one annual that I'm listing here. Everything else shows up this month. So the reason I do that is for the next step. So when I define reports, singular or more than one I have to have already told it what type of subscription it is, or what's the length is subscription. So those are the only ones that show up here as available.
Give a report or I mean optional description, give it a priority. The lower the number, the higher up it shows on your screen. In other words, the more important one and then you can select one or many. For instance, you can come in here you can make an adjustment. For instance, I'm going to edit this and I want to just point out you can mix annual with monthly six month it will normalize the results for it will do the math. So for instance, if it's an annual product and it gets purchased, let's say on January, the money will get split up 12 ways across the next 12 months. I'm going to add another one in here, I don't know let's put this one in with that along with the annual so I'm going to choose both of those. I'm gonna leave it as is go ahead and update it.
So now I blended monthly and annual into this other report. So I've got very important to find. Now the only thing I have to do is just log in and check the screen and I'll be honest here I've kind randomize the data. So it might make it might not look right if you're paying attention because if you know I just got one subscription, it should be flat. But for instance, this isn't flat, that's it really should be close to flat, I'm just randomizing the data. So this is the first one, which I said was exclusively monthly only, and it reports your revenue per month. This one is a combination of annual and monthly, and I want to point out something Today is September 2018. But notice this shows December 2018, that's because this annual product was purchased on December of 2017, and then it got spread out over 12 months.
So you may argue that well, you can count this yet, but it has been spent and if it gets refunded, it'll it'll assembly get removed from this view all. That's how you can display monthly recurring revenue from ThriveCart.