Step 4: associate your compiled workbook EXE files

The integration kit was designed to support multiple Excel workbooks at once. So, you must install the kit only once on your server even to manage multiple workbooks.

All the parameters of your Excel workbooks must be configured in a file called workbooks.json in JSON format.

You will find a template of the file in the “inc” directory of the application. We will see how to configure it in the following steps.

1. Navigate to the “inc” subfolder and edit the workbooks.json file stored on your server.

Once again, check that the workbooks.json file cannot be accessed publicly (the .htaccess prevents end users from accessing it) because this file contains sensitive data for generating activation keys!

2. Here is the content of the workbooks.json file:

{
    "products": {
        "31": {
            "title": "My workbook title",
            "xlspadlockprivatekey": "{a04deb75-5288-4e0d-9254-58d44b63ecd4}",
            "xlspadlockmasterkey": "765DEB91C5886835F7E8740E72",
            "variations": {
                "32": {
                    "usehardwarelocking": 1,
                    "maxactivperorder": 2,
                    "keymaxdays": 180,
                    "shownagscreen": 0
                },
                "33": {
                    "usehardwarelocking": 1,
                    "keymaxdays": 10,
                    "maxactivperorder": 1,
                    "shownagscreen": 1
                }
            }
     }
    }
}

“products” is a mandatory section. Do not change the value. The schema used is the following:

{
    "products": {
        "product ID": {
                …
                "variations": {
                "variation ID 1": {

It is quite possible to define several products and therefore several Excel workbooks identified by their product ID (value automatically assigned by WooCommerce when you add a product).

Similarly, for each product, you can have several variations and configure the WooCommerce Integration Kit to create activation keys dedicated to each product variation.

For example, you can have a “trial version” variation with a nag screen and a “registered version” variation for the same workbook that only lasts one year before mandatory renewal.

Many possibilities are available.