Integracja PrestaShop z BigQuery
Dowiedz się, jak połączyć PrestaShop z Google BigQuery w WitCloud, aby pobierać zamówienia, klientów, produkty, stany magazynowe i inne dane sklepu do analizy.
Aktualizacja
Wprowadzenie
Ten moduł łączy Twój sklep PrestaShop z Google Cloud BigQuery. WitCloud odczytuje zamówienia, pozycje zamówień, klientów, adresy, produkty, kombinacje, stany magazynowe, kategorie, producentów, waluty, reguły koszyka i inne dane sklepu przez web service (API) PrestaShop i zapisuje je w datasecie BigQuery Twojego projektu. Dzięki temu możesz analizować sprzedaż i stany magazynowe razem z danymi reklamowymi oraz używać tych tabel w rozwiązaniu All in One.
Konfiguracja
Wykonaj poniższe kroki, aby połączyć PrestaShop z BigQuery. WitCloud potrzebuje adresu Twojego sklepu i klucza web service PrestaShop, który ma prawo odczytu Twoich danych.
Utwórz klucz web service przed rozpoczęciem: wkleisz go w WitCloud w kroku Autoryzacja. Wystarczy dostęp tylko do odczytu, ponieważ WitCloud tylko odczytuje dane ze sklepu.
Utwórz klucz web service w PrestaShop
Ten krok wykonujesz w panelu administracyjnym PrestaShop, który nie jest częścią WitCloud. Nazwy menu poniżej pochodzą z PrestaShop i mogą się różnić w zależności od jego wersji i języka. Jeśli nie możesz ich znaleźć, zajrzyj do dokumentacji PrestaShop.
- Zaloguj się do panelu administracyjnego PrestaShop jako administrator.
- Przejdź do Advanced Parameters > Webservice i upewnij się, że web service jest włączony.
- Kliknij Add new webservice key i wygeneruj klucz.
- Nadaj kluczowi dostęp do odczytu (View, metoda GET) do zasobów, które chcesz pobierać, np. zamówień, klientów, produktów i stanów magazynowych.
- Zapisz klucz i skopiuj go. Zachowaj go w tajemnicy: każdy, kto go ma, może odczytać dane, do których klucz daje dostęp.
Konfiguracja modułu
Przejdź do Integracje i kliknij Dodaj integrację.

Wybierz PrestaShop z listy dostępnych integracji.

Wpisz Nazwa źródła danych, np. „PrestaShop 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://your-shop.com. Przycisk Autoryzuj jest nieaktywny, dopóki nie wpiszesz poprawnego adresu.

Autoryzacja
Jeśli ten sklep PrestaShop został już autoryzowany w WitCloud, wybierz istniejący token z listy Autoryzacja Prestashop i pomiń dwa kolejne kroki.
Kliknij Autoryzuj.

W oknie Autoryzuj wklej klucz web service w pole Token dostępu i kliknij Utwórz. WitCloud sprawdza klucz pod wpisanym adresem sklepu. Jeśli sklep jest nieosiągalny, adres lub klucz jest błędny albo klucz nie ma uprawnień do odczytu danych, powód pojawi się pod formularzem.

Zapisany token zostanie wybrany automatycznie. Na liście widnieje jako adres sklepu i zamaskowany fragment klucza. Token możesz też wybrać z listy Autoryzacja Prestashop.

Ustawienia zaawansowane
Kliknij Pokaż ustawienia zaawansowane, aby zobaczyć trzy kolejne pola.
W polu Odświeżanie danych (produkty, stany magazynowe) wpisz, co ile godzin mają być odświeżane tabele przechowujące cały katalog (takie jak produkty i stany magazynowe). 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 przyjmuje zapytania tylko z dozwolonych adresów IP, np. za zaporą sieciową lub Cloudflare. Wszystkie zapytania o dane wychodzą wtedy 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. Domyślnie zaznaczone są wszystkie 18 tabel opisanych w schemacie danych poniżej, a co najmniej jedna musi pozostać zaznaczona. Pobieranie mniejszej liczby tabel przyspiesza pobieranie danych.

Tabele customers i addresses zawierają dane osobowe Twoich klientów, takie jak imiona i nazwiska, adresy e-mail, adresy pocztowe i numery telefonów. Usuń je z pola Tabele do pobrania, jeśli ich nie potrzebujesz.
Kliknij Dalej.

Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni do pobrania przy pierwszym uruchomieniu, maksymalnie 365.

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

