Connectors
Magento 1
Connectors
Magento 1
Description
Magento is a modern cloud commerce platform with an open-source ecosystem.
Connector Details
| Name | Value |
|---|---|
| Platform | Magento 1 |
| Auth Type | API Keys |
| Direction | Read |
Supported Data
See the table below for the list of data you can read with the Magento 1 connector.
| Table Name | Fields |
|---|---|
| orders | name, status, coupon_code, shipping_description, customer_id, base_discount_amount, base_grand_total, base_shipping_amount, base_shipping_tax_amount, base_subtotal, base_tax_amount, base_total_paid, base_total_refunded, discount_amount, grand_total, shipping_amount, shipping_tax_amount, store_to_order_rate, subtotal, tax_amount, total_paid, total_refunded, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, shipping_discount_amount, subtotal_incl_tax, total_due, increment_id, base_currency_code, discount_description, remote_ip, store_currency_code, store_name, created_at, addresses, order_items, order_comments |
| productcategories | product_id, category_id |
| products | name, entity_id, attribute_set_id, type_id, sku, manufacturer, size_format, tax_class_id, status, visibility, product_type, color, is_imported, remove_compare_link, ebizmarts_mark_visited, cjm_hideshipdate, eraser_shape, style_option, colour_option, paper_type, guest_hide_price, pack_size, price, weight, special_price, msrp, description, meta_keyword, short_description, searchindex_weight, custom_layout_update, mobile_description, cjm_stockmessage, useful_for, news_to_date, news_from_date, special_from_date, special_to_date, custom_design_from, custom_design_to, cjm_expecdate, cjm_preorderdate, meta_title, meta_description, options_container, size_inches, msrp_enabled, size_metric, msrp_display_actual_price_type, qty_per_pack, url_key, country_of_manufacture, product_barcode, isbn, custom_design, page_layout, cjm_stocktext, cjm_ships_in, cjm_preordertext, gift_message_available, xero_item_code, hs_code |
| stockitems | item_id, product_id, stock_id, qty, min_qty, use_config_min_qty, is_qty_decimal, backorders, use_config_backorders, min_sale_qty, use_config_min_sale_qty, max_sale_qty, use_config_max_sale_qty, is_in_stock, low_stock_date, notify_stock_qty, use_config_notify_stock_qty, manage_stock, use_config_manage_stock, stock_status_changed_auto, use_config_qty_increments, qty_increments, use_config_enable_qty_inc, enable_qty_increments, is_decimal_divided |