menu inventory software menu inventory software HOME DISCOVER PRODUCTS NEWS DOWNLOADS INDUSTRIES CUSTOMERS CONTACT LANGUAGES logiciel de stock

Frequently Asked Questions Inventory Software

All answers abour inventory software

What is inventory control ?

You will find answers to the most common questions on this page.
Select the topic you are interested in, or use the page search CTRL-F of your browser.
For more complete answers, refer to the SIM User Manual.

General topics
  • SIM is best for what size of company? How many inventory items can SIM support?
  • Can I use SIM with my ERP, accounting or online store software?
  • Does SIM require an Internet connection? Can it be a mobile app or SAAS software?
  • What technology is used to program SIM?
  • Does SIM offer a cloud solution?
  • Can I manually enter my data into SIM?
  • Can I import my existing data into SIM?
  • Does SIM support barcodes?
  • Can I print barcodes with SIM?
  • Can I use existing barcodes?
  • What barcode readers are compatible with SIM?
  • How can I update my version of SIM?
  • User manual
  • Newly released options
Getting started
  • What is the most difficult part of setting up SIM?
  • How do I get started?
  • How can I keep existing data?
  • How much time does it take to implement SIM in a company?
  • Can I create references and barcodes?
  • Can I change the order of rows?
  • Can I change the order of columns?
  • Where does the last created item get placed?
Export and analyse data
  • Can I export and analyze my data?
  • Can I integrate SIM with other IT platforms?


SIM is best for what size of company? How many inventory items can SIM support?

SIM supports up to 20 workstations and 100,000 items.
There is practically no company or amount of stock that is too big or too small. Stocking capacity of the software is defined by the amount of traffic.
SIM is not designed for AMAZON-type warehouses that manage dozens of items in parallel. SIM is designed to be simple and inexpensive, the standard configuration is limited to one hundred minute operations. In 90% of cases, this is more than enough. To go beyond 10 simultaneous users, or to increase bit rates, a user would need to opt for a different technology and to switch to Microsoft SQL Server or MySQL, which allows for SIM.

Can I use SIM with my ERP, accounting or online store software?

With PRODUCTS / Export we create files that your ERP or your accounting software can read.
With TOOLS / DATA / Import you can integrate data from your software.
As an option, SIM can manage any file formats, and allow changes in one mouse click.
Other links are possible (ie. direct access to a database, Internet connection) but the file system is usually sufficient.
Please contact us to get an interface to most common App: WooCommerce, QuickBooks, SAP, Shopify, etc.

Does SIM require an Internet connection? Can it be a mobile app or SAAS software?

SIM works without any connection. The SIM.exe program and SIM.mdb data are installed on your PC or server.
There is no need for any connection, either Internet or Intranet. You can get all the benefits offline.
If your PCs are connected, they can share data through any type of connection: (ie. windows sharing, internal server or Web).
SAAS is the "rental" software that puts you entirely at the mercy of your provider.
At SOLTI we want to have a win-win relationship with our users.
We believe that selling a license is better for both parties.

What technology is SIM developed on?

SIM is developed with Microsoft. Net tools with C # language.
Despite all the latest trends that come and go, the biggest professional apps use Microsoft.
Of course, the worldwide web and mobile device apps have fabulous tools, but they are intended for consumer applications and cannot be compared, in terms of reliability with professional software.
Just ask financial traders and space industry developpers if they use Android and Javascript!
In addition to Net language, SIM uses Microsoft Office standards and SQL language that is universal for all databases.

Does SIM offer a cloud solution?

With SIM, you decide what level of security you want.
Data can stay on one PC, hosted on one of your servers, or shared via DropBox or Google Drive.
We can help you choose and install the best architecture, according to your needs.


Can I manually enter my data into SIM?

Some adopt SIM when cleaning their stock. In that instance, it is sometimes preferable to manually enter each description of the product, to ensure that your data is accurate. Another option is to simply scan everything using barcodes, and to later correct the descriptions in your data. But beyond 300 references, it is advisable to use Excel!

Can I import my existing data into SIM?

In PRODUCT tab, use the EXPORT button to create a CSV file
Open this file with Excel, add your data with copy/paste
In TOOLS/DATA click on IMPORT SIM PRODUCTS to integrate your file

You can also use IMPORT SPECIFIC PRODUCT to change the order of your columns

In case you encounter a problem, just send us your Excel file! We can help you!

Getting started

What is the most difficult part of setting up SIM?

It's psychological, often related to a resistance to change.
Stock without software can be a potential concern, an unknown area, based on constraints related to stock breaks, purchases, accounting inventory...
In fact, these concerns disappear when you no longer are burdened with the need to remember and manage references and locations.
Stock that is saved on a PC-computer becomes visible and mastered. It becomes a source of satisfaction, inspiration and motivation.

How do I get started?

You should start as soon as possible since every day that goes by without a computerized solution, means you lose a bit more of your data.
Every day that passes means you lose time. SIM usually allows in less than one hour to switch your files from an Excel-run system to a SIM-run system that allows for data storage and traceability.
You can gradually switch your data, by group or according to actual stock movements. No need to update dormant products! Whatever you do, you will always know, thanks to the history of events, at what stage of "migration" you are at. Why wait?

How can I manage existing data?

