How It Works

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

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

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

1. A new Order is placed on BigCommerce
2. The BigCommerce connector downloads the order
3. The sales order is invoiced and posted in the ERP
4. The BigCommerce connector notifies BigCommerce that the order has been shipped

Note: The item/location to use on sales orders 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 BigCommerce 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 Connector.Customer Type -> Item Price
  • Price based on each Customer Type -> Price List (This requires a BigCommerce Enterprise license)
  • Price from the connector location -> List Price
  • Item taxable -> tax_status
  • Item quantity available for the item from the location on the connector -> stock_quantity
  • Item backorders flag > backorders
  • Item weight ->
    
    • Normal Items - Weight
    • Kits and non-stocked items - sum of components
  • Item cube dimensions -> dimensions
• Contacts - BigCommerce 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 BigCommerce order status to "completed"
  • Uploads tracking information

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

• Download from BigCommerce to your ERP:
  
  • New and updated customers
    • Customer number based on existing linkage or Connector setup if new -> 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.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.