Veeqo
V
Veeqo

tap-veeqo (matatika variant)

Veeqo is a cloud-based inventory and order management software for e-commerce businesses.

E-commerce businesses use Veeqo manage their inventory, orders, and shipping across multiple sales channels. It has basic features such as inventory levels, low stock alerts, and management of purchase orders. The software also allows businesses to manage their orders from multiple sales channels in one place, print shipping labels, and automatically update tracking information. Through the Veeqo API, integrations with a variety of e-commerce platforms, marketplaces, and shipping carriers are supported. Veeqo also provides some out of the box analytics and reporting, enough for many businesses to gain basic insights into their sales performance and inventory trends.

Matatika extracts data from the Veeqo API to enable more sophisticated businesses to streamline their operations, reduce errors, and improve their overall efficiency. Our clients tell us its a game changer to have a single space where advanced sales performance and inventory trends are analyzed. Some of the key use case we solve include:

Automated Industry Sales Reporting

Producing standard 3rd party industry sales reports is a breeze. Matatika automatically maps product sales to user defined categories. Saving hours each month for our clients.

Veeqo API streams: Orders, Products, Tags

Tax liabilities and Sales accounts

Matatika automates the reconciliation and update of your accounting system with user defined sales accounts that need to respect zero rated sales, or sales in user defined categories or departments.

Veeqo API streams: Orders, Products, Suppliers, Tags

Forecasting

Whether its sales, inventory, or marketing effectiveness that you need, Matatika provides advanced insights about your business from a single trusted space.

Veeqo API streams: Orders, Returns, Allocations, Products, Purchase Orders, Suppliers, Company, Warehouses, Customers, Stores, Delivery Methods, Shipments, Stock Entries, Tags

Prerequisites

To obtain an API key for Veeqo, follow these steps:

  1. Log in to your Veeqo account.

  2. Click on your profile icon in the top right corner of the screen.

  3. Select "Settings" from the dropdown menu.

  4. Click on "API" in the left-hand menu.

  5. Click on the "Generate new API key" button.

  6. Give your API key a name and select the permissions you want to grant.

  7. Click on the "Generate API key" button.

  8. Your new API key will be displayed on the screen.

Available Streams

StreamDescriptionReplicationReplication KeyPrimary Key
ordersSales orders, with their allocations and returnsIncrementalupdated_atid
productsProducts, with their variants and stock levelsIncrementalupdated_atid
product_property_specificsProperty values set on each productFull Table—product_id, id, product_property_id
product_option_specificsOption values set on each productFull Table—product_id, id, product_property_id
sellablesSellable product variants, with their stock entriesFull Table—id
variant_property_specificsProperty values set on each product variantFull Table—variant_id, id, product_specific_id, product_property_id
product_brandsProduct brandsFull Table—id
product_propertiesProduct property definitionsFull Table—id
product_tagsTags available for productsFull Table—id
purchase_ordersPurchase orders, with their supplier and ordered variantsFull Table—id
suppliersSuppliersFull Table—id
customersCustomers, with their addressesFull Table—id
storesSales channels connected to VeeqoFull Table—id
warehousesWarehousesFull Table—id
delivery_methodsDelivery methodsFull Table—id
employeesUsers of the Veeqo accountFull Table—id
tagsTags available for ordersFull Table—id

Limitations

  • Per-record requests for child streams. product_property_specifics and product_option_specifics make one API request for each product, and variant_property_specifics makes one for each sellable. A sync of these streams takes longer as the catalogue grows.
  • Credit limits are text. Veeqo returns a supplier's credit_limit as either text or a number, so it is always loaded as text.

Data recovery / backfill

orders and products keep a bookmark between syncs: the latest updated_at they have loaded. Every other stream is full table and re-syncs completely on each run, so it needs no backfill.

The first sync of orders and products reads their full history. To backfill or re-sync them, reset the pipeline state so that the next sync starts from the beginning again.

The tables below list the main fields of each stream. Every stream has more fields; the full schemas are in the tap's catalog.

orders

Supports incremental replication using updated_at.

FieldTypeDescription
idintegerUnique order identifier
numberstringOrder number
statusstringOrder status
channelobjectThe sales channel the order came from
customerobjectThe customer who placed the order
deliver_toobjectDelivery address
delivery_methodobjectDelivery method
allocationsarrayAllocations of the order to warehouses, with their line items and shipments
returnsarrayReturns against the order
subtotal_pricenumberTotal before delivery, tax and discounts
total_pricenumberTotal price of the order
total_taxnumberTotal tax
currency_codestringCurrency of the order
created_atdatetimeCreation timestamp
shipped_atdatetimeShipping timestamp
updated_atdatetimeLast modification timestamp — replication key

