Skip to content
Light
English

How to import product price lists via spreadsheet

Available on:

Demander Web

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.

  1. Open the Import screen.
  2. If the screen asks for Empresa, select the company.
  3. In Tabela, select Lista Preço Produtos.
  4. Click Baixar a planilha de exemplo. The file is PlanilhaExemploListaPrecoProduto.xlsx.
  5. Use that model spreadsheet. Do not create another from scratch.
  6. Keep the first two rows: column names and Obrigatório / Opcional.
  7. Fill in data from the third row, one price per row.
  8. Pay attention to the required fields.
  9. Import the file in Importar arquivo (or drag the file). Accepts XLSX, ODS or CSV, up to 8 MB.

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.