⚠️ How to Purge Old Sales History WITHOUT Restocking Inventory in Aronium?

Answered

Follow

احمد يوسف

• May 21, 2026 21:42

I have a very important inquiry regarding Aronium POS, and it's causing me a highly frustrating issue. After a long period of work, I need to delete old customer records and sales transactions to clear up space and lighten the database. However, the problem is that when I delete these transactions, the program automatically adds the sold quantities back into the stock! ​This obviously causes a disaster in inventory tracking, because the quantities currently in my shop are the actual, physical stock, and the items the program returns to the inventory don't even exist in reality. ​What is the solution to this problem? Because this way, it's impossible for anyone to clean up old records, and the data will just keep growing until it reaches gigabytes, making the program heavy and laggy. Is there a way to purge or delete the archive while freezing/locking the current inventory quantities?

1

• 

  احمد يوسف

  • May 22, 2026 14:35

  I completely agree with you and back your request 100%! This is a critical issue that completely defeats the purpose of "database maintenance" in Aronium.
  ​It makes absolutely no sense that deleting old transactions or archiving past sales automatically reverts those sold quantities back into the current stock. Doing this completely ruins the accuracy of our actual physical inventory and messes up the entire POS records.
  ​Database shrinking and cleaning old history without altering current stock levels is an essential feature for any business operating long-term. Otherwise, the software will inevitably become heavy and slow over time due to data accumulation.
  ​We strongly urge the Aronium development team to implement a clear, independent option when purging old data: (Delete history while freezing/locking current stock levels without modification). We hope the management prioritizes this request immediately, as it directly affects the stability of our business operations.

  0

  Comment actions Permalink
• 

  مروان حاتم

  • May 22, 2026 14:41

  This is a major flaw that needs an urgent fix. Deleting old history should strictly mean purging historical data, not triggering a mass recalculation that resets or messes up current stock levels. Forcing the inventory back to zero or modifying current quantities during a cleanup makes the purge feature completely unusable.
  ​In any professional POS system, current stock is an absolute reality based on physical counts. Once a year or period ends, we need to shrink the database to keep the system fast and responsive, but our current on-hand inventory must remain untouched.
  ​If we cannot clear old invoices without breaking our live inventory numbers, the database will eventually bloat, and the software will freeze. The developers must add a simple checkbox: "Keep current stock levels unchanged during deletion." We need this update as soon as possible.

  0

  Comment actions Permalink
• 

  Aronium Support

  • May 23, 2026 08:36

  Hello,

  Thank you for the detailed explanation and bringing this up. We understand why this would be frustrating, especially when you are trying to clean old data while keeping your current stock quantities correct.

  In Aronium, documents are the source of truth for stock quantities. Sales, purchases, stock returns, inventory counts, and other stock-related documents are all part of the calculation. Because of that, deleting old sales documents will affect stock, since Aronium recalculates stock based on the remaining documents.

  Keeping a separate “current stock” value independent from documents would be quite complex and is not something we currently plan to implement. Our principle is that stock quantities must always have a source. In other words, the system should not simply keep “10” as a quantity without knowing where those 10 items came from.

  The correct way to handle this is to use Inventory Count as a fixed point in time for your stock quantities.

  For example, if you want to delete documents before January 1st, 2026, you can first make sure you have the actual physical quantities for that date. Then create an Inventory Count with the stock quantities captured on January 1st, 2026. After that, you can delete older documents up to that date.

  This way you can achieve both goals:

  1. Old documents are removed.
  2. Stock quantities remain correct based on the Inventory Count.

  You can find more information about Inventory Count document at https://help.aronium.com/hc/en-us/articles/115001110085-Inventory-count. 

  We may consider automating this type of cleanup in the future, but for now, the same result can be achieved by using Inventory Count as described above.

  Best regards, Aronium team.

  1

  Comment actions Permalink

Please sign in to leave a comment.