Skip to main content
Magazord is a Brazilian e-commerce platform with a built-in ERP, covering online stores, marketplaces, orders, inventory, billing and logistics in a single back office. Nekt extracts this data through the Magazord Integration API.

​
Configuring Magazord as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the Magazord option from the list of connectors. Click Next and you’ll be prompted to add your access.

​
1. Add account access

The following configurations are required:
  • Panel URL: The base URL of your Magazord administrative panel, for example https://yourstore.painel.magazord.com.br (no trailing path). The API is served under this domain.
  • API Token: The API token of your Magazord account. If you don’t have one yet, request your integration credentials from Magazord (for example via your account manager or integracao@magazord.com.br).
  • API Password: The API password paired with the token. Both are sent using HTTP Basic authentication.
Optionally, under advanced settings:
  • Start Date: The earliest date from which records will be synced for incremental streams (defaults to 2023-01-01).
  • Store Timezone: IANA timezone used to render date filters in store-local time (defaults to America/Sao_Paulo).
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.
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: you can choose between INCREMENTAL and FULL_TABLE.
    • Incremental: every time the extraction happens, we’ll get only the new data - which is good if, for example, you want to keep every record ever fetched.
    • Full table: every time the extraction happens, we’ll get the current state of the data - which is good if, for example, you don’t want to have deleted data in your catalog.
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). 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.

​
Streams and Fields

Below you’ll find all available data streams from Magazord and their corresponding fields. Orders, customers, products, carts, invoices, prices and stock movements sync incrementally; the remaining streams are extracted as full tables.
Orders across all stores and marketplaces, incrementally synced by their last-change timestamp.Key Fields:
  • id - Internal ID of the order
  • codigo - Order code
  • data_hora - Date/time when the order was created
  • valor_produto - Total product value of the order
  • valor_frete - Shipping value
  • valor_desconto - Discount value granted at purchase time
  • valor_total - Total order value paid by the customer
  • pessoa_id / pessoa_nome / pessoa_cpf_cnpj - Customer identification
  • forma_pagamento_id / forma_pagamento_nome - Payment method
  • condicao_pagamento_nome - Payment condition (cash, installments)
  • pedido_situacao / pedido_situacao_descricao - Order status code and description
  • loja_id - Store the order belongs to
  • loja_do_marketplace_id / loja_do_marketplace_nome - Marketplace store, when applicable
  • synced_at - Sync timestamp used as the incremental replication key
People and companies registered in the account, with their addresses and contacts, incrementally synced by their last-update date.Key Fields:
  • id - Internal ID of the person
  • tipo - Person type (individual or company)
  • nome - Name of the person
  • email - Email address
  • cpf_cnpj - CPF/CNPJ of the person
  • data_cadastro - Registration date
  • data_hora_atualizacao - Date of the last update
  • nome_fantasia / inscricao_estadual - Company details, when applicable
  • pessoa_endereco - Addresses (JSON array)
  • pessoa_contato - Contacts such as phones and emails (JSON array)
Products in the catalog with their variations, incrementally synced by their last-update timestamp.Key Fields:
  • id - ID of the product
  • nome - Name of the product
  • codigo - Code of the product
  • tipo - Type (product, service or kit)
  • marca - ID of the product’s brand
  • ativo - Whether the product is active
  • ncm / cest / origem_fiscal - Fiscal codes
  • peso / altura / largura / comprimento - Dimensions
  • data_lancamento - Launch date
  • categorias - IDs of the categories (the first is the main one)
  • derivacoes - Variations/SKUs of the product (JSON array)
Shopping carts (open, abandoned or converted), incrementally synced by their update date.Key Fields:
  • id - ID of the cart
  • status - Status (open, abandoned or purchased)
  • data_inicio - When the cart was created
  • data_atualizacao - Last update to the cart and its items (replication key)
  • hash - Unique hash of the cart
  • pedido - Order linked to the cart, when converted (JSON)
  • draft - Partially filled cart data (JSON)
