Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

Find what to reorder before the weekend

A ready reorder list from your stock sheet, with how much to buy.

  • ForKirana, medical and hardware shops that run out of fast items on busy days.
  • HelperStock Keeper
  • ModeBerri Strawberry 1
  • AttachExcel sheet

Copy the prompt

This is my stock sheet with columns for item, stock in hand and average daily sale. Tell me what will run out before [day] and how much I should order of each, keeping [number] days of extra stock.

Change the words in [brackets] to your own.

What to attach

An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.

Run it

Berri opens with the prompt filled in and the Stock Keeper helper picked. Nothing is sent until you press send.

Run this in Berri

Tips

  • Add a column for supplier name and ask Berri to group the order list by supplier.
  • Ask for a reminder every Thursday at 5 pm to send the updated sheet.
What Berri sends back
Find what to reorder before the weekendStock Keeper
XLSstock.xlsx

This is my stock sheet with columns for item, stock in hand and average daily sale. Tell me what will run out before Sunday and how much I should order of each, keeping 3 days of extra stock.

Reading stock.xlsx

Four items will run out before Sunday:

ItemIn handRuns outOrder
Sugar 1 kg18Friday40
Tea 250 g9Thursday24
Salt 1 kg12Saturday20
Soap bar20Saturday36

Order today and everything lasts till next Wednesday.

Figures here are made up to show the shape of the answer. Yours come from your own file and words.

Your own job, in your own words.

Try Berri