Skip to content

Know what to restock before it runs out.

Your AI reads the ERP's stock, the purchasing policy and the quotes, and saves the finished order, with the source of every number.

Drag to move the window. With the keyboard, use the arrow keys; Enter puts the window back.

Which products do I need to restock this week?

SiglataInventory5 of 12 records
produtocobertura_diassituacao
"Coffee 500 g"2abaixo_minimo
"Olive oil 500 ml"5abaixo_minimo
"Milk 1 L"6abaixo_minimo
"Sugar 1 kg"7abaixo_minimo
"Detergent 500 ml"8abaixo_minimo
Using Siglata · saving ReorderUsed Siglata · saved Reorder in 5 records

5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.

Reposicao_semana_40.xlsxv7 to v8SavedPrevious version kept
Siglata
In SiglataInventory12 records
StatusBelow minimum5Near minimum2On track5
The Inventory table in Siglata, 12 records.
RowProductSupplierStockSales/dayCoverageStatusReorder
1Coffee 500 gTorrefação Sol1462 daysBelow minimum—118
2Olive oil 500 mlRede Norte2045 daysBelow minimum—92
3Milk 1 LLaticínios Serra110186 daysBelow minimum—178
4Sugar 1 kgDistribuidora Sul6397 daysBelow minimum—198
5Detergent 500 mlHigiene Total3248 daysBelow minimum—68
6Cooking oil 900 mlRede Norte5769 daysNear minimum—
7Eggs, dozenGranja Boa Vista96910 daysNear minimum—
8Butter 200 gLaticínios Serra95811 daysOn track—
9Beans 1 kgDistribuidora Sul88712 daysOn track—
10Tomato sauce 340 gAtacado Leste41313 daysOn track—
11Rice 5 kgDistribuidora Sul1401014 daysOn track—
12Cookies 400 gAtacado Leste91518 daysOn track—
TodayEstoque_final_v2 (1).xlsxCompatibility modeSaved 3 days ago
J7fx=SE(H5<10;"REPOR";"")&'Plan2 (2)'!B7+#REF!
ABCDEHIJKLM1STOCK CONTROL - SEP/26 (DO NOT TOUCH!!)2updated 9/28 by Marcos · use only this version3codePRODUCTSuppl.stock dtwnJardinsTOTALsales/dayCover.NOTESreorder??order4CF-0500Coffee 500 GTorrefação Sol 9.011,00'146 un2check w/ supplier!!1109/18/20265AZ-0500OLIVE OIL 500 ML Rede Norte'166 un20456,0009/196LT-1000Milk 1 Llaticínios serra334611018.06,00check in the ERP46 un09/207AC-1000Sugar 1 kgDistribuidora SUL2634.063,00'97 un#REF!21-Sep8DT-0500Detergent 500 ml HIGIENE TOTAL17,00'2132 un48Jardins negative?21.022.099OL-0900 Cooking oil 900 mlRede Norte38 un44576#N/A'442026-09-2310OV-0012eggs, dozenGranja Boa Vista752996.09,00'1029Sep 2411MN-0200Butter 200 GDAIRY (all)29.040,00'958 un11??4009/25/202612FJ-1000BEANS 1 KG'3748 un8871248,0009/2613MT-0340Tomato sauce 340 g#REF!27413.013,0027 un09/2714AR-5000Rice 5 kgDistribuidora SUL92109.0140,00'1014 unpromo until the 5th10918-Sep15BS-0400Cookies 400 g ATACADO LESTE71,00'2791 un51827.019.0916GRAND TOTAL847 ?171819202122
Sheet1Sheet2 (2)copy of Sheet1DO NOT USE

Illustrative data. Drag the divider to compare.

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.

  1. 1Export from the ERP
  2. 2Download PDFs
  3. 3Drag 5 files
  4. 4Ask
  5. 5Copy the answer
  6. 6Paste into the sheet
  7. 7Forward
  1. 1Ask
  2. 2The AI checks the stock
  3. 3It saves the order in the table
  4. 4It answers and keeps v8
