search-icon

BigCommerce is a top-3 platform for e-commerce and provides a full package of services for e-store creation: sting, front-end design, SEO, payments and marketing tools needed to build an online store. Integration of DEAR Inventory module with BigCommerce allows our clients to get yet another powerful sales and promotional e-shop channel for growing their business.


Integration with BigCommerce pulls sales information to and from a BigCommerce online store to DEAR inventory management system and (if applicable) to a connected accounting system, as well as synchronising inventory and products.


Prerequisites

  • Knowledge about the Processing a Sale process (required)
  • Knowledge about Products and Product Management (required)
  • Master UserBigCommerce account with the following configured:
    • Products 
    • Shipping settings
    • Financial Settings (currencies, online & offline payment methods, taxation rules)
    • Partner Profile (allows to configure company information, customer service policies, shipping options, return policy, privacy policy and tax information)


Table of Contents


BigCommerce integration setup

[back to top]


First, you will need to create and configure a BigCommerce account (if you haven't already) and connect your BigCommerce store to DEAR. Your BigCommerce must have products, shipping settings, financial settings, and partner profile configured before integration DEAR. 


It is possible to link several BigCommerce stores to a single DEAR account, with each linked store having its own independent catalog, logs and settings. However, only two (2) free external integrations are available under DEAR's standard subscription plan. If you plan to integrate more than two (2) BigCommmerce stores or you have already integrated a couple of external platforms other than BigCommerce with DEAR, you will first need to purchase licenses for the additional external integrations under the My Subscription page.


Connecting to BigCommerce

[back to top]


There are two ways to connect to BigCommerce. You will need your store hash for both, which can be found on your BigCommerce portal URL. 


NOTE: It's possible to use one DEAR account with multiple BigCommerce stores (sale channels), but BigCommerce store can be connected to only one DEAR inventory.


Connect through the BigCommerce App Marketplace

[back to top]


NOTE: DEAR is currently pending application to be added to the BigCommerce App Marketplace. Please use Store API connection for now. 


Connect to DEAR through the BigCommerce marketplace (App API). 

  1. From your BigCommerce account, go to the App Marketplace (Store Control Panel → Apps → Marketplace → Apps)
  2. Search for DEAR Inventory and Install. It will now be visible in your apps.
  3. Launch DEAR from Store Control Panel → Apps → My Apps → Apps → DEAR Inventory → Launch. This will launch a new browser tab where you can open DEAR. 
  4. Grant access to DEAR. 
  5. Now, return to your DEAR account and navigate to Integration → BigCommerce.
  6. Click + to connect a new store
  7. Select Type of Connection: App API, enter the shop hash, and click Connect to BigCommerce.


Connecting to BigCommerce using API

[back to top]


Connect to DEAR by generating BigCommerce API credentials (Store API).

  1. From your BigCommerce account, go to the App Marketplace (Store Control Panel → Advanced Settings → API Accounts)
  2. Click Create API Account → Create API Token. A maximum of 50 accounts can be created per one BigCommerce store.
  3. Enter a name, such as DEAR Inventory. 
  4. Grant the highest level of access to DEAR for all options and Save.
  5. This generates a popup with API credentials. 
    • NOTE: Make a copy of this information, you cannot return to  it. If you lose this information you will have to create another API account to connect. 
  6. Make a note of your API credentials.
  7. Now, return to your DEAR account and navigate to Integration → BigCommerce.
  8. Click + to connect a new store
  9. Select Type of Connection: Store API. Enter your credentials and click Connect to BigCommerce.


Configure integration settings

[back to top]


Under the Setup tab, several integration settings can be customised.


General settings

[back to top]

 

Capture order when it is

This option specifies when a BigCommerce order will be captured: when it is created, when it is completed or when it is paid in BigCommerce. This setting is also taken into account for downloads of historical orders from BigCommerce.


Consolidate Orders

DEAR - BigCommerce Integration allows two options for order consolidation:

  • No Consolidation

  • Daily Consolidation.

No Consolidation indicates that sales will be captured from BigCommerce as they occur. Daily Consolidation will consolidate all orders from that day into a single order. DEAR will check for new sales to download once per hour.  


When Daily Consolidation is chosen, an additional setting becomes available: Consolidation Time. This is your local time when all pending orders aggregated during the day will be processed.


See the Pending Order Processing section below for more details.


Customer

For the pending order processing to be successful, an existing customer must be selected. The selected customer here is used when there is no available customer information in a sale order.


When the Consolidation Type is Daily Consolidation, this customer is used to create a new sale task which will combine all daily sales. A customer can be created in DEAR just for this purpose.


Regular Price Tier

BigCommerce offers two price tiers, Regular Price and Sale Price. Regular Price should be mapped to one of your DEAR price tiers here. 


Sale Price Tier

BigCommerce offers two price tiers, Regular Price and Sale Price. Sale Price should be mapped to one of your DEAR price tiers here. See Pricing and Price Tiers for more information.


Pick, Pack and Ship Processing Mode

When pending orders are processed by DEAR, new sale tasks are created. This setting tells DEAR if it should try to Auto Pick, Auto Pack and Auto Ship these tasks. If there is not enough stock on hand to pick the full quantity of products in an order, then Pick will remain in Draft state and Pack and Ship won’t be completed.


DEAR does not pick up shipment information from BigCommerce if auto-ship is selected and will not create fulfilment in BigCommerce in this scenario (if Auto Ship is enabled).


Process Auto-Assembly as

This dropdown field has two options:

  • For ordered quantity: Does not check stock quantity. An assembly order is created for the quantity specified in the sale order, regardless of stock availability. 
  • For minimum quantity required for picking: Assemble stock required to meet the quantity of specific sale order. 
    • If stock availability is negative, auto-assembly will produce a finished goods quantity which is more than the quantity ordered through sale order. 
    • If there is already stock available in inventory but not enough to fulfill the sale order quantity, auto-assembly will assemble the difference in quantity needed to meet the sale order requirement.
    • If stock availability exceeds sale order quantity, auto-assembly is not triggered. 

Stock availability is validated against the sale order location and does not take On Order quantity into account.


Link BigCommerce store to DEAR Location

Select a DEAR location to use for BigCommerce store sales fulfilment. Each BigCommerce store should have a dedicated Location within DEAR, which can be selected from the drop-down menu. One Location can be used for several stores. Selecting a particular warehouse limitss the availability of stock in BigCommerce to that location. If the default option All Locations is chosen DEAR will display consolidated stock quantities across all locations.


Account and cash settings

[back to top]


Invoice Status

This setting controls invoice status for sale tasks created as a result of pending order processing. By default, an invoice will not be authorised and will be in Draft state, waiting for adjustment and authorisation. However, if this setting is changed to AUTHORISED, the invoice will be automatically authorised and pending sync will be created for it to sync with an accounting application of your choice.


Optional Revenue Account

This is the revenue account to be used for all sales downloaded from BigCommerce. This will override settings at the Product/Customer level and any other account mapping.


Sales Representative Name

Select the sales representative from the list whose name will be specified for all sales captured by DEAR through this integration.


List products as Draft

This options lists all products as Draft on BigCommerce, thus allowing to review them first before activating them in DEAR. 


Update stock levels in BigCommerce

This setting controls if stock level updated automatically in BigCommerce store by DEAR at the time when available product quantity changes in DEAR. This may be useful for manual managing stock level in BigCommerce. 


NOTE: Please ensure you have the correct stock quantities entered in DEAR before you turn on this option as these values will override the stock quantities in BigCommerce.


Use BigCommerce as Master source for DEAR products

This option sets the direction of product data flow between DEAR and BigCommerce. When enabled, DEAR will not push product categories and brands to BigCommerce. Instead, products in DEAR should be updated with categories and brands from BigCommerce. This setting is on by default.


Export shipping information to BigCommerce

When this parameter is enabled, DEAR will push shipping information to BigCommerce.


Load Coupon Codes from BigCommerce

When enabled, this setting loads coupons from BigCommerce as a negative additional charge with the name of the related coupon in the sale comments field. If the setting is not enabled, the negative additional charge will be loaded with the name Discount.


Add Company to Address

Enable to add a company name to the address line for the order.


Map tax rules

[back to top]


When a pending order is processed by DEAR, a sale task is created. Each order and invoice line is assigned a tax rule. The tax rules specified in these settings will be used to create these lines.Click Load from BigCommerce to load a list of BigCommerce tax classes from the BigCommerce Store's Setup → Tax section and map each rule with a DEAR tax rule.


DEAR does not apply the tax rule to recalculate tax and is simply using the actual tax amount from the BigCommerce order. This means that if certain products are not taxable or with varying tax in BigCommerce, all data and totals in DEAR will look identical to BigCommerce, but with DEAR tax rule name selected in this setting. The Tax Free tax rule mapping specified in this setting is used to create these lines for non-taxable products. 


IMPORTANT!  Orders will be skipped on download if tax rules are not mapped.


Map payment methods

[back to top]

DEAR can capture payments made against orders in BigCommerce and is able to automatically add payments to a created sale invoice. To do this, Payment Account Mapping must be completed on this integration settings screen.  Click Load from BigCommerce to load payment methods from BigCommerce and map each one with an account which is able to receive payments from the chart of accounts.


This setting is not mandatory – if payment mapping is not completed, orders are still captured and downloaded from BigCommerce, but payments must be manually added to invoices in DEAR. Some customers prefer to keep invoices open and then reconcile them with payouts from BigCommerce.


Disconnect from BigCommerce

[back to top]


When you disconnect from the BigCommerce store, DEAR removes all associations between DEAR objects and BigCommerce, such as settings, catalog, pending orders & logs.


Product Catalog

[back to top]


The Catalog page allows users to manage the product catalog in BigCommerce. From here, users can download product information from the store to DEAR, list products from DEAR in the BigCommerce store, manage product status and update the store with stock level information.


From here you can Search catalog by entering SKU, Product Name and Category and Refresh to reload the catalog and show any new changes. 


Downloading products

[back to top]


Products can be loaded from BigCommerce to DEAR in the Catalog tab by clicking Download → Products. This operation may take some time. 


Products in BigCommerce can be downloaded as simple Products or as part of Product Family (i.e. Product Variations), similar to DEAR. BigCommerce allows an unlimited number of options, while DEAR allows only three. Due to this, only the first three options will be loaded per product from BigCommerce.


When downloading products from BigCommerce, DEAR should check if the product in BigCommerce is a single product or if it has multiple variations. If Products and Product Families have already been created/linked with BigCommerce, then DEAR updates the existing Products/Product Families instead of creating new ones.


In BigCommerce, Product SKU is optional whereas in DEAR it is mandatory. To resolve this, if the SKU field is empty in BigCommerce, DEAR skips this product.


BigCommerce has a hierarchical category structure, whereas DEAR has only one level of categories. Only the root categories in BigCommerce are linked to DEAR categories.


When downloading products, DEAR tries to avoid creating duplicates by first searching the existing products for matching items. This takes place in several steps:

  1. DEAR searches the product family by name using the BigCommerce product title.
  2. Then, for each variant, it searches the DEAR product by BigCommerce variant ID.
  3. If not found, it searches the DEAR product by BigCommerce product (or variant) SKU.

DEAR product names are unique but all BigCommerce product variations have the same name as the product family. Due to this, upon downloading products from BigCommerce, DEAR creates variation names from the BigCommerce Product name + Variant Option 1 Value + Variant Option 2 Value + Variant Option 3 Value, delimited by space. Variant options are only included in the name if they are defined for the BigCommerce Product. During product loading, DEAR automatically creates product categories for all product types in BigCommerce.


Data mapping for products between DEAR and BigCommerce is as follows:

DEAR 
BigCommerce 
SKU

Product or Product Variation SKU

NameProduct title
CategoryRoot Category
DescriptionProduct Description
WeightWeight
WidthWidth
HeightHeight
LengthDepth
Price Tier mapped for Regular Price. Default is Price Tier 1.Retail Price
Price Tier mapped for Sale Price. Default is Price Tier 2.Sale Price
Images

NOTE: Only downloaded when no images are attached to the product. Existing images will not be deleted.
Images
TagsTags/Keywords
QuantityQuantity
Sale Tax RuleTax Class
Custom FieldsFirst 10 product custom fields (except attributes used as options)
Option 1 Name Display name of first required option
Option 2 Name Display name of second required option
Option 3 Name Display name of third required option
Option 1 Value (for variation)Label for value related to option 1
Option 2 Value (for variation)Label for value related to option 2
Option 3 Value (for variation)Label for value related to option 3


Downloading customers

[back to top]


Download customers from the Catalog tab, Download → Customers. 


This function downloads all customers from BigCommerce to DEAR. If the customer already exists in DEAR, this function updates any details that have been changed in BigCommerce. As DEAR automatically creates customers when processing sales orders (if the No Consolidation option is selected in Integration Settings), this function is generally only used for testing purposes.


This function creates a customer in DEAR with Contact, Billing, and Business addresses captured from BigCommerce. 

NOTE: Uploading Customers from DEAR to BigCommerce is not possible.


List, unlist, and remove products on BigCommerce store

[back to top]


There are two possible statuses for products in the Catalog: Not Listed and Listed. Stock level synchronisation can be enabled or disabled for individual products from the Catalog. 


The Catalog tab allows products to be listed, unlisted, and removed individually. See List products in bulk to list larger quantities of products at a time. 


NOTE: Updating products from the catalog will update the stock level in BigCommerce regardless of the Update Stock Levels in BigCommerce setting status.


To list a product on BigCommerce:

  1. Click on the product in the Catalog tab. 
  2. In the pop-up window, click List on BigCommerce.
  3. Save your changes.


To update a product on BigCommerce:

  1. Click on the product in the Catalog tab. 
  2. In the pop-up window, click Update on BigCommerce.
  3. Save your changes.


To unlink a product on BigCommerce: 

  1. Click on the product in the Catalog tab. 
  2. Click Unlink.
  3. Save your changes.

Unlink breaks the link between the BigCommerce product and DEAR product but does not remove the product from BigCommerce.


To remove a product from BigCommerce:

  1. Click on the product in the Catalog tab. 
  2. Click Remove from BigCommerce.
  3. Save your changes.

Remove removes the product from BigCommerce.


List products in bulk

[back to top]


Aside from listing of individual products, products can be listed in bulk. If products are already listed, this action will update them.


To list products on BigCommerce in bulk:

  1. Go to the Bulk Listing tab.
  2. Select products to upload in bulk. You can select products by Category, Brand, Family, Product Tag, Listing Status, Products listed in (another sales channel or store), and through manual search.

NOTE: If you have multiple stores in another sales channel, e.g. two different BigCommerce stores, these will be displayed separately in the list of sales channels from which products can be selected for upload.

  1. Click List to upload all selected products.
  2. You can also select Unlist to remove selected products from BigCommerce or Unlink to break the link between BigCommerce product and DEAR product (but not remove the product from BigCommerce).


Sync stock levels with BigCommerce

[back to top]


NOTE: Updating products from the catalog will update the stock level in BigCommerce regardless of the Update Stock Levels in BigCommerce setting status.



Orders and sales

[back to top]


Processing pending orders

[back to top]


When a BigCommerce store is connected to DEAR, automatic notifications are triggered whenever the following happens:

  • A BigCommerce order is created
  • A BigCommerce order status is changed
  • A BigCommerce order is deleted.

Depending on the Order Capture setting selected, DEAR will capture a BigCommerce order and save it as a Pending order when the order is created, completed or paid. 


Whenever a sale is captured from BigCommerce, it is first placed into Pending Orders, and stock is allocated immediately. DEAR imports new orders immediately as individual sale orders (if No Consolidation is selected in the Integration Settings), or once a day as a consolidated sale order (if Daily Consolidation is selected).


If No Consolidation is selected, each BigCommerce sale is converted into an identical sale in DEAR, keeping the same customer and shipping information. If Daily Consolidation is selected, the single daily sale task will use the customer selected in the integration settings, and customer, billing, and shipping information imported from BigCommerce will be ignored.


When a BigCommerce order is cancelled or deleted, DEAR automatically finds and voids the corresponding sale task, if created, or removes the associated pending order if the order has not been processed yet.


When processing orders, the logic is identical to that in DEAR. Drop shipping, kitting, and other important scenarios are implemented in the same way as in DEAR.


Pending Orders can be processed manually by clicking Process. They can then be viewed in the Log tab.


Downloading orders and payments

[back to top]


Orders are automatically downloaded if their status in BigCommerce is changed (for example, a customer pays for an order).


NOTE: Generally, you do not need to trigger manual order download. However, if an order was not captured by DEAR, or to load historical sales, you can use the manual Load Order option in the Pending Orders tab.


Any imported order is saved to the Pending Orders section. It is a temporary storage of all sales and payments in DEAR. If an order already has an entry in the Log, i.e. if it was imported previously, it will be skipped. This guarantees that no duplicate sales will be created by DEAR.


While saving orders, DEAR captures customer information, billing, and shipping addresses. All line items are captured together with quantities, prices, and totals. Total order discounts are applied as additional charges to the whole order, without distribution by lines, to reduce the chance of discrepancy. Shipping, gift wrapping, and handling are also saved as additional charges on the invoice. 


For each line in a Sale, DEAR attempts to locate the corresponding product by SKU. If no product is found, DEAR attempts to download the sold product information from BigCommerce with the same logic as described in the Downloading Products section. If a matching product is still not found, DEAR marks this line as a Service (Non-product). After that, the sale is saved to pending orders containing all the data imported from BigCommerce: Tax, Quantity, and Total.


If a Payment Account has been specified in the Integration Settings, DEAR will always assign associated payments to the captured BigCommerce orders.


When a BigCommerce order is cancelled, DEAR automatically finds and voids the corresponding sale task if already created as a Sale Order or just removes the associated pending order if not yet processed.


The final step in the order download is to trigger the update of stock levels in other BigCommerce stores and other connected eCommerce channels.


Updating fulfilment in BigCommerce

[back to top]


When shipment is authorised in DEAR and the carrier specified, DEAR will try to create order shipment information in BigCommerce. This will only work in the No Consolidation processing mode. 


Shipping information is exported to BigCommerce when order has status ‘Processing’ or ’OnHold’. Only one tracking number is exported (e.g. orders with multiple packages will export a single tracking number). 


Logs

[back to top]


Each captured BigCommerce order, once saved to Pending Orders, creates a Log entry to track the link between the Sale in DEAR and in BigCommerce. This eliminates the possibility of creating duplicated orders when capturing the same order several times during manual order load. 


Each Log entry has a link to the sale task in DEAR. Depending on the settings selected by the user in the Setup tab, this sales task could be draft or authorised, one or more of the Pick, Pack and Ship tabs could be authorised, and payment could have been applied to the invoice.


Log entries allow you to see which sale task reflects a particular BigCommerce sale. You also have the option to delete a Log entry manually. This will allow reprocessing an order if required. 


NOTE: Deleting a log entry will not void or delete its associated sale task.


Reloading orders from BigCommerce

[back to top]


If for any reason you need to reload an order from BigCommerce, this can be managed in DEAR.

  1. Void the sale task. A record of this will be kept in DEAR for reconciliation purposes but the transactional data will be deleted. 
  2. Return to the BigCommerce integration Log tab and delete the Log entry. This will allow the order to be recaptured from BigCommerce.
  3. Navigate to the Pending Orders tab and click Load Orders, making sure the date is set to before the order to reload was made.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.