Integracja Magento z BigQuery

Połącz sklep Magento z BigQuery w WitCloud - zamówienia, produkty, atrybuty produktów, niskie stany magazynowe, kategorie, stawki podatkowe, waluty i ustawienia sklepu pobierane przez API REST Magento.

Aktualizacja

Wprowadzenie

Ta integracja pobiera dane Twojego sklepu Magento przez jego API REST i zapisuje je w Google Cloud BigQuery. Dostajesz zamówienia wraz z pozycjami, płatnościami i historią statusów, katalog produktów z atrybutami produktów i produktami o niskim stanie magazynowym, kategorie, stawki podatkowe, waluty i ustawienia sklepu. Dzięki temu możesz analizować sprzedaż i asortyment razem z danymi marketingowymi.

Konfiguracja

Wykonaj poniższe kroki, aby połączyć Magento z BigQuery. Po zakończeniu konfiguracji dane Twojego sklepu będą automatycznie trafiać do Twojego projektu BigQuery.

Potrzebujesz tokenu dostępu ze swojego sklepu Magento. Tworzysz go w panelu administracyjnym Magento (to interfejs Magento, nie WitCloud) i musi mieć uprawnienia do odczytu danych, które chcesz pobierać: zamówień, produktów, kategorii, stawek podatkowych, walut i stanów magazynowych. Potrzebujesz też adresu swojego sklepu, na przykład https://shop.example.com.

Konfiguracja modułu

Wejdź w menu do Integracje i kliknij Dodaj integrację.

Lista integracji z przyciskiem Dodaj integrację

Wybierz Magento z listy dostępnych integracji.

Katalog integracji zawężony do Magento

Wpisz Nazwę źródła danych, na przykład „Magento PL". Dobra nazwa pomoże Ci później rozpoznać źródło danych.

Pole Nazwa źródła danych wypełnione przykładową nazwą Magento PL

Wpisz Adres URL sklepu. Musi to być pełny adres zaczynający się od https:// lub http://. Dane Magento pobierane są osobno dla każdego sklepu, więc dla każdego sklepu dodaj osobną integrację.

Pole Adres URL sklepu wypełnione przykładowym adresem https://demo-shop.example

Autoryzacja

Jeśli token dostępu dla tego sklepu został już dodany, wybierz go z listy Autoryzacja Magento i pomiń resztę tego kroku.

Kliknij Autoryzuj. Przycisk jest nieaktywny, dopóki w polu Adres URL sklepu nie ma poprawnego adresu.

Przycisk Autoryzuj obok pola Autoryzacja Magento, aktywny po wpisaniu adresu sklepu

W oknie Autoryzuj wklej Token dostępu ze swojego sklepu Magento i kliknij Utwórz. Token jest ukryty podczas wpisywania; ikona oka pozwala go sprawdzić. Token mogą dodawać tylko osoby z rolą Edytor lub wyższą.

Okno Autoryzuj z polem Token dostępu wypełnionym przykładową wartością

Wybierz token z listy Autoryzacja Magento. Każdy token jest widoczny pod adresem sklepu i początkiem tokenu, dzięki czemu odróżnisz tokeny różnych sklepów.

Otwarta lista Autoryzacja Magento z jednym przykładowym tokenem

Ustawienia zaawansowane

Kliknij Pokaż ustawienia zaawansowane, aby je rozwinąć.

W polu Odświeżanie danych (produkty, stany magazynowe) ustaw, co ile godzin odświeżane są tabele produktów i niskich stanów magazynowych. Te tabele zawierają cały katalog, więc nie są pobierane przy każdym uruchomieniu: uruchomienie pomija je, jeśli od ich ostatniej aktualizacji minęło mniej godzin niż ta wartość. Wartość mieści się między 4 a 12 godzin; domyślnie jest to 4.

Otwarte ustawienia zaawansowane z polem Odświeżanie danych (produkty, stany magazynowe) ustawionym na 4 godziny

Jeśli Twój sklep jest chroniony, na przykład przez Cloudflare lub zaporę sieciową, włącz Stały adres IP. Wszystkie zapytania są wtedy wysyłane z tego samego adresu, widocznego obok przełącznika (34.118.32.227), który możesz dodać do listy dozwolonych adresów.

Przełącznik Stały adres IP w ustawieniach zaawansowanych

W polu Tabele do pobrania wybierz, które tabele mają być pobierane. Domyślnie zaznaczonych jest wszystkie osiem tabel, a co najmniej jedna musi pozostać zaznaczona. Im mniej tabel, tym szybsze uruchomienie.

Pole Tabele do pobrania z wybranymi wszystkimi ośmioma oferowanymi tabelami

