Magento 2

Get started with the Magento 2 connector!

Description

Magento is a modern cloud commerce platform with an open-source ecosystem.

Connector Details

NameValue
PlatformMagento 2
Auth TypeAPI Keys
DirectionBidirectional
Unified SchemaSupported in Ecommerce Unified Schema

Supported Data

See the table below for the list of data you can read with the Magento 2 connector.

Table NameFields
categories
id, parent_id, name, is_active, position, level, children, created_at, updated_at, path, include_in_menu, available_sort_by, custom_attributes
coupons
coupon_id, rule_id, code, usage_limit, times_used, is_primary, type
orders
adjustment_negative, adjustment_positive, applied_rule_ids, base_adjustment_negative, base_adjustment_positive, base_currency_code, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_discount_tax_compensation_amount, base_discount_tax_compensation_invoiced, base_discount_tax_compensation_refunded, base_shipping_amount, base_shipping_canceled, base_shipping_discount_amount, base_shipping_discount_tax_compensation_amnt, base_shipping_incl_tax, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_incl_tax, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_total_canceled, base_total_due, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, base_to_global_rate, base_to_order_rate, billing_address_id, can_ship_partially, can_ship_partially_item, coupon_code, created_at, customer_dob, customer_email, customer_firstname, customer_gender, customer_group_id, customer_id, customer_is_guest, customer_lastname, customer_middlename, customer_note, customer_note_notify, customer_prefix, customer_suffix, customer_taxvat, discount_amount, discount_canceled, discount_description, discount_invoiced, discount_refunded, edit_increment, email_sent, entity_id, ext_customer_id, ext_order_id, forced_shipment_with_invoice, global_currency_code, grand_total, discount_tax_compensation_amount, discount_tax_compensation_invoiced, discount_tax_compensation_refunded, hold_before_state, hold_before_status, increment_id, is_virtual, order_currency_code, original_increment_id, payment_authorization_amount, payment_auth_expiration, protect_code, quote_address_id, quote_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_amount, shipping_canceled, shipping_description, shipping_discount_amount, shipping_discount_tax_compensation_amount, shipping_incl_tax, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, state, status, store_currency_code, store_id, store_name, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_incl_tax, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_due, total_invoiced, total_item_count, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, updated_at, weight, x_forwarded_for, items, billing_address, payment, status_histories, extension_attributes
product_item_stocks
id, item_id, product_id, stock_id, qty, is_in_stock, is_qty_decimal, show_default_notification_message, use_config_min_qty, min_qty, use_config_min_sale_qty, min_sale_qty, use_config_max_sale_qty, max_sale_qty, use_config_backorders, backorders, use_config_notify_stock_qty, notify_stock_qty, use_config_qty_increments, qty_increments, use_config_enable_qty_inc, enable_qty_increments, use_config_manage_stock, manage_stock, low_stock_date, is_decimal_divided, stock_status_changed_auto
products
id, sku, name, attribute_set_id, price, status, visibility, type_id, created_at, updated_at, weight, extension_attributes, product_links, options, media_gallery_entries, tier_prices, custom_attributes
salerules
rule_id, name, store_labels, description, website_ids, customer_group_ids, from_date, uses_per_customer, is_active, condition, action_condition, stop_rules_processing, is_advanced, sort_order, simple_action, discount_amount, discount_step, apply_to_shipping, times_used, is_rss, coupon_type, use_auto_generation, uses_per_coupon, simple_free_shipping, extension_attributes

Credentials Setup

Follow the steps below to get the credentials you need to use the Magento 2 connector.

The Magento connector requires three fields. If you do not have Magento credentials, contact us about using the hotglue testing account.

  1. Store URL - The Store URL is usually the domain that is assigned to your IP address. This is usually the root. If you do not yet have a domain, your store URL will include a series of four numbers, each separated by a period in dotted quad notation.
  2. Username - This is the username you use to log into your Magento account
  3. Password - This is the password you use to log into your Magento account