Integracja Shoper z BigQuery
Dowiedz się, jak połączyć Shoper z Google BigQuery w WitCloud, aby pobierać zamówienia, produkty w zamówieniach, produkty, kategorie, stany magazynowe i inne dane ze sklepu.
Aktualizacja
Wprowadzenie
Ten moduł łączy Twój sklep Shoper z Google Cloud BigQuery. WitCloud pobiera przez API Shoper Twoje zamówienia i produkty w zamówieniach, katalog produktów (produkty, zdjęcia, kategorie, stany magazynowe, producentów) oraz ustawienia sklepu (statusy, waluty, metody płatności i dostawy, podatki) i zapisuje je w zbiorze danych BigQuery Twojego projektu. Dzięki temu możesz analizować sprzedaż, produkty i stany magazynowe razem z danymi reklamowymi.
Konfiguracja
Wykonaj poniższe kroki, aby połączyć Shoper z BigQuery. WitCloud potrzebuje adresu Twojego sklepu oraz nazwy użytkownika i hasła konta Shoper, które może korzystać z REST API Shoper (WebAPI).
Przygotuj konto Shoper przed rozpoczęciem: jego nazwę użytkownika i hasło wpiszesz w kroku Autoryzacja. Ze sklepu dane są tylko odczytywane; WitCloud niczego w nim nie zmienia.
Przygotuj konto w Shoper
Ten krok wykonujesz w panelu administracyjnym Shoper, który nie jest częścią WitCloud, dlatego nie pokazujemy go tutaj. Sposób utworzenia konta z dostępem do REST API Shoper (WebAPI) opisuje dokumentacja Shoper.
Upewnij się, że masz nazwę użytkownika i hasło takiego konta. Nie udostępniaj ich nikomu: każdy, kto je zna, może odczytać dane Twojego sklepu przez API.
Konfiguracja modułu
Przejdź do Integracje i kliknij Dodaj integrację.

Wybierz Shoper z listy dostępnych integracji.

Wpisz Nazwa źródła danych, np. „Shoper PL". Czytelna nazwa pomoże Ci później rozpoznać źródło danych.

Wpisz Adres URL sklepu: adres Twojego sklepu razem z https://, np. https://twoj-sklep.pl. Przycisk Autoryzuj jest nieaktywny, dopóki nie wpiszesz poprawnego adresu.

Autoryzacja
Jeśli ten sklep Shoper został już wcześniej autoryzowany w WitCloud, wybierz istniejący token z listy Autoryzacja Shoper i pomiń dwa następne kroki.
Kliknij Autoryzuj.

W oknie Autoryzuj wpisz Nazwa użytkownika i hasło konta Shoper, a następnie kliknij Utwórz. WitCloud sprawdza je w Twoim sklepie i zapisuje, aby mógł później odnowić dostęp. Jeśli hasło jest błędne, adres sklepu jest nieprawidłowy lub sklep jest nieosiągalny, przyczyna pojawi się pod formularzem.

Zapisany token zostanie wybrany automatycznie, a jego nazwa składa się z adresu sklepu i nazwy użytkownika. Możesz też wybrać token z listy Autoryzacja Shoper.

Ustawienia zaawansowane
Kliknij Pokaż ustawienia zaawansowane, aby zobaczyć trzy dodatkowe pola.
W polu Odświeżanie danych (produkty, stany magazynowe) wpisz, co ile godzin odświeżać tabele z całym katalogiem (produkty, zdjęcia produktów i stany magazynowe). Tabela, która była aktualizowana w ciągu ostatnich tylu godzin, jest pomijana przy następnym uruchomieniu. Wartość musi mieścić się między 4 a 12 godzin; domyślnie jest to 4.

Włącz Stały adres IP, jeśli Twój sklep ma dodatkowe zabezpieczenia sieciowe, np. Cloudflare. Wszystkie zapytania o dane są wtedy wysyłane z jednego stałego adresu IP, 34.118.32.227, który możesz dodać do listy dozwolonych adresów swojego sklepu.

