×

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.

On the initial run of the WooCommerce connector, the system will first download any existing Items and Contacts on WooCommerce and create linkages for them. The purpose of this is to keep from having duplicates created for existing items.

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)
    • Pricing -> Wholesale Pro Suite
    • Price from the connector location -> Product.regular_price
    • Item taxable -> tax_status
    • Item quantity available for the item from the location on the connector -> you can set the connector to pull from specific properties and quantity available
      • Default Warehouse
      • Summary
      • None
    • Item backorders flag > backorders
    • Item weight ->
      • Normal Items - Weight
      • Kits and non-stocked items - the sum of components
    • Item cube dimensions -> dimensions
    • Linkages for Variant Items are also downloaded, though we currently do not support actually creating variant items on the local side, so they would need to be pre-generated first.
  • Contacts - WooCommerce is built to handle individuals, not organizations. Only contacts with an email address and a first and last name will be uploaded.
    • Email -> Contact.email
    • First Name -> Customer.first_name
    • Last Name -> Customer.last_name
    • Address1 -> Customer.billing.address_1
    • Address2 -> Customer.billing.address_2
    • City -> Customer.billing.city
    • State-> Customer.billing.state
    • Zip -> Customer.billing.postcode
    • Country -> Customer.country
    • Phone -> Customer.billing.phone
  • Posted Invoices
    • Sets the associated WooCommerce order status to "completed"
    • Uploads tracking information to order meta data

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 with a status in Connector Account.Order Statuses to Download
      • 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.Shipping Total -> Freight
      • 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.