--- 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/trabalhos/reposicao-de-estoque --- # Know what to restock before it runs out. Canonical: https://www.siglata.com/en-US/trabalhos/reposicao-de-estoque 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 skill. 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/trabalhos/reposicao-de-estoque/planilha.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? 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. [Let's talk](https://wa.me/5516991184410?text=Hi!%20I'd%20like%20to%20see%20stock%20restocking%20with%20Siglata.)