Fiscal invoices (NF-e) with their line items, incrementally synced by emission date.Key Fields:
  • id - ID of the fiscal invoice
  • tipo - Inbound or outbound invoice
  • situacao - Status (typed, closed, authorized, cancelled, etc.)
  • numero / serie / chave - Invoice number, series and access key
  • data_emissao - Emission date/time (replication key)
  • itens - Line items with product, quantity, values and taxes (JSON array)
Financial titles to pay, extracted as a full table.Key Fields:
  • id - ID of the financial title
  • numero - Number of the title
  • data_abertura / data_geracao / data_vencimento - Opening, generation and due dates
  • valor_original / valor_liquidado / saldo - Original, settled and outstanding values
  • parcela - Installment indicator
  • situacao - Status of the title (JSON)
  • pessoa - Supplier linked to the title (JSON)
  • ultimo_movimento - Latest settlement movement (JSON)
Financial titles to receive, extracted as a full table.Key Fields:
  • id - ID of the financial title
  • numero - Number of the title
  • data_abertura / data_geracao / data_vencimento - Opening, generation and due dates
  • valor_original / valor_liquidado / saldo - Original, settled and outstanding values
  • parcela - Installment indicator
  • situacao - Status of the title (JSON)
  • pessoa - Customer linked to the title (JSON)
  • origem - Origin of the title, including the linked order (JSON)
Current stock position per product variation (SKU) and warehouse, extracted as a full table.Key Fields:
  • produto - Code of the product variation (SKU)
  • deposito - ID of the warehouse
  • quantidade_disponivel_venda - Quantity available for sale
  • quantidade_fisica - Physical quantity in stock
  • quantidade_reservado_saida - Quantity reserved for outbound orders
  • quantidade_prevista_entrada - Quantity expected to arrive
  • custo_medio / custo_virtual - Average and virtual costs
Stock movement history, incrementally synced by movement date/time.Key Fields:
  • movimentacao - ID of the stock movement
  • produto - Code of the product variation (SKU)
  • deposito - ID of the warehouse
  • quantidade - Quantity moved
  • valor_movimentacao - Total value of the movement
  • data_hora_movimentacao - Date/time of the movement (replication key)
  • tipo_operacao - Adjustment, inbound or outbound
  • origem - Origin of the movement
  • pedido_id / nota_fiscal_id - Related order and invoice
Prices per product variation and price table, incrementally synced by update time.Key Fields:
  • produto - Code of the product variation (SKU)
  • tabela_preco / tabela_nome - Price table
  • preco_venda - Current sale price
  • preco_antigo - Previous (crossed-out) price
  • percentual_desconto - Discount percentage
  • data_hora_atualizacao - Last price update (replication key)
Product categories, extracted as a full table.Key Fields:
  • id - Internal ID of the category
  • nome - Name of the category
  • pai - ID of the parent category
  • descricao - Description of the category
Product brands, extracted as a full table.Key Fields:
  • id - Internal ID of the brand
  • nome - Name of the brand
  • producao_propria - Whether the brand is produced in-house
Stores configured in the account, extracted as a full table.Key Fields:
  • id - Internal ID of the store
  • codigo - Code of the store
  • nome - Name of the store
  • ativo - Whether the store is active
  • url - URL of the store
  • grupo - Store group (JSON)
Shipping carriers, extracted as a full table.Key Fields:
  • id - Internal ID of the carrier
  • nome - Name of the carrier
  • pessoa - Carrier person registered in Magazord (JSON)
Price tables, extracted as a full table.Key Fields:
  • id - ID of the price table
  • nome - Name of the price table
  • ativa - Whether the price table is active
  • data_inicio / data_fim - Validity period
  • opcoes - Pricing options and rules (JSON)
Discount coupons, extracted as a full table.Key Fields:
  • id - Identifier of the coupon
  • codigo - Code entered by the customer at checkout
  • ativo - Whether the coupon is active
  • tipo_desconto - Discount type (value, percentage, fixed price, etc.)
  • valor_desconto - Discount value or percentage
  • valido_de / valido_ate - Validity period
  • loja - Store the coupon belongs to
If you have any questions about the Magazord connector, feel free to reach out through our support channels.