Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.
Para transportadoras regionais ou parceiros locais que não possuem API, o BulkRoute suporta o carregamento de tabelas de frete em planilha. Isso permite cotar com qualquer transportadora, mesmo sem integração técnica.
Emissão de etiqueta — não há API para gerar etiqueta. Use a etiqueta genérica do BulkRoute (PDF 100×150mm com Code-128).
Solicitação de coleta — você precisa agendar a coleta diretamente com a transportadora.
Rastreamento automático — sem API, o BulkRoute não consegue fazer polling. O status precisa ser atualizado manualmente ou via webhook outbound do seu ERP.
Cancelamento automático — você precisa cancelar diretamente com a transportadora.
Verificar se a linha correta está sendo selecionada
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"BulkRoute Central de Ajuda","colors":{"primary":"#2563eb","light":"#3b82f6","dark":"#1d4ed8"},"logo":{"light":"https://mintcdn.com/bulkroute/3b7W0SLBzshYyGcU/images/logo-light.svg?fit=max\u0026auto=format\u0026n=3b7W0SLBzshYyGcU\u0026q=85\u0026s=0a9290ede9e4a8387b55515feeea5769","dark":"https://mintcdn.com/bulkroute/3b7W0SLBzshYyGcU/images/logo-dark.svg?fit=max\u0026auto=format\u0026n=3b7W0SLBzshYyGcU\u0026q=85\u0026s=f424020e9995c8c6c9bce44c7723ea01","href":"https://www.bulkroute.com.br"},"favicon":"https://mintcdn.com/bulkroute/MhOHZ8TDV_D22IoT/images/favicon.svg?fit=max\u0026auto=format\u0026n=MhOHZ8TDV_D22IoT\u0026q=85\u0026s=9e12a37e0bd5f20833e1d0afc33a0163","navbar":{"links":[{"href":"https://app.bulkroute.com.br","label":"Painel Admin"},{"href":"mailto:suporte@bulkroute.com.br","label":"Suporte"}],"primary":{"type":"button","label":"Acessar Plataforma","href":"https://app.bulkroute.com.br"}},"footer":{"socials":{"website":"https://www.bulkroute.com.br","instagram":"https://instagram.com/bulkroute"}},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"bulkroute","hasAudioNarration":false,"actualSubdomain":"bulkroute","customDomains":["docs.bulkroute.com.br"],"gitSource":{"type":"github","owner":"isaaclopes","repo":"bulkroute-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"latestBuiltDeploymentHistoryId":"6abd408b4d04591a291392f0","collectionId":"2ab2ed48-f5b3-455b-86a5-58bc1a2abe04","liveDeploymentHistoryId":"6abd408b4d04591a291392f0","schemaVersion":"v3"},"entitlements":{},"buildId":"6abd408b4d04591a291392f0","clientVersion":"0.0.4067","searchFilterCounts":[{"language":"default","tag":"Documentação","count":27},{"language":"default","tag":"Operação Diária","count":17},{"language":"default","tag":"Painel Admin","count":9},{"language":"default","tag":"Seções do Painel","count":8},{"language":"default","tag":"Como Usar","count":7},{"language":"default","tag":"Transportadoras","count":7},{"language":"default","tag":"Conectando Transportadoras","count":7},{"language":"default","tag":"Integrações","count":6},{"language":"default","tag":"ERPs \u0026 Marketplaces","count":6},{"language":"default","tag":"API \u0026 Integração","count":3}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"transportadoras/planilha","slug":"/transportadoras/planilha","pageMetadata":{"title":"Importação de Tabelas em Planilha","description":"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.","href":"/transportadoras/planilha"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,em:`em`,li:`li`,ol:`ol`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{Heading,Table,Tip,Warning}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Para transportadoras regionais ou parceiros locais que não possuem API, o BulkRoute suporta o carregamento de tabelas de frete em planilha. Isso permite cotar com qualquer transportadora, mesmo sem integração técnica.`}),`\n`,_jsx(Heading,{level:`2`,id:`quando-usar`,children:`Quando usar`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:`Cenário`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Recomendado`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Transportadora regional sem API`}),_jsx(_components.td,{style:{textAlign:`left`},children:`✅ Planilha`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Transportadora com API mas sem webservice de cotação`}),_jsx(_components.td,{style:{textAlign:`left`},children:`✅ Planilha`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Negociação especial (tabela customizada)`}),_jsx(_components.td,{style:{textAlign:`left`},children:`✅ Planilha`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Transportadora com API ativa`}),_jsx(_components.td,{style:{textAlign:`left`},children:`❌ Use a API direta`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`modelo-de-planilha-suportado`,children:`Modelo de Planilha Suportado`}),`\n`,_jsxs(_components.p,{children:[`Você pode fazer o download do modelo padrão diretamente no painel ou preparar seu arquivo `,_jsx(_components.code,{children:`.csv`}),` ou `,_jsx(_components.code,{children:`.xlsx`}),` com a seguinte estrutura:`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:`cep_origem_inicio`}),_jsx(_components.th,{style:{textAlign:`left`},children:`cep_origem_fim`}),_jsx(_components.th,{style:{textAlign:`left`},children:`cep_destino_inicio`}),_jsx(_components.th,{style:{textAlign:`left`},children:`cep_destino_fim`}),_jsx(_components.th,{style:{textAlign:`left`},children:`peso_max_kg`}),_jsx(_components.th,{style:{textAlign:`left`},children:`valor_frete`}),_jsx(_components.th,{style:{textAlign:`left`},children:`prazo_dias`}),_jsx(_components.th,{style:{textAlign:`left`},children:`ad_valorem_pct`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`01000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`09999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`80000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`82999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`30.0`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`45.90`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`3`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`0.30`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`01000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`09999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`80000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`82999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`100.0`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`110.00`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`3`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`0.30`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`01000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`09999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`80000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`82999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`500.0`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`280.00`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`4`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`0.30`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`01000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`09999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`83000000`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`89999999`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`30.0`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`65.00`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`4`}),_jsx(_components.td,{\"data-numeric\":`true`,style:{textAlign:`left`},children:`0.30`})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`campos`,children:`Campos`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:`Campo`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Tipo`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`cep_origem_inicio`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`string (8 dígitos)`}),_jsx(_components.td,{style:{textAlign:`left`},children:`CEP inicial da faixa de origem`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`cep_origem_fim`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`string (8 dígitos)`}),_jsx(_components.td,{style:{textAlign:`left`},children:`CEP final da faixa de origem`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`cep_destino_inicio`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`string (8 dígitos)`}),_jsx(_components.td,{style:{textAlign:`left`},children:`CEP inicial da faixa de destino`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`cep_destino_fim`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`string (8 dígitos)`}),_jsx(_components.td,{style:{textAlign:`left`},children:`CEP final da faixa de destino`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`peso_max_kg`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`decimal`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Peso máximo cobrado nesta faixa`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`valor_frete`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`decimal`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Valor do frete em BRL`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`prazo_dias`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`integer`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Prazo de entrega em dias úteis`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`ad_valorem_pct`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`decimal`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Percentual de ad-valorem (seguro) — opcional`})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`lógica-de-matching`,children:`Lógica de matching`}),`\n`,_jsx(_components.p,{children:`Quando uma cotação chega, o BulkRoute busca a linha que:`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`CEP de origem está dentro da faixa `,_jsx(_components.code,{children:`cep_origem_inicio`}),` → `,_jsx(_components.code,{children:`cep_origem_fim`})]}),`\n`,_jsxs(_components.li,{children:[`CEP de destino está dentro da faixa `,_jsx(_components.code,{children:`cep_destino_inicio`}),` → `,_jsx(_components.code,{children:`cep_destino_fim`})]}),`\n`,_jsxs(_components.li,{children:[`Peso total ≤ `,_jsx(_components.code,{children:`peso_max_kg`}),` (usa a linha com menor `,_jsx(_components.code,{children:`peso_max_kg`}),` que atenda)`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`Se não encontrar nenhuma linha, a planilha é descartada da cotação.`}),`\n`,_jsx(Heading,{level:`2`,id:`como-importar`,children:`Como Importar`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`Acesse `,_jsx(_components.strong,{children:`Transportadoras`}),` > `,_jsx(_components.strong,{children:`Tabelas Offline / Planilhas`}),`.`]}),`\n`,_jsxs(_components.li,{children:[`Clique em `,_jsx(_components.strong,{children:`Nova Tabela`}),`.`]}),`\n`,_jsxs(_components.li,{children:[`Dê um nome de identificação (ex: `,_jsx(_components.em,{children:`TransRegional - Tabela Sul 2026`}),`).`]}),`\n`,_jsx(_components.li,{children:`Arraste seu arquivo CSV ou Excel.`}),`\n`,_jsxs(_components.li,{children:[`O sistema validará a consistência de:`,`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`Faixas de CEP (sem sobreposição inválida)`}),`\n`,_jsx(_components.li,{children:`Pesos (crescentes dentro da mesma faixa)`}),`\n`,_jsx(_components.li,{children:`Campos obrigatórios preenchidos`}),`\n`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`Clique em `,_jsx(_components.strong,{children:`Salvar e Publicar`}),`.`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`A partir desse momento, as cotações para as faixas de CEP contempladas incluirão essa opção automaticamente.`}),`\n`,_jsx(Heading,{level:`2`,id:`múltiplas-tabelas`,children:`Múltiplas Tabelas`}),`\n`,_jsx(_components.p,{children:`Você pode ter múltiplas tabelas ativas simultaneamente:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`TransRegional - Sul`}),` → CEPs 80000-82999`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`TransRegional - Sudeste`}),` → CEPs 00000-19999`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Transportadora X - Nacional`}),` → Todos os CEPs`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`O BulkRoute consulta todas as tabelas ativas e retorna a melhor opção para cada faixa.`}),`\n`,_jsx(Heading,{level:`2`,id:`atualização-de-tabela`,children:`Atualização de Tabela`}),`\n`,_jsx(_components.p,{children:`Quando a transportadora atualiza a tabela contratual:`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsx(_components.li,{children:`Importe a nova planilha com o mesmo nome (ou um novo nome)`}),`\n`,_jsxs(_components.li,{children:[`Se mesmo nome: o BulkRoute `,_jsx(_components.strong,{children:`substitui`}),` a tabela anterior`]}),`\n`,_jsx(_components.li,{children:`Se novo nome: ambas ficam ativas (você pode desativar a antiga depois)`}),`\n`]}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[`Mantenha um padrão de nomenclatura com ano/semestre: `,_jsx(_components.code,{children:`TransRegional-Sul-2026H2`}),`. Isso facilita saber qual tabela está vigente.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`limitações`,children:`Limitações`}),`\n`,_jsxs(Warning,{children:[_jsxs(_components.p,{children:[`Planilhas offline `,_jsx(_components.strong,{children:`não suportam`}),`:`]}),_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Emissão de etiqueta`}),` — não há API para gerar etiqueta. Use a etiqueta genérica do BulkRoute (PDF 100×150mm com Code-128).`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Solicitação de coleta`}),` — você precisa agendar a coleta diretamente com a transportadora.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Rastreamento automático`}),` — sem API, o BulkRoute não consegue fazer polling. O status precisa ser atualizado manualmente ou via webhook outbound do seu ERP.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Cancelamento automático`}),` — você precisa cancelar diretamente com a transportadora.`]}),`\n`]})]}),`\n`,_jsx(Heading,{level:`2`,id:`rastreamento-manual`,children:`Rastreamento manual`}),`\n`,_jsx(_components.p,{children:`Para shipments despachados via planilha offline:`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsx(_components.li,{children:`Quando a transportadora atualizar o status, atualize manualmente no painel`}),`\n`,_jsxs(_components.li,{children:[`Ou configure um webhook do seu ERP para atualizar via API: `,_jsx(_components.code,{children:`PATCH /shipments/{id}/status`})]}),`\n`,_jsx(_components.li,{children:`O cliente final recebe as notificações normalmente`}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`troubleshooting`,children:`Troubleshooting`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:`Problema`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Causa`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Solução`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Cotação não retorna a planilha`}),_jsx(_components.td,{style:{textAlign:`left`},children:`CEP fora da faixa`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Verificar faixas de CEP na planilha`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`Validation Error`}),` no upload`]}),_jsx(_components.td,{style:{textAlign:`left`},children:`Faixas sobrepostas`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Corrigir sobreposição no CSV`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Peso não encontrado`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Peso acima do máximo`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Adicionar linha com peso maior`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`Valor errado`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Linha com peso_max errado`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Verificar se a linha correta está sendo selecionada`})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Importação de Tabelas em Planilha","description":"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.","href":"/transportadoras/planilha"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Quando usar","slug":"quando-usar","depth":2,"children":[]},{"title":"Modelo de Planilha Suportado","slug":"modelo-de-planilha-suportado","depth":2,"children":[{"title":"Campos","slug":"campos","depth":3,"children":[]},{"title":"Lógica de matching","slug":"lógica-de-matching","depth":3,"children":[]}]},{"title":"Como Importar","slug":"como-importar","depth":2,"children":[]},{"title":"Múltiplas Tabelas","slug":"múltiplas-tabelas","depth":2,"children":[]},{"title":"Atualização de Tabela","slug":"atualização-de-tabela","depth":2,"children":[]},{"title":"Limitações","slug":"limitações","depth":2,"children":[]},{"title":"Rastreamento manual","slug":"rastreamento-manual","depth":2,"children":[]},{"title":"Troubleshooting","slug":"troubleshooting","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"bulkroute","siteName":"BulkRoute Central de Ajuda","title":"Importação de Tabelas em Planilha - BulkRoute Central de Ajuda","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-09-08T20:04:29.959Z","originalFileLocation":"transportadoras/planilha.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.\">\u003cmeta data-mint-head name=\"application-name\" content=\"BulkRoute Central de Ajuda\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Importação de Tabelas em Planilha - BulkRoute Central de Ajuda\">\u003cmeta data-mint-head property=\"og:description\" content=\"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"BulkRoute Central de Ajuda\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.bulkroute.com.br/transportadoras/planilha\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://bulkroute.mintlify.app/_mintlify/api/og/v2?division=Conectando+Transportadoras\u0026amp;title=Importa%C3%A7%C3%A3o+de+Tabelas+em+Planilha\u0026amp;description=Utilize+tabelas+de+frete+em+CSV%2FExcel+para+transportadoras+sem+integra%C3%A7%C3%A3o+via+API.\u0026amp;theme=0c7dcfd3b6758027c3a449b0\u0026amp;signature=5818e3e933a49634596579e4aea7c751b80d199f1823eecc2005e67c263993e4\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Importação de Tabelas em Planilha - BulkRoute Central de Ajuda\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://bulkroute.mintlify.app/_mintlify/api/og/v2?division=Conectando+Transportadoras\u0026amp;title=Importa%C3%A7%C3%A3o+de+Tabelas+em+Planilha\u0026amp;description=Utilize+tabelas+de+frete+em+CSV%2FExcel+para+transportadoras+sem+integra%C3%A7%C3%A3o+via+API.\u0026amp;theme=0c7dcfd3b6758027c3a449b0\u0026amp;signature=5818e3e933a49634596579e4aea7c751b80d199f1823eecc2005e67c263993e4\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/bulkroute/QzBF_XssoisPy8WG/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"BulkRoute Central de Ajuda\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#2563eb\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.bulkroute.com.br/transportadoras/planilha\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/transportadoras/planilha.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.bulkroute.com.br/#organization\",\"name\":\"BulkRoute Central de Ajuda\",\"url\":\"https://docs.bulkroute.com.br\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/bulkroute/3b7W0SLBzshYyGcU/images/logo-light.svg?fit=max\u0026auto=format\u0026n=3b7W0SLBzshYyGcU\u0026q=85\u0026s=0a9290ede9e4a8387b55515feeea5769\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.bulkroute.com.br#website\",\"name\":\"BulkRoute Central de Ajuda\",\"url\":\"https://docs.bulkroute.com.br\",\"publisher\":{\"@id\":\"https://docs.bulkroute.com.br/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.bulkroute.com.br/transportadoras/planilha#webpage\",\"url\":\"https://docs.bulkroute.com.br/transportadoras/planilha\",\"name\":\"Importação de Tabelas em Planilha\",\"description\":\"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.\",\"dateModified\":\"2026-09-08T20:04:29.959Z\",\"isPartOf\":{\"@id\":\"https://docs.bulkroute.com.br#website\"},\"breadcrumb\":{\"@id\":\"https://docs.bulkroute.com.br/transportadoras/planilha#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.bulkroute.com.br/transportadoras/planilha#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Conectando Transportadoras\",\"item\":\"https://docs.bulkroute.com.br/transportadoras/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importação de Tabelas em Planilha\",\"item\":\"https://docs.bulkroute.com.br/transportadoras/planilha\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.bulkroute.com.br/transportadoras/planilha#article\",\"headline\":\"Importação de Tabelas em Planilha\",\"name\":\"Importação de Tabelas em Planilha\",\"description\":\"Utilize tabelas de frete em CSV/Excel para transportadoras sem integração via API.\",\"url\":\"https://docs.bulkroute.com.br/transportadoras/planilha\",\"mainEntityOfPage\":{\"@id\":\"https://docs.bulkroute.com.br/transportadoras/planilha#webpage\"},\"dateModified\":\"2026-09-08T20:04:29.959Z\",\"publisher\":{\"@id\":\"https://docs.bulkroute.com.br/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.bulkroute.com.br#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"BulkRoute Central de Ajuda\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"BulkRoute Central de Ajuda","nav":{"global":null,"tabs":[{"tab":"Documentação","pages":[{"title":"Documentação","href":""}]},{"tab":"Painel Admin","pages":[{"title":"Painel Admin","href":"/painel-admin"}]},{"tab":"Transportadoras","groups":[{"group":"Conectando Transportadoras","pages":[{"title":"Visão Geral de Transportadoras","href":"/transportadoras/overview"},{"title":"Configurando a Braspress","href":"/transportadoras/braspress"},{"title":"Configurando o SSW Sistema de Transportes","href":"/transportadoras/ssw"},{"title":"Configurando a Jadlog","href":"/transportadoras/jadlog"},{"title":"Configurando os Correios (CWS API)","href":"/transportadoras/correios"},{"title":"Configurando Frota Própria \u0026 Motoristas","description":"Como despachar pedidos para veículos da sua empresa e motoristas usando o app PWA.","href":"/transportadoras/frota-propria"},{"title":"Importação de Tabelas em Planilha","href":"/transportadoras/planilha"}]}]},{"tab":"Integrações","pages":[{"title":"Integrações","href":"/integracoes/overview"}]},{"tab":"API \u0026 Integração","pages":[{"title":"API \u0026 Integração","href":"/api-reference/introduction"}]}]},"basePath":"","title":"Importação de Tabelas em Planilha - BulkRoute Central de Ajuda","buildId":"dpl_9VVk5y1P8k1ATeJguVngy9Q3cmbD","deploymentId":"dpl_9VVk5y1P8k1ATeJguVngy9Q3cmbD","dynamics":[],"chunks":[]}
