Dumping serial numbers to WP database

[ozfader]

I’m selling digital products which require authorisation. My programmer says the easiest way to do this, for both myself and my customers, is to automate the process, however that requires unique serial numbers being added to the WP database. I have generated random serials and placed them in eStore’s Serial Number/License Key Setting’s field, however I am lost as to what happens next. My coder sent me this email below…

We need 2 things for authorizer to work in full auto…

1. send serial # to client

2. save serial # in database

#1 is confirmed #2 for confirmation???

We need a record of the serial in the database for the authorizer to get owner details of serial otherwise the authorizer will have nothing to compare the serial number to determine if it is valid or not unless, of course, you are willing to enter serial number manually in authorizer database. This is the semi auto method I was talking about in my prev email, you enter serial number in authorizer database and on first run EA will check serial validity and if valid it will tie it to user’s PC mac number. The full auto method requires an existing record of serial number, in wordpress estore database, so authorizer can just cross check serial number there (no need to manually enter) tie it to mac number and record it in authorizer dbase with other owner infos. In your test purchase can you see a record of serial number z5fhAKmV9NYf8vSx in eStore database or purchase records? I’m about 80% sure that eStore saves serial number to dbase but need to confirm

My question is, can I use the fully auto method, or am I restricted to the semi-auto method?

Thanks…

[admin]

Yes, estore plugin does save the serial number is the customer database. So you can see which serial key/number was issued to which user.

What is this authorize thing you are talking about?

[ozfader]

Thanks, that helps greatly. Just to let you know, the email notification from this forum isn’t happening for me. I have to keep checking back for replies.

To answer your question re ‘authoriser’: I’m selling Forex trading software. To prevent sharing, the software is locked to a particular machine or machines using MAC address. My programmer’s explanation below will be better than mine…

After user has paid, you simply send them the serial number which they will enter in EA and on first run EA will check wordpress database for serial number and, if found, it will automatically register (write) serial number and MAC to authorizer database and lock serial/mac number to user’s machine. This will only work if serial number is registered in WordPress sql database so will need to check this to confirm.

[wzp]

…the email notification from this forum isn’t happening for me.

At the top of this page, click the “Add this topic to your favorites” link.

…After user has paid, you simply send them the serial number which they will enter in EA and on first run EA will check wordpress database for serial number and, if found, it will automatically register (write) serial number and MAC to authorizer database…

Whose “WordPress database” is being checked? The developer’s? Yours? The instructions need to be a little more clear. And if the database is on your site, are we talking about providing access to eStore’s serial number table, or some other table? You need more explicit directions from the developer. You can tell your developer that the serial number that gets issued to a customer is stored in the “wp_eStore_customer_tbl” database table (along with other details of the customer).

Is is possible for you to simply provide, in advance, the list of serial numbers to the developer? That way, as they are sent out by eStore, the developer has them ready for use.

[ozfader]

Thank you. I have sent my programmer a copy of your reply.

[ozfader]

Okay, I got this working (or so I thought), but another issue has arisen. Serials allocated to a free product are not being stored in the “wp_eStore_customer_tbl” database table if they are manually checked out.

If they are routed through the PayPal gateway they are fine. Squeeze form free purchases are also stored, but without serials (none are required). Because I have existing customers who are due free versions of the product that DOES require serials, I’m at a loss as to why they aren’t being stored. Any ideas?

Secondary question: As the serials have been allocated to the customers already, am I able to manually enter the members and serials into the WP MySQL database?

Thanks…

[ozfader]

I have manually added the serials to the database and that is working fine now. I just need to get an answer to how I can store the twin serials (in the format “111111 and 222222”) automatically into the WP database, using manual checkout.

Appreciate your help…

[admin]

Use the correct manual checkout setup according to what you need:

https://support.tipsandtricks-hq.com/forums/topic/wp-estores-manualoffline-checkout-methods-how-manual-checkout-works

[ozfader]

I’ve been using Option 2 below. It works in that it sends the notification email with product link, and distributes the serials to members. What it doesn’t do is automatically store these serials in the database. I’m having to do that manually.

Unless I’m missing something here…

[admin]

Yeah that option will save the serial key also. Have you checked the “Automatically Update Customer & Products Database” option in the manual checkout settings?

[ozfader]

Sorry, I got sidetracked on another issue.

I thought I had checked the “Automatically Update Customer & Products Database” box, but when I looked, it wasn’t. Hopefully it was that simple mistake…

Thanks for your help.

[Author]

Posts