How to import product price lists via spreadsheet
Available on:

In Demander Web, the Import screen registers the product price on the list from the model spreadsheet.
Products and price lists must already exist. To register product and list together, use the Produtos table.
Step by step
Section titled “Step by step”- Open the Import screen.
- If the screen asks for Empresa, select the company.
- In Tabela, select Lista Preço Produtos.
- Click Baixar a planilha de exemplo. The file is
PlanilhaExemploListaPrecoProduto.xlsx. - Use that model spreadsheet. Do not create another from scratch.
- Keep the first two rows: column names and Obrigatório / Opcional.
- Fill in data from the third row, one price per row.
- Pay attention to the required fields.
- Import the file in Importar arquivo (or drag the file). Accepts XLSX, ODS or CSV, up to 8 MB.
Required fields
Section titled “Required fields”The second row of the spreadsheet marks what is required. On each row fill in:
- Código do Produto
- Código Lista Preco
- Valor R$
- Percentual Desconto Máximo
The other fields are optional (unit, packaging, promotion, weight, customer, dimensions).
Prices are added to the Preços do Produto screen.
Manual registration: How to register product prices.