Integration of Baselinker with BigQuery

Connect Baselinker to Google BigQuery in WitCloud and collect orders, returns, invoices, products and inventory data for ecommerce analysis.

Updated

Introduction

This module connects Baselinker with Google Cloud BigQuery. It collects your ecommerce data - orders, returns, invoices, products, categories, storages and inventory - so you can analyze it next to the rest of your data in WitCloud.

Configuration guide

Follow the steps below to connect Baselinker with BigQuery. Once the setup is complete, your Baselinker data will be transferred to your BigQuery project.

Make sure you have admin access to your Baselinker account before starting the configuration.

Module setup

Go to Integrations in the menu and click Add integration.

Integrations list with a few example integrations and the Add integration button

Select Baselinker from the list of available integrations.

Integration catalog with Baselinker selected

Enter the Collect name, e.g., "Baselinker PL".

Collect name field filled in with the example name Baselinker PL

Authorization

If you have previously authorized the Baselinker module and do not require additional permissions, you can skip this step and select the existing authorization from the Baselinker authorization list.

Click Authorize.

Authorize button next to the Baselinker authorization field

Paste your Baselinker API token into the Access token field of the Authorize form and click Create.

Authorize pop-up with the Access token field filled with a placeholder value

Optionally, click Show advanced settings:

  • Timezone - the default is UTC.
  • Data freshness (products, stocks) - how often, in hours, tables that store the entire data history, such as products or stocks, are refreshed. You can enter a value from 4 to 12 hours.
  • Static IP - if your platform has additional network security measures such as Cloudflare, enable this option. All requests are then made from a single fixed IP address (shown after you switch the option on) that you can add to a whitelist.
  • Tables to collect - lets you narrow down the tables you want to collect. All tables are selected by default and at least one is required.

Advanced settings with the Timezone, Data freshness (products, stocks), Static IP and Tables to collect fields

Advanced settings with the Static IP switch and the Tables to collect field

Click Next.

Historical data and scheduling

In the Historical Data field, enter the number of days for which you want to fetch historical data. You can enter up to 365 days.

Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your Baselinker data will now be synchronized with BigQuery.

Data schema

Expand the tables below to view the full data schema collected from Baselinker.

