Magento 2 - Bestellungen abrufen
Vorlage zum Abrufen von Bestellungen aus Magento 2.
Diese Vorlage zeigt, wie man Aufträge aus Magneto 2 abruft. Die Aufträge werden in einem Master-Child datastore für die weitere Verarbeitung gespeichert. Die Auftragsdaten lassen sich dann anschließend zu einem Warenwirtschaftsystem oder zu einem Lieferanten (Dropshipping) exportieren.
Installiert folgende Komponenten:
- 1 Projekt mit Beispielflows, welche Sie an Ihre Anforderungen anpassen können.
- 2 Datastore Schemas.
- 2 Datastores.
- Beispiel-Daten für 2 Datastores.
Flows
Hier sehen Sie eine Vorschau der Flows, die mit dieser Vorlage installiert werden.
Magento2GetOrders-Beispielflow
Dieser Flow holte Auftragsdaten von Magento und speichert die Auftragskopfdaten in den datastore Magento2-OrderHeader (Master) und die dazugehörigen Auftragspositionen in den datastore Magento2-OrderItems (Child).
Datastore Schemas
Es werden Datastores mit folgenden Schemas installiert:
Magento2_OrderHeader-Schema
Felder anzeigen
name
entity_id
increment_id
applied_rule_ids
base_currency_code
base_discount_amount
base_discount_invoiced
base_grand_total
base_discount_tax_compensation_amount
base_discount_tax_compensation_invoiced
base_shipping_amount
base_shipping_discount_amount
base_shipping_incl_tax
base_shipping_invoiced
base_shipping_tax_amount
base_subtotal
base_subtotal_incl_tax
base_subtotal_invoiced
base_tax_amount
base_tax_invoiced
base_total_due
base_total_invoiced
base_total_invoiced_cost
base_total_paid
base_to_global_rate
base_to_order_rate
billing_address_id
created_at
customer_dob
customer_email
customer_firstname
customer_gender
customer_group_id
customer_id
customer_is_guest
customer_lastname
customer_note_notify
discount_amount
discount_invoiced
global_currency_code
grand_total
discount_tax_compensation_amount
discount_tax_compensation_invoiced
is_virtual
order_currency_code
protect_code
quote_id
shipping_amount
shipping_description
shipping_discount_amount
shipping_discount_tax_compensation_amount
shipping_incl_tax
shipping_invoiced
shipping_tax_amount
state
status
store_currency_code
store_id
store_name
store_to_base_rate
store_to_order_rate
subtotal
subtotal_incl_tax
subtotal_invoiced
tax_amount
tax_invoiced
total_due
total_invoiced
total_item_count
total_paid
total_qty_ordered
updated_at
weight
billing_address_address_type
billing_address_city
billing_address_country_id
billing_address_customer_address_id
billing_address_email
billing_address_entity_id
billing_address_firstname
billing_address_lastname
billing_address_parent_id
billing_address_postcode
billing_address_region_code
billing_address_region_id
billing_address_street
billing_address_telephone
payment_account_status
payment_additional_information
payment_amount_ordered
payment_amount_paid
payment_base_amount_ordered
payment_base_amount_paid
payment_base_shipping_amount
payment_base_shipping_captured
payment_cc_last4
payment_entity_id
payment_method
payment_parent_id
payment_shipping_amount
payment_shipping_captured
shipping_method
shipping_address_address_type
shipping_address_city
shipping_address_country_id
shipping_address_customer_address_id
shipping_address_email
shipping_address_entity_id
shipping_address_firstname
shipping_address_lastname
shipping_address_parent_id
shipping_address_postcode
shipping_address_region_code
shipping_address_region_id
shipping_address_street
shipping_address_telephone
shipping_total_base_shipping_amount
shipping_total_base_shipping_discount_amount
shipping_total_base_shipping_incl_tax
shipping_total_base_shipping_invoiced
shipping_total_base_shipping_tax_amount
shipping_total_shipping_amount
shipping_total_shipping_discount_amount
shipping_total_shipping_discount_tax_compensation_amount
shipping_total_shipping_incl_tax
shipping_total_shipping_invoiced
shipping_total_shipping_tax_amount
adjustment_negative
adjustment_positive
base_adjustment_negative
base_adjustment_positive
base_discount_refunded
base_discount_tax_compensation_refunded
base_shipping_refunded
base_shipping_tax_refunded
base_subtotal_refunded
base_tax_refunded
base_total_offline_refunded
base_total_refunded
discount_refunded
discount_tax_compensation_refunded
shipping_refunded
shipping_tax_refunded
subtotal_refunded
tax_refunded
total_offline_refunded
total_refunded
billing_address_region
payment_amount_refunded
payment_base_amount_refunded
payment_base_shipping_refunded
payment_shipping_refunded
shipping_address_region
shipping_total_base_shipping_refunded
shipping_total_base_shipping_tax_refunded
shipping_total_shipping_refunded
shipping_total_shipping_tax_refunded
email_sent
payment_cc_exp_year
payment_cc_ss_start_month
payment_cc_ss_start_year
base_discount_canceled
base_shipping_canceled
base_subtotal_canceled
base_tax_canceled
base_total_canceled
discount_canceled
shipping_canceled
subtotal_canceled
tax_canceled
total_canceled
shipping_total_base_shipping_canceled
shipping_total_shipping_canceled
customer_prefix
billing_address_prefix
shipping_address_company
shipping_address_prefix
remote_ip
entity_id
increment_id
applied_rule_ids
base_currency_code
base_discount_amount
base_discount_invoiced
base_grand_total
base_discount_tax_compensation_amount
base_discount_tax_compensation_invoiced
base_shipping_amount
base_shipping_discount_amount
base_shipping_incl_tax
base_shipping_invoiced
base_shipping_tax_amount
base_subtotal
base_subtotal_incl_tax
base_subtotal_invoiced
base_tax_amount
base_tax_invoiced
base_total_due
base_total_invoiced
base_total_invoiced_cost
base_total_paid
base_to_global_rate
base_to_order_rate
billing_address_id
created_at
customer_dob
customer_email
customer_firstname
customer_gender
customer_group_id
customer_id
customer_is_guest
customer_lastname
customer_note_notify
discount_amount
discount_invoiced
global_currency_code
grand_total
discount_tax_compensation_amount
discount_tax_compensation_invoiced
is_virtual
order_currency_code
protect_code
quote_id
shipping_amount
shipping_description
shipping_discount_amount
shipping_discount_tax_compensation_amount
shipping_incl_tax
shipping_invoiced
shipping_tax_amount
state
status
store_currency_code
store_id
store_name
store_to_base_rate
store_to_order_rate
subtotal
subtotal_incl_tax
subtotal_invoiced
tax_amount
tax_invoiced
total_due
total_invoiced
total_item_count
total_paid
total_qty_ordered
updated_at
weight
billing_address_address_type
billing_address_city
billing_address_country_id
billing_address_customer_address_id
billing_address_email
billing_address_entity_id
billing_address_firstname
billing_address_lastname
billing_address_parent_id
billing_address_postcode
billing_address_region_code
billing_address_region_id
billing_address_street
billing_address_telephone
payment_account_status
payment_additional_information
payment_amount_ordered
payment_amount_paid
payment_base_amount_ordered
payment_base_amount_paid
payment_base_shipping_amount
payment_base_shipping_captured
payment_cc_last4
payment_entity_id
payment_method
payment_parent_id
payment_shipping_amount
payment_shipping_captured
shipping_method
shipping_address_address_type
shipping_address_city
shipping_address_country_id
shipping_address_customer_address_id
shipping_address_email
shipping_address_entity_id
shipping_address_firstname
shipping_address_lastname
shipping_address_parent_id
shipping_address_postcode
shipping_address_region_code
shipping_address_region_id
shipping_address_street
shipping_address_telephone
shipping_total_base_shipping_amount
shipping_total_base_shipping_discount_amount
shipping_total_base_shipping_incl_tax
shipping_total_base_shipping_invoiced
shipping_total_base_shipping_tax_amount
shipping_total_shipping_amount
shipping_total_shipping_discount_amount
shipping_total_shipping_discount_tax_compensation_amount
shipping_total_shipping_incl_tax
shipping_total_shipping_invoiced
shipping_total_shipping_tax_amount
adjustment_negative
adjustment_positive
base_adjustment_negative
base_adjustment_positive
base_discount_refunded
base_discount_tax_compensation_refunded
base_shipping_refunded
base_shipping_tax_refunded
base_subtotal_refunded
base_tax_refunded
base_total_offline_refunded
base_total_refunded
discount_refunded
discount_tax_compensation_refunded
shipping_refunded
shipping_tax_refunded
subtotal_refunded
tax_refunded
total_offline_refunded
total_refunded
billing_address_region
payment_amount_refunded
payment_base_amount_refunded
payment_base_shipping_refunded
payment_shipping_refunded
shipping_address_region
shipping_total_base_shipping_refunded
shipping_total_base_shipping_tax_refunded
shipping_total_shipping_refunded
shipping_total_shipping_tax_refunded
email_sent
payment_cc_exp_year
payment_cc_ss_start_month
payment_cc_ss_start_year
base_discount_canceled
base_shipping_canceled
base_subtotal_canceled
base_tax_canceled
base_total_canceled
discount_canceled
shipping_canceled
subtotal_canceled
tax_canceled
total_canceled
shipping_total_base_shipping_canceled
shipping_total_shipping_canceled
customer_prefix
billing_address_prefix
shipping_address_company
shipping_address_prefix
remote_ip
Magento2_OrderItems-Schema
Felder anzeigen
name
items_order_id
items_item_id
items_identifier
items_sku
items_name
items_amount_refunded
items_base_amount_refunded
items_base_discount_invoiced
items_base_discount_tax_compensation_invoiced
items_base_price
items_base_row_invoiced
items_base_row_total
items_base_tax_invoiced
items_created_at
items_discount_invoiced
items_free_shipping
items_discount_tax_compensation_invoiced
items_is_qty_decimal
items_no_discount
items_original_price
items_price
items_product_id
items_product_type
items_qty_canceled
items_qty_invoiced
items_qty_ordered
items_qty_refunded
items_qty_shipped
items_row_invoiced
items_row_total
items_store_id
items_tax_invoiced
items_updated_at
items_weight
items_base_discount_refunded
items_base_discount_tax_compensation_refunded
items_base_tax_refunded
items_discount_refunded
items_discount_tax_compensation_refunded
items_tax_refunded
items_weee_tax_applied
items_applied_rule_ids
items_base_discount_amount
items_base_discount_tax_compensation_amount
items_base_original_price
items_base_price_incl_tax
items_base_row_total_incl_tax
items_base_tax_amount
items_discount_amount
items_discount_percent
items_discount_tax_compensation_amount
items_is_virtual
items_price_incl_tax
items_quote_item_id
items_row_total_incl_tax
items_row_weight
items_tax_amount
items_tax_percent
items_discount_tax_compensation_canceled
items_tax_canceled
items_order_id
items_item_id
items_identifier
items_sku
items_name
items_amount_refunded
items_base_amount_refunded
items_base_discount_invoiced
items_base_discount_tax_compensation_invoiced
items_base_price
items_base_row_invoiced
items_base_row_total
items_base_tax_invoiced
items_created_at
items_discount_invoiced
items_free_shipping
items_discount_tax_compensation_invoiced
items_is_qty_decimal
items_no_discount
items_original_price
items_price
items_product_id
items_product_type
items_qty_canceled
items_qty_invoiced
items_qty_ordered
items_qty_refunded
items_qty_shipped
items_row_invoiced
items_row_total
items_store_id
items_tax_invoiced
items_updated_at
items_weight
items_base_discount_refunded
items_base_discount_tax_compensation_refunded
items_base_tax_refunded
items_discount_refunded
items_discount_tax_compensation_refunded
items_tax_refunded
items_weee_tax_applied
items_applied_rule_ids
items_base_discount_amount
items_base_discount_tax_compensation_amount
items_base_original_price
items_base_price_incl_tax
items_base_row_total_incl_tax
items_base_tax_amount
items_discount_amount
items_discount_percent
items_discount_tax_compensation_amount
items_is_virtual
items_price_incl_tax
items_quote_item_id
items_row_total_incl_tax
items_row_weight
items_tax_amount
items_tax_percent
items_discount_tax_compensation_canceled
items_tax_canceled
Schneller loslegen mit Vorlagen
Vorlagen sind Beispiel-Flows, die als Basis für bestimmte Anwendungsfälle dienen - wie diese hier für Magento 2.
Dadurch muss man nicht von Null beginnen, sondern in der Regel nur noch Zugangsdaten oder einige Optionen konfigurieren.
Mit Synesty als No Code Middleware verbinden Sie Ihre Systeme, Schnittstellen und APIs ohne Programmierung per Drag&Drop.
Automatisieren Sie Geschäftsprozesse und Integrationen wie EDI Datenimport / Export oder eine einmalige Daten-Migration.
Wir unterstützen Datenformate wie CSV, Excel (XLS/XLSX), XML oder JSON und ermöglichen auch HTTP-Konnektoren zu REST- oder GraphQL-APIs. Kunden nutzen es auch für Auswertungen, ETL-Aufgaben oder Feed-Optimierung.
Unser No Code Flow-Editor und unsere Low Code Scripting Tools ermöglichen kreative Anpassungen für jede Art von Integration.