Woocommerce License Manager - Bulk Edit

[DanH]

I need to update a few hundred licenses. There doesn't seem to be a good option within the License Manager plugin (that we all use), nor a 3rd Party plug-in to help with this.

So I've gone into myPHP and grabbed a csv export of the database. So far so good, I can edit what I need to and resave the csv.

But.... Before I nuke my license database does anyone have any experience of this kind of thing?

What am I getting myself into? Is it safe to import a new table into the database? Is a csv file even a table? Will I duplicate the licenses? Help!!!

[ustk]

@DanH Not really experienced, but I'd do it in a staging environment to first test if the changes are working as you want

[d.healey]

@DanH what change do you need to make?

[DanH]

@d-healey I need to increase the maximum amount of activations. Super simple. I'm just scared of importing the edited file back into the system.

[d.healey]

@DanH I'd do it with a php script, but I'd still test it on a separate test server as @ustk recommends.

[Dan Korneff]

@DanH for these things I'm editing the database directly with phpmyadmin. Definitely backup your database beforehand.

[DanH]

@Dan-Korneff I've got 400 lines to edit - is there a practical way to do it in myPHPAdmin?

[Matt_SF]

@DanH you can do it using a SQL command ('UPDATE') . I'm not an expert but you can easily Google it.

[DanH]

@Matt_SF Thanks, I'm going to abort, seems too risky!

[Matt_SF]

@DanH Test it on a staging environment! You can then decide to do it or not

[oskarsh]

@Matt_SF real devs only test on production.

My advice is to test on a Friday evening as well and take the weekend off

[DanH]

@oskarsh

@Matt_SF I just can't be bothered to set it up. Did it manually.

Out of interest what's the best method to set up a staging area?

[d.healey]

@DanH said in Woocommerce License Manager - Bulk Edit:

Out of interest what's the best method to set up a staging area?

I just have a clone of my server running on my proxmox system. Some web hosts provide a dedicated staging system that allows you to test changes before automatically pushing them to the live server, I prefer to do it manually though.

[oskarsh]

@DanH
If you have a decent hoster you can just hit the staging button and it automatically copy over your setup to a new server.

If this is not available for you. Contact support and get a new dedicated server migrated by them professionally.

If none of these are available you will need to buy a new WP hosting package, then use one of the numerous export Wordpress plugins to that will export all your wordpress setup and data. Install the same plugin on the new clean wordpress and import your setup.

CAUTION - please do good research for the export plugin here since you are dealing with customer data, this will also probably cost some money.

@d-healey my recommendation is usually not to do this manually. In your case its fine since its a super minimal setup with good plugin choice but for the average wordpress user it causes more trouble.

[d.healey]

@oskarsh said in Woocommerce License Manager - Bulk Edit:

use one of the numerous export Wordpress plugins to that will export all your wordpress setup and data

If you're going this route then follow this video - https://www.youtube.com/watch?v=tIurrwfsCOg&t=22s

[Matt_SF]

@DanH i've had this plugin for quite some time, because my host back then didn't offer a staging environment, and I was a complete beginner : https://wpvivid.com/
I don't use it to push the changes I'm making, but it's a wp plugin so it's an easy-to-use solution

[Dan Korneff]

@DanH you can do it with a single line of code. Do you know the table and key you want to change?

[DanH]

@Dan-Korneff I've got the name of the table yep. I need to change the maximum activation amount on a specific product id.