Skip to content
Alternetis · Tools to simplify your daily life

Utilities for Sage 100,
Excel & PrestaShop.

Importing a stocktake, unlocking a record or preparing files: our utilities handle specific operations that take up your teams’ time.

Developed by Alternetis · Distributed on Soft-utile Softage Store

Procurement and logistics teams analyse management data
01 · Excel inventory import to Sage 100

Your Excel inventory.
Ready to enter Sage.

Do you count stock in Excel? This utility prepares a file in the Sage 100 import format, ready to integrate into your sales management system’s stocktake entry.

Excel inventory converted into file to import into Sage 100EXCEL · INVENTORYART-01120ART-0285ART-0342SAGE 100File to be imported
Excel → Sage inventory file

Stocks & inventories

  • Preparation of inventory quantities in Excel.
  • Generation of the file to be imported into Sage.
  • The sheet describes the management of ranges, lots, expiry dates and multi-locations.
In your daily lifeAfter counting the warehouse, prepare the Excel file and import the quantities into Sage, without re-entering each line.

Before importing, save your folder and check the format expected by your Sage version.

02 · User Logout Sage 100

A blocked session?
Get back in control.

A user still appears connected to Sage after their session has frozen? This utility disconnects a sales management or accounting user without restarting the server.

Targeted Logout of a Blocked Sage SessionSESSION SAGE!INTERVENTIONTargeted Logout
Session blocked → Targeted disconnection

Administration & sessions

  • Targeted treatment of a user connection.
  • Intervention on the relevant Sage sessions.
  • A tool for the administration of your environment.
In your daily lifeAfter a login interruption, a session will always appear active. Your administrator can intervene on this session.

A disconnection can interrupt an ongoing work: coordinate the intervention with the user concerned.

03 · Unlocking of records and documents Sage

A locked record.
Targeted intervention.

Unlock a record or document left locked in Sage 100 Sales Management. The utility works on the affected items without requiring a server restart.

Unlocking a Sage record to make it availableFICHE CLIENTRECORD AVAILABLE
Locked record → available record

Maintenance & continuity of work

  • Customer and supplier records.
  • Articles and families of articles.
  • Sales documents and purchase documents.
In your daily lifeA record remains unavailable after an incident. The administrator checks that no legitimate process is using it before releasing the lock.

Logout and unlock a file respond to two different situations. We help you identify the right tool.

04 · Password Recovery for Sage

Restore access.
Within a controlled process.

Password Recovery is a historical Sage password recovery tool. It is intended for authorized administrators involved in their management environment.

Sage access recovery by an authorised administratorOPEN ACCESS• • • • • •Sage folderADMINISTRATEURAuthorised access recovery
Lost access → controlled recovery

Access & Administration

  • Access recovery on supported versions.
  • Legacy utility for Sage accounting and sales management.
  • Verifying the version and context before any intervention.
In your daily lifeNeed to take over administration of an older Sage database after access has been lost? Tell us about your environment so we can assess the appropriate solution.

The original sheet mentions Sage i7 and V16 on SQL. Compatibility with a recent version must be confirmed.

05 · Rename images from Excel

Hundreds of files.
A list to rename them.

Prepare your file names in Excel and rename your images as a serial. This macro reduces repetitive manipulations when organizing a product catalog.

Rename photos with product references from ExcelPHOTOS PRODUITSIMG_001.jpgIMG_002.jpgIMG_003.jpgNAMES BY REFERENCEREF-101.jpgREF-102.jpgREF-103.jpg
Photos → organized file names

Product files & catalog

  • Mass renaming from an Excel list.
  • Organization of files according to your references.
  • Preparation of images before use in your catalog.
In your daily lifeLink the names of your photos to the references of your articles to get files that are easier to find and exploit.

It is a file renaming tool: it does not replace an Image Import module in your store.

06 · Export customers and orders PrestaShop

Your shop data.
Available in CSV.

Export customer data and orders from PrestaShop to a CSV file, to use in a spreadsheet or prepare a supplementary processing.

Export of customers and orders PrestaShop in CSVPRESTASHOPCustomers · OrdersEXPORT CSVData to be used
Shop → usable CSV file

E-commerce & data

  • Extraction of customer information and orders.
  • CSV file usable in your tools.
  • A one-time export requirement, distinct from automatic synchronization.
In your daily lifePrepare a order analysis or a work file from your store data.

The historical sheet mentions PrestaShop 1.5 to 1.6. For a recent version, let's check together the compatibility or adaptation required.

When your need gets wider

Start with a tool.
Develop the way you work.

A utility handles a specific task. When operations grow, a business application can take over.

From inventory to WMS

To organize receiving, locations and preparations, discover EasyLogistic for Sage 100 and GestMaker multi-ERP.

Explore our WMS →

From export to connection

To keep up with the exchanges between PrestaShop and Sage 100, explore PrestaConnect.

Discover PrestaConnect →

From files to data quality

To update the customer and supplier records and mass items, enrich the records and follow the controls, discover EasyUpdate100.

Discover EasyUpdate100 →
Before you choose

Your questions about our utilities.

Are these utilities compatible with my version?

Compatibility depends on the tool, the Sage or PrestaShop version and your environment. Some files are for historical versions. Tell us your version and the result you want before you decide to choose a solution.

Where to find the downloads and the rates?

The Soft-utile records show the distribution methods of each tool. The links on this page lead you directly to the shop. For an adaptation, accompaniment or a recent version, contact Alternetis.

What difference between disconnection and unlocking?

Disconnection acts on a user session. Unlocking releases a record or document that remains locked. The right choice depends on the cause of the problem and any processing still in progress.

Can a utility be adapted to the way we work?

Yes, we can study your need and the possibilities of adaptation or development. Present us the current operation, the files used and the expected result.

Let's take stock.

What task do you want to simplify?

Your software, its version and a concrete example are enough to start the exchange.