--- title: Know what to restock before it runs out. description: Your AI reads the ERP's stock, the purchasing policy and the quotes, and saves the finished order, with the source of every number. language: en-US canonical: https://www.siglata.com/en-US/use-cases/restocking --- # Know what to restock before it runs out. Canonical: https://www.siglata.com/en-US/use-cases/restocking Your AI reads the ERP's stock, the purchasing policy and the quotes, and saves the finished order, with the source of every number. ## 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. ## 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. ## Every number with its source Tap a quantity to see where it came from and why that supplier. ## You set the rule once The purchasing rule lives in a company document saved in Siglata. Each person works with their own access, and every change stays in the history, with the previous version kept. 1. 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. 2. 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. 3. 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. 4. Every number with its source: Tap a quantity to see where it came from and why that supplier. ### 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.xlsx v1: Row 2 · Stock: 14 · Sales/day: 6 Politica_de_compras.pdf v1: 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.pdf v1: Row 2 · Torrefação Sol · R$18.50 · arrives in 1 day, before it runs out Cotacoes_semana_40.pdf v1: 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.xlsx v7 to v8 ### 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.xlsx v1: Row 3 · Stock: 20 · Sales/day: 4 Politica_de_compras.pdf v1: 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.pdf v1: Row 4 · Rede Norte · R$26.90 · arrives in 3 days, before it runs out Cotacoes_semana_40.pdf v1: 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.xlsx v7 to v8 ### 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.xlsx v1: Row 4 · Stock: 110 · Sales/day: 18 Politica_de_compras.pdf v1: 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.pdf v1: Row 6 · Laticínios Serra · R$4.80 · arrives in 2 days, before it runs out Cotacoes_semana_40.pdf v1: 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.xlsx v7 to v8 ### 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.xlsx v1: Row 5 · Stock: 63 · Sales/day: 9 Politica_de_compras.pdf v1: 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.pdf v1: Row 8 · Distribuidora Sul · R$3.90 · arrives in 4 days, before it runs out Cotacoes_semana_40.pdf v1: 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.xlsx v7 to v8 ### 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.xlsx v1: Row 6 · Stock: 32 · Sales/day: 4 Politica_de_compras.pdf v1: 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.pdf v1: Row 10 · Higiene Total · R$2.40 · arrives in 5 days, before it runs out Cotacoes_semana_40.pdf v1: 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.xlsx v7 to v8 [Download the example (.xlsx)](https://www.siglata.com/en-US/use-cases/restocking/spreadsheet.xlsx) Illustrative data. [Read the ERP export guide](https://www.siglata.com/blog/chatgpt-planilhas-do-erp) ## Frequently asked questions ### Which ChatGPT does it work in? In ChatGPT on the web, Siglata is added as a custom MCP server, under Plugins. On Business and Enterprise, an admin adds it once for the team; on other plans, each person adds it, if the option shows up in their account. In Codex, each person connects it, on every plan that includes Codex. ### Does it work with my ERP? It works with any ERP that exports a spreadsheet or CSV, like Bling. The stock export is saved as a file in Siglata, or its rows go into a table, and your AI works from there, without going into the ERP's pages. ### 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.