Needing to delete affiliate data and start over

[Sherig]

I am having a problem with my affiliate program. Several months ago I moved my complete shopping cart and affiliate program over to my main site (www.sherigraham.com). I thought everything was fine, but recently found out that the affiliate program is not tracking sales.

I even went in and deleted all my affiliates thinking that having my affiliate sign up again would fix it. When I go to set up an affiliate account it tells me that there is already an affiliate by that name. It is almost like it has kept all the information even though I deleted and reinstalled the plugin.

Is there a way that I can totally start over with the WP affiliate plugin? I need all the data deleted so that I can start fresh.

I have really liked the WP Estore, WP Affiliate, and WP eMember plugins and don’t want to even think about switching. I know there must be a way to work this out.

Any help you can give would be much appreciated!

Thanks,

Sheri

[Peter]

If you want to completely erase all WP affiliate data do the following:

1)Firstly de-activate and delete the WP Affiliate plugin.

2) Then use PHPMyAdmin and “Drop” all tables which have a name starting with “wp_affiliates…”.

3) Then download and install a fresh copy of the Affiliate plugin as per this link:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

[Sherig]

Ok…I did everything you stated here, but I am still having a little problem. After installing the plugin again and activating it, I went in and signed myself up as an affiliate to test it out. After I filled out the form and submitted it to become an affiliate, it comes up with this message at the top of the form:

“Affiliate ID already exists, please choose different Affiliate ID!”

The wierd thing is that when I go to the “Manage Affiliates” tab in my dashboard, it shows my affiliate account. So it looks like it is allowing the new affiliate to sign up but giving that error message for some reason.

Any ideas why it would be doing that? Oh..I should say that when I signed myself up in the affiliate form I clicked “Check Availability” when I typed in my User ID and it said it was available.

Please help! This is going to totally confuse my affiliates when they sign up if it keeps giving them that error message.

[Peter]

I have heard of occasions where another plugin can cause issues by sending multiple POST submissions.

Can you please try the plugin conflict test as per this:

https://support.tipsandtricks-hq.com/forums/topic/test-to-identy-a-conflicting-theme-or-plugin

Another good way to find out if the duplicate post issue is happening on your site is to use Option 1 of affiliate area mentioned in the following documentation:

http://www.tipsandtricks-hq.com/wordpress-affiliate/setting-up-the-affiliate-viewarea-315

If you don’t see the issue when using option 1 then that will confirm it.

[Sherig]

Ok…I used the link as per Option 1 mentioned above and signed myself up as a new affiliate and it worked just fine.

So that means that it is either the theme or a plugin that is causing the problem?

I think I will just change and use Option 1 instead of going to the trouble to try to figure out which plugin is causing the problem.

Thanks so much!

[Sherig]

I don’t suppose there is any way I can retrieve my affiliate list since I deleted the files in the database?

[admin]

You don’t lose your affiliate records or settings when you delete the affiliate plugin and upload a new copy. So when you say you deleted the files in the database, do you mean

1) “you just deleted the plugin folder”

or do you mean

2) “you deleted the records in the database”?

If your answer is 1 then the affiliate account is still there. If your answer is 2 then the record is gone (you will need to create another affiliate account).

[Author]

Posts