Improved search on Products and Inventory lists

Overview

Search on the Products list and Inventory list has been improved so it is easier to find deleted products by their original SKU.

When a product is deleted, Planufac changes the SKU by adding ID_DELETED  at the end. Previously, search used an exact match only, so searching for the original SKU did not find the deleted product. Search can now use a partial (LIKE) match in the right situation, so the original SKU can still match the altered SKU.

Where it applies

• Products list
• Inventory list

Use the list search bar as usual.

How deleted product SKUs work

Because the stored SKU is no longer identical to the original, exact search alone could miss deleted rows when you paste the original SKU.

How search behaves now

Behaviour depends on the Hide Deleted control:

Practical examples

Hide Deleted is off

1. A product with SKU ABC-123  is deleted → SKU becomes something like ABC-123ID_DELETED .
2. In search, paste ABC-123 .
3. The deleted product should still appear, because the search matches part of the altered SKU.

Hide Deleted is on

1. Deleted products are hidden from the list.
2. Search works as before for the products you can see (exact-style matching on the active list).

How to find a deleted product by original SKU

1. Open Products or Inventory.
2. Turn Hide Deleted off so deleted products are included.
3. Paste or type the original SKU (or part of it) into the search bar.
4. Review the results — deleted products with ID_DELETED  on the SKU should be findable.

Tips

• For everyday searching of active products, leave Hide Deleted on if you prefer not to see deleted rows.
• You can still search by other fields your list search already supports; this improvement is aimed at SKU matching for deleted products.