×

How It Works

The BirdDog Magento Connector monitors your data for updates (add, change, or delete) and sends that to Magento while also monitoring Magento for new orders.

New orders placed on Magento will go through the following workflow:

  1. New Order is placed on Magento
  2. Magento Connector downloads Order
  3. The sales order is invoiced and posted
  4. Magento Connector notifies Magento that the order has been shipped and uploads any tracking numbers

The location for the order line is checked in the following Order. If the location hasn't been set or is invalid (doesn't exist in this Item's Location list) then move onto the next one:

  • Item's Sales Location
  • Location from the Order's Ship To
  • Location from the Order's Customer
  • Connector location
  • Item's default location

The following data is uploaded to Magento:

  • Item Data
    • Item Number -> SKU
    • Item Description 1 and 2 or Short Description if PIM is in use -> Name
    • Price based on customer type from Connector Customer Type -> Price
    • Item Weight -> Weight
    • Item Country of Origin -> Country of Manufacture
  • Item Default Warehouse Stock Data -> stock_item.qty
  • Item Summary Stock Data -> stock_item.qty
  • Customer and Item Price codes -> Advanced Pricing
    • Special Pricing Note: Magento does not support tier price codes except for customers. It basically only supports customer and customer item price codes, and then the flat item price.
  • Customer Data
    • Email
    • First Name
    • Last Name
    • Address Data

The BirdDog Magento Connector monitors Magento for new Orders and downloads them:

  • Download from Magento to ERP:
    • New Customers
      • First and Last Name -> Name
      • Email
      • Default Billing Address Line 1 -> Address 1
      • Default Billing Address Line 2 -> Address 2
      • Default Billing Address City -> City
      • Default Billing Address State-> State
      • Default Billing Address Zip-> Zip
      • Default Billing Address Country-> Country
      • Default Billing Address Phone -> Phone
      • Connector Default Terms -> Terms
      • Connector Default Customer Type-> Customer Type
      • Connector Default Ship Via -> Ship Via
      • Connector Default Sales Person -> Sales Person
      • Connector Default Tax Code / Schedule -> Tax Code / Schedule
      • Connector Default Location -> Location
    • Orders
      • Notes
        • Orders canceled on Magento are ignored
      • Next sales order number in Order Entry -> Order Number
      • Customer number
        • Magento guest orders use the connector guest customer number
        • Connector Customer Number Setting
          • Next Customer Number - Get from Accounts Receivable
          • Guest Customer Number - Get from Connector
      • Customer Name -> Bill To Name
      • Billing Address Line 1 -> Bill To Address 1
      • Billing Address Line 2 -> Bill To Address 2
      • Billing Address Line 3 -> Bill To Address 3
      • Billing Address City -> Bill To City
      • Billing Address State-> Bill To State
      • Billing Address Zip-> Bill To Zip
      • Billing Address Country-> Bill To Country
      • Customer Name -> Ship To Name
      • Shipping Address Line 1 -> Ship To Address 1
      • Shipping Address Line 2 -> Ship To Address 2
      • Shipping Address Line 3 -> Ship To Address 3
      • Shipping Address City -> Ship To City
      • Shipping Address State-> Ship To State
      • Shipping Address Zip-> Ship To Zip
      • Shipping Address Country-> Ship To Country
      • Magento Order Id -> PO Number
      • Connector Location -> Location
      • Comments and Magento Order Id -> Comments
      • Freight
      • Tax
      • Payment
    • Order Lines
      • Item Number from linkage or SKU -> Item Number
      • Connector Location, if it doesn't exist for the item then Item's Default Location-> Location
      • Quantity Ordered
      • Price
      • Discount Amount / Quantity Ordered * Price -> Discount Percent