Mass Action Tool

This content is new and in-progress for MSI and includes content for "in development" and 1.0.0 Beta features. Information may change depending on development.

---

You can use the use the Mass Action tool to make quick updates across multiple products. This is helpful for transferring inventory between sources and removing a source without editing each product individually.

• Assign product sources - Add sources to multiple products.
• Transfer Inventory - Move all quantities of products from one source to another for Multi Source merchants.
• Unassign product sources - Remove sources from the products. Any inventory quantity assigned to that source is no longer available.

Currently, there are limitations for Default Source and Default Stock to remember when using mass actions:

• MSI Minimal Viable Product (MVP) release does not have Bundle and Grouped products support, support of these product types preserved only for Default Source/Default Stock which are pre-created by the system at the time on MSI installation, that's why Bundle and Grouped products could be assigned only to Default Source and Default Stock. In future releases of MSI, we will expand support for composite products.
• Merchant CAN NOT assign Default Source to Custom Stock. The root cause for this now is that building an index for Custom Stock, the system would not be able to handle Grouped and Bundle products which could be potentially assigned to Default Source
• Merchant CAN NOT assign Custom Sources to Default Stock. The root cause for this now is how the index for Default Stock is implemented. In MVP release of MSI the system re-uses Stock Status legacy index (cataloginventory_stock_status MySQL table) built by CatalogInventory module. MSI just wraps it with MySQL View to make index contract look the same as for other Multi Stock indexes created for custom stocks

         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,
         `legacy_stock_status`.`website_id` AS `website_id`,
         `legacy_stock_status`.`stock_id` AS `stock_id`,
         `legacy_stock_status`.`qty` AS `quantity`,
         `legacy_stock_status`.`stock_status` AS `is_salable`,
         `product`.`sku` AS `sku` 
         from 
         (
         	`cataloginventory_stock_status` `legacy_stock_status` 
         	join 
         	`catalog_product_entity` `product` 
         	on
         	((`legacy_stock_status`.`product_id` = `product`.`entity_id`))
     	 )

Based on the above a merchant can't start using Multi-Sourcing functionality simply by adding one more Custom Source and assigning it to Default Stock. To do that a merchant has to create new Custom Stock and a bunch of Custom Sources assigned to it, then fill these custom sources with inventory data (products with their stock per source). The simplest way of doing this is to use Mass Action Tool migrating existing data assigned to Default Source to custom ones.

Assign product sources

Use the Assign Sources tool to add one or more sources to your products. The tool helps when creating and assigning custom sources to your Default Stock or custom stocks and preparing new locations and inventory.

After adding new custom sources, you can add inventory quantities per product or for multiple products using the import feature. See MSI Import and Export Product Data for details.

1. On the Admin sidebar, tap Catalog. Then choose Products.

2. Select the products you want to modify sources. Browse or search to find the products and select those checkboxes.

3. Tap the Actions drop-down menu, and choose Assign Inventory Source. Tap OK to verify the Mass Action tool.

   Select products and assign sources

4. Select checkboxes for all sources you want to add to the products.

5. Tap Assign Sources.

   Add sources to selected products

The sources are added to the products with an inventory quantity of 0. You can add inventory amounts as available per source.

Transfer inventory to source

Depending on your business needs and status of location, Multi Source merchants may need to transfer product inventory from one source location to another. For example, you may be closing a warehouse location or no longer ship specific products from a location, moving all operations for those products to a new location.

This option allows you to select one or more products, the origin source to transfer inventory, and the destination source to receive quantities:

• Only inventory quantities for the selected source are moved.
• If a product does not have that source, it is skipped.
• All product inventory for the source is moved.

You have an option to also unassign the source when transferring inventory quantities.

To transfer inventory:

1. On the Admin sidebar, tap Catalog. Then choose Products.

2. Select products you want to transfer inventory. Browse or search to find the products and select those checkboxes.

3. Tap the Actions drop-down menu, and choose Transfer Inventory. Tap OK to verify the Mass Action tool.

   Select products to transfer inventory

4. Select the origin source to transfer products to a new destination. Tap Continue.

5. Select the destination source to transfer products to a new destination.

6. To remove the source from the products, select the optional checkbox Unassign from origin source after transfer.

   Select sources to transfer inventory

7. Tap Inventory Transfer. All product quantities are deducted from the origin source and added to the destination source. The Quantity and Salable Quantity automatically update.

Unassign product sources

When unassigning a source from a product, you are indicating the product will no longer be stocked at that location. This process will completely clear all inventory data for source currently assigned to the product. If you need to move the existing inventory to a new location, consider using the Transfer inventory option.

Important: When you unassign a source from a product, all source data including inventory amounts is removed from that product. This can affect salable quantities and reservations for unprocessed orders. After checkout and before shipment, all product quantities in the order have associated reservations. If you unassign a source, you can cause issues with reservations and processing orders.

We strongly recommend completing all orders and shipments for those products prior to removing the source.

1. On the Admin sidebar, tap Catalog. Then choose Products.

2. Select the products you want to modify sources. Browse or search to find the products and select those checkboxes.

3. Tap the Actions drop-down menu, and choose Unassign Inventory Source. Tap OK to verify the Mass Action tool.

   Select products and assign sources

4. Select the source you want to remove from the products.

5. Tap Unassign Sources. An alert displays that unassigning will remove all specific source and quantity data from the product.

6. To complete, click Unassign Sources.

   Remove sources from selected products