hello everyone, How Can track the expiration dates of my products
already searched articles related to expiration dates for the entire board, but not found anything that could be useful for my question.
I was wondering if this setting is possible
Have you not answered your own question 
Or are they mockup images?
Possibly wants Automation to “popup” messages as it seems at the moment the function is manual and just displays a text result i.e. no evaluation.
1 Like
Fair shout pauln, @Cazz dates can be tricky to work with, you would need to ensure date format is consistent which as we currently have no mask/formatting parameters for item tags would be down to you to enter correctly.
You could constrain on order added {ITEM TAG:Expiry Date} > {DATE} (think {DATE} should work, if not + alternative probably better, kendash probably a good one to give suggestion on that part)
Might want to add a date formatting expression to them both possibly so they are defiantly in matching format.
Maybe add cancel last order action after the popup/ask question…
2 Likes
Great summary @JTRTech - I do like your straight up answers!
This gives me an idea… 
Product TAGS could almost be styled like above as a Custom Fields?
I was looking for a way to create a Purchase Order by a “Grouping Function” - Group Under Supplier i.e. small batch bought from a Beer supplier. Do you think this could be built around a product TAG? Are they editable through Automation as that all what is needed?
@pauln I do try and keep thinks simple, although often too much as think kendash has a template response for my questions asking to explain in more detail (
kendash - only playing)
Not sure what you mean by this, if you mean options for field type like date etc like on entity fields this was a suggestion I raise a fair while ago, cant remember what the verdict was, think it was along the lines of since its a admin only feature and not available to edit in POS like custom fields it wasn’t a necessity 
but it was a while ago so might be remembering incorrectly.
Im pretty sure we dont have an action to update a product tag but could probably work out a script to do it for you 
Am a little flat out this week, my hotel PMS system goes in on monday and still polishing up the setup. Got a training terminal to install tomorrow for staff to learn and hopefully find any glitches/bugs in the setup. but start a new thread and we can discuss.
1 Like
Hey JTR you are quite correct - no Actions for Update Products & Inventory? All good information, maybe something @emre might have in planning.
I wouldnt like to attempt script for inventory related things with out helpers anyway as A. not familier with inventory system and B. pretty sure it would be UBER complex.
Updating Item Tags shouldn’t bee too hard with a script & SQL insert and a few hours tinkering. Let me know is tag part is any use and will have a look as soon as hotel system is sorted.
No worries I am thinking of another solution! 
Data we can get at for Automation.
So not to derail this thread I will start another in time, get your almighty Hotel System done and we can discuss later. I reckon it may work but I will implement test inventory first.
Cheers and good luck with yours!
1 Like
Yes @JTRTech it is a kind of model, but only in appearance, basically there are no configuration capable of firing the expiration date through the automation commands, this is just a button automation of firing the MSG TEST MESSAGE, nothing more 
this is just an idea of how I would like it to work.
That’s right @pauln this is just an idea. I wish to work with actions and rules able to get this result.
Good idea @JTRTech {ITEM TAG: Expiry Date}> {DATE} is probably this right setup.
I will work on that, and I’ll let you know how it was
thank you
You main hurdle will be handling date format in a way which can be used in the constraint
Took me a while to get dates right in my PMS scripts.
How I Can control the expiration dates of my products
A customer, request I extend his installation because he has a mini-mart in the same location as the business. I will need sambaPOS V5 to auto-check the product expiration date before sales. I search the forum and found this but is not detailed enough for a beginner like me.
so please I will need a step by step guide on how to implement this if possible for me to get the kb link
Hello Team, is there a proper tutorial/ screen shots please on how to do this. I need products expiry alert for our grocery store. Thank you.
Hello Anyone there? Can you help me with to get Product Expiry Alert Please! Any Screen Tutorial would help.
Thank you
Could you explain a little more of what you are looking to have the expiry date do?
Do you want to run a report to know what items are expiring?
Do you want a pop-up for the user when they enter an item that has expired?
How do you want to handle the expiry date when you get more of the same item in that has a different expiry date?
Hi Bob,
Yes! want to run a report to know what items are expiring?
it would be good to receive an alert popup please if the item has expired.
Many Thanks
Here is how to set it up:
Go to Manage → Settings → Program Settings → General Settings → Product Tag Captions enter Expiry Date.
Then go to Manage → Products → Product List → <select item> → enter the expiration date in the Expiry Date field.
Warning: There is no mechanism to restrict the date to a format of MM/dd/yyyy, you will need to make sure you follow this format when entering dates on the products. (i.e. Feb 9 2024 would be 02/09/2024 - Notice the leading zero before 2 and the 9)
You can change the date format to you region if you prefer, just make sure you make all the same adjustment below.
— OR —
To bulk edit expiry date, go to Manage → Products → Product Tag Editor. Enter the expiration dates for items in the Expiry Date column.
— Action Needed ----
If you do not have a show message action you can create one:
— Rule —
Rule Name:
Event Name: Order Added to Ticket
Constraint: {ITEM TAG:Expiry Date} Is Not Null <blank>
Action: Show Message.
- Constraint:
'{ITEM TAG:Expiry Date}' <= '{DATE:MM/dd/yyyy}' - show message:
This item has expired!\rExpired on {ITEM TAG:Expiry Date}
— Report —
Manage → Reports → Add Report
You will have to experiment with what column(s) you want on the report and the size to print.
[#Expiry Date:1,1,1,1,1]
>Name|Group Code|Tag|Barcode|Expiry Date
{REPORT SQL DETAILS:SELECT
p.[Name]
,p.[GroupCode]
,p.[Tag]
,p.Barcode
,ct.[tagValue]
FROM [MenuItems] p
CROSS APPLY OPENJSON(p.[CustomTags]) WITH (tagName varchar(255) '$.TN',tagValue varchar(2048) '$.TV') ct
WHERE ct.[tagName]='Expiry Date'
and tagValue IS NOT NULL:F.Name,F.GroupCode,F.Tag,F.Barcode,F.tagValue}
If can resize the columns by dragging the column headers dividers. If you want to save the column settings, right click in the body of the report and choose “Save Changes” in the popup.
The Dates filter in the report explorer will not have any effect on the report. You will need to right click on the header columns and choose “Filter Editor”. (Experiment as needed.)
Let me know if you have any questions.
3 Likes