SIGE 12.1 · Stock/Costs · Branch 0101 Head office
F3 QueryF4 FilterF5 RefreshF12 Export
CodeDescriptionUnitBalanceCommittedReserved
000101ACHOCOLATADO PO 400GUN124.008.003.00
000104AGUA MINERAL 500MLUN480.006.002.00
000123CAFE TORRADO 500GUN14.000.004.00
000128AZEITE EXTRA 500MLUN20.002.001.00
000131LEITE UHT INTEGRAL 1LCX110.0012.005.00
000133ACUCAR REFINADO 1KGUN63.004.000.00
000138DETERGENTE LIQ 500MLUN32.001.002.00

Record 3/38 · MATA010 · F1 Help

Inbox · marcos.lima@empresa.com.br
New mailSearch
  • 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
Downloads
  • 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
Estoque_final_v2 (1).xlsx · Compatibility Mode
C3fx=PROCV(A3;'Plan2 (2)'!A:H;8;0)
ABCD
1RESTOCK WEEK 40 (DO NOT TOUCH)
2ProductCOVERrestocknotes
3coffee 500g2118check w/ supplier
4OLIVE OIL 500ML592
5Sugar 1 kg#REF!198??
6Milk 1L6178
7NOTE: check in the ERP · old version in v6_revisada_MARCOS.xlsx
8

ReadyPasted by hand100%

Politica_compras_2024 (1).pdf

Purchasing policy

Minimum cover of 10 days per item.

page 3 of 14

ChatGPT
5 files

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 kg198
Milk 1 L178
Coffee 500 g118
Olive oil 500 ml92

Copied

Estoque_final_v2 (1).xlsxVendas_set_CORRIGIDO.csvPolitica_compras_2024 (1).pdfTabela_fornecedor (3).pdfEstoque_final_v2.xlsx
Ask anything
WhatsApp
Purchasing · teamMarcos, Paula, Renata
Marcos

Does anyone have the updated stock?

06:51
Paula

Which version? I have v2 (1) and FINAL (2).

06:53

Restock: sugar 198, milk 178, coffee 118, olive oil 92.

07:05
Message
Warning

There are 14 purchase orders pending approval in the SIGACOM module. Do you want to view them now?

Please wait…

Exporting: recalculating balances (SB2). Record 11,207 of 38,590.

ChatGPT

Which products do I need to restock this week?

SiglataInventory5 of 12 records
produtocobertura_diassituacao
"Coffee 500 g"2abaixo_minimo
"Olive oil 500 ml"5abaixo_minimo
"Milk 1 L"6abaixo_minimo
"Sugar 1 kg"7abaixo_minimo
"Detergent 500 ml"8abaixo_minimo
Using Siglata · saving ReorderUsed Siglata · saved Reorder in 5 records

5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.

Reposicao_semana_40.xlsxv7 to v8SavedPrevious version kept
Ask anythingSiglata

Inventory

12 records
Reposicao_semana_40.xlsxv7 to v8Saved
The Inventory table in Siglata, 12 records.
RowProductCoverageStatusReorder
1Coffee 500 g2 daysBelow minimum—118
2Olive oil 500 ml5 daysBelow minimum—92
3Milk 1 L6 daysBelow minimum—178
4Sugar 1 kg7 daysBelow minimum—198
5Detergent 500 ml8 daysBelow minimum—68
6Cooking oil 900 ml9 daysNear minimum—
7Eggs, dozen10 daysNear minimum—
8Butter 200 g11 daysOn track—
9Beans 1 kg12 daysOn track—
10Tomato sauce 340 g13 daysOn track—
11Rice 5 kg14 daysOn track—
12Cookies 400 g18 daysOn 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.

ChatGPT

Which products do I need to restock this week?

SiglataInventory5 of 12 records
produtocobertura_diassituacao
"Coffee 500 g"2abaixo_minimo
"Olive oil 500 ml"5abaixo_minimo
"Milk 1 L"6abaixo_minimo
"Sugar 1 kg"7abaixo_minimo
"Detergent 500 ml"8abaixo_minimo
Using Siglata · saving ReorderUsed Siglata · saved Reorder in 5 records

