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 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.

Open OAuth Applications

Create the application

Click Add Application (top right corner), give it a name such as Nekt, and save.

Copy the credentials

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.

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, 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.
Determine when to execute an 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 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, 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.

Orders

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.

Order Items

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.

Product Sets

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.

Products

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.

Product Stocks

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)

Product Prices

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

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.

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.

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.

Documentation

Get started

Context

Activate

Workspace

Resources

Dafiti as a data source

Configuring Dafiti as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Things to know

Streams and Fields

​Configuring Dafiti as a Source

​1. Add account access

​2. Select streams

​3. Configure data streams

​4. Configure data source

​5. Check your new source

​Things to know

​Streams and Fields

Configuring Dafiti as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Things to know

Streams and Fields