Know what to restock before it runs out.
Which products do I need to restock this week?
| produto | cobertura_dias | situacao |
|---|---|---|
| "Coffee 500 g" | 2 | abaixo_minimo |
| "Olive oil 500 ml" | 5 | abaixo_minimo |
| "Milk 1 L" | 6 | abaixo_minimo |
| "Sugar 1 kg" | 7 | abaixo_minimo |
| "Detergent 500 ml" | 8 | abaixo_minimo |
5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.
Connected apps
| Row | Product | Supplier | Stock | Sales/day | Coverage | Status | Reorder |
|---|---|---|---|---|---|---|---|
| 1 | Coffee 500 g | Torrefação Sol | 14 | 6 | 2 days | Below minimum | —118 |
| 2 | Olive oil 500 ml | Rede Norte | 20 | 4 | 5 days | Below minimum | —92 |
| 3 | Milk 1 L | Laticínios Serra | 110 | 18 | 6 days | Below minimum | —178 |
| 4 | Sugar 1 kg | Distribuidora Sul | 63 | 9 | 7 days | Below minimum | —198 |
| 5 | Detergent 500 ml | Higiene Total | 32 | 4 | 8 days | Below minimum | —68 |
| 6 | Cooking oil 900 ml | Rede Norte | 57 | 6 | 9 days | Near minimum | — |
| 7 | Eggs, dozen | Granja Boa Vista | 96 | 9 | 10 days | Near minimum | — |
| 8 | Butter 200 g | Laticínios Serra | 95 | 8 | 11 days | On track | — |
| 9 | Beans 1 kg | Distribuidora Sul | 88 | 7 | 12 days | On track | — |
| 10 | Tomato sauce 340 g | Atacado Leste | 41 | 3 | 13 days | On track | — |
| 11 | Rice 5 kg | Distribuidora Sul | 140 | 10 | 14 days | On track | — |
| 12 | Cookies 400 g | Atacado Leste | 91 | 5 | 18 days | On track | — |
Below minimum5
Near minimum2
On track5
Illustrative data. Drag the divider to compare.
| Row | Product | Supplier | Stock | Sales/day | Coverage | Status | Reorder |
|---|---|---|---|---|---|---|---|
| 1 | Coffee 500 g | Torrefação Sol | 14 | 6 | 2 days | Below minimum | —118 |
| 2 | Olive oil 500 ml | Rede Norte | 20 | 4 | 5 days | Below minimum | —92 |
| 3 | Milk 1 L | Laticínios Serra | 110 | 18 | 6 days | Below minimum | —178 |
| 4 | Sugar 1 kg | Distribuidora Sul | 63 | 9 | 7 days | Below minimum | —198 |
| 5 | Detergent 500 ml | Higiene Total | 32 | 4 | 8 days | Below minimum | —68 |
| 6 | Cooking oil 900 ml | Rede Norte | 57 | 6 | 9 days | Near minimum | — |
| 7 | Eggs, dozen | Granja Boa Vista | 96 | 9 | 10 days | Near minimum | — |
| 8 | Butter 200 g | Laticínios Serra | 95 | 8 | 11 days | On track | — |
| 9 | Beans 1 kg | Distribuidora Sul | 88 | 7 | 12 days | On track | — |
| 10 | Tomato sauce 340 g | Atacado Leste | 41 | 3 | 13 days | On track | — |
| 11 | Rice 5 kg | Distribuidora Sul | 140 | 10 | 14 days | On track | — |
| 12 | Cookies 400 g | Atacado Leste | 91 | 5 | 18 days | On track | — |
Below minimum5
Near minimum2
On track5
Which products do I need to restock this week?
| produto | cobertura_dias | situacao |
|---|---|---|
| "Coffee 500 g" | 2 | abaixo_minimo |
| "Olive oil 500 ml" | 5 | abaixo_minimo |
| "Milk 1 L" | 6 | abaixo_minimo |
| "Sugar 1 kg" | 7 | abaixo_minimo |
| "Detergent 500 ml" | 8 | abaixo_minimo |
5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.
- Supplier
- Torrefação Sol
- Coverage
- 2 days
- Reorder
- 118
History
ChatGPT changed Reorder · 07:05
- Supplier
- Rede Norte
- Coverage
- 5 days
- Reorder
- 92
History
ChatGPT changed Reorder · 07:05
- Supplier
- Laticínios Serra
- Coverage
- 6 days
- Reorder
- 178
History
ChatGPT changed Reorder · 07:05
- Supplier
- Distribuidora Sul
- Coverage
- 7 days
- Reorder
- 198
History
ChatGPT changed Reorder · 07:05
- Supplier
- Higiene Total
- Coverage
- 8 days
- Reorder
- 68
History
ChatGPT changed Reorder · 07:05
- Supplier
- Rede Norte
- Coverage
- 9 days
- Reorder
- —
History
Paula created the record · 09/12
- Supplier
- Granja Boa Vista
- Coverage
- 10 days
- Reorder
- —
History
Paula created the record · 09/12
- Supplier
- Laticínios Serra
- Coverage
- 11 days
- Reorder
- —
History
Paula created the record · 09/12
- Supplier
- Distribuidora Sul
- Coverage
- 12 days
- Reorder
- —
History
Paula created the record · 09/12
- Supplier
- Atacado Leste
- Coverage
- 13 days
- Reorder
- —
History
Paula created the record · 09/12
- Supplier
- Distribuidora Sul
- Coverage
- 14 days
- Reorder
- —
History
Paula created the record · 09/12
- Supplier
- Atacado Leste
- Coverage
- 18 days
- Reorder
- —
History
Paula created the record · 09/12
The same morning, every week
Stock lives in the ERP, quotes arrive by WhatsApp and email, and someone matches it all in a spreadsheet, product by product.
TodayWith Siglata
You take 7 steps to get one answer.You take 1 step. The AI does the rest.
- 1Export from the ERP
- 2Download PDFs
- 3Drag 5 files
- 4Ask
- 5Copy the answer
- 6Paste into the sheet
- 7Forward
- 1Ask
- 2The AI checks the stock
- 3It saves the order in the table
- 4It answers and keeps v8
| Code | Description | Unit | Balance | Committed | Reserved |
|---|---|---|---|---|---|
| 000101 | ACHOCOLATADO PO 400G | UN | 124.00 | 8.00 | 3.00 |
| 000104 | AGUA MINERAL 500ML | UN | 480.00 | 6.00 | 2.00 |
| 000123 | CAFE TORRADO 500G | UN | 14.00 | 0.00 | 4.00 |
| 000128 | AZEITE EXTRA 500ML | UN | 20.00 | 2.00 | 1.00 |
| 000131 | LEITE UHT INTEGRAL 1L | CX | 110.00 | 12.00 | 5.00 |
| 000133 | ACUCAR REFINADO 1KG | UN | 63.00 | 4.00 | 0.00 |
| 000138 | DETERGENTE LIQ 500ML | UN | 32.00 | 1.00 | 2.00 |
| Date | Doc | TM | Product | Qty |
|---|---|---|---|---|
| 09/28 | NF 88412 | 501 | CAFE TORRADO 500G | −36.00 |
| 09/28 | NF 88407 | 501 | LEITE UHT 1L | −54.00 |
| 09/27 | REQ 1180 | 999 | ACUCAR 1KG | −12.00 |
| 09/27 | ESTORNO | 499 | AZEITE 500ML | 4.00 |
14 orders awaiting approval from Marcos.
FRM-40350: the query could not retrieve records.
Record 3/38 · MATA010 · F1 Help
- Rodrigo AlvesRE: RE: FW: Updated stock v7 FINAL (2).xlsx
- SP warehouseBalance mismatch, warehouse 01 vs spreadsheet
- FinanceFW: Invoice 1042 overdue · R$8,400.00
- PurchasingRE: Roasted coffee quote · supplier 000412
- Estoque_final_v2 (1).xlsxSpreadsheet
- Vendas_set_CORRIGIDO.csvCSV file
- Politica_compras_2024 (1).pdfPDF document
- Tabela_fornecedor (3).pdfPDF document
- Estoque_final_v2.xlsxSpreadsheet
- Estoque_final.xlsxSpreadsheet
- Politica_compras_2024.pdfPDF document
| A | B | C | D | |
|---|---|---|---|---|
| 1 | RESTOCK WEEK 40 (DO NOT TOUCH) | |||
| 2 | Product | COVER | restock | notes |
| 3 | coffee 500g | 2 | 118 | check w/ supplier |
| 4 | OLIVE OIL 500ML | 5 | 92 | |
| 5 | Sugar 1 kg | #REF! | 198 | ?? |
| 6 | Milk 1L | 6 | 178 | |
| 7 | NOTE: check in the ERP · old version in v6_revisada_MARCOS.xlsx | |||
| 8 | ||||
#REF! · the source sheet was deleted
copy of Sheet1 (out of date since 09/12)
DO NOT USE · kept just in case
ReadyPasted by hand100%
Purchasing policy
Minimum cover of 10 days per item.
page 3 of 14
Which products do I need to restock this week?
I found two versions of the stock file. I used Estoque_final_v2 (1).xlsx. Restock:
| Sugar 1 kg | 198 |
| Milk 1 L | 178 |
| Coffee 500 g | 118 |
| Olive oil 500 ml | 92 |
Copied
Does anyone have the updated stock?
06:51Which version? I have v2 (1) and FINAL (2).
06:53Restock: sugar 198, milk 178, coffee 118, olive oil 92.
07:05Here's the new price list, valid from 10/01.
yesterdayIs this week's restock going out today?
06:40There are 14 purchase orders pending approval in the SIGACOM module. Do you want to view them now?
Exporting: recalculating balances (SB2). Record 11,207 of 38,590.
Which products do I need to restock this week?
| produto | cobertura_dias | situacao |
|---|---|---|
| "Coffee 500 g" | 2 | abaixo_minimo |
| "Olive oil 500 ml" | 5 | abaixo_minimo |
| "Milk 1 L" | 6 | abaixo_minimo |
| "Sugar 1 kg" | 7 | abaixo_minimo |
| "Detergent 500 ml" | 8 | abaixo_minimo |
5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.
Inventory
12 records| Row | Product | Coverage | Status | Reorder |
|---|---|---|---|---|
| 1 | Coffee 500 g | 2 days | Below minimum | —118 |
| 2 | Olive oil 500 ml | 5 days | Below minimum | —92 |
| 3 | Milk 1 L | 6 days | Below minimum | —178 |
| 4 | Sugar 1 kg | 7 days | Below minimum | —198 |
| 5 | Detergent 500 ml | 8 days | Below minimum | —68 |
| 6 | Cooking oil 900 ml | 9 days | Near minimum | — |
| 7 | Eggs, dozen | 10 days | Near minimum | — |
| 8 | Butter 200 g | 11 days | On track | — |
| 9 | Beans 1 kg | 12 days | On track | — |
| 10 | Tomato sauce 340 g | 13 days | On track | — |
| 11 | Rice 5 kg | 14 days | On track | — |
| 12 | Cookies 400 g | 18 days | On track | — |
With Siglata, the same job is one step: you ask in ChatGPT, and it checks the stock table, saves the order and keeps v8 of the spreadsheet.
A one-line request
You ask for this week's restock. Your AI finds the files, does the math and saves the order as a new version of the spreadsheet, with the previous one kept.
Which products do I need to restock this week?
| produto | cobertura_dias | situacao |
|---|---|---|
| "Coffee 500 g" | 2 | abaixo_minimo |
| "Olive oil 500 ml" | 5 | abaixo_minimo |
| "Milk 1 L" | 6 | abaixo_minimo |
| "Sugar 1 kg" | 7 | abaixo_minimo |
| "Detergent 500 ml" | 8 | abaixo_minimo |
5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.
Inventory
12 records · 5 below the minimum| Row | Product | Supplier | Stock | Sales/day | Coverage | Status | Reorder |
|---|---|---|---|---|---|---|---|
| 1 | Coffee 500 g | Torrefação Sol | 14 | 6 | 2 days | Below minimum | —118 |
| 2 | Olive oil 500 ml | Rede Norte | 20 | 4 | 5 days | Below minimum | —92 |
| 3 | Milk 1 L | Laticínios Serra | 110 | 18 | 6 days | Below minimum | —178 |
| 4 | Sugar 1 kg | Distribuidora Sul | 63 | 9 | 7 days | Below minimum | —198 |
| 5 | Detergent 500 ml | Higiene Total | 32 | 4 | 8 days | Below minimum | —68 |
| 6 | Cooking oil 900 ml | Rede Norte | 57 | 6 | 9 days | Near minimum | — |
| 7 | Eggs, dozen | Granja Boa Vista | 96 | 9 | 10 days | Near minimum | — |
| 8 | Butter 200 g | Laticínios Serra | 95 | 8 | 11 days | On track | — |
| 9 | Beans 1 kg | Distribuidora Sul | 88 | 7 | 12 days | On track | — |
| 10 | Tomato sauce 340 g | Atacado Leste | 41 | 3 | 13 days | On track | — |
| 11 | Rice 5 kg | Distribuidora Sul | 140 | 10 | 14 days | On track | — |
| 12 | Cookies 400 g | Atacado Leste | 91 | 5 | 18 days | On track | — |
Below minimum5
Near minimum2
On track5
Every number with its source
Tap a quantity to see where it came from and why that supplier.
| Row | Product | Supplier | Stock | Sales/day | Coverage | Status | Reorder |
|---|---|---|---|---|---|---|---|
| 1 | Coffee 500 g | Torrefação Sol | 14 | 6 | 2 days | Below minimum | —118 |
| 2 | Olive oil 500 ml | Rede Norte | 20 | 4 | 5 days | Below minimum | —92 |
| 3 | Milk 1 L | Laticínios Serra | 110 | 18 | 6 days | Below minimum | —178 |
| 4 | Sugar 1 kg | Distribuidora Sul | 63 | 9 | 7 days | Below minimum | —198 |
| 5 | Detergent 500 ml | Higiene Total | 32 | 4 | 8 days | Below minimum | —68 |
Coffee 500 g · Reorder 118
- Coverage
- 14 ÷ 6 ≈ 2.3 days
- Reorder
- Until delivery (1 day): 14 − 6 = 8
Target: 21 days × 6 = 126
Restock: 126 − 8 = 118
- Estoque_ERP_export_hoje.xlsxv1 to · Row 2 · Stock: 14 · Sales/day: 6
- Politica_de_compras.pdfv1 to · item 2: 21 days
| Supplier | BRL | Delivery | Status |
|---|---|---|---|
| Torrefação Sol | R$18.50 | 1 day | Chosen |
| Rede Norte | R$17.90 | 3 days |
- Cotacoes_semana_40.pdfv1 to · Row 2 · Torrefação Sol · R$18.50 · arrives in 1 day, before it runs out
- Cotacoes_semana_40.pdfv1 to · Row 3 · Rede Norte · R$17.90 · arrives in 3 days, after it runs out
It picks the cheapest among those that deliver before the product runs out, and writes the reason in the spreadsheet.
Reposicao_semana_40.xlsxv7 to v8SavedOlive oil 500 ml · Reorder 92
- Coverage
- 20 ÷ 4 ≈ 5.0 days
- Reorder
- Until delivery (3 days): 20 − 12 = 8
Target: 25 days × 4 = 100
Restock: 100 − 8 = 92
- Estoque_ERP_export_hoje.xlsxv1 to · Row 3 · Stock: 20 · Sales/day: 4
- Politica_de_compras.pdfv1 to · item 2: 25 days
| Supplier | BRL | Delivery | Status |
|---|---|---|---|
| Rede Norte | R$26.90 | 3 days | Chosen |
| Laticínios Serra | R$27.50 | 2 days |
- Cotacoes_semana_40.pdfv1 to · Row 4 · Rede Norte · R$26.90 · arrives in 3 days, before it runs out
- Cotacoes_semana_40.pdfv1 to · Row 5 · Laticínios Serra · R$27.50 · arrives in 2 days, before it runs out
It picks the cheapest among those that deliver before the product runs out, and writes the reason in the spreadsheet.
Reposicao_semana_40.xlsxv7 to v8SavedMilk 1 L · Reorder 178
- Coverage
- 110 ÷ 18 ≈ 6.1 days
- Reorder
- Until delivery (2 days): 110 − 36 = 74
Target: 14 days × 18 = 252
Restock: 252 − 74 = 178
- Estoque_ERP_export_hoje.xlsxv1 to · Row 4 · Stock: 110 · Sales/day: 18
- Politica_de_compras.pdfv1 to · item 2: 14 days
| Supplier | BRL | Delivery | Status |
|---|---|---|---|
| Laticínios Serra | R$4.80 | 2 days | Chosen |
| Distribuidora Sul | R$4.60 | 7 days |
- Cotacoes_semana_40.pdfv1 to · Row 6 · Laticínios Serra · R$4.80 · arrives in 2 days, before it runs out
- Cotacoes_semana_40.pdfv1 to · Row 7 · Distribuidora Sul · R$4.60 · arrives in 7 days, after it runs out
It picks the cheapest among those that deliver before the product runs out, and writes the reason in the spreadsheet.
Reposicao_semana_40.xlsxv7 to v8SavedSugar 1 kg · Reorder 198
- Coverage
- 63 ÷ 9 ≈ 7.0 days
- Reorder
- Until delivery (4 days): 63 − 36 = 27
Target: 25 days × 9 = 225
Restock: 225 − 27 = 198
- Estoque_ERP_export_hoje.xlsxv1 to · Row 5 · Stock: 63 · Sales/day: 9
- Politica_de_compras.pdfv1 to · item 2: 25 days
| Supplier | BRL | Delivery | Status |
|---|---|---|---|
| Distribuidora Sul | R$3.90 | 4 days | Chosen |
| Higiene Total | R$4.10 | 3 days |
- Cotacoes_semana_40.pdfv1 to · Row 8 · Distribuidora Sul · R$3.90 · arrives in 4 days, before it runs out
- Cotacoes_semana_40.pdfv1 to · Row 9 · Higiene Total · R$4.10 · arrives in 3 days, before it runs out
It picks the cheapest among those that deliver before the product runs out, and writes the reason in the spreadsheet.
Reposicao_semana_40.xlsxv7 to v8SavedDetergent 500 ml · Reorder 68
- Coverage
- 32 ÷ 4 ≈ 8.0 days
- Reorder
- Until delivery (5 days): 32 − 20 = 12
Target: 20 days × 4 = 80
Restock: 80 − 12 = 68
- Estoque_ERP_export_hoje.xlsxv1 to · Row 6 · Stock: 32 · Sales/day: 4
- Politica_de_compras.pdfv1 to · item 2: 20 days
| Supplier | BRL | Delivery | Status |
|---|---|---|---|
| Higiene Total | R$2.40 | 5 days | Chosen |
| Torrefação Sol | R$2.20 | 9 days |
- Cotacoes_semana_40.pdfv1 to · Row 10 · Higiene Total · R$2.40 · arrives in 5 days, before it runs out
- Cotacoes_semana_40.pdfv1 to · Row 11 · Torrefação Sol · R$2.20 · arrives in 9 days, after it runs out
It picks the cheapest among those that deliver before the product runs out, and writes the reason in the spreadsheet.
Reposicao_semana_40.xlsxv7 to v8SavedIllustrative data.
You set the rule once
The purchasing rule lives in a company skill. Each person works with their own access, and every change stays in the history, with the previous version kept.
Who accesses what
| Row | Person | Inventory | Purchasing | Finance |
|---|---|---|---|---|
| 1 | You Admin | Can edit | Can edit | Can edit |
| 2 | Marcos Purchasing | |||
| 3 | Renata Finance | |||
| 4 | Rodrigo Sales |
Click a level to change it. Each person's ChatGPT, Codex or Claude Code follows that person's access.
Today's activity
Reposicao_semana_40.xlsxv8 to- M
Marcos, via ChatGPT, updated Reposicao_semana_40.xlsx (5 rows)
The 5 cells that changed from v7 to v8 Product Reorder in v7 Reorder in v8 Sugar 1 kg — 198 Milk 1 L — 178 Coffee 500 g — 118 Olive oil 500 ml — 92 Detergent 500 ml — 68 - R
Rodrigo, via Codex, tried to read Finance: no access
- R
Renata, via Claude Code, read Politica_de_compras.pdf
- M
Marcos, via ChatGPT, read inventory in the ERP
- Y
You gave Marcos “can read and edit” in Purchasing
- R
Rodrigo, via Codex, read yesterday's sales in the POS
- R
Renata, via Claude Code, prepared the payment reminders
Frequently asked questions
Which ChatGPT does it work in?
ChatGPT Business and Enterprise: an admin enables Siglata once for the team. On Pro, Siglata is read-only, in developer mode. On Plus and Free, it doesn't work in ChatGPT on the web. In Codex, each person connects it, on every plan that includes Codex.
Does it work with my ERP?
Two ways. Your AI works with the ERP's exports, as spreadsheets or CSV, and also in the ERP's own pages, like Bling, with the login the company connected and without seeing the password.
Does it always pick the cheapest supplier?
It picks the cheapest among those that deliver before the product runs out, and writes the reason in the spreadsheet.
Who sees the order and the quotes?
Whoever has access to Purchasing at the company. Each person's AI works with their access, and every step is logged.
No question matches that term. Let’s talk.
Want to see it with your company's stock?
We'll show the restock with an export from your ERP, in a WhatsApp conversation.