A VTEX é um gigante do e-commerce brasileiro que oferece uma plataforma de comércio unificado utilizada por mais de 2500 empresas em 25 países, entre elas estão Walmart, Coca-cola, Sony, Disney e AmBev.
A nossa integração permite que você coloque as informações da VTEX no seu Data Warehouse e faça cruzamentos com dados de outras ferramentas.
Adicionando o conector
Para adicionar o conector da VTEX na plataforma da Kondado, siga os passos abaixo:
1) Acesse o painel administrativo da VTEX com a conta de usuário master
2) Na barra lateral, acesse Configurações da Conta, depois Gerenciamento da Conta e então clique em Chaves de aplicação
3) Clique no botão Gerenciar minhas chaves, você será direcionado(a) para a página Minhas chaves:
4) Clique no botão Gerar Chave
5) Insira um nome para a chave de aplicação que está sendo criada
PASSO IMPORTANTE PARA O FUNCIONAMENTO DO CONECTOR:
6) Clique em +Adicionar Perfis para associar a chave aos perfis de acesso desejados -> a chave de aplicação será capaz de autenticar integrações com os módulos e funcionalidades aos quais os perfis escolhidos dão acesso
7) Clique no botão Gerar
8) No campo que é exibido em seguida, fica o token. Por uma questão de segurança, ele é exibido apenas uma vez. Copie esse token e guarde-o em local seguro.
9) Faça login na plataforma da Kondado e vá para a página de adicionar conectores
10) Selecione o conector da VTEX e preencha as informações conforme imagem abaixo
a) Nome da conta: é a primeira parte da sua URL administrativa da VTEX. Por exemplo, se a sua URL é kondado.myvtex.com, o valor a ser preenchido é kondado
b) Access Key: corresponde a Chave de aplicação gerada no passo (7)
c) Access Secret: corresponde ao Token de aplicação gerado no passo (7) e copiado no passo (8)
d) Dê um nome ao seu conector e clique em SALVAR
Integrações
Índice
- Coupons
- Inventory
- Master data
- Orders
- Orders Logistics Info
- Orders Marketing Data
- Orders Shipping Data
- Orders details
- Orders items
- Orders payment transactions
- Orders rates and benefits
- Orders totals
- Promotions
- SKUs
- SKUs: kits
- SKUs: prices
Gráfico de relacionamento
Clique para ampliar
Orders com o status de incompleto não serão retornadas
Coupons
Campo | Tipo | |
---|---|---|
text |
[en] Coupon code [upper case applied by Kondado] |
|
text |
[en] Coupon expiration interval per use. |
|
boolean |
[en] Defines if the coupon is archived (true) or not (false). |
|
timestamp |
||
float |
[en] Maximum items per client that the coupon can be applied. |
|
text |
[en] UTM campaign code. |
|
text |
[en] UTM source code. |
Inventory
Campo | Tipo | |
---|---|---|
text |
||
text |
||
text |
||
float |
||
float |
||
boolean |
Master data
Esta integração requer a permissão “ADMIN_DS”
Esta integração está em modo beta
Campo | Tipo | |
---|---|---|
text |
[en] Master data entity Id |
|
timestamp |
[en] Timestamp of when record was last updated |
|
timestamp |
[en] Timestamp of when record was created |
|
text |
[en] an example of a dynamic property |
|
float |
[en] an example of a dynamic property |
|
date |
[en] an example of a dynamic property |
Orders
Campo | Tipo | |
---|---|---|
text |
[en] Change receipt order Id |
|
text |
[en] Order Origin: Marketplace or Fulfillment |
|
text |
[en] Order Status |
|
boolean |
[en] If is in a Work Flow Retry |
|
text |
[en] Last sent transactional message |
|
float |
[en] Order Sequence ID |
|
text |
||
text |
[en] Payment System Name |
|
text |
[en] Seller Name who was responsible for the order |
|
timestamp |
||
text |
||
boolean |
[en] If is in a Work Flow Retry |
|
timestamp |
||
text |
||
text |
[en] Marketplace Order Id |
|
text |
||
boolean |
[en] If is a Order Completed |
|
text |
||
float |
[en] Releated Gift List Type |
|
text |
[en] Order Sales Channel Id |
|
float |
[en] Total Order Items |
|
timestamp |
[en] Authorized Order Date |
|
timestamp |
[en] Order Creation Date |
|
text |
[en] Status Description |
|
text |
[en] Releated Gift List Id |
|
timestamp |
||
text |
[en] Currency Code in ISO 4217 |
|
text |
Orders Logistics Info
Objeto principal
Campo | Tipo | |
---|---|---|
text |
[en] Order Id |
|
float |
||
text |
||
text |
||
text |
||
text |
||
float |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
boolean |
||
text |
||
float |
||
text |
||
float |
||
text |
||
timestamp |
||
text |
[en] Shipping Country in ISO 3166 ALPHA-3 abbreviation |
|
text |
vtex_logisticsinfo__slas
Campo | Tipo | |
---|---|---|
text |
[en] Order Id |
|
float |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
boolean |
||
text |
||
float |
||
text |
||
text |
vtex_logisticsinfo__deliveryIds
Campo | Tipo | |
---|---|---|
text |
[en] Order Id |
|
float |
||
text |
||
text |
||
text |
||
text |
||
float |
||
text |
Orders Marketing Data
Campo | Tipo | |
---|---|---|
text |
[en] Order Id |
|
text |
[en] UTM Source Parameters |
|
text |
[en] UTM Source Parameters |
|
text |
[en] UTM Medium Parameters |
|
text |
[en] UTM Campaign Parameters |
|
text |
[en] Order Discount Coupon [upper case applied by Kondado] |
|
text |
[en] UTMI Campaign Internal Parameters |
|
text |
[en] UTMI Page Internal Parameters |
|
text |
[en] UTMI Part Internal Parameters |
|
text |
[en] Marketing Tags Array |
Orders Shipping Data
Objeto principal
Campo | Tipo | |
---|---|---|
text |
[en] Order Id |
|
text |
[en] Shipping Address Type |
|
text |
[en] Shipping Neighborhood |
|
text |
[en] Shipping Address Id |
|
text |
[en] Shipping Complement |
|
text |
[en] Shipping Number |
|
text |
[en] Shipping Street |
|
text |
[en] Shipping Geo Coordinates Array |
|
text |
[en] Shipping City |
|
text |
[en] Shipping Reference |
|
text |
[en] Shipping Receiver Name |
|
text |
[en] Shipping Country in ISO 3166 ALPHA-3 abbreviation |
|
text |
[en] Shipping State |
|
text |
[en] Shipping Postal Code |
vtex_orders_shipping_data__selectedAddresses
Campo | Tipo | |
---|---|---|
text |
[en] Related Order Id |
|
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
Orders details
Campo | Tipo | |
---|---|---|
text |
[en] Change receipt order Id |
|
text |
[en] Order Origin: 'Marketplace' or 'Fulfillment' |
|
text |
[en] Marketplace Services Endpoint |
|
text |
[en] Open Text Field Object |
|
text |
[en] Order Sequence ID |
|
text |
||
text |
[en] Marketplace Order Id |
|
text |
[en] Custom Data Object |
|
text |
[en] Responsible store e-mail |
|
boolean |
||
timestamp |
[en] Order Last Change Date |
|
text |
||
boolean |
[en] If is a Order Completed |
|
text |
[en] Seller Name who was responsible for the order |
|
text |
||
text |
||
text |
[en] Cliente Corporate Telephone |
|
boolean |
[en] If the Client is a Corporate Client |
|
text |
||
text |
[en] Client Corporate Document |
|
text |
[en] Client Telephone |
|
text |
[en] Client User Profile ID |
|
text |
[en] Client Document Type |
|
text |
||
text |
[en] Client First Name |
|
text |
||
text |
[en] Client Last Name |
|
text |
[en] Client Corporate Inscription |
|
text |
[en] Client Corporate Name |
|
text |
[en] Client Document |
|
text |
[en] Client e-mail |
|
text |
[en] Order Form Id |
|
timestamp |
[en] Order Creation Date |
|
boolean |
[en] If Cancellation is allowed |
|
text |
||
timestamp |
[en] Invoice Date |
|
boolean |
[en] If Order Edition is allowed |
|
text |
[en] Merchant Name |
|
timestamp |
[en] Authorized Order Date |
|
text |
[en] Cancel Reason |
|
text |
[en] Account Hostname registered in License Manager |
|
text |
[en] Call Center Operator responsible for the order |
|
float |
[en] Price Tag Value |
|
text |
[en] Status Description |
|
text |
||
text |
[en] Order Group Id |
|
text |
[en] Order Status |
|
text |
[en] Order Seller Id |
|
text |
||
text |
||
float |
[en] Rounding Error Total Amount |
|
text |
[en] Order Sales Channel Id |
|
text |
[en] If is a Certified Marketplace |
|
text |
[en] Marketplace Base URL |
|
text |
[en] Marketplace Name |
Orders items
Objeto principal
Campo | Tipo | |
---|---|---|
text |
[en] Order Id |
|
int |
[en] This field is calculated by Kondado and indicates the position of the given item within the order response array – useful for referrencing with other pipelines that use the field 'itemindex' |
|
text |
||
text |
||
text |
||
boolean |
[en] If this item is a gift in order context |
|
float |
[en] Comission value registered to Seller |
|
float |
[en] Comission value registered to Seller |
|
text |
||
float |
[en] Item Shipping Price |
|
text |
[en] SKU EAN |
|
text |
||
text |
[en] Item Name |
|
text |
||
text |
||
text |
[en] Item Measurement Unit |
|
float |
[en] Item Unit Multipler |
|
text |
[en] Item Product ID |
|
text |
[en] Item Reference ID |
|
text |
[en] Item Tax Code |
|
text |
||
float |
[en] Item Tax |
|
text |
[en] Product Slug URL |
|
text |
||
text |
[en] Call Center Operator responsible for the order |
|
text |
[en] Item ID |
|
text |
[en] Item Seller |
|
text |
[en] Item Order Unique ID |
|
float |
||
text |
[en] Item Pre Sale Date |
|
float |
[en] Item Selling Price |
|
text |
[en] Invoice Date |
|
float |
[en] Item Price |
|
text |
||
float |
[en] Item Reward value |
|
text |
[en] Reservation ID |
|
text |
[en] SKU Image URL |
|
float |
[en] Item List Price |
|
float |
[en] Item Quantity |
|
text |
[en] Brand Name |
|
text |
[en] Brand ID |
|
text |
[en] Item Category ID |
|
text |
[en] All releated Product Clusters |
|
text |
||
text |
||
text |
||
text |
||
float |
[en] Item Cubic Weight |
|
float |
[en] Item Height |
|
float |
[en] Item Length |
|
float |
[en] Item Weight |
|
float |
[en] Item Width |
vtex_orders_items__additionalinfo__categories
Campo | Tipo | |
---|---|---|
text |
[en] Related Order ID |
|
text |
[en] Related Item Order Unique ID |
|
text |
||
text |
Orders payment transactions
Objeto principal
Campo | Tipo | |
---|---|---|
text |
||
boolean |
[en] If is a active transaction |
|
text |
[en] Transaction Merchant Name |
|
text |
[en] Transaction Status |
|
text |
[en] Transaction Id |
vtex_payment_transactions__payments
Campo | Tipo | |
---|---|---|
text |
||
text |
[en] Transaction Id |
|
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
[en] Connector Return Code |
|
text |
||
text |
[en] Connector Authorization Id |
|
text |
||
text |
||
text |
||
text |
||
text |
[en] Payment Card Holder |
|
date |
[en] Payment Due Date |
|
text |
[en] Payment Card expire Month |
|
text |
[en] Payment Card expire Year |
|
text |
[en] Payment Card First Digits |
|
text |
||
text |
[en] Gift Card Caption |
|
text |
[en] Gift Card Id |
|
text |
[en] Gift Card Name |
|
text |
||
text |
[en] Payment Group. It represents the payment method. |
|
text |
||
float |
||
text |
||
text |
[en] Payment Card Last Digits |
|
text |
||
text |
||
text |
||
text |
||
text |
||
float |
||
text |
||
text |
[en] Payment URL |
|
float |
Orders rates and benefits
Objeto principal
Campo | Tipo | |
---|---|---|
text |
[en] Order Seller Id |
|
text |
[en] Item Description |
|
boolean |
[en] If it is allowed to acumulate the Rates and Benefits |
|
text |
[en] The id of the promotion[Kondado] |
|
text |
[en] Rates and Benefits Name |
vtex_orders_rates_and_benefits_matchedParameters
Campo | Tipo | |
---|---|---|
text |
[en] Order Seller Id |
|
text |
[en] The id of the promotion[Kondado] |
|
text |
||
text |
Orders totals
Campo | Tipo | |
---|---|---|
text |
[en] Change receipt order Id |
|
float |
[en] Itens total |
|
float |
[en] Discounts total |
|
float |
[en] Shipping/freight total |
|
float |
[en] Tax total |
Promotions
Objeto principal
Campo | Tipo | |
---|---|---|
text |
[en] Promotion ID |
|
boolean |
[en] If set as true, gifts Multiplier is activated. |
|
boolean |
[en] If set to false, this Promotion will be applied to any trade policies present on the idsSalesChannel field. If set to true, trade policies present on that field will make this Promotion or Tax not to be applied. |
|
timestamp |
[en] Promotion or Tax Begin Date |
|
text |
[en] Internal description of the Promotion or Tax. |
|
timestamp |
[en] Promotion or Tax End Date |
|
boolean |
||
boolean |
[en] if set as true the Promotion is activated. If set as false the Promotion is deactivated. |
|
boolean |
[en] If set as true the Promotion is archived. If set as false the Promotion is not archived. |
|
boolean |
||
timestamp |
||
float |
[en] Defines how many times the Promotion can be used. |
|
text |
[en] Promotion name or Tax name. |
|
float |
[en] Percentual Tax over purchase total value. |
|
boolean |
||
float |
[en] Object composed by the brands that will activate or deactivate the Promotion |
|
boolean |
[en] if set to true, this Promotion will be applied to any brand present on the brands field. If set to false, brands present on that field will make this Promotion not to be applied. |
|
float |
[en] Object composed by the categories that will activate or deactivate the Promotion |
|
boolean |
[en] If set to true, this Promotion will be applied to any category present on the categories field. If set to false, categories present on that field will make this Promotion not to be applied. |
|
float |
[en] Object composed by the collections that will activate or deactivate the Promotion |
|
boolean |
||
float |
[en] Object composed by the products that will activate or deactivate the Promotion |
|
boolean |
[en] If set to true, this Promotion will be applied to any product present on the products field. If set to false, products present on that field will make this Promotion not to be applied. |
|
float |
||
boolean |
||
float |
[en] Object composed by the SKUs that will activate or deactivate the Promotion |
|
boolean |
[en] If set to true, this Promotion will be applied to any SKU present on the skus field. If set to false, SKUs present on that field will make this Promotion not to be applied. |
|
text |
||
text |
[en] Defines what is the type of the promotion |
|
text |
||
text |
[en] Coupon utmSource code. |
|
text |
promotions__Campaigns
promotions_idsSalesChannel
SKUs
Objeto principal
Campo | Tipo | |
---|---|---|
text |
[en] SKU ID |
|
float |
[en] SKU Width |
|
float |
[en] Packaged Weight in Kilos |
|
float |
[en] SKU Height |
|
float |
[en] Multiplies the amount of SKUs inserted on the cart |
|
float |
[en] Commercial Condition ID |
|
text |
[en] SKU RefId |
|
boolean |
[en] Shows if the SKU is a Kit |
|
boolean |
[en] Defines if Kit components can be sold apart |
|
text |
[en] SKU Estimated Date Arrival |
|
float |
[en] Packaged Width |
|
text |
[en] SKU Name |
|
float |
[en] Packaged Height |
|
float |
||
float |
[en] Packaged Length |
|
float |
[en] SKU Length |
|
text |
[en] Product ID |
|
text |
[en] Manufacturer Code |
|
text |
[en] Measurement Unit |
|
float |
[en] SKU Weight in Kilos |
|
float |
[en] How much the client will get rewarded by buying the SKU |
|
text |
[en] Defines deliver model |
|
timestamp |
[en] SKU Creation Date |
|
boolean |
[en] Shows if the SKU is active |
|
text |
[en] SKU EAN |
vtex_skus_videos
SKUs: kits
Campo | Tipo | |
---|---|---|
float |
[en] KIT SKU ID (parent) |
|
float |
[en] COMPONENT SKU ID (child) |
|
float |
[en] Component quantity. |
|
float |
[en] Component price per unit |
SKUs: prices
Objeto principal
Campo | Tipo | |
---|---|---|
float |
[en] SKU unique identifier number. |
|
float |
[en] SKU selling base price. |
|
float |
[en] SKU selling cost price. |
|
float |
[en] SKU's suggested selling price. |
|
float |
[en] The profit percentage that is to be obtained from the sale of that SKU |
vtex_skus_prices__fixedPrices
Campo | Tipo | |
---|---|---|
float |
[en] SKU unique identifier number. |
|
timestamp |
||
timestamp |
||
float |
[en] SKU List Fixed Price. |
|
float |
[en] Minimum quantity of the SKU for the fixed price to be applied. |
|
float |
[en] Trade policy name or ID than have the fixed price configured. |
|
float |
[en] Fixed price value. |