products

Supports incremental replication using updated_at.

FieldTypeDescription
idintegerUnique product identifier
titlestringProduct title
descriptionstringProduct description
brandobjectProduct brand
sellablesarrayVariants of the product
tagsarrayTags on the product
total_stock_levelintegerStock level across all warehouses
total_available_stock_levelintegerStock available to sell across all warehouses
total_quantity_soldintegerUnits sold
on_hand_valuenumberValue of the stock on hand
created_atdatetimeCreation timestamp
deleted_atdatetimeDeletion timestamp
updated_atdatetimeLast modification timestamp — replication key

product_property_specifics and product_option_specifics

FieldTypeDescription
product_idintegerProduct identifier
idintegerUnique value identifier
product_property_idintegerProperty identifier
product_property_namestringProperty name
valuestringProperty value

sellables

FieldTypeDescription
idintegerUnique sellable identifier
typestringSellable type
sku_codestringSKU
upc_codestringUPC barcode
full_titlestringProduct and variant title
pricenumberSelling price
cost_pricenumberCost price
productobjectThe product the variant belongs to
stock_entriesarrayStock levels and bin locations in each warehouse
stock_level_at_all_warehousesintegerStock level across all warehouses
available_stock_level_at_all_warehousesintegerStock available to sell across all warehouses
total_quantity_soldintegerUnits sold
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp

variant_property_specifics

FieldTypeDescription
variant_idintegerProduct variant identifier
idintegerUnique value identifier
product_specific_idintegerProduct property value identifier
product_property_idintegerProperty identifier
product_property_namestringProperty name
valuestringProperty value

product_brands

FieldTypeDescription
idintegerUnique brand identifier
namestringBrand name
display_positionintegerPosition in display order
products_countintegerNumber of products with the brand

product_properties

FieldTypeDescription
idintegerUnique property identifier
namestringProperty name

product_tags and tags

FieldTypeDescription
idintegerUnique tag identifier
namestringTag name
colourstringTag colour
taggings_countintegerNumber of records with the tag
deleted_atdatetimeDeletion timestamp

purchase_orders

FieldTypeDescription
idintegerUnique purchase order identifier
numberstringPurchase order number
statestringPurchase order state
supplierobjectThe supplier
destination_warehouseobjectThe warehouse that receives the stock
purchase_order_product_variantsarrayOrdered product variants and quantities
units_orderedintegerUnits ordered
units_receivedintegerUnits received
total_including_taxnumberTotal including tax
currency_codestringCurrency of the purchase order
expected_datedatetimeExpected delivery date
received_atdatetimeReceipt timestamp
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp

suppliers

FieldTypeDescription
idintegerUnique supplier identifier
namestringSupplier name
countrystringCountry
currency_codestringCurrency used with the supplier
credit_limitstringCredit limit
active_purchase_order_countintegerNumber of open purchase orders
completed_purchase_order_countintegerNumber of completed purchase orders
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp

customers

FieldTypeDescription
idintegerUnique customer identifier
full_namestringCustomer name
company_namestringCompany name
emailstringEmail address
customer_typestringCustomer type
billing_addressobjectBilling address
shipping_addressesarrayShipping addresses
payment_termsintegerPayment terms, in days

stores

FieldTypeDescription
idintegerUnique channel identifier
namestringChannel name
type_codestringChannel type, such as Shopify or Amazon
statestringChannel state
currency_codestringCurrency of the channel
countrystringCountry
default_warehouseobjectDefault warehouse for the channel's orders
pulled_orders_atdatetimeWhen orders were last imported from the channel

warehouses

FieldTypeDescription
idintegerUnique warehouse identifier
namestringWarehouse name
citystringCity
countrystringCountry
post_codestringPostcode
inventory_type_codestringInventory type
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp

delivery_methods

FieldTypeDescription
idintegerUnique delivery method identifier
namestringDelivery method name
coststringDelivery cost
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp
deleted_atdatetimeDeletion timestamp

employees

FieldTypeDescription
idintegerUnique user identifier
loginstringLogin name
emailstringEmail address
roleobjectUser role
default_warehouse_idintegerDefault warehouse
company_ownerbooleanWhether the user owns the account
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp

Settings

API key

A unique identifier used to authenticate and authorize requests to the Veeqo API.

Meltano Cloud Connector

Veeqo connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano Cloud?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Ingest & transform data with AIConnect Claude or any MCP-compatible assistant to Meltano Cloud. Add connectors, run pipelines, build dbt models and diagnose failed runs in plain English, against the same Git-backed project your team works in.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.