Kliknij Dalej.

Wypełnione ustawienia źródła danych z przyciskiem Dalej

Dane historyczne i harmonogram

W polu Dane historyczne wpisz liczbę dni zamówień do pobrania wstecz od dziś, maksymalnie 365.

Pole Dane historyczne wypełnione wartością 365 dni

Zamówienia są pobierane dzień po dniu, według daty utworzenia zamówienia. Pozostałe tabele (produkty, atrybuty produktów, niskie stany magazynowe, kategorie, stawki podatkowe, waluty, ustawienia sklepu) to zdjęcie bieżącego stanu Twojego sklepu, robione przy każdym uruchomieniu.

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.

Kliknij Utwórz, aby zakończyć konfigurację.

Ustawienia pobierania danych z przyciskiem Utwórz

Gotowe! Dane z Magento będą teraz synchronizowane z BigQuery zgodnie z utworzonym harmonogramem.

Schemat danych

Poniższe tabele powstają w Twoim datasecie BigQuery, osobny zestaw dla każdej integracji Magento. Tabela zamówień zawiera dane osobowe, które Magento zwraca razem z zamówieniem, takie jak adres e-mail, imię i nazwisko, numer telefonu oraz adresy rozliczeniowy i dostawy klienta, więc nadawaj do niej dostęp rozważnie.

