Integracja Baselinker z BigQuery
Podłącz Baselinker do Google BigQuery w WitCloud i pobieraj zamówienia, zwroty, faktury, produkty oraz dane magazynowe, aby analizować sprzedaż e-commerce.
Aktualizacja
Wprowadzenie
Ta integracja łączy Baselinker z Google Cloud BigQuery. Pobiera dane e-commerce - zamówienia, zwroty, faktury, produkty, kategorie, magazyny i stany magazynowe - dzięki czemu możesz analizować je obok pozostałych danych w WitCloud.
Przewodnik konfiguracji
Wykonaj poniższe kroki, aby połączyć Baselinker z BigQuery. Po zakończeniu konfiguracji dane z Baselinker będą przesyłane do Twojego projektu BigQuery.
Zanim zaczniesz konfigurację, upewnij się, że masz dostęp administratora do swojego konta Baselinker.
Konfiguracja modułu
Przejdź do Integracje w menu i kliknij Dodaj integrację.

Wybierz Baselinker z listy dostępnych integracji.

Wpisz Nazwę źródła danych, np. „Baselinker PL".

Autoryzacja
Jeśli moduł Baselinker był już wcześniej autoryzowany i nie potrzebujesz dodatkowych uprawnień, możesz pominąć ten krok i wybrać istniejącą autoryzację z listy Autoryzacja Baselinker.
Kliknij Autoryzuj.

Wklej swój token API z Baselinker w pole Token dostępu w formularzu Autoryzuj i kliknij Utwórz.

Opcjonalnie kliknij Pokaż ustawienia zaawansowane:
- Strefa czasowa - domyślnie UTC.
- Odświeżanie danych (produkty, stany magazynowe) - jak często, w godzinach, odświeżane są tabele przechowujące całą historię danych, takie jak produkty czy stany magazynowe. Możesz wpisać wartość od 4 do 12 godzin.
- Stały adres IP - jeśli Twoja platforma ma dodatkowe zabezpieczenia sieciowe, np. Cloudflare, włącz tę opcję. Wszystkie zapytania będą wtedy wysyłane z jednego stałego adresu IP (pojawia się po włączeniu opcji), który możesz dodać do listy dozwolonych adresów.
- Tabele do pobrania - pozwala zawęzić listę tabel, które chcesz pobierać. Domyślnie zaznaczone są wszystkie, a co najmniej jedna tabela jest wymagana.


Kliknij Dalej.
Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni, z których chcesz pobrać dane historyczne. Możesz podać maksymalnie 365 dni.

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.

Gotowe! Dane z Baselinker będą teraz synchronizowane z BigQuery.
Schemat danych
Rozwiń poniższe tabele, aby zobaczyć pełny schemat danych pobieranych z Baselinker.
Schemat danych tabeli baselinker_external_categories
| Nazwa pola | Tryb | Typ |
|---|---|---|
| storage_id | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| parent_id | NULLABLE | STRING |
Schemat danych tabeli baselinker_invoices
| Nazwa pola | Tryb | Typ |
|---|---|---|
| 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 |
Schemat danych tabeli baselinker_order_extra_fields
| Nazwa pola | Tryb | Typ |
|---|---|---|
| extra_field_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| editor_type | NULLABLE | STRING |
Schemat danych tabeli baselinker_order_returns_statuses
| Nazwa pola | Tryb | Typ |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| name_for_customer | NULLABLE | JSON |
| color | NULLABLE | STRING |
Schemat danych tabeli baselinker_order_returns
| Nazwa pola | Tryb | Typ |
|---|---|---|
| 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 |
Schemat danych tabeli baselinker_order_statuses
| Nazwa pola | Tryb | Typ |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| name_for_customer | NULLABLE | STRING |
| color | NULLABLE | STRING |
Schemat danych tabeli baselinker_orders
| Nazwa pola | Tryb | Typ |
|---|---|---|
| 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 |
Schemat danych tabeli baselinker_external_products
| Nazwa pola | Tryb | Typ |
|---|---|---|
| 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 |
Schemat danych tabeli baselinker_external_storages
| Nazwa pola | Tryb | Typ |
|---|---|---|
| storage_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
Schemat danych tabeli baselinker_inventory_price_groups
| Nazwa pola | Tryb | Typ |
|---|---|---|
| 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 |
Schemat danych tabeli baselinker_inventory_products
| Nazwa pola | Tryb | Typ |
|---|---|---|
| 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 |
