Skip to main content

Archiving menu items - not showing up on historic sales mix reports.

Anonymous User
I am running this report for the last 6 weeks and also the same 6 weeks last year to look at a movement in volumes. This years sales data is fine and ties back to our till data but last years is missing almost £600k based on the sites I am looking at. This is equates to about 12% of the sales. Can you think of any reason why this might be? I’m thinking it might have something to do with archived items. If menu items are archived, are they removed from the historic sales data? If not, what else could it be? This is proving very tricky to understand any vol vs avg spend trends so I’d like to understand this.
0 votes

Linked Ideas

Comments

Anonymous User
Thanks Paul, Very helpful. Usually I would run sales data direct from our epos systems. The reason for not doing so is that we currently have two till systems (due to an aquisition) and the reporting is very different. Was hoping to utilise FnB to counteract his and get a group wide picture but alas it appears not possible. Thanks for your reply. Kind Regards, Jack
Paul Mortensen

Hi Jack,

 

Thank you for your question. Your presumptions are correct, the gap in sales are due to archived recipes. The report generates and runs based on current live data.

When reviewing sales mix information, we would recommend you use the reports available on your Epos rather than FnB.

As FnB is primarily a purchasing and stock control tool, we ensure archived products are still visible after being archived in your reporting, eg. the Product performance matrix and any of your purchasing reports. However, your pos provider should have a record of historical PLU data.

 

Many thanks

Paul

Please sign in to leave a comment.