Expiration Date Manager

Welcome to the Expiration Date Manager, the new and improved version of the "Expiry Date Checker" app (which can be found here: https://help.aronium.com/hc/en-us/community/posts/360000265571-Expiration-date-product?page=3#comments). This powerful tool helps you keep track of product expiration dates, preventing waste and ensuring your inventory is always fresh. This guide will walk you through setting up and using all the new features.

1. What You Need Before You Start

To use this application, you will need two things:

An SQLite Database File: The application reads data from a specific SQLite database (.db, .sqlite) generated by your point-of-sale or inventory system. Make sure you know where this file is located on your computer.
(Optional) CallMeBot API Keys: If you want to receive notifications on WhatsApp or Facebook, you must sign up for the free service CallMeBot and get your API keys.
- For WhatsApp: You will need your API key and the target phone number (including country code).
- For Facebook: You will need your API key.

2. First-Time Setup (Very Important!)

The first time you open the application, you must configure it in the Settings tab.

Database Connection:
- Click the "Browse..." button.
- Find and select your SQLite database file.
- Once selected, the application will automatically try to connect. If successful, the "Invalid Database Path" message at the bottom will disappear.
General Configuration:
- Shop Name: Enter the name of your store (e.g., "My Shop"). This name will be used in notification messages.
- Warning Threshold (Days): This is the most important setting. It determines how many days in advance an item is considered "expiring soon." For example, a value of 7 means any item expiring in 7 days or less will be highlighted in yellow.
- Rows per Page: Choose how many items you want to see on each page in the main list (25, 50, or 100).
Notification Configuration (Optional):
- Enter your WhatsApp target phone and WhatsApp API key from CallMeBot if you want to use WhatsApp notifications.
- Enter your Facebook API key if you want to use Facebook Messenger notifications.
Save Your Settings:
- Scroll to the bottom and click the large blue "Save Settings" button.

3. Using the Expiration List

This is your main screen for viewing inventory.

Viewing Data: The table shows all items from your database, sorted by the soonest expiration date first. Unlike the old app that used the description field to enter the expiration date, this one gets the date we entered when we purchased the product, so there's no need to enter anything in the description field.
Column Meanings:
- ID: The unique product ID from your database.
- Item Name: The name of the product.
- Expiration Date: The date the product expires.
- Days Left: How many days are left until the expiration date. 0 means it expires today or has already expired.
- Status: A color-coded status for a quick overview:
  - Expired (Red): The product has passed its expiration date.
  - Expiring Soon (Yellow): The product will expire within your "Warning Threshold."
  - Good (Green): The product is not expiring soon.
- Info: Click the blue (i) icon to see more details about an item, such as the quantity and purchase date.
Searching and Refreshing:
- Use the search bar at the top to quickly find an item by its name.
- Click the Refresh Icon to reload the data from your database.
Navigating Pages:
- Use the arrow buttons at the bottom-right to move between pages if you have many items.

4. Sending an Expiration Report

This is the most powerful feature. You can send a summary of all expiring and expired items directly to your phone.

Click the "Send List of ALL Expiring Items" button at the bottom of the "Expiration List" tab.
A small window will ask you to choose between WhatsApp and Facebook.
A confirmation window will appear, showing you a preview of the exact message that will be sent.
Click "OK" to send the report.

The report is automatically generated based on your settings and will separate items into two lists: "expired list" and "soon list".

5. Advanced Customization (Settings Tab)

You can customize the application even further in the Settings tab.

Notification Templates:
- You can change the text of the report messages. Use the "Insert Placeholder" button to add dynamic data like {shop_name}, {expired_list}, and {soon_list}.
- Bulk Report Main Message: This is the overall structure of the report.
- Bulk Report Item Loop Format: This controls how each individual item looks within the list (e.g., • {item_name} (x{item_quantity}) - Exp: {expiration_date}).
Appearance:
- Use the Theme dropdown to switch between Light and various Dark modes to suit your preference.
Language:
- Change the application's display language. You can even customize existing translations or add new languages yourself!

Remember to always click "Save Settings" after making any changes.

Download link: https://mega.nz/file/8E0EyTKI#_VE37gLCnJTbpGT215H7XeBZAauAu5Am6WG2lGyfuXg

John

December 09, 2025 22:04
Edited

Hey everyone,

I have finalized a minor update that introduces two key reporting improvements:

PDF Export: Allows you to generate clean, print-ready reports for documentation.
CSV Export: Enables raw data export for further analysis in Excel or other spreadsheet tools.

Niku F (Flori N)

December 10, 2025 17:57

Hello can give me email addres please i want to ask for something. My is nike4938 gmail

December 11, 2025 05:08

Hey Niku,

Sure, you can reach me at: j93609566@gmail.com
Feel free to send me your questions there.

Best regards.

OnyxZone

December 19, 2025 17:47

Tried to download this and it said file corrupter. Could you please check.?

December 20, 2025 22:52

Hey OnyxZone,

Please reach out to me at j93609566@gmail.com
so we can further investigate this issue.