5 products are below minimum coverage. The largest order is Sugar 1 kg (198 units). I saved v8 of the order sheet.

Reposicao_semana_40.xlsxv7 to v8SavedPrevious version kept
Ask anythingSiglata

Inventory

12 records · 5 below the minimum
The Inventory table in Siglata, 12 records.
RowProductSupplierStockSales/dayCoverageStatusReorder
1Coffee 500 gTorrefação Sol1462 daysBelow minimum—118
2Olive oil 500 mlRede Norte2045 daysBelow minimum—92
3Milk 1 LLaticínios Serra110186 daysBelow minimum—178
4Sugar 1 kgDistribuidora Sul6397 daysBelow minimum—198
5Detergent 500 mlHigiene Total3248 daysBelow minimum—68
6Cooking oil 900 mlRede Norte5769 daysNear minimum—
7Eggs, dozenGranja Boa Vista96910 daysNear minimum—
8Butter 200 gLaticínios Serra95811 daysOn track—
9Beans 1 kgDistribuidora Sul88712 daysOn track—
10Tomato sauce 340 gAtacado Leste41313 daysOn track—
11Rice 5 kgDistribuidora Sul1401014 daysOn track—
12Cookies 400 gAtacado Leste91518 daysOn track—
SourcesERPSuppliersPurchasing policyYour AIRestock saved in 5 rowsspreadsheet v8

Every number with its source

Tap a quantity to see where it came from and why that supplier.

The Inventory table in Siglata, 12 records.
RowProductSupplierStockSales/dayCoverageStatusReorder
1Coffee 500 gTorrefação Sol1462 daysBelow minimum—118
2Olive oil 500 mlRede Norte2045 daysBelow minimum—92
3Milk 1 LLaticínios Serra110186 daysBelow minimum—178
4Sugar 1 kgDistribuidora Sul6397 daysBelow minimum—198
5Detergent 500 mlHigiene Total3248 daysBelow 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
Compare suppliers
SupplierBRLDeliveryStatus
Torrefação SolR$18.501 dayChosen
Rede NorteR$17.903 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 v8Saved

Olive 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
Compare suppliers
SupplierBRLDeliveryStatus
Rede NorteR$26.903 daysChosen
Laticínios SerraR$27.502 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 v8Saved

Milk 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
Compare suppliers
SupplierBRLDeliveryStatus
Laticínios SerraR$4.802 daysChosen
Distribuidora SulR$4.607 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 v8Saved

Sugar 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
Compare suppliers
SupplierBRLDeliveryStatus
Distribuidora SulR$3.904 daysChosen
Higiene TotalR$4.103 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 v8Saved

Detergent 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
Compare suppliers
SupplierBRLDeliveryStatus
Higiene TotalR$2.405 daysChosen
Torrefação SolR$2.209 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 v8Saved
Download the example (.xlsx)

Illustrative data.

Read the ERP export guide

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

RowPersonInventoryPurchasingFinance
1You AdminCan editCan editCan edit
2Marcos Purchasing
3Renata Finance
4Rodrigo 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
  1. M

    Marcos, via ChatGPT, updated Reposicao_semana_40.xlsx (5 rows)

    The 5 cells that changed from v7 to v8
    ProductReorder in v7Reorder in v8
    Sugar 1 kg—198
    Milk 1 L—178
    Coffee 500 g—118
    Olive oil 500 ml—92
    Detergent 500 ml—68
  2. R

    Rodrigo, via Codex, tried to read Finance: no access

  3. R

    Renata, via Claude Code, read Politica_de_compras.pdf

  4. M

    Marcos, via ChatGPT, read inventory in the ERP

  5. Y

    You gave Marcos “can read and edit” in Purchasing

  6. R

    Rodrigo, via Codex, read yesterday's sales in the POS

  7. 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.

Want to see it with your company's stock?

We'll show the restock with an export from your ERP, in a WhatsApp conversation.