# Magento
# Wprowadzenie
Moduł Magento pozwala na automatyczne zbieranie danych Twojego sklepu Magento.
# Przykład działania
- Konfigurujemy moduł w platformie udzielając dostępu do sklepu Magento
- Ustawiamy moduł w harmonogramie - dane będą gromadzone i przechowywane w zbiorze danych WitCloud
- Po przetworzeniu tabeli można skorzystać z innych modułów raportowych które są z nią zintegrowane.
# Schemat danych
Zbieramy najważniejsze informacje z Magento do 2 tabel:
- magento_orders
Rozwiń aby zapoznać się ze schematem danych
Field name | Type | Mode |
---|---|---|
applied_rule_ids | STRING | NULLABLE |
base_currency_code | STRING | NULLABLE |
base_discount_amount | FLOAT | NULLABLE |
base_discount_invoiced | FLOAT | NULLABLE |
base_grand_total | FLOAT | NULLABLE |
base_discount_tax_compensation_amount | FLOAT | NULLABLE |
base_discount_tax_compensation_invoiced | FLOAT | NULLABLE |
base_shipping_amount | FLOAT | NULLABLE |
base_shipping_discount_amount | FLOAT | NULLABLE |
base_shipping_discount_tax_compensation_amnt | FLOAT | NULLABLE |
base_shipping_incl_tax | FLOAT | NULLABLE |
base_shipping_invoiced | FLOAT | NULLABLE |
base_shipping_tax_amount | FLOAT | NULLABLE |
base_subtotal | FLOAT | NULLABLE |
base_subtotal_incl_tax | FLOAT | NULLABLE |
base_subtotal_invoiced | FLOAT | NULLABLE |
base_tax_amount | FLOAT | NULLABLE |
base_tax_invoiced | FLOAT | NULLABLE |
base_total_due | FLOAT | NULLABLE |
base_total_invoiced | FLOAT | NULLABLE |
base_total_invoiced_cost | FLOAT | NULLABLE |
base_total_paid | FLOAT | NULLABLE |
base_to_global_rate | FLOAT | NULLABLE |
base_to_order_rate | FLOAT | NULLABLE |
billing_address_id | FLOAT | NULLABLE |
coupon_code | STRING | NULLABLE |
created_at | TIMESTAMP | NULLABLE |
customer_email | STRING | NULLABLE |
customer_firstname | STRING | NULLABLE |
customer_group_id | INTEGER | NULLABLE |
customer_id | INTEGER | NULLABLE |
customer_is_guest | INTEGER | NULLABLE |
customer_lastname | STRING | NULLABLE |
customer_note_notify | INTEGER | NULLABLE |
discount_amount | FLOAT | NULLABLE |
discount_description | STRING | NULLABLE |
discount_invoiced | FLOAT | NULLABLE |
email_sent | INTEGER | NULLABLE |
entity_id | INTEGER | NULLABLE |
global_currency_code | STRING | NULLABLE |
grand_total | FLOAT | NULLABLE |
discount_tax_compensation_amount | FLOAT | NULLABLE |
discount_tax_compensation_invoiced | FLOAT | NULLABLE |
increment_id | STRING | NULLABLE |
is_virtual | INTEGER | NULLABLE |
order_currency_code | STRING | NULLABLE |
protect_code | STRING | NULLABLE |
quote_id | INTEGER | NULLABLE |
remote_ip | STRING | NULLABLE |
shipping_amount | FLOAT | NULLABLE |
shipping_description | STRING | NULLABLE |
shipping_discount_amount | INTEGER | NULLABLE |
shipping_discount_tax_compensation_amount | INTEGER | NULLABLE |
shipping_incl_tax | FLOAT | NULLABLE |
shipping_invoiced | FLOAT | NULLABLE |
shipping_tax_amount | FLOAT | NULLABLE |
state | STRING | NULLABLE |
status | STRING | NULLABLE |
store_currency_code | STRING | NULLABLE |
store_id | INTEGER | NULLABLE |
store_name | STRING | NULLABLE |
store_to_base_rate | FLOAT | NULLABLE |
store_to_order_rate | FLOAT | NULLABLE |
subtotal | FLOAT | NULLABLE |
subtotal_incl_tax | FLOAT | NULLABLE |
subtotal_invoiced | FLOAT | NULLABLE |
tax_amount | FLOAT | NULLABLE |
tax_invoiced | FLOAT | NULLABLE |
total_due | FLOAT | NULLABLE |
total_invoiced | FLOAT | NULLABLE |
total_item_count | INTEGER | NULLABLE |
total_paid | FLOAT | NULLABLE |
total_qty_ordered | INTEGER | NULLABLE |
updated_at | TIMESTAMP | NULLABLE |
weight | FLOAT | NULLABLE |
x_forwarded_for | STRING | NULLABLE |
items | RECORD | REPEATED |
items. amount_refunded | FLOAT | NULLABLE |
items. applied_rule_ids | STRING | NULLABLE |
items. base_amount_refunded | FLOAT | NULLABLE |
items. base_discount_amount | FLOAT | NULLABLE |
items. base_discount_invoiced | FLOAT | NULLABLE |
items. base_discount_tax_compensation_amount | FLOAT | NULLABLE |
items. base_discount_tax_compensation_invoiced | FLOAT | NULLABLE |
items. base_original_price | FLOAT | NULLABLE |
items. base_price | FLOAT | NULLABLE |
items. base_price_incl_tax | FLOAT | NULLABLE |
items. base_row_invoiced | FLOAT | NULLABLE |
items. base_row_total | FLOAT | NULLABLE |
items. base_row_total_incl_tax | FLOAT | NULLABLE |
items. base_tax_amount | FLOAT | NULLABLE |
items. base_tax_invoiced | FLOAT | NULLABLE |
items. created_at | TIMESTAMP | NULLABLE |
items. discount_amount | FLOAT | NULLABLE |
items. discount_invoiced | FLOAT | NULLABLE |
items. discount_percent | INTEGER | NULLABLE |
items. free_shipping | INTEGER | NULLABLE |
items. discount_tax_compensation_amount | FLOAT | NULLABLE |
items. discount_tax_compensation_invoiced | FLOAT | NULLABLE |
items. is_qty_decimal | INTEGER | NULLABLE |
items. is_virtual | INTEGER | NULLABLE |
items. item_id | INTEGER | NULLABLE |
items. name | STRING | NULLABLE |
items. no_discount | INTEGER | NULLABLE |
items. order_id | INTEGER | NULLABLE |
items. original_price | INTEGER | NULLABLE |
items. price | FLOAT | NULLABLE |
items. price_incl_tax | FLOAT | NULLABLE |
items. product_id | INTEGER | NULLABLE |
items. product_type | STRING | NULLABLE |
items. qty_canceled | INTEGER | NULLABLE |
items. qty_invoiced | INTEGER | NULLABLE |
items. qty_ordered | INTEGER | NULLABLE |
items. qty_refunded | INTEGER | NULLABLE |
items. qty_shipped | INTEGER | NULLABLE |
items. quote_item_id | INTEGER | NULLABLE |
items. row_invoiced | FLOAT | NULLABLE |
items. row_total | FLOAT | NULLABLE |
items. row_total_incl_tax | FLOAT | NULLABLE |
items. row_weight | FLOAT | NULLABLE |
items. sku | STRING | NULLABLE |
items. store_id | INTEGER | NULLABLE |
items. tax_amount | FLOAT | NULLABLE |
items. tax_invoiced | FLOAT | NULLABLE |
items. tax_percent | INTEGER | NULLABLE |
items. updated_at | TIMESTAMP | NULLABLE |
items. weee_tax_applied | STRING | NULLABLE |
items. weight | FLOAT | NULLABLE |
items. product_option | RECORD | NULLABLE |
items.product_option. extension_attributes | RECORD | NULLABLE |
items.product_option.extension_attributes. configurable_item_options | RECORD | REPEATED |
items.product_option.extension_attributes.configurable_item_options. option_id | STRING | NULLABLE |
items.product_option.extension_attributes.configurable_item_options. option_value | INTEGER | NULLABLE |
billing_address | RECORD | NULLABLE |
billing_address. address_type | STRING | NULLABLE |
billing_address. city | STRING | NULLABLE |
billing_address. country_id | STRING | NULLABLE |
billing_address. email | STRING | NULLABLE |
billing_address. entity_id | INTEGER | NULLABLE |
billing_address. firstname | STRING | NULLABLE |
billing_address. lastname | STRING | NULLABLE |
billing_address. parent_id | INTEGER | NULLABLE |
billing_address. postcode | STRING | NULLABLE |
billing_address. street | STRING | REPEATED |
billing_address. telephone | STRING | NULLABLE |
payment | RECORD | NULLABLE |
payment. account_status | STRING | NULLABLE |
payment. amount_ordered | FLOAT | NULLABLE |
payment. amount_paid | FLOAT | NULLABLE |
payment. base_amount_ordered | FLOAT | NULLABLE |
payment. base_amount_paid | FLOAT | NULLABLE |
payment. base_amount_paid_online | FLOAT | NULLABLE |
payment. base_shipping_amount | FLOAT | NULLABLE |
payment. base_shipping_captured | FLOAT | NULLABLE |
payment. cc_exp_year | STRING | NULLABLE |
payment. cc_last4 | STRING | NULLABLE |
payment. cc_ss_start_month | STRING | NULLABLE |
payment. cc_ss_start_year | STRING | NULLABLE |
payment. entity_id | INTEGER | NULLABLE |
payment. last_trans_id | STRING | NULLABLE |
payment. method | STRING | NULLABLE |
payment. parent_id | INTEGER | NULLABLE |
payment. shipping_amount | FLOAT | NULLABLE |
payment. shipping_captured | FLOAT | NULLABLE |
status_histories | RECORD | REPEATED |
status_histories. comment | STRING | NULLABLE |
status_histories. created_at | TIMESTAMP | NULLABLE |
status_histories. entity_id | INTEGER | NULLABLE |
status_histories. is_customer_notified | INTEGER | NULLABLE |
status_histories. is_visible_on_front | INTEGER | NULLABLE |
status_histories. parent_id | INTEGER | NULLABLE |
status_histories. status | STRING | NULLABLE |
extension_attributes | RECORD | NULLABLE |
extension_attributes. shipping_assignments | RECORD | REPEATED |
extension_attributes.shipping_assignments. shipping | RECORD | NULLABLE |
extension_attributes.shipping_assignments.shipping. address | RECORD | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. address_type | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. city | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. country_id | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. email | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. entity_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. firstname | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. lastname | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. parent_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. postcode | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping.address. street | STRING | REPEATED |
extension_attributes.shipping_assignments.shipping.address. telephone | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping. method | STRING | NULLABLE |
extension_attributes.shipping_assignments.shipping. total | RECORD | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. base_shipping_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. base_shipping_discount_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. base_shipping_discount_tax_compensation_amnt | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. base_shipping_incl_tax | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. base_shipping_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. base_shipping_tax_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. shipping_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. shipping_discount_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. shipping_discount_tax_compensation_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. shipping_incl_tax | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. shipping_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.shipping.total. shipping_tax_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments. items | RECORD | REPEATED |
extension_attributes.shipping_assignments.items. amount_refunded | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. applied_rule_ids | STRING | NULLABLE |
extension_attributes.shipping_assignments.items. base_amount_refunded | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. base_discount_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_discount_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_discount_tax_compensation_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_discount_tax_compensation_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_original_price | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. base_price | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_price_incl_tax | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_row_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_row_total | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_row_total_incl_tax | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_tax_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. base_tax_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. created_at | TIMESTAMP | NULLABLE |
extension_attributes.shipping_assignments.items. discount_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. discount_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. discount_percent | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. free_shipping | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. discount_tax_compensation_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. discount_tax_compensation_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. is_qty_decimal | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. is_virtual | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. item_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. name | STRING | NULLABLE |
extension_attributes.shipping_assignments.items. no_discount | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. order_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. original_price | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. price | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. price_incl_tax | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. product_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. product_type | STRING | NULLABLE |
extension_attributes.shipping_assignments.items. qty_canceled | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. qty_invoiced | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. qty_ordered | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. qty_refunded | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. qty_shipped | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. quote_item_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. row_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. row_total | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. row_total_incl_tax | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. row_weight | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. sku | STRING | NULLABLE |
extension_attributes.shipping_assignments.items. store_id | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. tax_amount | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. tax_invoiced | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. tax_percent | INTEGER | NULLABLE |
extension_attributes.shipping_assignments.items. updated_at | TIMESTAMP | NULLABLE |
extension_attributes.shipping_assignments.items. weee_tax_applied | STRING | NULLABLE |
extension_attributes.shipping_assignments.items. weight | FLOAT | NULLABLE |
extension_attributes.shipping_assignments.items. product_option | RECORD | NULLABLE |
extension_attributes.shipping_assignments.items.product_option. extension_attributes | RECORD | NULLABLE |
extension_attributes.shipping_assignments.items.product_option.extension_attributes. configurable_item_options | RECORD | REPEATED |
extension_attributes.shipping_assignments.items.product_option.extension_attributes.configurable_item_options. option_id | STRING | NULLABLE |
extension_attributes.shipping_assignments.items.product_option.extension_attributes.configurable_item_options. option_value | INTEGER | NULLABLE |
extension_attributes. payment_additional_info | RECORD | REPEATED |
extension_attributes.payment_additional_info. key | STRING | NULLABLE |
extension_attributes.payment_additional_info. value | STRING | NULLABLE |
extension_attributes. applied_taxes | RECORD | REPEATED |
extension_attributes.applied_taxes. code | STRING | NULLABLE |
extension_attributes.applied_taxes. title | STRING | NULLABLE |
extension_attributes.applied_taxes. percent | INTEGER | NULLABLE |
extension_attributes.applied_taxes. amount | FLOAT | NULLABLE |
extension_attributes.applied_taxes. base_amount | FLOAT | NULLABLE |
extension_attributes. item_applied_taxes | RECORD | REPEATED |
extension_attributes.item_applied_taxes. type | STRING | NULLABLE |
extension_attributes.item_applied_taxes. applied_taxes | RECORD | REPEATED |
extension_attributes.item_applied_taxes.applied_taxes. code | STRING | NULLABLE |
extension_attributes.item_applied_taxes.applied_taxes. title | STRING | NULLABLE |
extension_attributes.item_applied_taxes.applied_taxes. percent | FLOAT | NULLABLE |
extension_attributes.item_applied_taxes.applied_taxes. amount | FLOAT | NULLABLE |
extension_attributes.item_applied_taxes.applied_taxes. base_amount | FLOAT | NULLABLE |
extension_attributes. converting_from_quote | BOOLEAN | NULLABLE |
extension_attributes. cash_on_delivery_fee | INTEGER | NULLABLE |
extension_attributes. base_cash_on_delivery_fee | INTEGER | NULLABLE |
- magento_products
Rozwiń aby zapoznać się ze schematem danych
Field name | Type | Mode |
---|---|---|
id | INTEGER | NULLABLE |
sku | STRING | NULLABLE |
name | STRING | NULLABLE |
attribute_set_id | INTEGER | NULLABLE |
price | FLOAT | NULLABLE |
status | INTEGER | NULLABLE |
visibility | INTEGER | NULLABLE |
type_id | STRING | NULLABLE |
created_at | STRING | NULLABLE |
updated_at | STRING | NULLABLE |
weight | FLOAT | NULLABLE |
extension_attributes | RECORD | NULLABLE |
extension_attributes. website_ids | INTEGER | REPEATED |
extension_attributes. category_links | RECORD | REPEATED |
extension_attributes.category_links. position | INTEGER | NULLABLE |
extension_attributes.category_links. category_id | STRING | NULLABLE |
extension_attributes. bundle_product_options | RECORD | REPEATED |
extension_attributes.bundle_product_options. option_id | INTEGER | NULLABLE |
extension_attributes.bundle_product_options. title | STRING | NULLABLE |
extension_attributes.bundle_product_options. required | BOOLEAN | NULLABLE |
extension_attributes.bundle_product_options. type | STRING | NULLABLE |
extension_attributes.bundle_product_options. position | INTEGER | NULLABLE |
extension_attributes.bundle_product_options. sku | STRING | NULLABLE |
extension_attributes.bundle_product_options. product_links | RECORD | REPEATED |
extension_attributes.bundle_product_options.product_links. can_change_quantity | INTEGER | NULLABLE |
extension_attributes.bundle_product_options.product_links. id | STRING | NULLABLE |
extension_attributes.bundle_product_options.product_links. is_default | BOOLEAN | NULLABLE |
extension_attributes.bundle_product_options.product_links. option_id | INTEGER | NULLABLE |
extension_attributes.bundle_product_options.product_links. position | INTEGER | NULLABLE |
extension_attributes.bundle_product_options.product_links. price | FLOAT | NULLABLE |
extension_attributes.bundle_product_options.product_links. price_type | INTEGER | NULLABLE |
extension_attributes.bundle_product_options.product_links. qty | FLOAT | NULLABLE |
extension_attributes.bundle_product_options.product_links. sku | STRING | NULLABLE |
extension_attributes. stock_item | RECORD | NULLABLE |
extension_attributes.stock_item. item_id | INTEGER | NULLABLE |
extension_attributes.stock_item. product_id | INTEGER | NULLABLE |
extension_attributes.stock_item. stock_id | INTEGER | NULLABLE |
extension_attributes.stock_item. qty | INTEGER | NULLABLE |
extension_attributes.stock_item. is_in_stock | BOOLEAN | NULLABLE |
extension_attributes.stock_item. is_qty_decimal | BOOLEAN | NULLABLE |
extension_attributes.stock_item. show_default_notification_message | BOOLEAN | NULLABLE |
extension_attributes.stock_item. use_config_min_qty | BOOLEAN | NULLABLE |
extension_attributes.stock_item. min_qty | INTEGER | NULLABLE |
extension_attributes.stock_item. use_config_min_sale_qty | INTEGER | NULLABLE |
extension_attributes.stock_item. min_sale_qty | INTEGER | NULLABLE |
extension_attributes.stock_item. use_config_max_sale_qty | BOOLEAN | NULLABLE |
extension_attributes.stock_item. max_sale_qty | INTEGER | NULLABLE |
extension_attributes.stock_item. use_config_backorders | BOOLEAN | NULLABLE |
extension_attributes.stock_item. backorders | INTEGER | NULLABLE |
extension_attributes.stock_item. use_config_notify_stock_qty | BOOLEAN | NULLABLE |
extension_attributes.stock_item. notify_stock_qty | INTEGER | NULLABLE |
extension_attributes.stock_item. use_config_qty_increments | BOOLEAN | NULLABLE |
extension_attributes.stock_item. qty_increments | INTEGER | NULLABLE |
extension_attributes.stock_item. use_config_enable_qty_inc | BOOLEAN | NULLABLE |
extension_attributes.stock_item. enable_qty_increments | BOOLEAN | NULLABLE |
extension_attributes.stock_item. use_config_manage_stock | BOOLEAN | NULLABLE |
extension_attributes.stock_item. manage_stock | BOOLEAN | NULLABLE |
extension_attributes.stock_item. low_stock_date | STRING | NULLABLE |
extension_attributes.stock_item. is_decimal_divided | BOOLEAN | NULLABLE |
extension_attributes.stock_item. stock_status_changed_auto | INTEGER | NULLABLE |
extension_attributes. downloadable_product_links | RECORD | REPEATED |
extension_attributes.downloadable_product_links. id | INTEGER | NULLABLE |
extension_attributes.downloadable_product_links. title | STRING | NULLABLE |
extension_attributes.downloadable_product_links. sort_order | INTEGER | NULLABLE |
extension_attributes.downloadable_product_links. is_shareable | INTEGER | NULLABLE |
extension_attributes.downloadable_product_links. price | INTEGER | NULLABLE |
extension_attributes.downloadable_product_links. number_of_downloads | INTEGER | NULLABLE |
extension_attributes.downloadable_product_links. link_type | STRING | NULLABLE |
extension_attributes.downloadable_product_links. link_file | STRING | NULLABLE |
extension_attributes.downloadable_product_links. link_file_content | RECORD | NULLABLE |
extension_attributes.downloadable_product_links.link_file_content. file_data | STRING | NULLABLE |
extension_attributes.downloadable_product_links.link_file_content. name | STRING | NULLABLE |
extension_attributes.downloadable_product_links. link_url | STRING | NULLABLE |
extension_attributes.downloadable_product_links. sample_type | STRING | NULLABLE |
extension_attributes.downloadable_product_links. sample_file | STRING | NULLABLE |
extension_attributes.downloadable_product_links. sample_file_content | RECORD | NULLABLE |
extension_attributes.downloadable_product_links.sample_file_content. file_data | STRING | NULLABLE |
extension_attributes.downloadable_product_links.sample_file_content. name | STRING | NULLABLE |
extension_attributes.downloadable_product_links. sample_url | STRING | NULLABLE |
extension_attributes. downloadable_product_samples | RECORD | REPEATED |
extension_attributes.downloadable_product_samples. id | INTEGER | NULLABLE |
extension_attributes.downloadable_product_samples. title | STRING | NULLABLE |
extension_attributes.downloadable_product_samples. sort_order | INTEGER | NULLABLE |
extension_attributes.downloadable_product_samples. sample_type | STRING | NULLABLE |
extension_attributes.downloadable_product_samples. sample_file | STRING | NULLABLE |
extension_attributes.downloadable_product_samples. sample_file_content | RECORD | NULLABLE |
extension_attributes.downloadable_product_samples.sample_file_content. file_data | STRING | NULLABLE |
extension_attributes.downloadable_product_samples.sample_file_content. name | STRING | NULLABLE |
extension_attributes.downloadable_product_samples. sample_url | STRING | NULLABLE |
extension_attributes. giftcard_amounts | RECORD | REPEATED |
extension_attributes.giftcard_amounts. attribute_id | INTEGER | NULLABLE |
extension_attributes.giftcard_amounts. website_id | INTEGER | NULLABLE |
extension_attributes.giftcard_amounts. value | INTEGER | NULLABLE |
extension_attributes.giftcard_amounts. website_value | INTEGER | NULLABLE |
extension_attributes. configurable_product_options | RECORD | REPEATED |
extension_attributes.configurable_product_options. id | INTEGER | NULLABLE |
extension_attributes.configurable_product_options. attribute_id | STRING | NULLABLE |
extension_attributes.configurable_product_options. label | STRING | NULLABLE |
extension_attributes.configurable_product_options. position | INTEGER | NULLABLE |
extension_attributes.configurable_product_options. is_use_default | BOOLEAN | NULLABLE |
extension_attributes.configurable_product_options. values | RECORD | REPEATED |
extension_attributes.configurable_product_options.values. value_index | INTEGER | NULLABLE |
extension_attributes.configurable_product_options. product_id | INTEGER | NULLABLE |
extension_attributes. configurable_product_links | INTEGER | REPEATED |
extension_attributes. vertex_commodity_code | RECORD | NULLABLE |
extension_attributes.vertex_commodity_code. code | STRING | NULLABLE |
extension_attributes.vertex_commodity_code. type | STRING | NULLABLE |
product_links | RECORD | REPEATED |
product_links. sku | STRING | NULLABLE |
product_links. link_type | STRING | NULLABLE |
product_links. linked_product_sku | STRING | NULLABLE |
product_links. linked_product_type | STRING | NULLABLE |
product_links. position | INTEGER | NULLABLE |
product_links. extension_attributes | RECORD | NULLABLE |
product_links.extension_attributes. qty | INTEGER | NULLABLE |
options | RECORD | REPEATED |
options. product_sku | STRING | NULLABLE |
options. option_id | INTEGER | NULLABLE |
options. title | STRING | NULLABLE |
options. type | STRING | NULLABLE |
options. sort_order | INTEGER | NULLABLE |
options. is_require | BOOLEAN | NULLABLE |
options. price | FLOAT | NULLABLE |
options. price_type | STRING | NULLABLE |
options. sku | STRING | NULLABLE |
options. file_extension | STRING | NULLABLE |
options. max_characters | INTEGER | NULLABLE |
options. image_size_x | INTEGER | NULLABLE |
options. image_size_y | INTEGER | NULLABLE |
options. values | RECORD | REPEATED |
options.values. title | STRING | NULLABLE |
options.values. sort_order | INTEGER | NULLABLE |
options.values. price | FLOAT | NULLABLE |
options.values. price_type | STRING | NULLABLE |
options.values. sku | STRING | NULLABLE |
options.values. option_type_id | INTEGER | NULLABLE |
options. extension_attributes | RECORD | NULLABLE |
options.extension_attributes. vertex_flex_field | STRING | NULLABLE |
media_gallery_entries | RECORD | REPEATED |
media_gallery_entries. id | INTEGER | NULLABLE |
media_gallery_entries. media_type | STRING | NULLABLE |
media_gallery_entries. label | STRING | NULLABLE |
media_gallery_entries. position | INTEGER | NULLABLE |
media_gallery_entries. disabled | BOOLEAN | NULLABLE |
media_gallery_entries. types | STRING | REPEATED |
media_gallery_entries. file | STRING | NULLABLE |
media_gallery_entries. content | RECORD | REPEATED |
media_gallery_entries.content. base64_encoded_data | STRING | NULLABLE |
media_gallery_entries.content. type | STRING | NULLABLE |
media_gallery_entries.content. name | STRING | NULLABLE |
media_gallery_entries. extension_attributes | RECORD | REPEATED |
media_gallery_entries.extension_attributes. video_content | RECORD | REPEATED |
media_gallery_entries.extension_attributes.video_content. media_type | STRING | NULLABLE |
media_gallery_entries.extension_attributes.video_content. video_provider | STRING | NULLABLE |
media_gallery_entries.extension_attributes.video_content. video_url | STRING | NULLABLE |
media_gallery_entries.extension_attributes.video_content. video_title | STRING | NULLABLE |
media_gallery_entries.extension_attributes.video_content. video_description | STRING | NULLABLE |
media_gallery_entries.extension_attributes.video_content. video_metadata | STRING | NULLABLE |
tier_prices | RECORD | REPEATED |
tier_prices. customer_group_id | INTEGER | NULLABLE |
tier_prices. qty | FLOAT | NULLABLE |
tier_prices. value | FLOAT | NULLABLE |
tier_prices. extension_attributes | RECORD | NULLABLE |
tier_prices.extension_attributes. percentage_value | FLOAT | NULLABLE |
tier_prices.extension_attributes. website_id | INTEGER | NULLABLE |
custom_attributes | RECORD | REPEATED |
custom_attributes. attribute_code | STRING | NULLABLE |
custom_attributes. value | STRING | REPEATED |
# Konfiguracja
# Zanim zaczniesz
TIP
Upewnij się, że masz odpowiedni dostęp do sklepu Magento. Do konfiguracji modułu potrzebny będzie token API, który można wygenerować w panelu Magento zgodnie z następującą instrukcją: link (opens new window)
# Rozpocznij tworzenie modułu
Z menu po lewej stronie wybierz zakładkę Collect, następnie kliknij w przycisk Add new data collect
Z listy dostępnych modułów wybieramy Magento
# Początkowe ustawienia
W pierwszym kroku mamy do uzupełnienia jedno pole.
Collect name - nazwa naszego modułu. Będzie on widoczny pod tą nazwą w innych miejscach w platformie.
# Autoryzacja z Magento
W następnym kroku musimy nadać dostęp aplikacji WitCloud do Magento. Jest to konieczne aby WitCloud mógł zaciągnąć dane.
Aby to zrobić naciskamy na przycisk "Click here to authorize"
Wypełnij formularz autoryzacji z Magento.
Po prawidłowej autoryzacji kliknij przycisk Finish
# Ustawienie modułu w harmonogramie
Twój moduł Magento jest już utworzony w WitCloud 📊. Ostatnim krokiem jest ustalenie harmonogramu i uwzględnienie w nim naszego modułu. O tym jak to zrobić możesz przeczytać tutaj link (opens new window)