You can of course enter your references manually, one by one, checking the description and the actual quantity.
You also can, (from version 2.58) use an "injector" that accepts all Excel.csv file formats.
If this work is not to your liking, you can entrust us with your data, or a file from your files for migration assistance.
At any time, you can export your data again in .CSV format to make corrections or quickly enter data in an Excel file.

How much time does it take to implement SIM in a company?

Commissioning time depends only on you. In simple cases, SIM installation takes 3 minutes and, integration of an Excel table five minutes.
In two hours, you've forgotten the difficulties and worries of Excel.
In other cases, the implementation of SIM corresponds to a move, a restructuring, a general overhaul of the operation of your stock.
That's where SIM’s modularity is important: the transition is at your own pace, from simple to complex. Software options or modifications are closely related in real time to your work and needs.
Rotating inventories allows for progressive updates of your data.
At no time is your production disrupted by SIM.

Can I create references and barcodes?

When starting from scratch, without any product list and no existing barcode, you want to know how to create barcodes.
Here are the main points to keep in mind:

The best is to use simple numbers like 10001, 10003, ...
The one thing that really matters is that each product has a different barcode.
You will soon get accustomed to any numbering system.


Can I change the order of rows?

The database gives an incremental identifier ID. It is technically feasible to display products in alphabetical order. By clicking on the top of the column, you change the order. It is also possible to configure in the reverse order, with the most recent at the top. When exporting and then re-importing a database, the product IDs are reassigned in file order. You will see in practice that you will work a lot with the search function and that ultimately the initial display order does not matter.

Can I change the order of columns?

The order of the columns corresponds to a summary of current requests.
Certainly your Excel files will be organized a little differently.
It is however very useful for all to adopt a certain standard and very practical from a technical perspective to preserve a pre-defined structure.
You will see that after 3 days of use, you will have fully integrated the new layout.
It is however necessary to adjust the length of the columns.

Where does the last created item get placed?

A new line is created with the next available number. If you want to modify a product’s ID, you will need to export the data, sort the excel file and re-import data.
This is a way to remove empty deleted lines.
In fact, nobody really worries about line numbers or IDs, as users normally depend on search buttons and filters.


Does SIM support barcodes?

The barcode is the logical extension of computerization of stock. The barcode is a small timesaver, but above all, offers reliability and comfort in use because a barcode reader can read and memorize a reference effortlessly in less than a second. SIM is designed for easy use with or without a barcode. To optimize the use of a wired or wireless reader, regardless of the model (OPTICON brand is recommended), you will need the SIM option "Bar Code Reading".

Can I print barcodes with SIM?

Barcode printing is possible without software, with a conventional printer. However, if you want to avoid reference errors and if you want a reliable system, you should consider acquiring software. SIM can print on A4-size paper but for extensive use and quality labels, we recommend using a specialized printer. There are printers from 100€ to 500€ depending on the type of media and print quality. SIM is compatible with all printers since it uses the Windows driver provided by the manufacturer. To format labels for printing, you will need the "SIM Label" option.

Can I use existing barcodes?

If your suppliers label their products, you can incorporate their references. The "Extra Column" option allows you to manage the vendor reference in addition to yours. You can have vendor labels coexist with your own labels, in case a product doesn’t have one. With the "Multivendor" option you can even have different labels for the same reference.

What barcode reader is compatible with SIM?

Inexpensive wired readers are one option that can scan up to 5 meters away from a PC. Another option are Batch readers, which work in a two-step process: first by scanning products and storing into memory, and secondly, uploading onto a PC. A third solution is the use of connected drives. Via bluetooth, you have the advantage of an inexpensive solution but with limited range. With Wifi, you are often dependent on business computing, therefore the most reliable solution is radio connection. In most cases, a batch is sufficient. There is no "best reader". You must find the ergonomics that suits your operations and that is adapted to your budget.

Software update

How can I update my version of SIM?

SIM updates are free: if you are comfortable with copying files, you can do updates yourself, allowing you to benefit from a small bug fix or a new feature. Keep in mind that if your software is over two years old, it may have compatibility issues. To provide you with dedicated technical support, you should have either a maintenance contract, or be in the first month of software warranty. This will be an opportunity for us to verify your data, your backups, and to help you optimize your installation.

To help you, you must have a maintenance contract, or be in the first month of warranty. This will be an opportunity to check your data, your backups, to help you optimize your installation.

User manual

One problem encountered is the file extensions .mdb and .ini do not necessarily appear in your file explorer ..
For the parameter file, the icon is a gear wheel, for the database file: it is the largest of the SIM files, except the PDF file

Newly released options

Installation of new options may require a resetting of tables. It needs to follow the following three steps:

Export data

Can I export and analyze my data?

There are several ways to analyze and export your data, depending on the amount of time you want to spend and the desired level of sorting. These methods are valid on the products tab, for analyzing references and quantities, or on the log tab for movements.

In all cases, you can get a .CSV result file. With Excel, you will be able to analyze, sort, and print your data as usual.

Can I integrate SIM with with other IT platforms?

SIM easily adapts to many IT solutions.
By using Microsoft software on one of your machines rather than a hosted web server, SIM allows unlimited transfer by:

To track your online sales inventory (PrestaShop, PHP), to integrate the references coming from your ERP (SAP, Cegid, Divalto), to report the outputs to your account (SAGE, BP, CIEL) ... Ask us for a free estimate!