Gotowe! Dane z PrestaShop będą teraz synchronizowane z BigQuery. Zamówienia, pozycje zamówień, reguły koszyka w zamówieniach, klienci i adresy dostawy zamówień są pobierane dzień po dniu, według daty ich utworzenia. Pozostałe tabele (produkty, kombinacje, stany magazynowe, kategorie, producenci, kraje, waluty, statusy zamówień, opcje produktów, adresy sklepu i reguły koszyka) są pobierane w całości przy każdym uruchomieniu.
Schemat danych
Poniższe tabele pokazują dane pobierane z PrestaShop. Ich nazwy w BigQuery mają postać prestashop_<tabela>_<ID konektora>, na przykład prestashop_orders_<ID konektora>.
Schemat danych tabeli prestashop_addresses
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_customer | NULLABLE | STRING |
| id_manufacturer | NULLABLE | STRING |
| id_supplier | NULLABLE | STRING |
| id_warehouse | NULLABLE | STRING |
| id_country | NULLABLE | STRING |
| id_state | NULLABLE | STRING |
| alias | NULLABLE | STRING |
| company | NULLABLE | STRING |
| lastname | NULLABLE | STRING |
| firstname | NULLABLE | STRING |
| vat_number | NULLABLE | STRING |
| address1 | NULLABLE | STRING |
| address2 | NULLABLE | STRING |
| postcode | NULLABLE | STRING |
| city | NULLABLE | STRING |
| other | NULLABLE | STRING |
| phone | NULLABLE | STRING |
| phone_mobile | NULLABLE | STRING |
| dni | NULLABLE | STRING |
| deleted | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
Schemat danych tabeli prestashop_cart_rules
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | JSON |
| description | NULLABLE | STRING |
| code | NULLABLE | STRING |
| quantity | NULLABLE | STRING |
| quantity_per_user | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| date_from | NULLABLE | DATETIME |
| date_to | NULLABLE | DATETIME |
| priority | NULLABLE | STRING |
| partial_use | NULLABLE | BOOLEAN |
| minimum_amount | NULLABLE | FLOAT |
| minimum_amount_tax | NULLABLE | BOOLEAN |
| minimum_amount_currency | NULLABLE | STRING |
| minimum_amount_shipping | NULLABLE | BOOLEAN |
| country_restriction | NULLABLE | BOOLEAN |
| carrier_restriction | NULLABLE | BOOLEAN |
| group_restriction | NULLABLE | BOOLEAN |
| cart_rule_restriction | NULLABLE | BOOLEAN |
| product_restriction | NULLABLE | BOOLEAN |
| shop_restriction | NULLABLE | BOOLEAN |
| free_shipping | NULLABLE | BOOLEAN |
| reduction_percent | NULLABLE | FLOAT |
| reduction_amount | NULLABLE | FLOAT |
| reduction_tax | NULLABLE | BOOLEAN |
| reduction_currency | NULLABLE | STRING |
| reduction_product | NULLABLE | STRING |
| reduction_exclude_special | NULLABLE | BOOLEAN |
| gift_product | NULLABLE | STRING |
| gift_product_attribute | NULLABLE | STRING |
| highlight | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
Schemat danych tabeli prestashop_categories
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_parent | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| id_shop_default | NULLABLE | STRING |
| is_root_category | NULLABLE | BOOLEAN |
| position | NULLABLE | STRING |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| name | NULLABLE | JSON |
| link_rewrite | NULLABLE | JSON |
| description | NULLABLE | JSON |
| meta_title | NULLABLE | JSON |
| meta_description | NULLABLE | JSON |
| meta_keywords | NULLABLE | JSON |
| associations | NULLABLE | RECORD |
| associations.categories | REPEATED | RECORD |
| associations.categories.id | NULLABLE | STRING |
| associations.products | REPEATED | RECORD |
| associations.products.id | NULLABLE | STRING |
Schemat danych tabeli prestashop_combinations
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_product | NULLABLE | STRING |
| location | NULLABLE | STRING |
| ean13 | NULLABLE | STRING |
| isbn | NULLABLE | STRING |
| upc | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| quantity | NULLABLE | INTEGER |
| reference | NULLABLE | STRING |
| supplier_reference | NULLABLE | STRING |
| wholesale_price | NULLABLE | FLOAT |
| price | NULLABLE | FLOAT |
| ecotax | NULLABLE | FLOAT |
| weight | NULLABLE | FLOAT |
| unit_price_impact | NULLABLE | FLOAT |
| minimal_quantity | NULLABLE | INTEGER |
| low_stock_threshold | NULLABLE | INTEGER |
| low_stock_alert | NULLABLE | BOOLEAN |
| default_on | NULLABLE | BOOLEAN |
| available_date | NULLABLE | STRING |
| associations | NULLABLE | RECORD |
| associations.product_option_values | REPEATED | RECORD |
| associations.product_option_values.id | NULLABLE | STRING |
| associations.images | REPEATED | RECORD |
| associations.images.id | NULLABLE | STRING |
Schemat danych tabeli prestashop_countries
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_zone | NULLABLE | STRING |
| id_currency | NULLABLE | STRING |
| call_prefix | NULLABLE | STRING |
| iso_code | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| contains_states | NULLABLE | BOOLEAN |
| need_identification_number | NULLABLE | BOOLEAN |
| need_zip_code | NULLABLE | BOOLEAN |
| zip_code_format | NULLABLE | STRING |
| display_tax_label | NULLABLE | BOOLEAN |
| name | NULLABLE | JSON |
Schemat danych tabeli prestashop_currencies
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| names | NULLABLE | JSON |
| name | NULLABLE | STRING |
| symbol | NULLABLE | JSON |
| iso_code | NULLABLE | STRING |
| numeric_iso_code | NULLABLE | STRING |
| precision | NULLABLE | FLOAT |
| conversion_rate | NULLABLE | FLOAT |
| deleted | NULLABLE | BOOLEAN |
| active | NULLABLE | BOOLEAN |
| unofficial | NULLABLE | STRING |
| modified | NULLABLE | BOOLEAN |
| pattern | NULLABLE | JSON |
Schemat danych tabeli prestashop_customers
| Field Name | Mode | Type |
|---|---|---|
| id | REQUIRED | STRING |
| id_default_group | NULLABLE | STRING |
| id_lang | NULLABLE | STRING |
| newsletter_date_add | NULLABLE | STRING |
| ip_registration_newsletter | NULLABLE | STRING |
| secure_key | NULLABLE | STRING |
| deleted | NULLABLE | BOOLEAN |
| lastname | NULLABLE | STRING |
| firstname | NULLABLE | STRING |
| NULLABLE | STRING | |
| id_gender | NULLABLE | STRING |
| birthday | NULLABLE | STRING |
| newsletter | NULLABLE | BOOLEAN |
| optin | NULLABLE | BOOLEAN |
| website | NULLABLE | STRING |
| company | NULLABLE | STRING |
| siret | NULLABLE | STRING |
| ape | NULLABLE | STRING |
| outstanding_allow_amount | NULLABLE | FLOAT |
| show_public_prices | NULLABLE | BOOLEAN |
| id_risk | NULLABLE | STRING |
| max_payment_days | NULLABLE | INTEGER |
| active | NULLABLE | BOOLEAN |
| note | NULLABLE | STRING |
| is_guest | NULLABLE | BOOLEAN |
| id_shop | NULLABLE | STRING |
| id_shop_group | NULLABLE | STRING |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| associations | NULLABLE | RECORD |
| associations.groups | REPEATED | RECORD |
| associations.groups.id | NULLABLE | STRING |
Schemat danych tabeli prestashop_manufacturers
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | INTEGER |
| active | NULLABLE | BOOLEAN |
| link_rewrite | NULLABLE | STRING |
| name | NULLABLE | STRING |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| description | NULLABLE | JSON |
| short_description | NULLABLE | JSON |
| meta_title | NULLABLE | JSON |
| meta_description | NULLABLE | JSON |
| meta_keywords | NULLABLE | JSON |
Schemat danych tabeli prestashop_order_cart_rules
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_order | NULLABLE | STRING |
| id_cart_rule | NULLABLE | STRING |
| id_order_invoice | NULLABLE | STRING |
| name | NULLABLE | STRING |
| value | NULLABLE | FLOAT |
| value_tax_excl | NULLABLE | FLOAT |
| free_shipping | NULLABLE | BOOLEAN |
Schemat danych tabeli prestashop_order_details
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_order | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| product_attribute_id | NULLABLE | STRING |
| product_quantity_reinjected | NULLABLE | STRING |
| group_reduction | NULLABLE | FLOAT |
| discount_quantity_applied | NULLABLE | STRING |
| download_hash | NULLABLE | STRING |
| download_deadline | NULLABLE | STRING |
| id_order_invoice | NULLABLE | STRING |
| id_warehouse | NULLABLE | STRING |
| id_shop | NULLABLE | STRING |
| id_customization | NULLABLE | STRING |
| product_name | NULLABLE | STRING |
| product_quantity | NULLABLE | STRING |
| product_quantity_in_stock | NULLABLE | STRING |
| product_quantity_return | NULLABLE | STRING |
| product_quantity_refunded | NULLABLE | STRING |
| product_price | NULLABLE | FLOAT |
| reduction_percent | NULLABLE | FLOAT |
| reduction_amount | NULLABLE | FLOAT |
| reduction_amount_tax_incl | NULLABLE | FLOAT |
| reduction_amount_tax_excl | NULLABLE | FLOAT |
| product_quantity_discount | NULLABLE | FLOAT |
| product_ean13 | NULLABLE | STRING |
| product_isbn | NULLABLE | STRING |
| product_upc | NULLABLE | STRING |
| product_mpn | NULLABLE | STRING |
| product_reference | NULLABLE | STRING |
| product_supplier_reference | NULLABLE | STRING |
| product_weight | NULLABLE | FLOAT |
| tax_computation_method | NULLABLE | STRING |
| id_tax_rules_group | NULLABLE | STRING |
| ecotax | NULLABLE | FLOAT |
| ecotax_tax_rate | NULLABLE | FLOAT |
| download_nb | NULLABLE | STRING |
| unit_price_tax_incl | NULLABLE | FLOAT |
| unit_price_tax_excl | NULLABLE | FLOAT |
| total_price_tax_incl | NULLABLE | FLOAT |
| total_price_tax_excl | NULLABLE | FLOAT |
| total_shipping_price_tax_excl | NULLABLE | FLOAT |
| total_shipping_price_tax_incl | NULLABLE | FLOAT |
| purchase_supplier_price | NULLABLE | FLOAT |
| original_product_price | NULLABLE | FLOAT |
| original_wholesale_price | NULLABLE | FLOAT |
| total_refunded_tax_excl | NULLABLE | FLOAT |
| total_refunded_tax_incl | NULLABLE | FLOAT |
| associations | NULLABLE | RECORD |
| associations.taxes | REPEATED | RECORD |
| associations.taxes.id | NULLABLE | STRING |
Schemat danych tabeli prestashop_order_states
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| unremovable | NULLABLE | STRING |
| delivery | NULLABLE | STRING |
| hidden | NULLABLE | BOOLEAN |
| send_email | NULLABLE | BOOLEAN |
| module_name | NULLABLE | STRING |
| invoice | NULLABLE | BOOLEAN |
| color | NULLABLE | STRING |
| logable | NULLABLE | BOOLEAN |
| shipped | NULLABLE | BOOLEAN |
| paid | NULLABLE | BOOLEAN |
| pdf_delivery | NULLABLE | BOOLEAN |
| pdf_invoice | NULLABLE | BOOLEAN |
| deleted | NULLABLE | BOOLEAN |
| name | NULLABLE | JSON |
| template | NULLABLE | JSON |
Schemat danych tabeli prestashop_orders
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_address_delivery | NULLABLE | STRING |
| id_address_invoice | NULLABLE | STRING |
| id_cart | NULLABLE | STRING |
| id_currency | NULLABLE | STRING |
| id_lang | NULLABLE | STRING |
| id_customer | NULLABLE | STRING |
| id_carrier | NULLABLE | STRING |
| current_state | NULLABLE | STRING |
| module | NULLABLE | STRING |
| invoice_number | NULLABLE | STRING |
| invoice_date | NULLABLE | STRING |
| delivery_number | NULLABLE | STRING |
| delivery_date | NULLABLE | STRING |
| valid | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| shipping_number | NULLABLE | STRING |
| note | NULLABLE | STRING |
| id_shop_group | NULLABLE | STRING |
| id_shop | NULLABLE | STRING |
| secure_key | NULLABLE | STRING |
| payment | NULLABLE | STRING |
| recyclable | NULLABLE | BOOLEAN |
| gift | NULLABLE | BOOLEAN |
| gift_message | NULLABLE | STRING |
| mobile_theme | NULLABLE | BOOLEAN |
| total_discounts | NULLABLE | FLOAT |
| total_discounts_tax_incl | NULLABLE | FLOAT |
| total_discounts_tax_excl | NULLABLE | FLOAT |
| total_paid | NULLABLE | FLOAT |
| total_paid_tax_incl | NULLABLE | FLOAT |
| total_paid_tax_excl | NULLABLE | FLOAT |
| total_paid_real | NULLABLE | FLOAT |
| total_products | NULLABLE | FLOAT |
| total_products_wt | NULLABLE | FLOAT |
| total_shipping | NULLABLE | FLOAT |
| total_shipping_tax_incl | NULLABLE | FLOAT |
| total_shipping_tax_excl | NULLABLE | FLOAT |
| carrier_tax_rate | NULLABLE | FLOAT |
| total_wrapping | NULLABLE | FLOAT |
| total_wrapping_tax_incl | NULLABLE | FLOAT |
| total_wrapping_tax_excl | NULLABLE | FLOAT |
| round_mode | NULLABLE | STRING |
| round_type | NULLABLE | STRING |
| conversion_rate | NULLABLE | FLOAT |
| reference | NULLABLE | STRING |
| associations | NULLABLE | RECORD |
| associations.order_rows | REPEATED | RECORD |
| associations.order_rows.id | NULLABLE | STRING |
| associations.order_rows.product_id | NULLABLE | STRING |
| associations.order_rows.product_attribute_id | NULLABLE | STRING |
| associations.order_rows.product_quantity | NULLABLE | STRING |
| associations.order_rows.product_name | NULLABLE | STRING |
| associations.order_rows.product_reference | NULLABLE | STRING |
| associations.order_rows.product_ean13 | NULLABLE | STRING |
| associations.order_rows.product_isbn | NULLABLE | STRING |
| associations.order_rows.product_upc | NULLABLE | STRING |
| associations.order_rows.product_price | NULLABLE | STRING |
| associations.order_rows.id_customization | NULLABLE | STRING |
| associations.order_rows.unit_price_tax_incl | NULLABLE | STRING |
| associations.order_rows.unit_price_tax_excl | NULLABLE | STRING |
Schemat danych tabeli prestashop_product_option_values
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_attribute_group | NULLABLE | STRING |
| color | NULLABLE | STRING |
| position | NULLABLE | STRING |
| name | NULLABLE | JSON |
Schemat danych tabeli prestashop_product_options
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| is_color_group | NULLABLE | BOOLEAN |
| group_type | NULLABLE | STRING |
| position | NULLABLE | STRING |
| name | NULLABLE | JSON |
| public_name | NULLABLE | JSON |
| associations | NULLABLE | RECORD |
| associations.product_option_values | REPEATED | RECORD |
| associations.product_option_values.id | NULLABLE | STRING |
Schemat danych tabeli prestashop_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_manufacturer | NULLABLE | STRING |
| id_supplier | NULLABLE | STRING |
| id_category_default | NULLABLE | STRING |
| new | NULLABLE | STRING |
| cache_default_attribute | NULLABLE | STRING |
| id_default_image | NULLABLE | STRING |
| id_default_combination | NULLABLE | STRING |
| id_tax_rules_group | NULLABLE | STRING |
| position_in_category | NULLABLE | STRING |
| type | NULLABLE | STRING |
| id_shop_default | NULLABLE | STRING |
| reference | NULLABLE | STRING |
| supplier_reference | NULLABLE | STRING |
| location | NULLABLE | STRING |
| width | NULLABLE | FLOAT |
| height | NULLABLE | FLOAT |
| depth | NULLABLE | FLOAT |
| weight | NULLABLE | FLOAT |
| quantity_discount | NULLABLE | BOOLEAN |
| ean13 | NULLABLE | STRING |
| isbn | NULLABLE | STRING |
| upc | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| cache_is_pack | NULLABLE | BOOLEAN |
| cache_has_attachments | NULLABLE | BOOLEAN |
| is_virtual | NULLABLE | BOOLEAN |
| state | NULLABLE | STRING |
| additional_delivery_times | NULLABLE | STRING |
| delivery_in_stock | NULLABLE | JSON |
| delivery_out_stock | NULLABLE | JSON |
| product_type | NULLABLE | STRING |
| on_sale | NULLABLE | BOOLEAN |
| online_only | NULLABLE | BOOLEAN |
| ecotax | NULLABLE | FLOAT |
| minimal_quantity | NULLABLE | INTEGER |
| low_stock_threshold | NULLABLE | STRING |
| low_stock_alert | NULLABLE | BOOLEAN |
| price | NULLABLE | FLOAT |
| wholesale_price | NULLABLE | FLOAT |
| unity | NULLABLE | STRING |
| unit_price_ratio | NULLABLE | STRING |
| additional_shipping_cost | NULLABLE | FLOAT |
| customizable | NULLABLE | STRING |
| text_fields | NULLABLE | STRING |
| uploadable_files | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| redirect_type | NULLABLE | STRING |
| id_type_redirected | NULLABLE | STRING |
| available_for_order | NULLABLE | STRING |
| available_date | NULLABLE | STRING |
| show_condition | NULLABLE | BOOLEAN |
| condition | NULLABLE | STRING |
| show_price | NULLABLE | BOOLEAN |
| indexed | NULLABLE | BOOLEAN |
| visibility | NULLABLE | STRING |
| advanced_stock_management | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| pack_stock_type | NULLABLE | STRING |
| meta_description | NULLABLE | JSON |
| meta_keywords | NULLABLE | JSON |
| meta_title | NULLABLE | JSON |
| link_rewrite | NULLABLE | JSON |
| name | NULLABLE | JSON |
| description | NULLABLE | JSON |
| description_short | NULLABLE | JSON |
| available_now | NULLABLE | JSON |
| available_later | NULLABLE | JSON |
| associations | NULLABLE | RECORD |
| associations.categories | REPEATED | RECORD |
| associations.categories.id | NULLABLE | STRING |
| associations.images | REPEATED | RECORD |
| associations.images.id | NULLABLE | STRING |
| associations.combinations | REPEATED | RECORD |
| associations.combinations.id | NULLABLE | STRING |
| associations.product_option_values | REPEATED | RECORD |
| associations.product_option_values.id | NULLABLE | STRING |
| associations.product_features | REPEATED | RECORD |
| associations.product_features.id | NULLABLE | STRING |
| associations.product_features.id_feature_value | NULLABLE | STRING |
| associations.tags | REPEATED | RECORD |
| associations.tags.id | NULLABLE | STRING |
| associations.stock_availables | REPEATED | RECORD |
| associations.stock_availables.id | NULLABLE | STRING |
| associations.stock_availables.id_product_attribute | NULLABLE | STRING |
| associations.attachments | REPEATED | RECORD |
| associations.attachments.id | NULLABLE | STRING |
| associations.accessories | REPEATED | RECORD |
| associations.accessories.id | NULLABLE | STRING |
| associations.product_bundle | REPEATED | RECORD |
| associations.product_bundle.id | NULLABLE | STRING |
| associations.product_bundle.id_product_attribute | NULLABLE | STRING |
| associations.product_bundle.quantity | NULLABLE | INTEGER |
Schemat danych tabeli prestashop_shop_urls
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_shop | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| main | NULLABLE | BOOLEAN |
| domain | NULLABLE | STRING |
| domain_ssl | NULLABLE | STRING |
| physical_uri | NULLABLE | STRING |
| virtual_uri | NULLABLE | STRING |
Schemat danych tabeli prestashop_stock_availables
| Field Name | Mode | Type |
|---|---|---|
| id | REQUIRED | STRING |
| id_product | REQUIRED | STRING |
| id_product_attribute | NULLABLE | STRING |
| id_shop | REQUIRED | STRING |
| id_shop_group | REQUIRED | STRING |
| quantity | NULLABLE | INTEGER |
| depends_on_stock | NULLABLE | BOOLEAN |
| out_of_stock | NULLABLE | INTEGER |
| location | NULLABLE | STRING |
Schemat danych tabeli prestashop_stocks
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_warehouse | NULLABLE | STRING |
| id_product | NULLABLE | STRING |
| id_product_attribute | NULLABLE | STRING |
| reference | NULLABLE | STRING |
| ean13 | NULLABLE | STRING |
| isbn | NULLABLE | STRING |
| upc | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| physical_quantity | NULLABLE | INTEGER |
| usable_quantity | NULLABLE | INTEGER |
| price_te | NULLABLE | FLOAT |
