Product Availability: Calculation of Available Quantities

During the configuration of Acumatica ERP Retail-Commerce Edition, you can specify which item quantity in MYOB Advanced you want to be synchronized with the Shopify store for the items whose quantities are tracked. To do so, you select one of the following options in the Availability Mode box:

• 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 Shopify Stores (BC201010) form, you select one of the following options:

• All Warehouses: To calculate the available quantity of the item in the Shopify store based on the quantity of the item in all warehouses. If All Warehouses warehouse mode is selected and multiple locations exist in the Shopify store, the available quantities of items are synchronized with the first location created in the Shopify store.
• Specific Warehouses: To calculate the available quantity of the item based on the quantity in the selected warehouses and warehouse locations.

  When you select this option, the Warehouse Mapping for Inventory Export table appears below the Warehouse Mode box. In this table, you specify a list of warehouses and warehouse locations to be used the calculation of item availability. If multiple warehouse locations have been created in the Shopify store, you can specify which Shopify location should be updated with the availability data from a particular warehouse or warehouse location from MYOB Advanced.

  The Warehouse Mapping for Inventory Export table contains the following columns:

  • Warehouse (required): A warehouse from MYOB Advanced that holds inventory items whose availability data should be exported to the Shopify store. You can select a warehouse from the list of all active warehouses that have been created on the Warehouses (IN204000) form.
  • Location ID (optional): A warehouse location from MYOB Advanced that contains inventory items whose availability data should be exported to the Shopify store. You can select a warehouse location from the list, which contains the active locations that have been created on the Warehouses form for the warehouse selected in the Warehouse column of the row. If no location is selected, the system exports the availability data for items stored in all locations of the selected warehouse.
  • Shopify Location (required): The Shopify warehouse location to which the system will export availability data for inventory items from MYOB Advanced. You select a location from the list, which contains all the warehouse locations created in the Shopify store.

  If Specific Warehouses warehouse mode is selected and no values are specified in the Warehouse Mapping for Inventory Export table, the system will behave as it would if the All Warehouses mode was selected.

If you have 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 synchronized items in the Shopify store, and you need to perform the full synchronization of the Product Availability entity again.