Table 15 - Products
- This article introduces the fields of the product integration layout. To better understand the concept behind the products, see our article on Product Concept.
- To carry out this integration, you must send the information along with Table 13 - Product Price.
| Order | Field Description | Format and Size | Required | Version | Note | ||||
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=15 (2) | Yes | 1.0 | |||||
| 2 | Product Code (code) | Text (30) | Yes | 1.0 | |||||
| 3 | Product Group Code (codGrupoProduto) | Text (30) | No | 1.0 | |||||
| 4 | Brand Code (codMarca) | Integer (10) | No | 1.0 | |||||
| 5 | Product Description (description) | Text (100) | Yes | 1.0 | |||||
| 6 | Balance in Stock (saldoEstoque) | Decimal (15.4) | No | 1.0 | |||||
| 7 | Sales Unit (unidadeVenda) | Text (5) | No | 1.0 | Informs whether the product is CX, FD, UN… | ||||
| 8 | Not Used | No | 1.0 | Not Used, old precoProduto | |||||
| 9 | Allows Discount (permiteDesconto) | Integer (1) | Yes | 1.0 | 0 - Does not allow, 1 - Allows The information in this field is no longer being used. We are only taking into consideration the “Maximum Discount Percentage” field intable 13 - Product Prices. | ||||
| 10 | Unused | No | 1.0 | Unused, old percentualMinimo | |||||
| 11 | Unused | No | 1.0 | Unused, old percentualMaximo | |||||
| 12 | Size Code (codTamanho) | Text (50) | No | 2.40 | Size code. EX: S, M, L, XXL, EGG, 10, 40, 41…. (On the Demander web it is possible to configure the display order of each size, currently this information does not come via integration) | ||||
| 13 | Not Used | No | 1.0 | No Used | |||||
| 14 | Not Used | No | 1.0 | Not Used | |||||
| 15 | Not Used | No | 1.0 | No Used | |||||
| 16 | Not Used | No | 1.0 | Not Used | |||||
| 17 | Not Used | No | 1.0 | No Used | |||||
| 18 | Free Field 1 (campoLivre1) | Text (500) | No | 1.0 | |||||
| 19 | Free Field 2 (campoLivre2) | Text (500) | No | 1.0 | |||||
| 20 | Free Field 3 (campoLivre3) | Text (2000) | No | 1.0 | |||||
| 21 | Active (active) | Integer (1) | Yes | 1.0 | |||||
| 22 | Minimum quantity per Order (qtdeMinimaPorPedido) | Decimal (10,2) | No | 1.11 | This field defines the minimum quantity allowed to add a product to the order.Example:If the defined value is6, the system will only allow the item to be included if the quantity entered is greater than 6.
| ||||
| 23 | Reference (reference) | Text (50) | No | 1.0 | Product Reference, can be used forTo send an alphanumeric code, | ||||
| 24 | Batch Control (controlePorLote) | Integer (1) | No | 2.10 | Identifies whether the product is batch controlled.*(Mandatory field for batch control in the app) 0 - Does not control the batch batch, 1 - Controls the batch The number of days to be notified when the batch is due can be configured on the Company Settings screen, General tab in the field “Number of days to view expiring batches” | ||||
| 25 | Product NCM (codNCM) | Text (50) | No | 2.13 | Product NCM Code, information used in IPI and ST calculations. | ||||
| 26 | Tariff Price (ICMS ST) (precoPauta) | Double | No | 2.13 | Product Tariff Price (Minimum Price), can be used in the ICMS ST calculation, depending on the configuration. | ||||
| 27 | Note (observation) | Text (5000) | No | 2.20 | Replace the line breaks (real) with the text “\n”, so that the entire product record is on a single line. | ||||
| 28 | Note displayed in the Online Store (observacaoLojaVirtual) | Text (2000) | No | 2.37 | Replace line breaks (real) with text “\n”, so the entire product record is on a single line. | ||||
| 29 | Stock Date (dataEstoque) | DateTime | No | 2.44 | Date and time of the last stock change for this product. ATTENTION: In no way send the current date and time in this field, this will negatively affect the synchronization performance of sellers, as with each synchronization they will download all of the company’s stock records. If your system is not structured to provide the date/time of the last stock change of the product in question, leave this field empty. (segmentosRelacionados) | Text (500) | No | 2.48 | Code of segments related to the product. These codes must be separated by a comma (,). Each code will be validated separately as an integer. |
| 31 | Main product code (codProdutoPrincipal) | Text (30) | No | 3.3 | Group product code for the different grade variations of this product | ||||
| 32 | Main product description (descProdutoPrincipal) | Text (100) | No | 3.3 | Buncher product description | ||||
| 33 | Grid segment code (codSegmentoGrade) | Text (50) | No | 3.3 | Code referring to the grid segment of table 133 – Grid Segment | ||||
| 34 | Grid variation code 1 (codTipoGradeVariacao1) | Text (50) | No | 3.3 | Grid Variation Code 1 | ||||
| 35 | Grid Variation Code 2 (codTipoGradeVariacao2) | Text (50) | No | 3.3 | Grid Variation Code 2 | ||||
| 36 | Grid Variation Code 3 (codTipoGradeVariacao3) | Text (50) | No | 3.3 | Depreciated | ||||
| 37 | Grid Variation Code 4 (codTipoGradeVariacao4) | Text (50) | No | 3.3 | Depreciated | ||||
| 38 | Bar Code (codigoBarras) | Text (20) | No | 3.69 | Product barcode, which can be EAN8, EAN13, UCC12, DUN14 or its own barcode defined internally by the company. This field is used as a filter in the product search fields on Android and iOS.Ex: Where the product is the “1L Milk Carton”: -The barcode on the individual 1-liter packaging corresponds to codigoBarras -The barcode on the milk carton packaging that contains 12 liters corresponds to codigoBarrasEmbalagem (field 39) Ex2: Where the product is the “Milk Carton with 12 units”t;: -The barcode on the packaging of the milk carton that contains the 12 liters corresponds to codigoBarras. -Do not send anything in field 39. | ||||
| 39 | Packaging Barcode | Text(20) | No | 4.30 | Ex: Where the product is “1 L Milk Carton”: -The barcode of individual 1-liter packages corresponds to codigoBarras(field 38) -The barcode on the packaging of the milk carton that contains the 12 liters, corresponds to codigoBarrasEmbalagem Ex2: Where the product is the “Milk Carton with 12 units”: -The barcode on the packaging of the milk carton that contains the 12 liters, corresponds to codigoBarras (send in the field 38). -Do not send anything in field 39. | ||||
| 40 |
| Text(50) | No | 4.32 | The field “Separation Order” is crucial for efficient separation of products in the application. By filling in this field, you determine the order in which the products will be presented for separation, which helps with organization and agility of the process. It is important to configure the “Separation Settings” and choose the sorting option by the “Product. Separation Order” field to use this resource. | ||||
| 41 | qtdePorPallet | Decimal | No | 4.47 | Determines the number of units of the product that fit on a pallet. |
Registration Example:
15 |1407 |