Data schema for baselinker_external_categories
Field NameModeType
storage_idNULLABLESTRING
category_idNULLABLESTRING
nameNULLABLESTRING
parent_idNULLABLESTRING
Data schema for baselinker_invoices
Field NameModeType
invoice_idNULLABLESTRING
order_idNULLABLESTRING
series_idNULLABLESTRING
typeNULLABLESTRING
numberNULLABLESTRING
yearNULLABLESTRING
monthNULLABLESTRING
sub_idNULLABLESTRING
postfixNULLABLESTRING
date_addNULLABLEINTEGER
date_sellNULLABLEINTEGER
date_pay_toNULLABLEINTEGER
currencyNULLABLESTRING
total_price_bruttoNULLABLEFLOAT
total_price_nettoNULLABLEFLOAT
invoice_fullnameNULLABLESTRING
invoice_companyNULLABLESTRING
invoice_nipNULLABLESTRING
invoice_addressNULLABLESTRING
invoice_cityNULLABLESTRING
invoice_postcodeNULLABLESTRING
invoice_countryNULLABLESTRING
invoice_country_codeNULLABLESTRING
sellerNULLABLESTRING
paymentNULLABLESTRING
additional_infoNULLABLESTRING
correcting_to_invoice_idNULLABLESTRING
correcting_reasonNULLABLESTRING
correcting_itemsNULLABLEBOOLEAN
correcting_dataNULLABLEBOOLEAN
external_invoice_numberNULLABLESTRING
external_idNULLABLESTRING
exchange_currencyNULLABLESTRING
exchange_rateNULLABLESTRING
exchange_dateNULLABLESTRING
exchange_infoNULLABLESTRING
itemsREPEATEDRECORD
├─ items.nameNULLABLESTRING
├─ items.skuNULLABLESTRING
├─ items.eanNULLABLESTRING
├─ items.price_bruttoNULLABLEFLOAT
├─ items.price_nettoNULLABLEFLOAT
├─ items.tax_rateNULLABLEFLOAT
├─ items.quantityNULLABLEINTEGER
├─ items.is_shipmentNULLABLEINTEGER
Data schema for baselinker_order_extra_fields
Field NameModeType
extra_field_idNULLABLESTRING
nameNULLABLESTRING
editor_typeNULLABLESTRING
Data schema for baselinker_order_returns_statuses
Field NameModeType
idNULLABLESTRING
nameNULLABLESTRING
name_for_customerNULLABLEJSON
colorNULLABLESTRING
Data schema for baselinker_order_returns
Field NameModeType
return_idNULLABLESTRING
order_idNULLABLESTRING
shop_order_idNULLABLESTRING
external_order_idNULLABLESTRING
reference_numberNULLABLESTRING
order_return_sourceNULLABLESTRING
order_return_source_idNULLABLESTRING
status_idNULLABLESTRING
date_addNULLABLEINTEGER
date_in_statusNULLABLEINTEGER
user_loginNULLABLESTRING
currencyNULLABLESTRING
refundedNULLABLEFLOAT
emailNULLABLESTRING
phoneNULLABLESTRING
delivery_priceNULLABLEFLOAT
delivery_fullnameNULLABLESTRING
delivery_companyNULLABLESTRING
delivery_addressNULLABLESTRING
delivery_postcodeNULLABLESTRING
delivery_cityNULLABLESTRING
delivery_stateNULLABLESTRING
delivery_country_codeNULLABLESTRING
delivery_countryNULLABLESTRING
extra_field_1NULLABLESTRING
extra_field_2NULLABLESTRING
admin_commentsNULLABLESTRING
delivery_package_moduleNULLABLESTRING
delivery_package_nrNULLABLESTRING
productsREPEATEDRECORD
├─ products.order_return_product_idNULLABLESTRING
├─ products.storageNULLABLESTRING
├─ products.storage_idNULLABLESTRING
├─ products.product_idNULLABLESTRING
├─ products.variant_idNULLABLESTRING
├─ products.nameNULLABLESTRING
├─ products.skuNULLABLESTRING
├─ products.eanNULLABLESTRING
├─ products.locationNULLABLESTRING
├─ products.warehouse_idNULLABLESTRING
├─ products.auction_idNULLABLESTRING
├─ products.attributesNULLABLESTRING
├─ products.price_bruttoNULLABLEFLOAT
├─ products.tax_rateNULLABLEFLOAT
├─ products.quantityNULLABLEINTEGER
├─ products.weightNULLABLEFLOAT
├─ products.bundle_idNULLABLESTRING
├─ products.status_idNULLABLESTRING
├─ products.return_reason_idNULLABLESTRING
refund_account_numberNULLABLESTRING
refund_ibanNULLABLESTRING
refund_swiftNULLABLESTRING
fulfillment_statusNULLABLESTRING
Data schema for baselinker_order_statuses
Field NameModeType
idNULLABLESTRING
nameNULLABLESTRING
name_for_customerNULLABLESTRING
colorNULLABLESTRING
Data schema for baselinker_orders
Field NameModeType
order_idNULLABLESTRING
invoice_countryNULLABLESTRING
pack_stateNULLABLEINTEGER
shop_order_idNULLABLESTRING
invoice_cityNULLABLESTRING
invoice_addressNULLABLESTRING
invoice_nipNULLABLESTRING
pick_stateNULLABLEINTEGER
invoice_companyNULLABLESTRING
delivery_point_cityNULLABLESTRING
delivery_point_postcodeNULLABLESTRING
delivery_package_nrNULLABLESTRING
extra_field_1NULLABLESTRING
extra_field_2NULLABLESTRING
delivery_countryNULLABLESTRING
invoice_country_codeNULLABLESTRING
delivery_point_addressNULLABLESTRING
delivery_point_idNULLABLESTRING
order_pageNULLABLESTRING
want_invoiceNULLABLEBOOLEAN
delivery_country_codeNULLABLESTRING
delivery_cityNULLABLESTRING
delivery_addressNULLABLESTRING
payment_methodNULLABLESTRING
delivery_companyNULLABLESTRING
invoice_fullnameNULLABLESTRING
delivery_fullnameNULLABLESTRING
delivery_package_moduleNULLABLESTRING
delivery_priceNULLABLEFLOAT
payment_doneNULLABLEFLOAT
invoice_postcodeNULLABLESTRING
payment_method_codNULLABLEINTEGER
delivery_postcodeNULLABLESTRING
date_in_statusNULLABLETIMESTAMP
order_status_idNULLABLESTRING
admin_commentsNULLABLESTRING
user_commentsNULLABLESTRING
currencyNULLABLESTRING
delivery_point_nameNULLABLESTRING
emailNULLABLESTRING
date_addNULLABLETIMESTAMP
phoneNULLABLESTRING
order_sourceNULLABLESTRING
delivery_methodNULLABLESTRING
order_source_idNULLABLESTRING
external_order_idNULLABLESTRING
date_confirmedNULLABLETIMESTAMP
user_loginNULLABLESTRING
order_source_infoNULLABLESTRING
confirmedNULLABLEBOOLEAN
productsREPEATEDRECORD
├─ products.weightNULLABLEFLOAT
├─ products.quantityNULLABLEINTEGER
├─ products.product_idNULLABLESTRING
├─ products.auction_idNULLABLESTRING
├─ products.price_bruttoNULLABLEFLOAT
├─ products.eanNULLABLESTRING
├─ products.skuNULLABLESTRING
├─ products.storageNULLABLESTRING
├─ products.variant_idNULLABLESTRING
├─ products.order_product_idNULLABLESTRING
├─ products.tax_rateNULLABLEFLOAT
├─ products.attributesNULLABLESTRING
├─ products.nameNULLABLESTRING
├─ products.storage_idNULLABLESTRING
user_login_hashNULLABLESTRING
phone_hashNULLABLESTRING
invoice_fullname_hashNULLABLESTRING
email_hashNULLABLESTRING
delivery_fullname_hashNULLABLESTRING
delivery_address_hashNULLABLESTRING
delivery_point_address_hashNULLABLESTRING
invoice_address_hashNULLABLESTRING
custom_extra_fieldsNULLABLEJSON
Data schema for baselinker_external_products
Field NameModeType
storage_idNULLABLESTRING
product_idNULLABLESTRING
eanNULLABLESTRING
skuNULLABLESTRING
nameNULLABLESTRING
quantityNULLABLEINTEGER
price_nettoNULLABLEFLOAT
price_bruttoNULLABLEFLOAT
price_wholesale_nettoNULLABLEFLOAT
tax_rateNULLABLEFLOAT
weightNULLABLEFLOAT
descriptionNULLABLESTRING
description_extra1NULLABLESTRING
description_extra2NULLABLESTRING
description_extra3NULLABLESTRING
description_extra4NULLABLESTRING
man_nameNULLABLESTRING
man_imageNULLABLESTRING
category_idNULLABLESTRING
imagesREPEATEDSTRING
featuresREPEATEDRECORD
├─ features.keyNULLABLESTRING
├─ features.valueNULLABLESTRING
variantsREPEATEDRECORD
├─ variants.variant_idNULLABLESTRING
├─ variants.nameNULLABLESTRING
├─ variants.priceNULLABLEFLOAT
├─ variants.quantityNULLABLEINTEGER
├─ variants.eanNULLABLESTRING
├─ variants.skuNULLABLESTRING
Data schema for baselinker_external_storages
Field NameModeType
storage_idNULLABLESTRING
nameNULLABLESTRING
Data schema for baselinker_inventory_price_groups
Field NameModeType
price_group_idNULLABLESTRING
nameNULLABLESTRING
descriptionNULLABLESTRING
currencyNULLABLESTRING
is_defaultNULLABLEBOOLEAN
price_group_typeNULLABLESTRING
source_price_group_idNULLABLESTRING
price_multiplierNULLABLEFLOAT
price_additionNULLABLEFLOAT
is_bundle_price_calculatedNULLABLEBOOLEAN
bundle_price_multiplierNULLABLEFLOAT
bundle_price_additionNULLABLEFLOAT
Data schema for baselinker_inventory_products
Field NameModeType
inventory_idNULLABLESTRING
inventory_nameNULLABLESTRING
product_idNULLABLESTRING
parent_idNULLABLESTRING
nameNULLABLESTRING
skuNULLABLESTRING
eanNULLABLESTRING
asinNULLABLESTRING
is_bundleNULLABLEBOOLEAN
tax_rateNULLABLEFLOAT
average_costNULLABLEFLOAT
average_landed_costNULLABLEFLOAT
pricesREPEATEDRECORD
├─ prices.price_group_idNULLABLESTRING
├─ prices.priceNULLABLEFLOAT
linksREPEATEDRECORD
├─ links.storage_idNULLABLESTRING
├─ links.product_idNULLABLESTRING
├─ links.variant_idNULLABLESTRING