Product Availability: Calculation of Available Quantities

During the configuration of a BigCommerce store, you specify which item quantity in MYOB Advanced you want to be synchronized with the store for the items whose quantities are tracked. To do so, you select one of the following options in the Availability Mode box on the Inventory Settings tab of the BigCommerce Stores (BC201000) form:

  • On Hand: The system synchronizes the on-hand quantity stored at particular warehouses or warehouse locations.
  • Available for Shipping: The system synchronizes the quantity available for shipping, which is calculated as the quantity on hand minus the quantities shipped, minus the quantities allocated for sales, production, and service orders, minus the quantities in locations for which the Include in Qty. Available check box is cleared on the Locations tab of the Warehouses (IN204000) form, minus the quantities on issues that have not been released yet.
  • Available: The system synchronizes the available quantity. You can configure the way the available quantity is calculated by using an availability calculation rule. For more information, see Availability Calculation Rules: General Information.

You also select whether quantity calculations should include available quantities from all warehouses or from only the specified warehouses or warehouse locations. To do so, in the Warehouse Mode box on the Inventory Settings tab of the BigCommerce Stores form, you select one of the following options:

  • All Warehouses: To use for calculation the quantities of the item from all warehouses
  • Specific Warehouses: To use for calculation the quantities from only the specified warehouses or warehouse locations.

    When you select this option, the system displays a table in which you should specify the needed warehouses and warehouse locations. If you specify a warehouse but do not specify any of its locations, quantities available from the entire warehouse are used for quantity calculations. If you specify multiple warehouses and warehouse locations, the quantities available from all specified warehouses and warehouse locations are used for quantity calculations.

    Note: The functionality of multiple warehouses and multiple warehouse locations is available if the Multiple Warehouses and Multiple Warehouse Locations features are enabled on the Enable/Disable Features (CS100000) form.

If you have previously synchronized the Product Availability entity, when you modify any of the settings described in this section, the system resets the availability synchronization status for all items synchronized with the BigCommerce store, and you need to perform the full synchronization of the Product Availability entity again.