How It Works

×

The BirdDog WooCommerce Connector monitors your data for updates (add, change, or delete) and sends that to your WooCommerce-enabled WordPress site while also monitoring it for new orders using the V3 REST API documented at https://woocommerce.github.io/woocommerce-rest-api-docs/#introduction.

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

  1. New Order is placed on WooCommerce
  2. WooCommerce Connector downloads Order
  3. The sales order is invoiced and posted
  4. WooCommerce Connector notifies your site that the order has been shipped

Note: The item/location to use will come from the location set on the connector, if the item does not have this item/location then the item's default location will be used.

The following data is uploaded to your WooCommerce site:

  • Basic item data
    • Item number -> Product.sku
    • Item description 1 and 2 -> Product.name
    • Item short description -> Product.name (if using PIM)
    • Item long description -> Product.description(if using PIM)
    • Price based on customer type from Connector Customer Type -> Product.price
    • Price from the connector location -> Product.regular_price
    • Item taxable -> tax_status
    • Item control flag > manage_stock
    • Item quantity available for the item from the location on the connector > stock_quantity
    • Item backorders flag > backorders
    • Item weight -> weight
    • Item dimensions -> dimensions
  • Customers - WooCommerce is built to handle individuals, not organizations. Only customers with an email address and a first and last name in customer name will be uploaded, customers with a single name (ie. Google or Apple) will display a warning and not be uploaded.
    • Email -> Customer.email
    • Name -> Parsed into First and Last name and uploaded to Customer.first_name and last_name. For example, Bill Smith and Bill L. Smith will both be uploaded as Bill Smith while ABC Printing will be uploaded as First name - ABC, last name - Printing.
    • Address1 -> Customer.billing.address_1
    • Address2 -> Customer.billing.address_2
    • City -> Customer.billing.city
    • State-> Customer.billing.state
    • Zip -> Customer.billing.postcode
    • Phone -> Customer.billing.phone

The BirdDog WooCommerce Connector monitors your WooCommerce site for new Orders and downloads them:

  • Download from WooCommerce to your ERP:
    • New and updated customers
      • Accounts Receivable Next Customer Number -> Customer Number
      • Connector.Customer Type- > Customer Type
      • Connector.Terms - > Terms
      • Connector.Sales Person- > Sales Person
      • Connector.Ship Via- > Ship Via
      • Connector.Tax Code/Schedule- > Code/Schedule
      • Customer.billing.first_name and last_name -> Name
      • Customer.billing.address_1 -> Bill_To_Addr_1
      • Customer.billing.address_2 -> Bill_To_Addr_2
      • Customer.billing.city -> City
      • Customer.billing.state -> State
      • Customer.billing.zip -> Zip
      • Customer.billing.country -> Country
      • Customer.billing.phone-> Phone
    • Orders
      • Order Entry Next Order Number -> Order Number
      • Order.number -> PO Number
      • Order.number -> Comment
      • Order.customer_note -> Comment
      • Connector.Location -> Location
      • Customer.Sales Persons -> Sales Persons
      • Customer.Terms Code -> Terms Code
      • Customer.Ship Via Code -> Ship Via Code
      • Customer.Discount % -> Discount %
      • Customer.Currency Code -> Currency Code
      • Customer.Taxable -> Taxable
      • Customer.Form Number -> Form Number
      • Customer.Balance Method -> Balance Method
      • Customer.Profit Center and Department -> Profit Center and Department
      • Customer.Department -> Department
      • Order.billing.first_name and last_name -> Bill_To_Name
      • Order.billing.address_1 -> Bill_To_Addr_1
      • Order.billing.address_2 -> Bill_To_Addr_2
      • Order.billing.city, state, and zip -> Bill_To_Addr_3
      • Order.billing.country -> Bill_To_Country
      • Order.shipping.first_name and last_name -> Ship_To_Name
      • Order.shipping.address_1 -> Ship_To_Addr_1
      • Order.shipping.address_2 -> Ship_To_Addr_2
      • Order.shipping.city, state, and zip -> Ship_To_Addr_3
      • Order.shipping.country -> Ship_To_Country
      • Order.total_tax -> Sales Tax 1
      • Order.total -> if marked paid then written as a payment against the order
    • Order lines
      • OrderLineItem.sku -> Item Number
      • Connector.Location -> Location
      • OrderLineItem.quantity -> Quantity Ordered
      • OrderLineItem.price -> Price
      • Quantity to Ship is calculated based upon quantity on hand and existing allocations.