Table 13 - Product Prices
- This article presents the fields of the product prices integration layout. To better understand the concept behind price lists, see our article on Price List Concept.
- To carry out this integration, you need to send the information along with:
| Order | Field Description | Format and Size | Required | Version | Observations |
| 1 | Table Identifier (IDENTIFICADOR) | FIXED=13 (2) | Yes | 1.0 | |
| 2 | Product Code (codProduto) | Text (30) | Yes | 1.0 | |
| 3 | Price List Code (codListaPreco) | Text (20) | Yes | 1.0 | |
| 4 | Unit of Measure (unidade) | Text (5) | No | 1.0 | Unit of measure in which the product is sold. |
| 5 | Quantity per Package (qtdeEmbalagem) | Decimal (15,3) | No | 1.0 | If empty, defaults to 1. Number of units per package, informative field only. |
| 6 | Price (valor) | Decimal | Yes | 1.0 | |
| 7 | Maximum Discount Percentage (percDescontoMaximo) | Decimal | Yes | 1.13 | This field limits the maximum discount that the salesperson can give for this product when placing the order. |
| 8 | Allows Fractional Sale (permiteVendaFracionaria) | Integer (1) | No | 2.5 | This field defines whether the product can be sold in fractional quantities.
|
| 9 | Promotional Value (promocaoValor) | Decimal | No | 2.5 | Promotional price of the product, having greater prominence than the normal product price. |
| 10 | Promotion Start Date (promocaoDataInicio) | DateTime | No | 2.5 | Date from which the promotional price will be available. |
| 11 | Promotion End Date (promocaoDataFim) | DateTime | No | 2.5 | Date and time when the promotion ends. ATTENTION: be careful with the date and time format, because sending 2021-03-01 is the same as 2021-03-01 00:00:00. If you need the promotion to be valid until the end of the day, you must send it like this: 2021-03-01 23:59:59 |
| 12 | Considered Launch until (lancamentoAte) | DateTime | No | 2.12 | Date and time when the product ceases to be considered a Launch. ATTENTION: be careful with the date and time format, because sending 2021-03-01 is the same as 2021-03-01 00:00:00. If you need the launch to be considered until the end of the day, you must send it like this: 2021-03-01 23:59:59 |
| 13 | Multiples allowed per package (multiplosPermitidosPorEmbalagem) | Text (100) | No | 2.16 | Field used in validating the order quantity. Separate with commas the lowest common multiples of quantities that can be sold. EX: "6, 9, 15" if the product can be sold in batches of 6, 9, or 15. |
| 14 | IPI value per unit (valorIpiPorUnidade) | Decimal (15,2) | No | 2.24 | Enter the IPI value per standard unit of the product here. This field only needs to be provided if the IPI calculation uses the calculation mode "2 - Value per Standard Unit" (see field "IPI Calculation Mode" in table "42 - Tax Configuration"). |
| 15 | Pre-fixed Price Options (opcoesDePrecoPreFixado) | Text | No | 2.26 | This field should only be filled in if you want to allow the salesperson to choose the unit price from a pre-fixed table. For example, if you send the values "5.90;5.95;6.15;", the salesperson must choose one of the 3 provided prices from a list. There is no limit on the number of values entered. Common scenario for animal feed factories. If you do not know what this is, leave this field empty. |
| 16 | Locked price (precoTravado) | Decimal (15,2) | No | 2.48 | This price takes priority over promotions, normal product prices, and pre-fixed prices. In addition, only discount by 'discount table' can 'edit' the 'locked price'. |
| 17 | Customer Code (codCliente) | Integer (10) | No | 3.11 | Fill in only if this is an exclusive price for a specific customer. |
| 18 | Gross Weight (kg) (pesoBruto) | Decimal | No | 3.10 | Gross weight in kg of 1 unit of the product. (EX: If the product is a BOX OF 12 BOTTLES, enter in this field the gross weight of the entire box, and not the weight of an individual bottle.) |
| 19 | Net Weight (kg) (pesoLiquido) | Decimal | No | 3.10 | Net weight in kg of 1 unit of the product. (EX: If the product is a BOX OF 12 BOTTLES, enter in this field the gross weight of the entire box, and not the weight of an individual bottle.) |
| 20 | Cubage (cubagem) | Decimal | No | 3.10 | Cubage in cubic meters of 1 unit of the product |
| 21 | Maximum Surcharge Percentage (percAcrescimoMaximo) | Decimal (15,2) | No | 3.15 | Determines the maximum surcharge percentage that can be applied to this item. When set to zero, the configuration is not used. |
| 22 | Replacement cost (custoReposicao) | Decimal (8,2) | No | 3.38 | This field is also used in validating the Order release hierarchy |
| 23 | Description of packaging sales unit (unidadeEmbalagem) | Text (5) | No | 3.38 | |
| 24 | Height (altura) | Decimal | No | 3.66 | |
| 25 | Width (largura) | Decimal | No | 3.66 | |
| 26 | Length/Depth (comprimento) | Decimal | No | 3.66 | |
| 27 | Price by Quantity JSON (jsonPrecoPorQuantidade) | Text | No | 3.67 | See details in the article Price by Quantity Integration. |
| 28 | Redispatch unit value | Decimal | No | 4.55 | If the company is configured to use redispatch, this value is automatically populated in the "Redispatch unit value" field on the order items screen. |
Record Example:
13|100487|1|CX|6|5.98|20|1|3.4|2015-01-23|2015-05-23|4,8,12|0,50||12|10|3|15.5|UN|0.5|1|2.5|[{"qtdeInicial":5,"valorUnitario":50.00,"percDescontoMaximo":10.00,"percAcrescimoMaximo":10.00},{"qtdeInicial":10,"valorUnitario":20.00}]|