W polu Tabele do pobrania możesz usunąć tabele, których nie potrzebujesz. Pole oferuje orders, order_products, products, product_images, categories, categories_tree, stock, producers, statuses, currencies, option_values, application_config, payments, shippings i taxes; domyślnie wszystkie są zaznaczone, a co najmniej jedna musi pozostać zaznaczona.

Kliknij Dalej.

Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni, które mają zostać pobrane przy pierwszym uruchomieniu, maksymalnie 365.

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

Gotowe! Dane z Shoper będą teraz synchronizowane z BigQuery. Zamówienia i produkty w zamówieniach są pobierane dzień po dniu, więc dla nich uzupełniane są dni historyczne; wszystkie pozostałe tabele są przy każdym uruchomieniu pobierane w całości.
Schemat danych
Poniższe tabele pokazują dane pobierane z Shoper.
Schemat danych tabeli shoper_application_config
| Field Name | Mode | Type |
|---|---|---|
| is_mobile | NULLABLE | BOOLEAN |
| is_facebook | NULLABLE | BOOLEAN |
| shop_url | NULLABLE | STRING |
| shop_email | NULLABLE | STRING |
| shop_company_name | NULLABLE | STRING |
| shop_phone | NULLABLE | STRING |
| shop_tax_id | NULLABLE | STRING |
| shop_address_1 | NULLABLE | STRING |
| shop_address_2 | NULLABLE | STRING |
| shop_city | NULLABLE | STRING |
| shop_zip_code | NULLABLE | STRING |
| shop_province | NULLABLE | STRING |
| shop_country | NULLABLE | STRING |
| shop_trade | NULLABLE | STRING |
| shop_regon | NULLABLE | STRING |
| shop_off | NULLABLE | STRING |
| shop_name | NULLABLE | STRING |
| shop_full_address | NULLABLE | STRING |
| shop_trade_code | NULLABLE | STRING |
| product_defaults_tax_id | NULLABLE | STRING |
| product_defaults_code | NULLABLE | STRING |
| product_defaults_stock | NULLABLE | STRING |
| product_defaults_warn_level | NULLABLE | STRING |
| product_defaults_order | NULLABLE | STRING |
| product_defaults_active | NULLABLE | STRING |
| product_defaults_weight | NULLABLE | STRING |
| product_defaults_unit_id | NULLABLE | STRING |
| product_defaults_availability_id | NULLABLE | STRING |
| product_defaults_delivery_id | NULLABLE | STRING |
| product_defaults_bundle_unit_id | NULLABLE | STRING |
| license_id | NULLABLE | STRING |
| shopping_vat_eu_enable | NULLABLE | STRING |
| shopping_allow_product_different_currency | NULLABLE | STRING |
| shopping_price_levels | NULLABLE | STRING |
| shopping_save_basket | NULLABLE | STRING |
| shopping_update_stock_on_buy | NULLABLE | STRING |
| shopping_basket_adding | NULLABLE | STRING |
| shopping_allow_to_buy_not_reg | NULLABLE | STRING |
| shopping_order_via_token | NULLABLE | STRING |
| shopping_confirm_order | NULLABLE | STRING |
| shopping_min_prod_quantity | NULLABLE | STRING |
| shopping_min_order_value | NULLABLE | STRING |
| shopping_off | NULLABLE | STRING |
| shopping_products_allow_zero | NULLABLE | STRING |
| shopping_allow_overselling | NULLABLE | STRING |
| shopping_parcel_create_status_id | NULLABLE | STRING |
| shopping_parcel_send_status_id | NULLABLE | STRING |
| shopping_change_status_payment_made_id | NULLABLE | STRING |
| shopping_change_status_refund_made_id | NULLABLE | STRING |
| shopping_shipping_extra_step | NULLABLE | STRING |
| shopping_newproducts_days | NULLABLE | STRING |
| shopping_newproducts_mode | NULLABLE | STRING |
| shopping_bestseller_days | NULLABLE | STRING |
| shopping_bestseller_mode | NULLABLE | STRING |
| shopping_bestseller_algorithm | NULLABLE | STRING |
| shopping_price_comparision_field | NULLABLE | STRING |
| shopping_volumetric_weight_enable | NULLABLE | STRING |
| shopping_promo_codes_enable | NULLABLE | STRING |
| shopping_pesel | NULLABLE | STRING |
| product_notifies_enable | NULLABLE | STRING |
| registration_enable | NULLABLE | STRING |
| registration_confirm | NULLABLE | STRING |
| registration_login_to_see_price | NULLABLE | STRING |
| registration_new_cust_discount | NULLABLE | STRING |
| registration_require_address | NULLABLE | STRING |
| shipping_add_payment_cost_to_free_shipping | NULLABLE | STRING |
| shipping_volumetric_weight_enable | NULLABLE | STRING |
| product_search_type | NULLABLE | STRING |
| product_search_all_tokens | NULLABLE | STRING |
| product_search_code | NULLABLE | STRING |
| product_search_short_description | NULLABLE | STRING |
| product_search_description | NULLABLE | STRING |
| digital_product_unlocking_status_id | NULLABLE | STRING |
| digital_product_link_expiration_time | NULLABLE | STRING |
| digital_product_number_of_downloads | NULLABLE | STRING |
| comment_enable | NULLABLE | STRING |
| comment_for_users | NULLABLE | STRING |
| comment_moderation | NULLABLE | STRING |
| loyalty_enable | NULLABLE | STRING |
| blog_items_per_page | NULLABLE | STRING |
| blog_comments_enable | NULLABLE | STRING |
| blog_comments_for_users | NULLABLE | STRING |
| blog_comments_moderation | NULLABLE | STRING |
| blog_download_enable | NULLABLE | STRING |
| blog_download_for_users | NULLABLE | STRING |
| blog_news_default_url_format | NULLABLE | STRING |
| blog_category_default_url_format | NULLABLE | STRING |
| blog_use_new_url_namespace | NULLABLE | STRING |
| locale_timezone | NULLABLE | STRING |
| locale_default_weight | NULLABLE | STRING |
| default_language_name | NULLABLE | STRING |
| default_language_id | NULLABLE | STRING |
| default_currency_id | NULLABLE | STRING |
| default_currency_name | NULLABLE | STRING |
| warehouses_enabled | NULLABLE | BOOLEAN |
Schemat danych tabeli shoper_categories
| Field Name | Mode | Type |
|---|---|---|
| category_id | NULLABLE | STRING |
| root | NULLABLE | BOOLEAN |
| order | NULLABLE | INTEGER |
| translations | REPEATED | RECORD |
| translations.language | NULLABLE | STRING |
| translations.trans_id | NULLABLE | STRING |
| translations.category_id | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| translations.name | NULLABLE | STRING |
| translations.description | NULLABLE | STRING |
| translations.description_bottom | NULLABLE | STRING |
| translations.seo_title | NULLABLE | STRING |
| translations.seo_description | NULLABLE | STRING |
| translations.seo_keywords | NULLABLE | STRING |
| translations.seo_url | NULLABLE | STRING |
| translations.permalink | NULLABLE | STRING |
| translations.active | NULLABLE | BOOLEAN |
| translations.isdefault | NULLABLE | BOOLEAN |
| translations.items | NULLABLE | INTEGER |
Schemat danych tabeli shoper_categories_tree
| Field Name | Mode | Type |
|---|---|---|
| parent_id | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| category_path | REPEATED | STRING |
Schemat danych tabeli shoper_currencies
| Field Name | Mode | Type |
|---|---|---|
| currency_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| order | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| rate_sync | NULLABLE | STRING |
| rate_date | NULLABLE | DATE |
| default | NULLABLE | BOOLEAN |
Schemat danych tabeli shoper_option_values
| Field Name | Mode | Type |
|---|---|---|
| ovalue_id | NULLABLE | STRING |
| option_id | NULLABLE | STRING |
| order | NULLABLE | STRING |
| total_products | NULLABLE | INTEGER |
| change_price_type | NULLABLE | STRING |
| change_price_value | NULLABLE | FLOAT |
| percent | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| translations.translation_id | NULLABLE | STRING |
| translations.ovalue_id | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| translations.value | NULLABLE | STRING |
Schemat danych tabeli shoper_order_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| order_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| type | NULLABLE | STRING |
| stock_id | NULLABLE | STRING |
| price | NULLABLE | FLOAT |
| discount_perc | NULLABLE | FLOAT |
| quantity | NULLABLE | INTEGER |
| delivery_time | NULLABLE | INTEGER |
| name | NULLABLE | STRING |
| code | NULLABLE | STRING |
| pkwiu | NULLABLE | STRING |
| tax | NULLABLE | STRING |
| tax_value | NULLABLE | FLOAT |
| unit | NULLABLE | STRING |
| option | NULLABLE | STRING |
| unit_fp | NULLABLE | BOOLEAN |
| weight | NULLABLE | FLOAT |
| loyalty | NULLABLE | RECORD |
| loyalty.exchanged | NULLABLE | BOOLEAN |
| loyalty.score | NULLABLE | INTEGER |
| loyalty.ratio | NULLABLE | STRING |
| delivery_time_hours | NULLABLE | FLOAT |
| children | REPEATED | RECORD |
| children.id | NULLABLE | STRING |
| children.order_id | NULLABLE | STRING |
| children.stock_id | NULLABLE | STRING |
| children.price | NULLABLE | FLOAT |
| children.discount_perc | NULLABLE | FLOAT |
| children.quantity | NULLABLE | INTEGER |
| children.delivery_time | NULLABLE | INTEGER |
| children.name | NULLABLE | STRING |
| children.code | NULLABLE | STRING |
| children.pkwiu | NULLABLE | STRING |
| children.tax | NULLABLE | STRING |
| children.tax_value | NULLABLE | FLOAT |
| children.unit | NULLABLE | STRING |
| children.option | NULLABLE | STRING |
| children.unit_fp | NULLABLE | BOOLEAN |
| children.weight | NULLABLE | FLOAT |
Schemat danych tabeli shoper_orders
| Field Name | Mode | Type |
|---|---|---|
| order_id | NULLABLE | STRING |
| user_id | NULLABLE | STRING |
| date | NULLABLE | TIMESTAMP |
| status_date | NULLABLE | TIMESTAMP |
| confirm_date | NULLABLE | TIMESTAMP |
| delivery_date | NULLABLE | TIMESTAMP |
| status_id | NULLABLE | STRING |
| sum | NULLABLE | FLOAT |
| payment_id | NULLABLE | STRING |
| user_order | NULLABLE | BOOLEAN |
| shipping_id | NULLABLE | STRING |
| shipping_cost | NULLABLE | FLOAT |
| NULLABLE | STRING | |
| code | NULLABLE | STRING |
| confirm | NULLABLE | BOOLEAN |
| notes | NULLABLE | STRING |
| notes_priv | NULLABLE | STRING |
| notes_pub | NULLABLE | STRING |
| currency_id | NULLABLE | STRING |
| currency_rate | NULLABLE | FLOAT |
| paid | NULLABLE | FLOAT |
| discount_client | NULLABLE | FLOAT |
| discount_group | NULLABLE | FLOAT |
| discount_levels | NULLABLE | FLOAT |
| discount_code | NULLABLE | FLOAT |
| code_id | NULLABLE | STRING |
| lang_id | NULLABLE | STRING |
| origin | NULLABLE | STRING |
| registered | NULLABLE | BOOLEAN |
| promo_code | NULLABLE | STRING |
| is_paid | NULLABLE | BOOLEAN |
| is_overpayment | NULLABLE | BOOLEAN |
| is_underpayment | NULLABLE | BOOLEAN |
| total_parcels | NULLABLE | INTEGER |
| total_products | NULLABLE | INTEGER |
| loyalty_cost | NULLABLE | INTEGER |
| loyalty_score | NULLABLE | INTEGER |
| shipping_tax_name | NULLABLE | STRING |
| shipping_tax_value | NULLABLE | FLOAT |
| shipping_tax_id | NULLABLE | STRING |
| delivery_address | NULLABLE | RECORD |
| delivery_address.address_id | NULLABLE | STRING |
| delivery_address.order_id | NULLABLE | STRING |
| delivery_address.type | NULLABLE | STRING |
| delivery_address.city | NULLABLE | STRING |
| delivery_address.postcode | NULLABLE | STRING |
| delivery_address.state | NULLABLE | STRING |
| delivery_address.country | NULLABLE | STRING |
| delivery_address.phone | NULLABLE | STRING |
| delivery_address.country_code | NULLABLE | STRING |
| delivery_address.tax_identification_number | NULLABLE | STRING |
| billing_address | NULLABLE | RECORD |
| billing_address.address_id | NULLABLE | STRING |
| billing_address.order_id | NULLABLE | STRING |
| billing_address.type | NULLABLE | STRING |
| billing_address.city | NULLABLE | STRING |
| billing_address.postcode | NULLABLE | STRING |
| billing_address.state | NULLABLE | STRING |
| billing_address.country | NULLABLE | STRING |
| billing_address.phone | NULLABLE | STRING |
| billing_address.country_code | NULLABLE | STRING |
| billing_address.tax_identification_number | NULLABLE | STRING |
Schemat danych tabeli shoper_payments
| Field Name | Mode | Type |
|---|---|---|
| payment_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| order | NULLABLE | STRING |
| install | NULLABLE | BOOLEAN |
| visible | NULLABLE | BOOLEAN |
| translations | REPEATED | RECORD |
| translations.language | NULLABLE | STRING |
| translations.translation_id | NULLABLE | STRING |
| translations.payment_id | NULLABLE | STRING |
| translations.title | NULLABLE | STRING |
| translations.description | NULLABLE | STRING |
| translations.vendor_description | NULLABLE | STRING |
| translations.active | NULLABLE | STRING |
| translations.notify | NULLABLE | STRING |
| translations.notify_mail | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| currencies | REPEATED | STRING |
Schemat danych tabeli shoper_producers
| Field Name | Mode | Type |
|---|---|---|
| producer_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| web | NULLABLE | STRING |
| gfx | NULLABLE | STRING |
| isdefault | NULLABLE | BOOLEAN |
| translations | REPEATED | RECORD |
| translations.language | NULLABLE | STRING |
| translations.translation_id | NULLABLE | STRING |
| translations.producer_id | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| translations.name | NULLABLE | STRING |
| translations.description | NULLABLE | STRING |
| translations.seo_title | NULLABLE | STRING |
| translations.seo_description | NULLABLE | STRING |
| translations.seo_keywords | NULLABLE | STRING |
| translations.seo_url | NULLABLE | STRING |
Schemat danych tabeli shoper_product_images
| Field Name | Mode | Type |
|---|---|---|
| gfx_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| main | NULLABLE | BOOLEAN |
| order | NULLABLE | STRING |
| unic_name | NULLABLE | STRING |
| hidden | NULLABLE | BOOLEAN |
| extension | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| translations.gfx_id | NULLABLE | STRING |
| translations.name | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
Schemat danych tabeli shoper_products
| Field Name | Mode | Type |
|---|---|---|
| product_id | NULLABLE | STRING |
| type | NULLABLE | STRING |
| producer_id | NULLABLE | STRING |
| group_id | NULLABLE | STRING |
| tax_id | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| unit_id | NULLABLE | STRING |
| add_date | NULLABLE | TIMESTAMP |
| edit_date | NULLABLE | TIMESTAMP |
| other_price | NULLABLE | FLOAT |
| promo_price | NULLABLE | FLOAT |
| code | NULLABLE | STRING |
| dimension_w | NULLABLE | FLOAT |
| dimension_h | NULLABLE | FLOAT |
| dimension_l | NULLABLE | FLOAT |
| ean | NULLABLE | STRING |
| pkwiu | NULLABLE | STRING |
| is_product_of_day | NULLABLE | BOOLEAN |
| loyalty_score | NULLABLE | INTEGER |
| loyalty_price | NULLABLE | INTEGER |
| in_loyalty | NULLABLE | BOOLEAN |
| bestseller | NULLABLE | BOOLEAN |
| newproduct | NULLABLE | BOOLEAN |
| vol_weight | NULLABLE | FLOAT |
| gauge_id | NULLABLE | STRING |
| currency_id | NULLABLE | STRING |
| additional_isbn | NULLABLE | STRING |
| additional_kgo | NULLABLE | STRING |
| additional_bloz7 | NULLABLE | STRING |
| additional_bloz12 | NULLABLE | STRING |
| additional_gtu | NULLABLE | STRING |
| additional_producer | NULLABLE | STRING |
| related | REPEATED | STRING |
| options | REPEATED | STRING |
| main_image | NULLABLE | RECORD |
| main_image.gfx_id | NULLABLE | STRING |
| main_image.order | NULLABLE | INTEGER |
| main_image.name | NULLABLE | STRING |
| main_image.unic_name | NULLABLE | STRING |
| main_image.hidden | NULLABLE | BOOLEAN |
| stock | NULLABLE | RECORD |
| stock.stock_id | NULLABLE | STRING |
| stock.product_id | NULLABLE | STRING |
| stock.extended | NULLABLE | BOOLEAN |
| stock.price | NULLABLE | FLOAT |
| stock.active | NULLABLE | BOOLEAN |
| stock.default | NULLABLE | BOOLEAN |
| stock.stock | NULLABLE | FLOAT |
| stock.warn_level | NULLABLE | FLOAT |
| stock.sold | NULLABLE | FLOAT |
| stock.code | NULLABLE | STRING |
| stock.ean | NULLABLE | STRING |
| stock.weight | NULLABLE | FLOAT |
| stock.weight_type | NULLABLE | STRING |
| stock.availability_id | NULLABLE | STRING |
| stock.delivery_id | NULLABLE | STRING |
| stock.gfx_id | NULLABLE | STRING |
| stock.package | NULLABLE | FLOAT |
| stock.price_wholesale | NULLABLE | FLOAT |
| stock.price_special | NULLABLE | FLOAT |
| stock.calculation_unit_id | NULLABLE | STRING |
| stock.calculation_unit_ratio | NULLABLE | FLOAT |
| categories | REPEATED | STRING |
| special_offer | NULLABLE | RECORD |
| special_offer.promo_id | NULLABLE | STRING |
| special_offer.date_from | NULLABLE | TIMESTAMP |
| special_offer.date_to | NULLABLE | TIMESTAMP |
| special_offer.discount | NULLABLE | FLOAT |
| special_offer.discount_wholesale | NULLABLE | FLOAT |
| special_offer.discount_special | NULLABLE | FLOAT |
| unit_price_calculation | NULLABLE | BOOLEAN |
| children | REPEATED | RECORD |
| children.id | NULLABLE | STRING |
| children.bundle_id | NULLABLE | STRING |
| children.stock_id | NULLABLE | STRING |
| children.product_id | NULLABLE | STRING |
| children.stock | NULLABLE | FLOAT |
| children.order | NULLABLE | INTEGER |
| translations | REPEATED | RECORD |
| translations.language | NULLABLE | STRING |
| translations.translation_id | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| translations.name | NULLABLE | STRING |
| translations.description | NULLABLE | STRING |
| translations.short_description | NULLABLE | STRING |
| translations.active | NULLABLE | BOOLEAN |
| translations.seo_title | NULLABLE | STRING |
| translations.seo_description | NULLABLE | STRING |
| translations.seo_keywords | NULLABLE | STRING |
| translations.seo_url | NULLABLE | STRING |
| translations.permalink | NULLABLE | STRING |
Schemat danych tabeli shoper_shippings
| Field Name | Mode | Type |
|---|---|---|
| shipping_id | NULLABLE | STRING |
| cost | NULLABLE | FLOAT |
| depend_on_w | NULLABLE | STRING |
| tax_id | NULLABLE | STRING |
| max_weight | NULLABLE | FLOAT |
| min_weight | NULLABLE | FLOAT |
| free_shipping | NULLABLE | FLOAT |
| order | NULLABLE | STRING |
| pkwiu | NULLABLE | STRING |
| max_cost | NULLABLE | FLOAT |
| visible | NULLABLE | BOOLEAN |
| mobile | NULLABLE | BOOLEAN |
| engine | NULLABLE | STRING |
| zone_id | NULLABLE | STRING |
| callback_url | NULLABLE | STRING |
| warehouse_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| url | NULLABLE | STRING |
| description | NULLABLE | STRING |
| vendor_description | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| is_default | NULLABLE | BOOLEAN |
| lang_id | NULLABLE | STRING |
| countries | REPEATED | STRING |
| ranges | REPEATED | RECORD |
| ranges.range_id | NULLABLE | STRING |
| ranges.from | NULLABLE | STRING |
| ranges.to | NULLABLE | STRING |
| ranges.price | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| translations.language | NULLABLE | STRING |
| translations.translation_id | NULLABLE | STRING |
| translations.shipping_id | NULLABLE | STRING |
| translations.name | NULLABLE | STRING |
| translations.url | NULLABLE | STRING |
| translations.description | NULLABLE | STRING |
| translations.vendor_description | NULLABLE | STRING |
| translations.active | NULLABLE | STRING |
| translations.is_default | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| payments | REPEATED | RECORD |
| payments.cost | NULLABLE | FLOAT |
| payments.percent | NULLABLE | STRING |
| payments.payment_id | NULLABLE | STRING |
Schemat danych tabeli shoper_statuses
| Field Name | Mode | Type |
|---|---|---|
| status_id | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| default | NULLABLE | BOOLEAN |
| color | NULLABLE | STRING |
| type | NULLABLE | STRING |
| order | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| translations.trans_id | NULLABLE | STRING |
| translations.status_id | NULLABLE | STRING |
| translations.name | NULLABLE | STRING |
| translations.lang_id | NULLABLE | STRING |
| translations.message | NULLABLE | STRING |
| translations.message_html | NULLABLE | STRING |
Schemat danych tabeli shoper_stock
| Field Name | Mode | Type |
|---|---|---|
| stock_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| extended | NULLABLE | BOOLEAN |
| price | NULLABLE | FLOAT |
| active | NULLABLE | BOOLEAN |
| default | NULLABLE | BOOLEAN |
| stock | NULLABLE | FLOAT |
| warn_level | NULLABLE | FLOAT |
| warehouses | REPEATED | RECORD |
| warehouses.id | NULLABLE | STRING |
| warehouses.stock | NULLABLE | FLOAT |
| sold | NULLABLE | FLOAT |
| code | NULLABLE | STRING |
| ean | NULLABLE | STRING |
| weight | NULLABLE | FLOAT |
| weight_type | NULLABLE | STRING |
| availability_id | NULLABLE | STRING |
| delivery_id | NULLABLE | STRING |
| gfx_id | NULLABLE | STRING |
| options | REPEATED | RECORD |
| options.option_id | NULLABLE | STRING |
| options.value_id | NULLABLE | STRING |
| package | NULLABLE | FLOAT |
| price_wholesale | NULLABLE | FLOAT |
| price_special | NULLABLE | FLOAT |
| price_type_special | NULLABLE | INTEGER |
| price_type_wholesale | NULLABLE | INTEGER |
| price_buying | NULLABLE | FLOAT |
| calculation_unit_id | NULLABLE | STRING |
| calculation_unit_ratio | NULLABLE | FLOAT |
Schemat danych tabeli shoper_taxes
| Field Name | Mode | Type |
|---|---|---|
| tax_id | NULLABLE | STRING |
| value | NULLABLE | INTEGER |
| name | NULLABLE | STRING |
| class | NULLABLE | STRING |
