I am wanting to update/change subscription plan of one plan to another.

Can't do it with the import feature. Am I missing something crucial that allows me to do this?

Otherwise I was just going to write a SQL query to do this. I just need to study the schema of CB subs tables to know all the columns/fields to change the id's of.

Post edited by: krileon, at: 2010/05/21 20:35

Is jos_cbsubs_subscriptions the only table I need to update to batch change one subscription to another?

So something like:

[code:1]UPDATE jos_cbsubs_subscriptions SET plan_id = '2' WHERE plan_id = '6';[/code:1]

Maybe that will work?

Post edited by: ahouchens, at: 2010/05/21 15:07

I also realized that if there was a "delete all" subscriptions button, I could use the Import feature. Is this button hiding anywhere?

I ran query to update the subscription status that I posted previously. It worked!

Now I noticed the Import feature in CB SUBS completely failed when trying to import with the single line of IDS feature. This I think is a bug, because the end result was creating duplicate subscription plans for users.

Now I am having to perform mysql queries to repair this table.

Good thing I'm an intermediate developer.

I am going to be executing:

Deleting Duplicates with Unique Keys in the table.

Post edited by: ahouchens, at: 2010/05/21 16:41