Schemat danych tabeli magento_orders
Field NameModeType
applied_rule_idsNULLABLESTRING
base_currency_codeNULLABLESTRING
base_discount_amountNULLABLEFLOAT
base_discount_invoicedNULLABLEFLOAT
base_grand_totalNULLABLEFLOAT
base_discount_tax_compensation_amountNULLABLEFLOAT
base_discount_tax_compensation_invoicedNULLABLEFLOAT
base_shipping_amountNULLABLEFLOAT
base_shipping_discount_amountNULLABLEFLOAT
base_shipping_discount_tax_compensation_amntNULLABLEFLOAT
base_shipping_incl_taxNULLABLEFLOAT
base_shipping_invoicedNULLABLEFLOAT
base_shipping_tax_amountNULLABLEFLOAT
base_subtotalNULLABLEFLOAT
base_subtotal_incl_taxNULLABLEFLOAT
base_subtotal_invoicedNULLABLEFLOAT
base_tax_amountNULLABLEFLOAT
base_tax_invoicedNULLABLEFLOAT
base_total_dueNULLABLEFLOAT
base_total_invoicedNULLABLEFLOAT
base_total_invoiced_costNULLABLEFLOAT
base_total_paidNULLABLEFLOAT
base_to_global_rateNULLABLEFLOAT
base_to_order_rateNULLABLEFLOAT
billing_address_idNULLABLEFLOAT
coupon_codeNULLABLESTRING
created_atNULLABLETIMESTAMP
customer_emailNULLABLESTRING
customer_firstnameNULLABLESTRING
customer_group_idNULLABLEINTEGER
customer_idNULLABLEINTEGER
customer_is_guestNULLABLEINTEGER
customer_lastnameNULLABLESTRING
customer_note_notifyNULLABLEINTEGER
discount_amountNULLABLEFLOAT
discount_descriptionNULLABLESTRING
discount_invoicedNULLABLEFLOAT
email_sentNULLABLEINTEGER
entity_idNULLABLEINTEGER
global_currency_codeNULLABLESTRING
grand_totalNULLABLEFLOAT
discount_tax_compensation_amountNULLABLEFLOAT
discount_tax_compensation_invoicedNULLABLEFLOAT
increment_idNULLABLESTRING
is_virtualNULLABLEINTEGER
order_currency_codeNULLABLESTRING
protect_codeNULLABLESTRING
quote_idNULLABLEINTEGER
remote_ipNULLABLESTRING
shipping_amountNULLABLEFLOAT
shipping_descriptionNULLABLESTRING
shipping_discount_amountNULLABLEFLOAT
shipping_discount_tax_compensation_amountNULLABLEFLOAT
shipping_incl_taxNULLABLEFLOAT
shipping_invoicedNULLABLEFLOAT
shipping_tax_amountNULLABLEFLOAT
stateNULLABLESTRING
statusNULLABLESTRING
store_currency_codeNULLABLESTRING
store_idNULLABLEINTEGER
store_nameNULLABLESTRING
store_to_base_rateNULLABLEFLOAT
store_to_order_rateNULLABLEFLOAT
subtotalNULLABLEFLOAT
subtotal_incl_taxNULLABLEFLOAT
subtotal_invoicedNULLABLEFLOAT
tax_amountNULLABLEFLOAT
tax_invoicedNULLABLEFLOAT
total_dueNULLABLEFLOAT
total_invoicedNULLABLEFLOAT
total_item_countNULLABLEINTEGER
total_paidNULLABLEFLOAT
total_qty_orderedNULLABLEINTEGER
updated_atNULLABLETIMESTAMP
weightNULLABLEFLOAT
x_forwarded_forNULLABLESTRING
itemsREPEATEDRECORD
items.amount_refundedNULLABLEFLOAT
items.applied_rule_idsNULLABLESTRING
items.base_amount_refundedNULLABLEFLOAT
items.base_discount_amountNULLABLEFLOAT
items.base_discount_invoicedNULLABLEFLOAT
items.base_discount_tax_compensation_amountNULLABLEFLOAT
items.base_discount_tax_compensation_invoicedNULLABLEFLOAT
items.base_original_priceNULLABLEFLOAT
items.base_priceNULLABLEFLOAT
items.base_price_incl_taxNULLABLEFLOAT
items.base_row_invoicedNULLABLEFLOAT
items.base_row_totalNULLABLEFLOAT
items.base_row_total_incl_taxNULLABLEFLOAT
items.base_tax_amountNULLABLEFLOAT
items.base_tax_invoicedNULLABLEFLOAT
items.created_atNULLABLETIMESTAMP
items.discount_amountNULLABLEFLOAT
items.discount_invoicedNULLABLEFLOAT
items.discount_percentNULLABLEINTEGER
items.free_shippingNULLABLEINTEGER
items.discount_tax_compensation_amountNULLABLEFLOAT
items.discount_tax_compensation_invoicedNULLABLEFLOAT
items.is_qty_decimalNULLABLEINTEGER
items.is_virtualNULLABLEINTEGER
items.item_idNULLABLEINTEGER
items.nameNULLABLESTRING
items.no_discountNULLABLEINTEGER
items.order_idNULLABLEINTEGER
items.original_priceNULLABLEFLOAT
items.priceNULLABLEFLOAT
items.price_incl_taxNULLABLEFLOAT
items.product_idNULLABLEINTEGER
items.product_typeNULLABLESTRING
items.qty_canceledNULLABLEINTEGER
items.qty_invoicedNULLABLEINTEGER
items.qty_orderedNULLABLEINTEGER
items.qty_refundedNULLABLEINTEGER
items.qty_shippedNULLABLEINTEGER
items.quote_item_idNULLABLEINTEGER
items.row_invoicedNULLABLEFLOAT
items.row_totalNULLABLEFLOAT
items.row_total_incl_taxNULLABLEFLOAT
items.row_weightNULLABLEFLOAT
items.skuNULLABLESTRING
items.store_idNULLABLEINTEGER
items.tax_amountNULLABLEFLOAT
items.tax_invoicedNULLABLEFLOAT
items.tax_percentNULLABLEINTEGER
items.updated_atNULLABLETIMESTAMP
items.weee_tax_appliedNULLABLESTRING
items.weightNULLABLEFLOAT
items.product_optionNULLABLERECORD
items.product_option.extension_attributesNULLABLERECORD
items.product_option.extension_attributes.configurable_item_optionsREPEATEDRECORD
items.product_option.extension_attributes.configurable_item_options.option_idNULLABLESTRING
items.product_option.extension_attributes.configurable_item_options.option_valueNULLABLEINTEGER
billing_addressNULLABLERECORD
billing_address.address_typeNULLABLESTRING
billing_address.cityNULLABLESTRING
billing_address.country_idNULLABLESTRING
billing_address.emailNULLABLESTRING
billing_address.entity_idNULLABLEINTEGER
billing_address.firstnameNULLABLESTRING
billing_address.lastnameNULLABLESTRING
billing_address.parent_idNULLABLEINTEGER
billing_address.postcodeNULLABLESTRING
billing_address.streetREPEATEDSTRING
billing_address.telephoneNULLABLESTRING
paymentNULLABLERECORD
payment.account_statusNULLABLESTRING
payment.amount_orderedNULLABLEFLOAT
payment.amount_paidNULLABLEFLOAT
payment.base_amount_orderedNULLABLEFLOAT
payment.base_amount_paidNULLABLEFLOAT
payment.base_amount_paid_onlineNULLABLEFLOAT
payment.base_shipping_amountNULLABLEFLOAT
payment.base_shipping_capturedNULLABLEFLOAT
payment.cc_exp_yearNULLABLESTRING
payment.cc_last4NULLABLESTRING
payment.cc_ss_start_monthNULLABLESTRING
payment.cc_ss_start_yearNULLABLESTRING
payment.entity_idNULLABLEINTEGER
payment.last_trans_idNULLABLESTRING
payment.methodNULLABLESTRING
payment.parent_idNULLABLEINTEGER
payment.shipping_amountNULLABLEFLOAT
payment.shipping_capturedNULLABLEFLOAT
status_historiesREPEATEDRECORD
status_histories.commentNULLABLESTRING
status_histories.created_atNULLABLETIMESTAMP
status_histories.entity_idNULLABLEINTEGER
status_histories.is_customer_notifiedNULLABLEINTEGER
status_histories.is_visible_on_frontNULLABLEINTEGER
status_histories.parent_idNULLABLEINTEGER
status_histories.statusNULLABLESTRING
extension_attributesNULLABLERECORD
extension_attributes.shipping_assignmentsREPEATEDRECORD
extension_attributes.shipping_assignments.shippingNULLABLERECORD
extension_attributes.shipping_assignments.shipping.addressNULLABLERECORD
extension_attributes.shipping_assignments.shipping.address.address_typeNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.cityNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.country_idNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.emailNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.entity_idNULLABLEINTEGER
extension_attributes.shipping_assignments.shipping.address.firstnameNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.lastnameNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.parent_idNULLABLEINTEGER
extension_attributes.shipping_assignments.shipping.address.postcodeNULLABLESTRING
extension_attributes.shipping_assignments.shipping.address.streetREPEATEDSTRING
extension_attributes.shipping_assignments.shipping.address.telephoneNULLABLESTRING
extension_attributes.shipping_assignments.shipping.methodNULLABLESTRING
extension_attributes.shipping_assignments.shipping.totalNULLABLERECORD
extension_attributes.shipping_assignments.shipping.total.base_shipping_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.base_shipping_discount_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.base_shipping_discount_tax_compensation_amntNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.base_shipping_incl_taxNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.base_shipping_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.base_shipping_tax_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.shipping_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.shipping_discount_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.shipping_discount_tax_compensation_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.shipping_incl_taxNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.shipping_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.shipping.total.shipping_tax_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.itemsREPEATEDRECORD
extension_attributes.shipping_assignments.items.amount_refundedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.applied_rule_idsNULLABLESTRING
extension_attributes.shipping_assignments.items.base_amount_refundedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_discount_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_discount_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_discount_tax_compensation_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_discount_tax_compensation_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_original_priceNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_priceNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_price_incl_taxNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_row_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_row_totalNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_row_total_incl_taxNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_tax_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.items.base_tax_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.created_atNULLABLETIMESTAMP
extension_attributes.shipping_assignments.items.discount_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.items.discount_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.discount_percentNULLABLEINTEGER
extension_attributes.shipping_assignments.items.free_shippingNULLABLEINTEGER
extension_attributes.shipping_assignments.items.discount_tax_compensation_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.items.discount_tax_compensation_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.is_qty_decimalNULLABLEINTEGER
extension_attributes.shipping_assignments.items.is_virtualNULLABLEINTEGER
extension_attributes.shipping_assignments.items.item_idNULLABLEINTEGER
extension_attributes.shipping_assignments.items.nameNULLABLESTRING
extension_attributes.shipping_assignments.items.no_discountNULLABLEINTEGER
extension_attributes.shipping_assignments.items.order_idNULLABLEINTEGER
extension_attributes.shipping_assignments.items.original_priceNULLABLEFLOAT
extension_attributes.shipping_assignments.items.priceNULLABLEFLOAT
extension_attributes.shipping_assignments.items.price_incl_taxNULLABLEFLOAT
extension_attributes.shipping_assignments.items.product_idNULLABLEINTEGER
extension_attributes.shipping_assignments.items.product_typeNULLABLESTRING
extension_attributes.shipping_assignments.items.qty_canceledNULLABLEINTEGER
extension_attributes.shipping_assignments.items.qty_invoicedNULLABLEINTEGER
extension_attributes.shipping_assignments.items.qty_orderedNULLABLEINTEGER
extension_attributes.shipping_assignments.items.qty_refundedNULLABLEINTEGER
extension_attributes.shipping_assignments.items.qty_shippedNULLABLEINTEGER
extension_attributes.shipping_assignments.items.quote_item_idNULLABLEINTEGER
extension_attributes.shipping_assignments.items.row_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.row_totalNULLABLEFLOAT
extension_attributes.shipping_assignments.items.row_total_incl_taxNULLABLEFLOAT
extension_attributes.shipping_assignments.items.row_weightNULLABLEFLOAT
extension_attributes.shipping_assignments.items.skuNULLABLESTRING
extension_attributes.shipping_assignments.items.store_idNULLABLEINTEGER
extension_attributes.shipping_assignments.items.tax_amountNULLABLEFLOAT
extension_attributes.shipping_assignments.items.tax_invoicedNULLABLEFLOAT
extension_attributes.shipping_assignments.items.tax_percentNULLABLEINTEGER
extension_attributes.shipping_assignments.items.updated_atNULLABLETIMESTAMP
extension_attributes.shipping_assignments.items.weee_tax_appliedNULLABLESTRING
extension_attributes.shipping_assignments.items.weightNULLABLEFLOAT
extension_attributes.shipping_assignments.items.product_optionNULLABLERECORD
extension_attributes.shipping_assignments.items.product_option.extension_attributesNULLABLERECORD
extension_attributes.shipping_assignments.items.product_option.extension_attributes.configurable_item_optionsREPEATEDRECORD
extension_attributes.shipping_assignments.items.product_option.extension_attributes.configurable_item_options.option_idNULLABLESTRING
extension_attributes.shipping_assignments.items.product_option.extension_attributes.configurable_item_options.option_valueNULLABLEINTEGER
extension_attributes.payment_additional_infoREPEATEDRECORD
extension_attributes.payment_additional_info.keyNULLABLESTRING
extension_attributes.payment_additional_info.valueNULLABLESTRING
extension_attributes.applied_taxesREPEATEDRECORD
extension_attributes.applied_taxes.codeNULLABLESTRING
extension_attributes.applied_taxes.titleNULLABLESTRING
extension_attributes.applied_taxes.percentNULLABLEINTEGER
extension_attributes.applied_taxes.amountNULLABLEFLOAT
extension_attributes.applied_taxes.base_amountNULLABLEFLOAT
extension_attributes.item_applied_taxesREPEATEDRECORD
extension_attributes.item_applied_taxes.typeNULLABLESTRING
extension_attributes.item_applied_taxes.applied_taxesREPEATEDRECORD
extension_attributes.item_applied_taxes.applied_taxes.codeNULLABLESTRING
extension_attributes.item_applied_taxes.applied_taxes.titleNULLABLESTRING
extension_attributes.item_applied_taxes.applied_taxes.percentNULLABLEFLOAT
extension_attributes.item_applied_taxes.applied_taxes.amountNULLABLEFLOAT
extension_attributes.item_applied_taxes.applied_taxes.base_amountNULLABLEFLOAT
extension_attributes.converting_from_quoteNULLABLEBOOLEAN
extension_attributes.cash_on_delivery_feeNULLABLEINTEGER
extension_attributes.base_cash_on_delivery_feeNULLABLEINTEGER
Schemat danych tabeli magento_products
Field NameModeType
idNULLABLEINTEGER
skuNULLABLESTRING
nameNULLABLESTRING
attribute_set_idNULLABLEINTEGER
priceNULLABLEFLOAT
statusNULLABLEINTEGER
visibilityNULLABLEINTEGER
type_idNULLABLESTRING
created_atNULLABLESTRING
updated_atNULLABLESTRING
weightNULLABLEFLOAT
extension_attributesNULLABLERECORD
extension_attributes.website_idsREPEATEDINTEGER
extension_attributes.category_linksREPEATEDRECORD
extension_attributes.category_links.positionNULLABLEINTEGER
extension_attributes.category_links.category_idNULLABLESTRING
extension_attributes.bundle_product_optionsREPEATEDRECORD
extension_attributes.bundle_product_options.option_idNULLABLEINTEGER
extension_attributes.bundle_product_options.titleNULLABLESTRING
extension_attributes.bundle_product_options.requiredNULLABLEBOOLEAN
extension_attributes.bundle_product_options.typeNULLABLESTRING
extension_attributes.bundle_product_options.positionNULLABLEINTEGER
extension_attributes.bundle_product_options.skuNULLABLESTRING
extension_attributes.bundle_product_options.product_linksREPEATEDRECORD
extension_attributes.bundle_product_options.product_links.can_change_quantityNULLABLEINTEGER
extension_attributes.bundle_product_options.product_links.idNULLABLESTRING
extension_attributes.bundle_product_options.product_links.is_defaultNULLABLEBOOLEAN
extension_attributes.bundle_product_options.product_links.option_idNULLABLEINTEGER
extension_attributes.bundle_product_options.product_links.positionNULLABLEINTEGER
extension_attributes.bundle_product_options.product_links.priceNULLABLEFLOAT
extension_attributes.bundle_product_options.product_links.price_typeNULLABLEINTEGER
extension_attributes.bundle_product_options.product_links.qtyNULLABLEFLOAT
extension_attributes.bundle_product_options.product_links.skuNULLABLESTRING
extension_attributes.stock_itemNULLABLERECORD
extension_attributes.stock_item.item_idNULLABLEINTEGER
extension_attributes.stock_item.product_idNULLABLEINTEGER
extension_attributes.stock_item.stock_idNULLABLEINTEGER
extension_attributes.stock_item.qtyNULLABLEINTEGER
extension_attributes.stock_item.is_in_stockNULLABLEBOOLEAN
extension_attributes.stock_item.is_qty_decimalNULLABLEBOOLEAN
extension_attributes.stock_item.show_default_notification_messageNULLABLEBOOLEAN
extension_attributes.stock_item.use_config_min_qtyNULLABLEBOOLEAN
extension_attributes.stock_item.min_qtyNULLABLEINTEGER
extension_attributes.stock_item.use_config_min_sale_qtyNULLABLEINTEGER
extension_attributes.stock_item.min_sale_qtyNULLABLEINTEGER
extension_attributes.stock_item.use_config_max_sale_qtyNULLABLEBOOLEAN
extension_attributes.stock_item.max_sale_qtyNULLABLEINTEGER
extension_attributes.stock_item.use_config_backordersNULLABLEBOOLEAN
extension_attributes.stock_item.backordersNULLABLEINTEGER
extension_attributes.stock_item.use_config_notify_stock_qtyNULLABLEBOOLEAN
extension_attributes.stock_item.notify_stock_qtyNULLABLEINTEGER
extension_attributes.stock_item.use_config_qty_incrementsNULLABLEBOOLEAN
extension_attributes.stock_item.qty_incrementsNULLABLEINTEGER
extension_attributes.stock_item.use_config_enable_qty_incNULLABLEBOOLEAN
extension_attributes.stock_item.enable_qty_incrementsNULLABLEBOOLEAN
extension_attributes.stock_item.use_config_manage_stockNULLABLEBOOLEAN
extension_attributes.stock_item.manage_stockNULLABLEBOOLEAN
extension_attributes.stock_item.low_stock_dateNULLABLESTRING
extension_attributes.stock_item.is_decimal_dividedNULLABLEBOOLEAN
extension_attributes.stock_item.stock_status_changed_autoNULLABLEINTEGER
extension_attributes.downloadable_product_linksREPEATEDRECORD
extension_attributes.downloadable_product_links.idNULLABLEINTEGER
extension_attributes.downloadable_product_links.titleNULLABLESTRING
extension_attributes.downloadable_product_links.sort_orderNULLABLEINTEGER
extension_attributes.downloadable_product_links.is_shareableNULLABLEINTEGER
extension_attributes.downloadable_product_links.priceNULLABLEFLOAT
extension_attributes.downloadable_product_links.number_of_downloadsNULLABLEINTEGER
extension_attributes.downloadable_product_links.link_typeNULLABLESTRING
extension_attributes.downloadable_product_links.link_fileNULLABLESTRING
extension_attributes.downloadable_product_links.link_file_contentNULLABLERECORD
extension_attributes.downloadable_product_links.link_file_content.file_dataNULLABLESTRING
extension_attributes.downloadable_product_links.link_file_content.nameNULLABLESTRING
extension_attributes.downloadable_product_links.link_urlNULLABLESTRING
extension_attributes.downloadable_product_links.sample_typeNULLABLESTRING
extension_attributes.downloadable_product_links.sample_fileNULLABLESTRING
extension_attributes.downloadable_product_links.sample_file_contentNULLABLERECORD
extension_attributes.downloadable_product_links.sample_file_content.file_dataNULLABLESTRING
extension_attributes.downloadable_product_links.sample_file_content.nameNULLABLESTRING
extension_attributes.downloadable_product_links.sample_urlNULLABLESTRING
extension_attributes.downloadable_product_samplesREPEATEDRECORD
extension_attributes.downloadable_product_samples.idNULLABLEINTEGER
extension_attributes.downloadable_product_samples.titleNULLABLESTRING
extension_attributes.downloadable_product_samples.sort_orderNULLABLEINTEGER
extension_attributes.downloadable_product_samples.sample_typeNULLABLESTRING
extension_attributes.downloadable_product_samples.sample_fileNULLABLESTRING
extension_attributes.downloadable_product_samples.sample_file_contentNULLABLERECORD
extension_attributes.downloadable_product_samples.sample_file_content.file_dataNULLABLESTRING
extension_attributes.downloadable_product_samples.sample_file_content.nameNULLABLESTRING
extension_attributes.downloadable_product_samples.sample_urlNULLABLESTRING
extension_attributes.giftcard_amountsREPEATEDRECORD
extension_attributes.giftcard_amounts.attribute_idNULLABLEINTEGER
extension_attributes.giftcard_amounts.website_idNULLABLEINTEGER
extension_attributes.giftcard_amounts.valueNULLABLEINTEGER
extension_attributes.giftcard_amounts.website_valueNULLABLEINTEGER
extension_attributes.configurable_product_optionsREPEATEDRECORD
extension_attributes.configurable_product_options.idNULLABLEINTEGER
extension_attributes.configurable_product_options.attribute_idNULLABLESTRING
extension_attributes.configurable_product_options.labelNULLABLESTRING
extension_attributes.configurable_product_options.positionNULLABLEINTEGER
extension_attributes.configurable_product_options.is_use_defaultNULLABLEBOOLEAN
extension_attributes.configurable_product_options.valuesREPEATEDRECORD
extension_attributes.configurable_product_options.values.value_indexNULLABLEINTEGER
extension_attributes.configurable_product_options.product_idNULLABLEINTEGER
extension_attributes.configurable_product_linksREPEATEDINTEGER
extension_attributes.vertex_commodity_codeNULLABLERECORD
extension_attributes.vertex_commodity_code.codeNULLABLESTRING
extension_attributes.vertex_commodity_code.typeNULLABLESTRING
product_linksREPEATEDRECORD
product_links.skuNULLABLESTRING
product_links.link_typeNULLABLESTRING
product_links.linked_product_skuNULLABLESTRING
product_links.linked_product_typeNULLABLESTRING
product_links.positionNULLABLEINTEGER
product_links.extension_attributesNULLABLERECORD
product_links.extension_attributes.qtyNULLABLEINTEGER
optionsREPEATEDRECORD
options.product_skuNULLABLESTRING
options.option_idNULLABLEINTEGER
options.titleNULLABLESTRING
options.typeNULLABLESTRING
options.sort_orderNULLABLEINTEGER
options.is_requireNULLABLEBOOLEAN
options.priceNULLABLEFLOAT
options.price_typeNULLABLESTRING
options.skuNULLABLESTRING
options.file_extensionNULLABLESTRING
options.max_charactersNULLABLEINTEGER
options.image_size_xNULLABLEINTEGER
options.image_size_yNULLABLEINTEGER
options.valuesREPEATEDRECORD
options.values.titleNULLABLESTRING
options.values.sort_orderNULLABLEINTEGER
options.values.priceNULLABLEFLOAT
options.values.price_typeNULLABLESTRING
options.values.skuNULLABLESTRING
options.values.option_type_idNULLABLEINTEGER
options.extension_attributesNULLABLERECORD
options.extension_attributes.vertex_flex_fieldNULLABLESTRING
media_gallery_entriesREPEATEDRECORD
media_gallery_entries.idNULLABLEINTEGER
media_gallery_entries.media_typeNULLABLESTRING
media_gallery_entries.labelNULLABLESTRING
media_gallery_entries.positionNULLABLEINTEGER
media_gallery_entries.disabledNULLABLEBOOLEAN
media_gallery_entries.typesREPEATEDSTRING
media_gallery_entries.fileNULLABLESTRING
media_gallery_entries.contentREPEATEDRECORD
media_gallery_entries.content.base64_encoded_dataNULLABLESTRING
media_gallery_entries.content.typeNULLABLESTRING
media_gallery_entries.content.nameNULLABLESTRING
media_gallery_entries.extension_attributesREPEATEDRECORD
media_gallery_entries.extension_attributes.video_contentREPEATEDRECORD
media_gallery_entries.extension_attributes.video_content.media_typeNULLABLESTRING
media_gallery_entries.extension_attributes.video_content.video_providerNULLABLESTRING
media_gallery_entries.extension_attributes.video_content.video_urlNULLABLESTRING
media_gallery_entries.extension_attributes.video_content.video_titleNULLABLESTRING
media_gallery_entries.extension_attributes.video_content.video_descriptionNULLABLESTRING
media_gallery_entries.extension_attributes.video_content.video_metadataNULLABLESTRING
tier_pricesREPEATEDRECORD
tier_prices.customer_group_idNULLABLEINTEGER
tier_prices.qtyNULLABLEFLOAT
tier_prices.valueNULLABLEFLOAT
tier_prices.extension_attributesNULLABLERECORD
tier_prices.extension_attributes.percentage_valueNULLABLEFLOAT
tier_prices.extension_attributes.website_idNULLABLEINTEGER
custom_attributesREPEATEDRECORD
custom_attributes.attribute_codeNULLABLESTRING
custom_attributes.valueNULLABLESTRING
Schemat danych tabeli magento_product_attributes
Field NameModeType
is_wysiwyg_enabledNULLABLEBOOLEAN
is_html_allowed_on_frontNULLABLEBOOLEAN
used_for_sort_byNULLABLEBOOLEAN
is_filterableNULLABLEBOOLEAN
is_filterable_in_searchNULLABLEBOOLEAN
is_used_in_gridNULLABLEBOOLEAN
is_visible_in_gridNULLABLEBOOLEAN
is_filterable_in_gridNULLABLEBOOLEAN
positionNULLABLEINTEGER
is_searchableNULLABLESTRING
is_visible_in_advanced_searchNULLABLESTRING
is_comparableNULLABLESTRING
is_used_for_promo_rulesNULLABLESTRING
is_visible_on_frontNULLABLESTRING
used_in_product_listingNULLABLESTRING
is_visibleNULLABLEBOOLEAN
scopeNULLABLESTRING
attribute_idNULLABLEINTEGER
attribute_codeNULLABLESTRING
frontend_inputNULLABLESTRING
entity_type_idNULLABLESTRING
is_requiredNULLABLEBOOLEAN
optionsREPEATEDRECORD
options.labelNULLABLESTRING
options.valueNULLABLESTRING
is_user_definedNULLABLEBOOLEAN
default_frontend_labelNULLABLESTRING
frontend_labelsREPEATEDRECORD
frontend_labels.store_idNULLABLEINTEGER
frontend_labels.labelNULLABLESTRING
backend_typeNULLABLESTRING
backend_modelNULLABLESTRING
default_valueNULLABLESTRING
Schemat danych tabeli magento_low_stocks
Field NameModeType
item_idNULLABLEINTEGER
product_idNULLABLEINTEGER
stock_idNULLABLEINTEGER
qtyNULLABLEINTEGER
is_in_stockNULLABLEBOOLEAN
is_qty_decimalNULLABLEBOOLEAN
show_default_notification_messageNULLABLEBOOLEAN
use_config_min_qtyNULLABLEBOOLEAN
min_qtyNULLABLEINTEGER
use_config_min_sale_qtyNULLABLEINTEGER
min_sale_qtyNULLABLEINTEGER
use_config_max_sale_qtyNULLABLEBOOLEAN
max_sale_qtyNULLABLEINTEGER
use_config_backordersNULLABLEBOOLEAN
backordersNULLABLEINTEGER
use_config_notify_stock_qtyNULLABLEBOOLEAN
notify_stock_qtyNULLABLEINTEGER
use_config_qty_incrementsNULLABLEBOOLEAN
qty_incrementsNULLABLEINTEGER
use_config_enable_qty_incNULLABLEBOOLEAN
enable_qty_incrementsNULLABLEBOOLEAN
use_config_manage_stockNULLABLEBOOLEAN
manage_stockNULLABLEBOOLEAN
low_stock_dateNULLABLETIMESTAMP
is_decimal_dividedNULLABLEBOOLEAN
stock_status_changed_autoNULLABLEINTEGER
Schemat danych tabeli magento_categories
Field NameModeType
idNULLABLEINTEGER
parent_idNULLABLEINTEGER
nameNULLABLESTRING
is_activeNULLABLEBOOLEAN
positionNULLABLEINTEGER
levelNULLABLEINTEGER
product_countNULLABLEINTEGER
Schemat danych tabeli magento_store_configs
Field NameModeType
idNULLABLEINTEGER
codeNULLABLESTRING
website_idNULLABLEINTEGER
localeNULLABLESTRING
base_currency_codeNULLABLESTRING
default_display_currency_codeNULLABLESTRING
timezoneNULLABLESTRING
weight_unitNULLABLESTRING
base_urlNULLABLESTRING
base_link_urlNULLABLESTRING
base_static_urlNULLABLESTRING
base_media_urlNULLABLESTRING
secure_base_urlNULLABLESTRING
secure_base_link_urlNULLABLESTRING
secure_base_static_urlNULLABLESTRING
secure_base_media_urlNULLABLESTRING
Schemat danych tabeli magento_tax_rates
Field NameModeType
idNULLABLEINTEGER
tax_country_idNULLABLESTRING
tax_region_idNULLABLEINTEGER
tax_postcodeNULLABLESTRING
rateNULLABLEFLOAT
codeNULLABLESTRING
titlesREPEATEDRECORD
titles.store_idNULLABLESTRING
titles.valueNULLABLESTRING
Schemat danych tabeli magento_currency
Field NameModeType
base_currency_codeNULLABLESTRING
base_currency_symbolNULLABLESTRING
default_display_currency_codeNULLABLESTRING
default_display_currency_symbolNULLABLESTRING
available_currency_codesREPEATEDSTRING
exchange_ratesREPEATEDRECORD
exchange_rates.currency_toNULLABLESTRING
exchange_rates.rateNULLABLEFLOAT