> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nekt.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Dafiti as a data source
> Bring data from Dafiti Seller Center to your Lakehouse.
Dafiti is one of the largest fashion and lifestyle marketplaces in Brazil. Sellers manage their catalog, orders, and payouts in **Dafiti Seller Center**. The connector extracts your orders and order items, your catalog with stock and prices, and your financial statements and transactions, so you can analyze sales, margins, and payouts in your Lakehouse.
## Configuring Dafiti as a Source
In the [Sources](https://app.nekt.ai/sources) tab, click on the "Add source" button located on the top right of your screen. Then, select the Dafiti option from the list of connectors.
Click **Next** and you'll be prompted to add your access.
### 1. Add account access
Dafiti Seller Center authenticates API access with an **OAuth application** that you create inside your own Seller Center account. It gives you an **Application ID** and an **Application Secret**.
Sign in to Dafiti Seller Center and open **Settings** → **Integration Management** → **OAuth Applications**.
Click **Add Application** (top right corner), give it a name such as `Nekt`, and save.
Copy the **Application ID** and the **Application Secret** shown for the new application.
The OAuth application is linked to the Seller Center user who creates it. If that user is deactivated or deleted, the connection stops working. Create the application with a user that will stay active and whose role can see orders, catalog, and finance — areas the user cannot access are skipped during extraction.
The following configurations are available:
* **Application ID**: the Application ID of the OAuth application. Required.
* **Application Secret**: the Application Secret shown together with the Application ID. Required.
* **Start Date**: the earliest date of orders and financial transactions to extract. Leave it empty to extract the full history.
* **Lookback Days**: how many days are re-read before the last sync point on orders and financial transactions, so records changed while a sync was running are never missed. The default is 7.
* **Window Days**: the size, in days, of each date range requested from Dafiti. The default of 30 fits most accounts.
* **Requests Per Second**: how fast the connector may call Dafiti. Seller Center allows 30 requests per second per seller, and that budget is shared with every other integration connected to your account (ERP, hub, marketplace manager). The default of 5 leaves room for them.
Once you're done, click **Next**.
### 2. Select streams
Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. You can select entire groups of streams or pick specific ones.
> Tip: The stream can be found more easily by typing its name.
Order Items come from the same requests as Orders, so selecting them adds no extraction time. Product Stocks, on the other hand, makes one request per product set — on large catalogs it is the slowest stream, so deselect it if you do not need stock levels.
Select the streams and click **Next**.
### 3. Configure data streams
Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.
* **Layer**: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
* **Folder**: a folder can be created inside the selected layer to group all tables being created from this new data source.
* **Table name**: we suggest a name, but feel free to customize it. You have the option to add a **prefix** to all tables at once and make this process faster!
* **Sync Type**: Orders, Order Items, and Finance Transactions support INCREMENTAL. The catalog streams, Finance Statements, and Seller are extracted in full on every run. Read more about Sync Types [here](https://docs.nekt.com/get-started/core-concepts/types-of-sync).
Once you are done configuring, click **Next**.
### 4. Configure data source
Describe your data source for easy identification within your organization, not exceeding 140 characters.
To define your [Trigger](https://docs.nekt.com/get-started/core-concepts/triggers), consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times).
Optionally, you can define some additional settings:
* Configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource [here](https://docs.nekt.com/get-started/core-concepts/resource-control).
* Determine when to execute an **Additional [Full Sync](https://docs.nekt.com/get-started/core-concepts/types-of-sync#additional-full-sync)**. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while.
Once you are ready, click **Next** to finalize the setup.
### 5. Check your new source
You can view your new source on the [Sources](https://app.nekt.ai/sources) page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.
For you to be able to see it on your [Catalog](https://app.nekt.ai/catalog), you need at least one successful source run.
## Things to know
* **Customer data is masked by Dafiti.** Restricted fields of the billing and shipping addresses, such as email and phone, come masked from the API.
* **Transactions follow their statement.** A transaction belongs to the open statement (`statement_id` 0) until the statement closes. The connector re-reads the open statement and the statements closed since the last sync, so `statement_id` is updated when a statement closes.
* **Only active categories.** The category tree returned by Dafiti contains active categories only.
# Streams and Fields
Below you'll find all available data streams from Dafiti and their corresponding fields. API reference: [Seller Center REST API](https://api.sellercenter.com.br/docs/).
Marketplace orders (`GET /v2/orders`). Every sync reads the orders created or with an item changed since the last sync, re-reading the last 7 days by default.
Primary key: `id` · Replication key: `updated_at`
| Field | Type | Description |
| :------------------------------- | :--------------- | :-------------------------------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the order. |
| `uuid` | String | Unique string identifier of the order. |
| `number` | String | Order number shown to the seller and the customer. |
| `region_id` | String | Order identifier on the shop (region) side. |
| `seller_id` | Integer | Identifier of the seller. |
| `source` | String | Channel the order came from. |
| `customer_first_name` | String | First name of the customer. |
| `customer_last_name` | String | Last name of the customer. |
| `national_registration_number` | String | Registration number (CPF/CNPJ) of the customer. |
| `billing_address` | String | Billing address of the customer; restricted fields come masked (JSON object) |
| `shipping_address` | String | Shipping address of the customer; restricted fields come masked (JSON object) |
| `payment_method` | String | Payment method used for the order. |
| `currency` | String | Currency of the order amounts. |
| `item_count` | Integer | Number of items in the order. |
| `packed_items_count` | Integer | Number of items already packed. |
| `unit_price_sum_with_fees` | Number | Sum of the unit prices of the items, fees included. |
| `grand_total` | Number | Sum of the prices paid for the items, fees included. |
| `shipping_fee_sst_sum` | Number | Sum of the shipping fee SST tax. |
| `status_list` | String | Number of items in each item status, keyed by status (JSON object) |
| `order_item_ids` | Array of Integer | Identifiers of the items of the order. |
| `invoice_required` | Boolean | Whether an invoice is required for the order. |
| `payout_pending` | Boolean | Whether the order's payout transactions are on hold. |
| `gift_option` | Boolean | Whether the order was marked as a gift. |
| `gift_message` | String | Gift message left by the customer. |
| `voucher_code` | String | Voucher code applied to the order. |
| `voucher_type` | String | Type of the voucher applied to the order. |
| `delivery_info` | String | Additional delivery information. |
| `remarks` | String | Additional remarks about the order. |
| `extra_attributes` | String | Additional attributes set by the seller. |
| `shipment_provider_type` | String | Shipment provider type across all items (standard, express, ...) |
| `shipment_provider_pre_selected` | Boolean | Whether the shipment provider was pre-selected. |
| `exchange_by_order_id` | String | Identifier of the order that replaces this one in an exchange. |
| `exchange_for_order_id` | String | Identifier of the original order this one exchanges. |
| `printed` | Boolean | Whether all items of the order were printed. |
| `can_generate_invoice` | Boolean | Whether an invoice can be generated for the order. |
| `can_generate_shipping_label` | Boolean | Whether a shipping label can be generated for the order. |
| `target_to_ship` | Datetime | Promised shipment date, when the promised-date feature is enabled. |
| `pending_since` | Datetime | Date and time when the order's items first became pending. |
| `address_updated_at` | Datetime | Date and time when the address was last updated. |
| `created_at` | Datetime | Date and time when the order was created. |
| `updated_at` | Datetime | Date and time when the order was last updated, used as the incremental replication key. |
One row per item of each order, with price, discounts, commission, shipment and invoice data. Expanded from the order payload, so it adds no extraction time.
Primary key: `id` · Replication key: `order_updated_at`
| Field | Type | Description |
| :------------------------------ | :-------------- | :----------------------------------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the order item. |
| `uuid` | String | Unique string identifier of the order item. |
| `src_id` | String | Identifier of the order item on the shop side. |
| `order_id` | Integer | Identifier of the order. |
| `order_number` | String | Number of the order. |
| `seller_id` | Integer | Identifier of the seller. |
| `status` | String | Item status (pending, ready\_to\_ship, shipped, delivered, canceled, returned, ...) |
| `is_processable` | Boolean | Whether the item can be processed by the seller (not consignment or awaiting fulfilment) |
| `failure_reason_type` | String | Type of the failure reason (canceled, returned, failed, ...) |
| `failure_reason_name` | String | Name of the failure reason. |
| `failure_reason_description` | String | Description of the failure reason. |
| `failure_reason_details` | String | Additional details of the failure reason. |
| `product_name` | String | Name of the product sold. |
| `product_sku` | String | Shop SKU of the product sold. |
| `product_seller_sku` | String | Seller SKU of the product sold. |
| `product_variation` | String | Variation (usually size) of the product sold. |
| `product_image_url` | String | URL of the product image. |
| `unit_price` | Number | Price of the item. |
| `paid_price` | Number | Price paid by the customer for the item. |
| `price_after_discount` | Number | Price of the item after discounts. |
| `discount_amount` | Number | Discount applied to the item. |
| `tax_amount` | Number | Tax amount of the item. |
| `tax_percent` | Number | Tax percentage of the item. |
| `paid_commission` | Number | Commission paid on the item. |
| `shipping_fee` | Number | Shipping fee of the item. |
| `shipping_service_cost` | Number | Shipping service cost of the item. |
| `shipping_voucher_amount` | Number | Shipping voucher amount applied to the item. |
| `wallet_credits` | Number | Wallet credits used by the customer on the item. |
| `store_credits` | Number | Store credits used on the item. |
| `sales_due_amount` | Number | Sales amount due for the item. |
| `vouchers` | String | Discounts applied to the item, with the share funded by the seller (JSON array of objects) |
| `shipment_type` | String | Shipment type (warehouse, dropshipping, crossdocking, ...) |
| `shipment_method` | String | Where the item is delivered (home, pickup, ...) |
| `crossdocking_delivery_type` | String | Crossdocking delivery type (send\_to\_warehouse or pickup) |
| `shipment_provider_name` | String | Name of the shipment provider. |
| `shipment_provider_type` | String | Type of the shipment provider (standard, express, ...) |
| `pre_shipment_provider_name` | String | Name of the pre-defined shipment provider. |
| `shipment_provider_preselected` | Boolean | Whether the shipment provider was pre-selected. |
| `shipment_provider_product` | String | Product of the shipment provider. |
| `shipment_weight` | Number | Weight of the shipment. |
| `tracking_code` | String | Tracking code of the shipment. |
| `pre_tracking_code` | String | Pre-defined tracking code of the shipment. |
| `invoice_number` | String | Number of the invoice of the item. |
| `invoice_access_key` | String | Access key of the invoice (NF-e) of the item. |
| `in_transit` | Boolean | Whether the item is in transit. |
| `premium` | Boolean | Whether the item is premium. |
| `is_hybrid` | Boolean | Whether the product is a hybrid product. |
| `is_outlet` | Boolean | Whether the item carries the outlet flag. |
| `printed` | Boolean | Whether the item has been printed. |
| `manifest_status` | String | Manifest status of the item. |
| `is_pickup_request_sent` | Boolean | Whether a pickup request was sent for the item. |
| `pending_package_id` | Integer | Pending package associated with the item. |
| `warehouse_name` | String | Warehouse the item ships from. |
| `purchase_order_src_id` | Integer | Purchase order identifier on the shop side. |
| `purchase_order_number` | String | Purchase order number. |
| `purchase_delivery_info` | String | Delivery information of the purchase order. |
| `extra_attributes` | String | Extra attributes of the item, such as installment fee and delivery type (JSON object) |
| `product_set_attributes` | String | Attributes of the product set of the item (JSON object) |
| `actions` | Array of String | Next actions allowed on the item. |
| `target_to_ship_at` | Datetime | Promised shipment date, when the promised-date feature is enabled. |
| `last_status_changed_at` | Datetime | Date and time when the item status last changed. |
| `created_at` | Datetime | Date and time when the item was created. |
| `updated_at` | Datetime | Date and time when the item was last updated. |
| `order_updated_at` | Datetime | Last update of the parent order, used as the incremental replication key. |
Every product set of your catalog, in any status (`GET /v2/product-sets?status=all`). A product set groups the variations (sizes) of a product.
Primary key: `id` · Full table
| Field | Type | Description |
| :-------------------- | :--------------- | :-------------------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the product set. |
| `uuid` | String | Unique string identifier of the product set. |
| `src_id` | String | Identifier in the shop system; empty while the set is not synchronised. |
| `name` | String | Product set name shown to customers. |
| `parent_sku` | String | SKU of the product acting as the main one of the set. |
| `seller_sku` | String | SKU of the product set on the seller's side. |
| `description` | String | Product description visible to end customers. |
| `brand_id` | Integer | Identifier of the brand of the product set. |
| `primary_category_id` | Integer | Identifier of the main category of the product set. |
| `categories` | Array of Integer | Identifiers of the additional categories the set is listed in. |
| `browse_nodes` | Array of Integer | Identifiers of the browse nodes the set is listed in. |
| `attribute_set_id` | Integer | Attribute set that defines which attributes apply to the product set. |
| `attributes` | String | Attribute values of the product set, keyed by attribute ID (JSON object) |
| `size_system` | Integer | Size system used by the product set. |
| `seller_id` | Integer | Identifier of the seller. |
| `status` | String | Product set status (active, inactive or deleted) |
| `sin` | String | Shared identifier when the set is a hybrid product sold by several sellers. |
| `created_at` | Datetime | Date and time when the product set was created. |
| `updated_at` | Datetime | Date and time when the product set was last updated. |
Every sellable variation (usually one per size) of your product sets (`GET /v2/products`).
Primary key: `id` · Full table
| Field | Type | Description |
| :------------------- | :------- | :---------------------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the product. |
| `uuid` | String | Unique string identifier of the product. |
| `product_set_id` | Integer | Identifier of the product set this variation belongs to. |
| `src_id` | String | Identifier in the shop system; empty while the product is not synchronised. |
| `shop_sku` | String | SKU on the shop's side, usually visible to customers. |
| `seller_sku` | String | SKU on the seller's side, unique across the seller's products. |
| `name` | String | Product name. |
| `variation` | String | Variation name, usually the size (e.g. M, 39) |
| `product_identifier` | String | Barcode of the product, such as EAN or Code-39. |
| `sin` | String | Shared identifier when the same product is sold by several sellers. |
| `seller_id` | Integer | Identifier of the seller. |
| `approval_status` | String | Quality-control approval status (pending, approved or rejected) |
| `status` | String | Product status (active, inactive or deleted) |
| `tax_class_id` | Integer | Tax class of this variation. |
| `shipment_type_id` | Integer | Shipment type of this variation (1 warehouse, 2 dropshipping, 3 crossdocking) |
| `duplicate_group_id` | Integer | Group identifier shared by products detected as duplicates. |
| `updated_by_user_id` | Integer | Identifier of the Seller Center user who last updated the product. |
| `src_updated_at` | Datetime | Date and time when the product was last synchronised with the shop. |
| `created_at` | Datetime | Date and time when the product was created. |
| `updated_at` | Datetime | Date and time when the product was last updated. |
Current stock of every product, including consignment and warehouse breakdowns. Seller Center only exposes stock per product set, so this stream makes one request per product set.
Primary key: `product_set_id`, `seller_sku` · Full table
| Field | Type | Description |
| :------------------------ | :------ | :--------------------------------------------------------------------------- |
| `product_set_id` | Integer | Identifier of the product set. |
| `seller_sku` | String | SKU of the product on the seller's side. |
| `shop_sku` | String | SKU of the product on the shop's side. |
| `name` | String | Product name. |
| `quantity` | Integer | Sellable stock in the seller's own warehouse. |
| `reserved_stock` | Integer | Stock reserved by pending or ready-to-ship dropshipping/crossdocking items. |
| `pre_verification_stock` | Integer | Stock waiting for pre-verification. |
| `available` | Integer | Available stock: own quantity plus sellable consignment, minus reservations. |
| `sellable_stock` | Integer | Sellable consignment stock (received, canceled, returned and failed) |
| `non_sellable_stock` | Integer | Non-sellable consignment stock (quarantined and defective) |
| `consignment_received` | Integer | Received consignment stock. |
| `consignment_quarantined` | Integer | Quarantined consignment stock. |
| `consignment_defective` | Integer | Defective consignment stock. |
| `consignment_canceled` | Integer | Canceled consignment stock. |
| `consignment_returned` | Integer | Returned consignment stock. |
| `consignment_failed` | Integer | Failed consignment stock. |
| `warehouses` | String | Stock per warehouse when multi-warehouse is enabled (JSON array of objects) |
Regular and sale price of every product, one row per product and country (`GET /v2/prices`).
Primary key: `product_id`, `country` · Full table
| Field | Type | Description |
| :---------------- | :------- | :-------------------------------------------------------- |
| `product_id` | Integer | Identifier of the product (variation) |
| `country` | String | Country the price applies to. |
| `product_set_id` | Integer | Identifier of the product set. |
| `price` | Number | Regular price of the product. |
| `sale_price` | Number | Sale price, when a sale is configured. |
| `sale_start_date` | Datetime | Start of the sale price period. |
| `sale_end_date` | Datetime | End of the sale price period. |
| `status` | String | Whether the product is sold in this country (e.g. active) |
Brands available to your seller account (`GET /v2/brands`).
Primary key: `id` · Full table
| Field | Type | Description |
| :-------------- | :------- | :--------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the brand. |
| `uuid` | String | Unique string identifier of the brand. |
| `src_id` | String | Identifier of the brand in the shop system. |
| `name` | String | Brand name. |
| `status` | String | Brand status (active, inactive or deleted) |
| `is_active` | Boolean | Whether the brand is active. |
| `is_approved` | Boolean | Whether the brand is approved for use in the marketplace. |
| `is_restricted` | Boolean | Whether the brand requires prior approval before it can be used. |
| `countries` | String | Comma-separated country codes where the brand is available. |
| `created_at` | Datetime | Date and time when the brand was created. |
| `updated_at` | Datetime | Date and time when the brand was last updated. |
The active category tree, flattened to one row per category (`GET /v2/category/tree`).
Primary key: `id` · Full table
| Field | Type | Description |
| :----------------- | :--------------- | :------------------------------------------------------------ |
| `id` | Integer | Unique numeric identifier of the category. |
| `uuid` | String | Unique string identifier of the category. |
| `parent_id` | Integer | Identifier of the parent category. |
| `name` | String | Category name. |
| `attribute_set_id` | Integer | Attribute set that applies to products of this category. |
| `path_ids` | Array of Integer | Identifiers of the categories from the root down to this one. |
| `path` | Array of String | Names of the categories from the root down to this one. |
| `depth` | Integer | Depth of the category in the tree (0 for roots) |
Financial transactions of your account — item prices, commissions, shipping fees, refunds, and adjustments — for both marketplace and consignment statements (`GET /v2/finance/transactions`).
Primary key: `id` · Replication key: `date`
| Field | Type | Description |
| :----------------------- | :------- | :------------------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the transaction. |
| `date` | Datetime | Date of the transaction, used as the incremental replication key. |
| `number` | String | Transaction number. |
| `type_id` | Integer | Identifier of the transaction type. |
| `type_name` | String | Name of the transaction type (e.g. commission, item price) |
| `group_name` | String | Name of the transaction group. |
| `tre_statement_group_id` | Integer | Transaction Rule Engine statement group identifier. |
| `amount` | Number | Amount of the transaction. |
| `vat_amount` | Number | VAT amount of the transaction. |
| `wht_amount` | Number | Withholding tax amount of the transaction. |
| `currency` | String | Currency of the transaction (ISO 4217) |
| `country` | String | Country of the transaction (ISO 3166-1 alpha-2) |
| `source` | String | Where the transaction was created (sellercenter, web, csv) |
| `comment` | String | Comment attached to the transaction. |
| `statement_id` | Integer | Statement the transaction belongs to; 0 while the statement is still open. |
| `statement_type` | String | Type of the statement of the transaction (marketplace or consignment) |
| `order_item_id` | Integer | Order item the transaction refers to, if any. |
| `order_number` | String | Order number the transaction refers to, if any. |
Account statements: the payout periods with their balances, due dates, and payment status (`GET /v2/finance/statements`).
Primary key: `id`, `type` · Full table
| Field | Type | Description |
| :------------------- | :------- | :------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the statement. |
| `type` | String | Statement type (marketplace or consignment) |
| `number` | String | Statement number. |
| `seller_id` | Integer | Identifier of the seller. |
| `start_date` | Datetime | Start of the period covered by the statement. |
| `end_date` | Datetime | End of the period covered by the statement. |
| `due_date` | Datetime | Date the statement payout is due. |
| `paid_at` | Datetime | Date and time the statement was paid. |
| `paid` | Boolean | Whether the statement has been paid. |
| `opening_balance` | Number | Balance at the start of the period. |
| `closing_balance` | Number | Balance at the end of the period. |
| `payout_amount` | Number | Amount paid out to the seller. |
| `guarantee_deposit` | Number | Guarantee deposit held from the payout. |
| `currency` | String | Currency of the statement (ISO 4217) |
| `country` | String | Country of the statement (ISO 3166-1 alpha-2) |
| `note` | String | Note attached to the statement. |
| `commission_invoice` | String | URL of the commission invoice document of the statement. |
The seller account the OAuth application belongs to (`GET /v2/seller`).
Primary key: `id` · Full table
| Field | Type | Description |
| :-------------------- | :------- | :----------------------------------------------------------------------------------------------- |
| `id` | Integer | Unique numeric identifier of the seller. |
| `uuid` | String | Unique string identifier of the seller. |
| `src_id` | String | Identifier of the seller in the Dafiti shop system. |
| `short_code` | String | Short code of the seller. |
| `status` | String | Seller status (active, inactive or deleted) |
| `name` | String | Seller display name. |
| `company_name` | String | Legal name of the seller company. |
| `email` | String | Contact email of the seller. |
| `tax_class` | String | Tax class of the seller. |
| `verified` | Boolean | Whether the seller account has been verified. |
| `listed` | Boolean | Whether the seller's products are currently listed in the shop. |
| `delist_reasons` | String | Reasons why the seller is delisted, such as holiday mode or order limits (JSON array of objects) |
| `profile_fields` | String | Approved values of the seller profile fields, with their display values (JSON array of objects) |
| `agreements_accepted` | Boolean | Whether the seller has accepted the current marketplace agreements. |
| `created_at` | Datetime | Date and time when the seller account was created. |
| `updated_at` | Datetime | Date and time when the seller account was last updated. |