Skip to content
Book a demoStart free
Connectors

Veeqo connector

Set up the Veeqo connector in Kaivo: authentication, configuration, the 11 BigQuery tables it syncs, and answers to common questions.

Veeqo connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Veeqo data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your e-commerce data instead of moving it.

Sync your Veeqo inventory and shipping data into BigQuery with Kaivo to analyse orders, stock, and fulfilment.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Veeqo account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

Kaivo syncs 11 tables from Veeqo into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

company (119 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
name STRING
owner__id FLOAT64
owner__email STRING
owner__login STRING
owner__role_id FLOAT64
owner__timezone STRING
owner__company_id FLOAT64
owner__created_at STRING
owner__updated_at STRING
owner__new_orders_opted_in BOOL
owner__failed_login_attempts FLOAT64
owner__new_products_opted_in BOOL
owner__orders_walkthrough_viewed BOOL
owner__two_factor_authentication_enabled BOOL
paying BOOL
settings__id FLOAT64
settings__timezone STRING
settings__date_format STRING
settings__weight_unit STRING
settings__phone_number STRING
settings__currency_code STRING
settings__phone_payments BOOL
settings__dimensions_unit STRING
settings__point_of_sale_enabled BOOL
settings__require_complete_packing BOOL
settings__stock_change_reason_required BOOL
settings__charge_taxes_on_shipping_rates BOOL
trialingx BOOL
created_at STRING
updated_at STRING
plan_features__api__any_actions BOOL
plan_features__roles__any_actions BOOL
plan_features__orders__nav_sub_items BOOL
plan_features__orders__auto_allocation BOOL
plan_features__orders__deallocate_when_packing BOOL
plan_features__picking__any_actions BOOL
plan_features__reports__stock BOOL
plan_features__reports__returns BOOL
plan_features__reports__forecast BOOL
plan_features__reports__team_metrics BOOL
plan_features__reports__shipping_metrics BOOL
plan_features__reports__inventory_history BOOL
plan_features__reports__daily_digest_email BOOL
plan_features__returns__any_actions BOOL
plan_features__channels__vend BOOL
plan_features__channels__noths BOOL
plan_features__channels__opencart BOOL
plan_features__channels__amazon_fba BOOL
plan_features__channels__prestashop BOOL
plan_features__channels__buy_shipping_terms BOOL
plan_features__channels__manage_stock_level BOOL
plan_features__channels__shopify_multi_location BOOL
plan_features__channels__amazon_wizard_short_flow BOOL
plan_features__channels__change_routing_order_type BOOL
plan_features__channels__amazon_wizard_shipping_only BOOL
plan_features__channels__update_remote_order_by_default BOOL
plan_features__channels__amazon_wizard_default_region_us BOOL
plan_features__channels__master_of_stock_activation_banner BOOL
plan_features__listings__any_actions BOOL
plan_features__printing__direct_print BOOL
plan_features__printing__sku_on_label BOOL
plan_features__reorders__any_actions BOOL
plan_features__shipping__shipping_credits BOOL
plan_features__shipping__ship_on_future_date BOOL
plan_features__shipping__ship_with_amazon_v2 BOOL
plan_features__shipping__payment_data_collection BOOL
plan_features__shipping__buy_shipping_sub_carrier_amzn_us BOOL
plan_features__dashboard__any_actions BOOL
plan_features__inventory__use_kits BOOL
plan_features__inventory__merge_review BOOL
plan_features__inventory__use_custom_views BOOL
plan_features__inventory__show_stock_levels BOOL
plan_features__inventory__change_stock_reason BOOL
plan_features__inventory__power_upgrade_stock_sync BOOL
plan_features__inventory__power_feature_inventory_tours BOOL
plan_features__suppliers__any_actions BOOL
plan_features__wholesale__any_actions BOOL
plan_features__accounting__xero BOOL
plan_features__accounting__settings BOOL
plan_features__fulfilment__allocate_action BOOL
plan_features__fulfilment__digital_picking_in_onboarding BOOL
plan_features__onboarding__endless_trial BOOL
plan_features__onboarding__inventory_features BOOL
plan_features__onboarding__amazon_quick_connect BOOL
plan_features__onboarding__hide_connect_carrier_step BOOL
plan_features__onboarding__bulk_ship_intro_experience BOOL
plan_features__onboarding__signup_redirects_to_amazon_wizard BOOL
plan_features__onboarding__signup_redirects_to_channels_wizard BOOL
plan_features__user_roles__admin BOOL
plan_features__user_roles__purchaser BOOL
plan_features__user_roles__accountant BOOL
plan_features__user_roles__picker_packer BOOL
plan_features__user_roles__warehouse_manager BOOL
plan_features__user_roles__customer_service_agent BOOL
plan_features__user_roles__customer_service_manager BOOL
plan_features__price_lists__any_actions BOOL
plan_features__settings_page__customers BOOL
plan_features__settings_page__usps_scan_forms BOOL
plan_features__settings_page__listings_linking BOOL
plan_features__settings_page__carrier_settings_page BOOL
plan_features__purchase_orders__any_actions BOOL
plan_features__stock_transfers__any_actions BOOL
plan_features__company_branding__any_actions BOOL
plan_features__shipping_providers__amazon_shipping_v2 BOOL
trial_end_date STRING
company_address__city STRING
company_address__phone STRING
company_address__region STRING
company_address__country STRING
company_address__post_code STRING
company_address__address_line_1 STRING
veeqo_product_name STRING
has_right_to_use_veeqo BOOL
chargify_product_handle STRING
shopify_app_store_referralx BOOL
has_ever_created_remote_channel BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • company__employees (16 columns)
  • company__active_features (4 columns)
customers (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
email STRING
phone STRING
full_name STRING
contact_data__email STRING
contact_data__phone STRING
created_by_id FLOAT64
customer_type STRING
billing_address__id FLOAT64
billing_address__zip STRING
billing_address__city STRING
billing_address__phone STRING
billing_address__state STRING
billing_address__country STRING
billing_address__address1 STRING
billing_address__last_name STRING
billing_address__first_name STRING
last_used_shipping_address__id FLOAT64
last_used_shipping_address__zip STRING
last_used_shipping_address__city STRING
last_used_shipping_address__phone STRING
last_used_shipping_address__state STRING
last_used_shipping_address__country STRING
last_used_shipping_address__address1 STRING
last_used_shipping_address__verified BOOL
last_used_shipping_address__last_name STRING
last_used_shipping_address__first_name STRING
last_used_shipping_address__location_found BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • customers__shipping_addresses (14 columns)
delivery_methods (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
cost STRING
name STRING
user_id FLOAT64
created_at STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
orders (181 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
number STRING
status STRING
channel__id FLOAT64
channel__city STRING
channel__name STRING
channel__email STRING
channel__state STRING
channel__region STRING
channel__remote BOOL
channel__country STRING
channel__with_fba BOOL
channel__is_master BOOL
channel__post_code STRING
channel__type_code STRING
channel__warehouse__id FLOAT64
channel__warehouse__name STRING
channel__created_by_id FLOAT64
channel__address_line_1 STRING
channel__address_line_2 STRING
channel__always_set_qty FLOAT64
channel__percent_of_qty FLOAT64
channel__default_warehouse__id FLOAT64
channel__default_warehouse__lat STRING
channel__default_warehouse__lng STRING
channel__default_warehouse__city STRING
channel__default_warehouse__name STRING
channel__default_warehouse__phone STRING
channel__default_warehouse__region STRING
channel__default_warehouse__country STRING
channel__default_warehouse__post_code STRING
channel__default_warehouse__company_id FLOAT64
channel__default_warehouse__created_at STRING
channel__default_warehouse__updated_at STRING
channel__default_warehouse__trading_name STRING
channel__default_warehouse__created_by_id FLOAT64
channel__default_warehouse__address_line_1 STRING
channel__default_warehouse__display_position FLOAT64
channel__default_warehouse__default_min_reorder FLOAT64
channel__default_warehouse__inventory_type_code STRING
channel__default_warehouse__letterbox_address_id STRING
channel__default_warehouse__letterbox_address_status STRING
channel__default_warehouse__click_and_collect_enabled BOOL
channel__ebay_site_code_id FLOAT64
channel__import_cost_price BOOL
channel__import_order_tags BOOL
channel__max_qty_to_advert FLOAT64
channel__min_threshold_qty FLOAT64
channel__routing_order_type FLOAT64
channel__import_product_tags BOOL
channel__pull_pending_orders BOOL
channel__pull_product_images BOOL
channel__skip_title_matching BOOL
channel__update_remote_order BOOL
channel__veeqo_dictates_price BOOL
channel__import_product_brands BOOL
channel__pull_historical_orders BOOL
channel__pull_product_properties BOOL
channel__remote_warehouses_exist BOOL
channel__pull_stock_level_required BOOL
channel__update_product_attributes BOOL
channel__amazon_fulfillment_enabled BOOL
channel__authorized_at_remote_store BOOL
channel__pull_unpaid_shopify_orders BOOL
channel__veeqo_dictates_stock_level BOOL
channel__create_product_if_unmatched BOOL
channel__default_send_shipment_email BOOL
channel__disabled_push_of_stock_level BOOL
channel__skip_fba_orders_and_products BOOL
channel__keep_inventory_tracking_value BOOL
channel__create_product_on_ended_listings BOOL
channel__end_ebay_listing_on_out_of_stock BOOL
channel__notify_on_outbound_shipment_date BOOL
channel__import_additional_payment_details BOOL
channel__link_with_similar_listings_by_sku BOOL
channel__automatic_product_linking_disabled BOOL
channel__outbound_shipment_notification_time STRING
channel__send_notification_emails_to_customers BOOL
channel__first_sync_finish_notice_marked_as_read BOOL
channel__link_to_products_linked_to_current_channel BOOL
payment__id FLOAT64
payment__order_id FLOAT64
payment__created_at STRING
payment__updated_at STRING
payment__payment_type STRING
payment__created_by_id FLOAT64
payment__reference_number STRING
customer__id FLOAT64
customer__email STRING
customer__phone STRING
customer__mobile STRING
customer__full_name STRING
customer__contact_data__email STRING
customer__contact_data__phone STRING
customer__created_by_id FLOAT64
customer__customer_type STRING
customer__billing_address__id FLOAT64
customer__billing_address__zip STRING
customer__billing_address__city STRING
customer__billing_address__email STRING
customer__billing_address__phone STRING
customer__billing_address__state STRING
customer__billing_address__country STRING
customer__billing_address__address1 STRING
customer__billing_address__last_name STRING
customer__billing_address__first_name STRING
customer__last_used_shipping_address__id FLOAT64
customer__last_used_shipping_address__zip STRING
customer__last_used_shipping_address__city STRING
customer__last_used_shipping_address__email STRING
customer__last_used_shipping_address__phone STRING
customer__last_used_shipping_address__state STRING
customer__last_used_shipping_address__country STRING
customer__last_used_shipping_address__address1 STRING
customer__last_used_shipping_address__verified BOOL
customer__last_used_shipping_address__last_name STRING
customer__last_used_shipping_address__first_name STRING
customer__last_used_shipping_address__location_found BOOL
total_tax FLOAT64
created_at STRING
created_by__id FLOAT64
created_by__email STRING
created_by__login STRING
deliver_to__id FLOAT64
deliver_to__zip STRING
deliver_to__city STRING
deliver_to__email STRING
deliver_to__phone STRING
deliver_to__state STRING
deliver_to__country STRING
deliver_to__address1 STRING
deliver_to__verified BOOL
deliver_to__last_name STRING
deliver_to__first_name STRING
deliver_to__location_found BOOL
shipped_at STRING
total_fees FLOAT64
updated_at STRING
total_price FLOAT64
with_duties BOOL
invoice_date STRING
mergeable_id STRING
merged_order BOOL
currency_code STRING
customer_note__id FLOAT64
customer_note__text STRING
customer_note__order_id FLOAT64
delivery_cost FLOAT64
international BOOL
picked_status STRING
refund_amount FLOAT64
can_be_shipped BOOL
subtotal_price FLOAT64
billing_address__id FLOAT64
billing_address__zip STRING
billing_address__city STRING
billing_address__email STRING
billing_address__phone STRING
billing_address__state STRING
billing_address__country STRING
billing_address__address1 STRING
billing_address__last_name STRING
billing_address__first_name STRING
delivery_method__id FLOAT64
delivery_method__cost FLOAT64
delivery_method__name STRING
is_amazon_prime BOOL
receipt_printed BOOL
total_discounts FLOAT64
adjustment_amount FLOAT64
mergable_checksum STRING
picked_completely BOOL
shipping_discount FLOAT64
fulfilled_by_amazon BOOL
allocated_completely BOOL
restock_shipped_items BOOL
is_amazon_premium_order BOOL
send_notification_email BOOL
additional_order_level_taxless_discount FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • orders__tags (6 columns)
  • orders__channel__warehouses (4 columns)
  • orders__channel__channel_warehouses (4 columns)
  • orders__channel__stock_level_update_requests (4 columns)
  • orders__returns (12 columns)
  • orders__returns__line_items (12 columns)
  • orders__customer__shipping_addresses (15 columns)
  • orders__line_items (58 columns)
  • orders__line_items__sellable__images (4 columns)
  • orders__line_items__sellable__reorders (4 columns)
  • orders__line_items__sellable__stock_entries (19 columns)
  • orders__line_items__sellable__variant_option_specifics (4 columns)
  • orders__line_items__sellable__variant_property_specifics (4 columns)
  • orders__allocations (66 columns)
  • orders__allocations__shipment__carrier_fees (4 columns)
  • orders__allocations__line_items (58 columns)
  • orders__allocations__line_items__sellable__images (4 columns)
  • orders__allocations__line_items__sellable__reorders (4 columns)
  • orders__allocations__line_items__sellable__stock_entries (19 columns)
  • orders__allocations__line_items__sellable__variant_option_specifics (4 columns)
  • orders__allocations__line_items__sellable__variant_property_specifics (4 columns)
  • orders__employee_notes (4 columns)
products (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id FLOAT64
image STRING
notes STRING
title STRING
weight FLOAT64
tax_rate FLOAT64
inventory__infinite BOOL
created_at STRING
updated_at STRING
web_page_url STRING
created_by_id FLOAT64
on_hand_value FLOAT64
thumbnail_url STRING
main_image_src STRING
origin_country STRING
web_meta_title STRING
web_page_title STRING
requires_review BOOL
hs_tariff_number STRING
total_stock_level FLOAT64
web_meta_keywords STRING
total_quantity_sold FLOAT64
web_meta_description STRING
total_allocated_stock_level FLOAT64
total_available_stock_level FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • products__tags (4 columns)
  • products__sellables (54 columns)
  • products__sellables__images (4 columns)
  • products__sellables__reorders (4 columns)
  • products__sellables__stock_entries (19 columns)
  • products__sellables__active_channels (4 columns)
  • products__sellables__channel_sellables (4 columns)
  • products__sellables__variant_option_specifics (4 columns)
  • products__sellables__variant_property_specifics (4 columns)
  • products__active_channels (4 columns)
  • products__channel_products (4 columns)
purchase_orders (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
returns (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id FLOAT64
user__id FLOAT64
user__name STRING
user__email STRING
number STRING
status STRING
created_at STRING
warehouse_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • returns__line_items (12 columns)
stores (79 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
city STRING
name STRING
email STRING
state STRING
region STRING
remote BOOL
country STRING
with_fba BOOL
is_master BOOL
post_code STRING
type_code STRING
warehouse__id FLOAT64
warehouse__name STRING
created_by_id FLOAT64
address_line_1 STRING
address_line_2 STRING
always_set_qty FLOAT64
percent_of_qty FLOAT64
default_warehouse__id FLOAT64
default_warehouse__lat STRING
default_warehouse__lng STRING
default_warehouse__city STRING
default_warehouse__name STRING
default_warehouse__phone STRING
default_warehouse__region STRING
default_warehouse__country STRING
default_warehouse__post_code STRING
default_warehouse__company_id FLOAT64
default_warehouse__created_at STRING
default_warehouse__updated_at STRING
default_warehouse__trading_name STRING
default_warehouse__created_by_id FLOAT64
default_warehouse__address_line_1 STRING
default_warehouse__display_position FLOAT64
default_warehouse__default_min_reorder FLOAT64
default_warehouse__inventory_type_code STRING
default_warehouse__letterbox_address_id STRING
default_warehouse__letterbox_address_status STRING
default_warehouse__click_and_collect_enabled BOOL
ebay_site_code_id FLOAT64
import_cost_price BOOL
import_order_tags BOOL
max_qty_to_advert FLOAT64
min_threshold_qty FLOAT64
routing_order_type FLOAT64
import_product_tags BOOL
pull_pending_orders BOOL
pull_product_images BOOL
skip_title_matching BOOL
update_remote_order BOOL
veeqo_dictates_price BOOL
import_product_brands BOOL
pull_historical_orders BOOL
pull_product_properties BOOL
remote_warehouses_exist BOOL
pull_stock_level_required BOOL
update_product_attributes BOOL
amazon_fulfillment_enabled BOOL
authorized_at_remote_store BOOL
pull_unpaid_shopify_orders BOOL
veeqo_dictates_stock_level BOOL
create_product_if_unmatched BOOL
default_send_shipment_email BOOL
disabled_push_of_stock_level BOOL
skip_fba_orders_and_products BOOL
keep_inventory_tracking_value BOOL
create_product_on_ended_listings BOOL
end_ebay_listing_on_out_of_stock BOOL
notify_on_outbound_shipment_date BOOL
import_additional_payment_details BOOL
link_with_similar_listings_by_sku BOOL
automatic_product_linking_disabled BOOL
outbound_shipment_notification_time STRING
send_notification_emails_to_customers BOOL
first_sync_finish_notice_marked_as_read BOOL
link_to_products_linked_to_current_channel BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • stores__warehouses (4 columns)
  • stores__channel_warehouses (4 columns)
  • stores__stock_level_update_requests (4 columns)
suppliers (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
name STRING
colour STRING
company_id FLOAT64
taggings_count FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
warehouses (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
city STRING
name STRING
phone STRING
region STRING
country STRING
post_code STRING
created_at STRING
updated_at STRING
trading_name STRING
created_by_id FLOAT64
address_line_1 STRING
display_position FLOAT64
default_min_reorder FLOAT64
inventory_type_code STRING
letterbox_address_status STRING
click_and_collect_enabled BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Veeqo supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Veeqo?

Section titled “How long does the initial sync take for Veeqo?”

It depends on how much history is in your Veeqo account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Veeqo’s schema changes?

Section titled “What happens when Veeqo’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Veeqo, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Veeqo instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Veeqo connector in Kaivo and all of its synced data is deleted with it.

Use orders and returns to track sales and returns over time.

Join products with warehouses to monitor stock across locations.

Use purchase_orders and suppliers to track buying and restocking.

Once Veeqo data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Veeqo data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Veeqo connector pricing and plan details.