IntelliScan

Make inventory changes and price of a fast and convenient way on your mobile device with IntelliScan.

The IntelliScan is fully integrated with the ERP IntelliShop used by customers IntelliComm Computer LTDA, but the application can be used by any user.

Just use the same input and output file format to integrate the solution with your own system.

Input / Import: file in .db format (SQLite database) with the following structure:

Table with all products generated.
CREATE TABLE [PRODUCTS] (
  [COD_BARRA] NUMERIC (15) NOT NULL,
  [COD_PRODUTO] NUMERIC (6) NOT NULL,
  [NOME_REDUZIDO] varchar (30)
  [PRECO_1] NUMERIC (9, 2)
  [STOCKS] NUMERIC (18, 3) DEFAULT 0,
  [CUSTO_ATUAL] NUMERIC (9, 2) DEFAULT 0,
  CONSTRAINT [] PRIMARY KEY ([COD_BARRA]));

Table with changes made by the user. This data will be populated and exported by the application.
CREATE TABLE [PRODUTOS_ALTERADOS] (
  [COD_BARRA] NUMERIC (15) NOT NULL,
  [COD_PRODUTO] NUMERIC (6) NOT NULL,
  [NOME_REDUZIDO] varchar (30)
  [PRECO_1] NUMERIC (9, 2)
  [QUANTITY] NUMERIC (18, 3) DEFAULT 0,
  [STOCKS] NUMERIC (18, 3) DEFAULT 0,
  [CUSTO_ATUAL] NUMERIC (9, 2) DEFAULT 0,
  CONSTRAINT [] PRIMARY KEY ([COD_BARRA]));

control table with the date of generation of the files and the version of the generator program.
CREATE TABLE [GENERATION] (
  [DATE] DATETIME NOT NULL,
  [VERSION] varchar (30) NOT NULL);

Output data / Export: File format with the .json products with the following structure:
{
    "products":[{
            "BAR" "7896436100628"
            "PRECO": 3.9,
            "QTY": 200
        },
        {
            "BAR" "7896436100628"
            "PRECO": 3.9,
            "QTY" 2300
        },
        ...
    ]
}.