Hello Marlon.

Thank you for your purchase.

The import will not work with numbers this big because the int in MySQL is 4 bytes long so the maximum values are -2.147.483.648 and 2.147.483.647. If you have values below 2.147.483.647, you can see in your table that numbers below that are inserted correctly. This is the INT limitation of your database, and technically it is linked to wpDataTables as well, because we're telling the code to insert the data as INT, not BIGINT.

You can take a look at the limits here.

Here's what you can do:

Go to ../wp-content/plugins/wpdatatables/source/class.constructor.php and around line 117 you'll see this:

if ($isMySql) {
            $columnCollate = '';
            $columnTextType = 'TEXT';
            $columnIntType = 'INT(11)';
            $columnDateTimeType = 'DATETIME';
            $nullable = '';
        }

Change 'INT(11)' to 'BIGINT', so it looks like this:

and after that you will be able to use large numbers.