For the final 6 years, I used to be utilizing a free WordPress plugin name Gocodes to handle my affiliate hyperlinks & this plugin had nearly 300+ cloaked hyperlinks. One tremendous day, the developer determined to tug this plugin off the free repo & many bloggers like me was disregarded at the hours of darkness with no way forward for this plugin.
For lengthy, I used to be caught with it & was questioning which must be the subsequent affiliate plugin that I can use. Deciding on an affiliate hyperlink administration is essential because it’s not solely restricted to hyperlink administration, it additionally meant it has to make sure your weblog doesn’t get penalize by utilizing affiliate hyperlinks & provides an advance function to assist us earn more money.
Few weeks again, I shared an in depth overview of ThirstyAffiliates plugin which is a free affiliate plugin for WordPress & provides few premium add-on. I promised you that I’ll share the information to migrating from Gocodes to ThirstyAffiliates & right here it’s.
Web page Contents
Earlier than we begin the export, beneath is the format by which I’ve to add my .csv file for Thirsty Associates.
Based on the format, we require Firm’s identify and the vacation spot URL. I’m not including the opposite columns as proper now; it’s not required. Now, let’s transfer on to how I exported one in every of my weblog Gocodes right into a .csv file.
Step 1: Choice and Copy of Gocodes into Excel
Go to Instruments> Gocodes. Copy & Paste all the info in an excel sheet. For reference, see the screenshot beneath.
Step 2: Association of the info in an organized method
As you may see above, the affiliate firms and cloaked URL are in the identical column. For instance, BluehostBF is the corporate, and http://wphostingdiscount.com/go/BluehostBF/ is the cloaked URL. I have to type it out and organize it in Three completely different columns. The first column will likely be of the corporate, 2nd Column-cloaked URL, and third Column – the vacation spot URL.
Step 3: Alternate Number of rows of Column A
To separate the Firm’s Identify from the Cloaked URL, we have to alternatively choose rows in Column A. For this, beginning in row 1, use the components
=INDEX(A:A,1+(2*ROW()-1)) for the even positions
=INDEX(A:A,1+(2*ROW()-2)) for the odd
Right here A: A is the vary that’s the complete column A. if you must do it for another Column, let’s say B, substitute A: A with B: B.
Merely paste this components in a brand new column and a brand new sheet. For reference, see the instance beneath
Right here I’ve opened a brand new excel sheet and entered the components. You’ll be able to see that I’ve added Sheet1! within the components. It’s as a result of the Gocodes which I’ve to type is in sheet1. You’ll be able to see within the earlier snapshot that I’ve pasted my Gocodes in Sheet 1. If you don’t want to repeat it to a brand new sheet, you may merely take away Sheet1!.
Subsequent, hover over the sting of the choice till you see the cursor change to an emblem with 4 arrows. Drag it. All odd rows of Column A will likely be pasted.
For Cloaked URL, Delete the column in Sheet 1 as we don’t require this.
Step 4: Unmerge Cells in Column B of Sheet 1
Choose the Column and Click on on Merge. On the drop down menu, one can find Unmerge Cells. Click on on it.
You will notice that every one the cells in Column B have unmerged as seen within the screenshot.
Step 5: Merely, Repeat Step 3.
Use fx=INDEX(Sheet1!B:B,1+(2*ROW()-2)) for the odd System.You will notice the consequence just like the beneath screenshot
Step 6: Copy this sheet into a brand new Excel Workbook & Save the Sheet as.CSV
Copy, paste sheet 2 in a brand new excel sheet. Click on on Save as > Format. Choose Window Comma Seperated (.CSV) and Save File.
Yay! You could have efficiently exported and saved your Gocodes as .CSV File.
Closing steps: Import .CSV File into ThirstyAffiliate plugins
Set up ThirstyAffiliates plugin when you haven’t completed that. The plugin is free & all you could pay is for addons (Solely in order for you it). You’ll be able to learn extra about their add-ons right here. For now, let’s simply follow transferring our present affiliate hyperlinks to Thirstyaffiliates.
After putting in the plugin, head to Affiliate hyperlinks> Settings & configure the hyperlink prefix. Ensure that the hyperlink prefix is similar as what Gocodes have. Here’s a screenshot for a similar:
Click on on Save.
Noe head to ThirstyAffiliate web site & obtain CSV importer add-on. This can be a paid addon & round a month again, I shared an enormous low cost provide with you. If you happen to missed that supply, you could purchase the add-ons at common worth. I counsel grabbing their bundle which helps you to take pleasure in extra addons.
After you have Put in & activated the CSV importer add-on, the very first thing you must do is to disable the Gocodes plugin. As soon as that’s completed, go to Affiliate hyperlinks> Import CSV
Right here you could choose the CSV file that you just created within the step 1. You may also obtain the pattern file once more & confirm the whole lot is so as. As soon as you might be positive, browse the file, Click on on Add file & import. Within the subsequent display, you’ll see the whole lot is imported efficiently. That is the sort of display that you’d be seeing:
Do click on on View hyperlink to check few hyperlinks & confirm the whole lot is completed proper.
In our case, I made two errors earlier than I acquired it proper.
- Mistake 1: My order of row was not proper so after importing I once more needed to delete all affiliate hyperlinks & restart the method.
- Mistake 2: My file was not saved in Home windows comma separated format so needed to resave it. This was straightforward & after this, the migration occurred rapidly.
Total this complete course of didn’t take too lengthy & I simply migrated the whole lot from Gocodes plugin to ThirstyAffiliates. Now, it’s time to setup all of the helpful add-ons of this plugin & I might overview add-ons within the coming days.
Go forward & comply with this fast information to migrating your affiliate hyperlinks from present WordPress plugin to ThirstyAffiliates.