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.

Select Baselinker from the list of available integrations.

Enter the Collect name, e.g., "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.

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

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.


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.

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

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 Name | Mode | Type |
|---|---|---|
| storage_id | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| parent_id | NULLABLE | STRING |
Data schema for baselinker_invoices
| Field Name | Mode | Type |
|---|---|---|
| invoice_id | NULLABLE | STRING |
| order_id | NULLABLE | STRING |
| series_id | NULLABLE | STRING |
| type | NULLABLE | STRING |
| number | NULLABLE | STRING |
| year | NULLABLE | STRING |
| month | NULLABLE | STRING |
| sub_id | NULLABLE | STRING |
| postfix | NULLABLE | STRING |
| date_add | NULLABLE | INTEGER |
| date_sell | NULLABLE | INTEGER |
| date_pay_to | NULLABLE | INTEGER |
| currency | NULLABLE | STRING |
| total_price_brutto | NULLABLE | FLOAT |
| total_price_netto | NULLABLE | FLOAT |
| invoice_fullname | NULLABLE | STRING |
| invoice_company | NULLABLE | STRING |
| invoice_nip | NULLABLE | STRING |
| invoice_address | NULLABLE | STRING |
| invoice_city | NULLABLE | STRING |
| invoice_postcode | NULLABLE | STRING |
| invoice_country | NULLABLE | STRING |
| invoice_country_code | NULLABLE | STRING |
| seller | NULLABLE | STRING |
| payment | NULLABLE | STRING |
| additional_info | NULLABLE | STRING |
| correcting_to_invoice_id | NULLABLE | STRING |
| correcting_reason | NULLABLE | STRING |
| correcting_items | NULLABLE | BOOLEAN |
| correcting_data | NULLABLE | BOOLEAN |
| external_invoice_number | NULLABLE | STRING |
| external_id | NULLABLE | STRING |
| exchange_currency | NULLABLE | STRING |
| exchange_rate | NULLABLE | STRING |
| exchange_date | NULLABLE | STRING |
| exchange_info | NULLABLE | STRING |
| items | REPEATED | RECORD |
| ├─ items.name | NULLABLE | STRING |
| ├─ items.sku | NULLABLE | STRING |
| ├─ items.ean | NULLABLE | STRING |
| ├─ items.price_brutto | NULLABLE | FLOAT |
| ├─ items.price_netto | NULLABLE | FLOAT |
| ├─ items.tax_rate | NULLABLE | FLOAT |
| ├─ items.quantity | NULLABLE | INTEGER |
| ├─ items.is_shipment | NULLABLE | INTEGER |
Data schema for baselinker_order_extra_fields
| Field Name | Mode | Type |
|---|---|---|
| extra_field_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| editor_type | NULLABLE | STRING |
Data schema for baselinker_order_returns_statuses
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| name_for_customer | NULLABLE | JSON |
| color | NULLABLE | STRING |
Data schema for baselinker_order_returns
| Field Name | Mode | Type |
|---|---|---|
| return_id | NULLABLE | STRING |
| order_id | NULLABLE | STRING |
| shop_order_id | NULLABLE | STRING |
| external_order_id | NULLABLE | STRING |
| reference_number | NULLABLE | STRING |
| order_return_source | NULLABLE | STRING |
| order_return_source_id | NULLABLE | STRING |
| status_id | NULLABLE | STRING |
| date_add | NULLABLE | INTEGER |
| date_in_status | NULLABLE | INTEGER |
| user_login | NULLABLE | STRING |
| currency | NULLABLE | STRING |
| refunded | NULLABLE | FLOAT |
| NULLABLE | STRING | |
| phone | NULLABLE | STRING |
| delivery_price | NULLABLE | FLOAT |
| delivery_fullname | NULLABLE | STRING |
| delivery_company | NULLABLE | STRING |
| delivery_address | NULLABLE | STRING |
| delivery_postcode | NULLABLE | STRING |
| delivery_city | NULLABLE | STRING |
| delivery_state | NULLABLE | STRING |
| delivery_country_code | NULLABLE | STRING |
| delivery_country | NULLABLE | STRING |
| extra_field_1 | NULLABLE | STRING |
| extra_field_2 | NULLABLE | STRING |
| admin_comments | NULLABLE | STRING |
| delivery_package_module | NULLABLE | STRING |
| delivery_package_nr | NULLABLE | STRING |
| products | REPEATED | RECORD |
| ├─ products.order_return_product_id | NULLABLE | STRING |
| ├─ products.storage | NULLABLE | STRING |
| ├─ products.storage_id | NULLABLE | STRING |
| ├─ products.product_id | NULLABLE | STRING |
| ├─ products.variant_id | NULLABLE | STRING |
| ├─ products.name | NULLABLE | STRING |
| ├─ products.sku | NULLABLE | STRING |
| ├─ products.ean | NULLABLE | STRING |
| ├─ products.location | NULLABLE | STRING |
| ├─ products.warehouse_id | NULLABLE | STRING |
| ├─ products.auction_id | NULLABLE | STRING |
| ├─ products.attributes | NULLABLE | STRING |
| ├─ products.price_brutto | NULLABLE | FLOAT |
| ├─ products.tax_rate | NULLABLE | FLOAT |
| ├─ products.quantity | NULLABLE | INTEGER |
| ├─ products.weight | NULLABLE | FLOAT |
| ├─ products.bundle_id | NULLABLE | STRING |
| ├─ products.status_id | NULLABLE | STRING |
| ├─ products.return_reason_id | NULLABLE | STRING |
| refund_account_number | NULLABLE | STRING |
| refund_iban | NULLABLE | STRING |
| refund_swift | NULLABLE | STRING |
| fulfillment_status | NULLABLE | STRING |
Data schema for baselinker_order_statuses
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| name_for_customer | NULLABLE | STRING |
| color | NULLABLE | STRING |
Data schema for baselinker_orders
| Field Name | Mode | Type |
|---|---|---|
| order_id | NULLABLE | STRING |
| invoice_country | NULLABLE | STRING |
| pack_state | NULLABLE | INTEGER |
| shop_order_id | NULLABLE | STRING |
| invoice_city | NULLABLE | STRING |
| invoice_address | NULLABLE | STRING |
| invoice_nip | NULLABLE | STRING |
| pick_state | NULLABLE | INTEGER |
| invoice_company | NULLABLE | STRING |
| delivery_point_city | NULLABLE | STRING |
| delivery_point_postcode | NULLABLE | STRING |
| delivery_package_nr | NULLABLE | STRING |
| extra_field_1 | NULLABLE | STRING |
| extra_field_2 | NULLABLE | STRING |
| delivery_country | NULLABLE | STRING |
| invoice_country_code | NULLABLE | STRING |
| delivery_point_address | NULLABLE | STRING |
| delivery_point_id | NULLABLE | STRING |
| order_page | NULLABLE | STRING |
| want_invoice | NULLABLE | BOOLEAN |
| delivery_country_code | NULLABLE | STRING |
| delivery_city | NULLABLE | STRING |
| delivery_address | NULLABLE | STRING |
| payment_method | NULLABLE | STRING |
| delivery_company | NULLABLE | STRING |
| invoice_fullname | NULLABLE | STRING |
| delivery_fullname | NULLABLE | STRING |
| delivery_package_module | NULLABLE | STRING |
| delivery_price | NULLABLE | FLOAT |
| payment_done | NULLABLE | FLOAT |
| invoice_postcode | NULLABLE | STRING |
| payment_method_cod | NULLABLE | INTEGER |
| delivery_postcode | NULLABLE | STRING |
| date_in_status | NULLABLE | TIMESTAMP |
| order_status_id | NULLABLE | STRING |
| admin_comments | NULLABLE | STRING |
| user_comments | NULLABLE | STRING |
| currency | NULLABLE | STRING |
| delivery_point_name | NULLABLE | STRING |
| NULLABLE | STRING | |
| date_add | NULLABLE | TIMESTAMP |
| phone | NULLABLE | STRING |
| order_source | NULLABLE | STRING |
| delivery_method | NULLABLE | STRING |
| order_source_id | NULLABLE | STRING |
| external_order_id | NULLABLE | STRING |
| date_confirmed | NULLABLE | TIMESTAMP |
| user_login | NULLABLE | STRING |
| order_source_info | NULLABLE | STRING |
| confirmed | NULLABLE | BOOLEAN |
| products | REPEATED | RECORD |
| ├─ products.weight | NULLABLE | FLOAT |
| ├─ products.quantity | NULLABLE | INTEGER |
| ├─ products.product_id | NULLABLE | STRING |
| ├─ products.auction_id | NULLABLE | STRING |
| ├─ products.price_brutto | NULLABLE | FLOAT |
| ├─ products.ean | NULLABLE | STRING |
| ├─ products.sku | NULLABLE | STRING |
| ├─ products.storage | NULLABLE | STRING |
| ├─ products.variant_id | NULLABLE | STRING |
| ├─ products.order_product_id | NULLABLE | STRING |
| ├─ products.tax_rate | NULLABLE | FLOAT |
| ├─ products.attributes | NULLABLE | STRING |
| ├─ products.name | NULLABLE | STRING |
| ├─ products.storage_id | NULLABLE | STRING |
| user_login_hash | NULLABLE | STRING |
| phone_hash | NULLABLE | STRING |
| invoice_fullname_hash | NULLABLE | STRING |
| email_hash | NULLABLE | STRING |
| delivery_fullname_hash | NULLABLE | STRING |
| delivery_address_hash | NULLABLE | STRING |
| delivery_point_address_hash | NULLABLE | STRING |
| invoice_address_hash | NULLABLE | STRING |
| custom_extra_fields | NULLABLE | JSON |
Data schema for baselinker_external_products
| Field Name | Mode | Type |
|---|---|---|
| storage_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| ean | NULLABLE | STRING |
| sku | NULLABLE | STRING |
| name | NULLABLE | STRING |
| quantity | NULLABLE | INTEGER |
| price_netto | NULLABLE | FLOAT |
| price_brutto | NULLABLE | FLOAT |
| price_wholesale_netto | NULLABLE | FLOAT |
| tax_rate | NULLABLE | FLOAT |
| weight | NULLABLE | FLOAT |
| description | NULLABLE | STRING |
| description_extra1 | NULLABLE | STRING |
| description_extra2 | NULLABLE | STRING |
| description_extra3 | NULLABLE | STRING |
| description_extra4 | NULLABLE | STRING |
| man_name | NULLABLE | STRING |
| man_image | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| images | REPEATED | STRING |
| features | REPEATED | RECORD |
| ├─ features.key | NULLABLE | STRING |
| ├─ features.value | NULLABLE | STRING |
| variants | REPEATED | RECORD |
| ├─ variants.variant_id | NULLABLE | STRING |
| ├─ variants.name | NULLABLE | STRING |
| ├─ variants.price | NULLABLE | FLOAT |
| ├─ variants.quantity | NULLABLE | INTEGER |
| ├─ variants.ean | NULLABLE | STRING |
| ├─ variants.sku | NULLABLE | STRING |
Data schema for baselinker_external_storages
| Field Name | Mode | Type |
|---|---|---|
| storage_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
Data schema for baselinker_inventory_price_groups
| Field Name | Mode | Type |
|---|---|---|
| price_group_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| description | NULLABLE | STRING |
| currency | NULLABLE | STRING |
| is_default | NULLABLE | BOOLEAN |
| price_group_type | NULLABLE | STRING |
| source_price_group_id | NULLABLE | STRING |
| price_multiplier | NULLABLE | FLOAT |
| price_addition | NULLABLE | FLOAT |
| is_bundle_price_calculated | NULLABLE | BOOLEAN |
| bundle_price_multiplier | NULLABLE | FLOAT |
| bundle_price_addition | NULLABLE | FLOAT |
Data schema for baselinker_inventory_products
| Field Name | Mode | Type |
|---|---|---|
| inventory_id | NULLABLE | STRING |
| inventory_name | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| parent_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| sku | NULLABLE | STRING |
| ean | NULLABLE | STRING |
| asin | NULLABLE | STRING |
| is_bundle | NULLABLE | BOOLEAN |
| tax_rate | NULLABLE | FLOAT |
| average_cost | NULLABLE | FLOAT |
| average_landed_cost | NULLABLE | FLOAT |
| prices | REPEATED | RECORD |
| ├─ prices.price_group_id | NULLABLE | STRING |
| ├─ prices.price | NULLABLE | FLOAT |
| links | REPEATED | RECORD |
| ├─ links.storage_id | NULLABLE | STRING |
| ├─ links.product_id | NULLABLE | STRING |
| ├─ links.variant_id | NULLABLE | STRING |
