Pre-sale question Hikaserial

Hi,

that's my scenario:

We need to sell an Excel spreasheet with a licence of use renovable year by year. In this Excel file some cells take values connecting to a DB and we would let it connect till the license of use is active.

Can we do this with hikaserial?

Example. With hikaserial and hikashop we sell the Excel spreadsheet and the licence code. User must insert the licence code somewhere into the Excel spreadsheet and it do a check somewhere on the DB to check if the licence code is valid or not. If valid user can use the Excel file otherway not (sure this is not an hikaserial feature, we do it with a macro or something else...)

What I want to know is this. Hikashop and Hikaserial can manage always the same licence code for the same user? I mean this. User buy Excel file and licence for the first year. After one year user need to renew the order. What happens in this case? Still the same licence key or another one licence key?

Any idea or solution about how we could use Hikaserial in the better way to do this?

Thanks in advice.

I don't know exactly how data are stored into DB, so at moment I did only an hypotesis, tell me if I'm wrong or right about that.

I suppose that HikaSerial generates a "product key" associated to user order, and this value is stored into MySql DB, right?
I suppose that into another DB colum another flag value, a "key status", tells me if this "product key" is yet valid or not (suppose that this key is valid only for one year, then user must renew again, and as you told me before user will have a new key when renew)

This way we could build some script to do something like that: those 2 columns (4 maybe with the user ID and user Order) from MySql DB into a MS Access DB (this to avoid final user to connect to MYSql DB and connect to MS Access DB)

Now my excel file could do some check into MS Access to restrict access or not according to key value and "key status".

Is that possible? I mean what data will I find into MySql DB about HikaSerial?

Hi Jerome

If I use Akeeba Subscription to limit the product to 1 year and this product have also attached a serial key, what will happen to that key after Subscription expired? Will the key still active or will expire with subscription?

Oh ok, thanks Jerome.

Now I'm sure I cannot use HikaSerial for my purpose. Anyway it would be a nice feature add an option to choose if serial can expire after a certain period.

Thanks so much anyway!