Adjust Stock in Magento MSI

Magento Multi-Source Inventory (MSI) (available on Magento 2.3) is undeniably a powerful tool for business owners to manage multiple physical locations. With MSI, business owners can manage stocks using multiple layers, including source, stock, and channel.

However, it’s a challenging system that takes time to get used to. Many retailers still struggle with how to utilize Magento 2.3 and MSI for their operations – for example, adjust stock.

In this article, we will walk you through some of the most popular methods to easily complete the Magento MSI stock adjustment.

Method 1: Import a CSV file directly to adjust stock in Magento MSI

This method is the most popular and utilizes the import function in Magento. Using a CSV file saves a lot of time when you have a large number of SKUs to adjust.

To import a CSV file to adjust stock in Magento MSI, you can follow the 6 steps below:

Step 1: Go to System > Data transfer > Import

Adjust stock in Magento MSI import CSV
Adjust stock in Magento MSI by importing CSV file

Step 2: Select Entity type: Stock sources

Adjust stock in Magento MSI by importing CSV file - select entity type
Adjust stock in Magento MSI by importing CSV file – select entity type

After you’ve selected Stock Sources, the system will display a sample file for you to download. To adjust stock in Magento MSI, your CSV file must contain the following information:

  • Source code: The code of the source that the change will be applied to;
  • SKU: The product SKU to be updated;
  • Status: 1 means enabled, 0 means disabled;
  • Quantity: The new SKU quantity.

Step 3: Select Import Behavior: Add/update

Adjust stock in Magento MSI by importing CSV file - select import behavior
Adjust stock in Magento MSI by importing CSV file – select import behavior

Step 4: Upload your CSV file
In this step, you can either select a file to import or use the file directory.

Step 5: Select the Check Data button

Step 6: Choose Import
After your data has been validated, Magento will return the result and display an Import button.

Adjust stock in Magento MSI by importing CSV file - CSV file validated
Adjust stock in Magento MSI by importing CSV file – CSV file validated

Select Import to continue the process. When the stock adjustment is complete, the system will display a notification.

Adjust stock in Magento MSI by importing CSV file - import complete
Adjust stock in Magento MSI by importing CSV file – import complete

Method 2: Manually adjust stock in Magento MSI using product catalog

You can use this method when you want to adjust stock for one or a few SKUs at the same time. To adjust stock in Magento 2.3 using product catalog, you can follow these 3 steps:
(Note: In this example, we’ve already assigned the product to the sources)

Step 1: Go to Products Catalog and select Edit for the product you want to adjust

Adjust stock in Magento MSI using product catalog - edit product
Adjust stock in Magento MSI using product catalog – edit product

Step 2: Adjust the quantity of the product in each source and click Save

Adjust stock in Magento MSI using product catalog - edit product quantity
Adjust stock in Magento MSI using product catalog – edit product quantity

Step 3: Double check the product catalog list:
If the stock adjustment in MSI is successful, you should see it directly in the product catalog.

Adjust stock in Magento MSI using product catalog - adjustment successful
Adjust stock in Magento MSI using product catalog – adjustment successful

Potential issues during stock adjustment with CSV import or manual edit

The two methods above are more suitable for small business with just a few Magento users. However, they can cause serious managerial problems for big companies with strict inventory process.

Specifically, if you adjust stock in Magento MSI using these two methods, you can’t keep a history of the stock adjustment. The adjustment can only be started and completed at that moment.

Another problem is the admin cannot create adjustment and save the details for later confirmation. As a result, it would be hard for the admin to know how the stock has been adjusted. They cannot see whether the stock has increased or decreased.

In addition, both methods only offer the ability to adjust stock by importing the new quantity of the product. In case you’ve just received new stock in your warehouse, you’ll have to find the new total of each product SKU in the purchased list to import into Magento 2.3.

Method 3: Adjust stock in Magento MSI using Magestore Solution

As first mover in the Magento market, Magestore has been the pioneer in Omnichannel POS Solution.

We’ve just added a new feature to our POS Enterprise edition for Magento 2.3 to help business owners adjust their stock conveniently. Our solution is designed in a simple way so users without any background in IT can perform stock adjustment easily.

Book a FREE demo with Magestore

Magestore Solution for Magento 2.3 comes with 3 options to select product(s) for stock adjustment in sources. Specifically, you can:

  • Scan product barcode to select the product(s);
  • Select product(s) from the catalog;
  • Import from a CSV file.
Magestore Adjust Stock feature for Magento 2.3
Magestore Adjust Stock feature for Magento 2.3

To adjust stock, admin simply has to select the source, the product(s), and apply the adjustment. You can even trace the history of all stock adjustment in the system.

But first, let’s take a closer look at the 4 steps to adjust stock in Magento 2.3.

Magestore Adjust Stock feature for Magento 2.3 - Stock adjustment process
Magestore Adjust Stock feature for Magento 2.3 – Stock adjustment process

Step 1: Select the source to adjust stock

In this step, you will select the source from the source list. In case you want to save the reason for adjusting stock, you can simply fill in the Reason field.

Magestore Adjust Stock feature for Magento 2.3 - create adjustment
Magestore Adjust Stock feature for Magento 2.3 – create adjustment

Step 2: Select product(s) to adjust quantity

In this step, Magestore Solution offers 3 different ways to select products:

Option 1: Scan barcode

In case all your products already have a barcode, this option saves you a lot of time compared to navigating the entire catalog to find the right products.

Magestore Adjust Stock feature for Magento 2.3 - scan barcode
Magestore Adjust Stock feature for Magento 2.3 – scan barcode

What’s even better is you can even scan a barcode that has not been assigned to the source. In doing so, once the product quantity has been updated, the product will be automatically assigned to the selected warehouse.

If you haven’t got a barcode system, you can easily generate or import your own barcode with Magestore Solution.

Option 2: Select product(s) from the product list

If you haven’t implemented a barcode system and don’t want to manually adjust one SKU at a time, this is the perfect solution.

Magestore Adjust Stock feature for Magento 2.3 - select product from list
Magestore Adjust Stock feature for Magento 2.3 – select product from list

Similar to the case of scanning barcode, you can select any product in the system to adjust stock, including those not assigned to the selected warehouse.

If you have any trouble finding the product on the list, you can always use the filter to minimize your effort.

Option 3: Import product(s) from a CSV file

Finally, if you prefer mass adjustment for many SKUs at a time, you can simply import a CSV file to the system. You can execute stock adjustment immediately, or just upload the CSV file for further adjustment.

What sets Magestore Solution apart from the core Magento feature? Our solution allows you to record the history of the adjustment. In addition, you can download a list of invalid SKU in case you have some errors in your CSV file. With this list, you can skip the exhausting process of going through the entire product list to identify the error(s).

Magestore Adjust Stock feature for Magento 2.3 - import product to adjust
Magestore Adjust Stock feature for Magento 2.3 – import product to adjust

Step 3: Adjust product quantity

You can adjust stock for each product by typing in New quantity or Adjust quantity. The system will automatically calculate the adjust quantity or the new quantity based on your input.

For example, if you currently have 20 items in stock, and type 1 into the Adjust Qty column, the system will automatically change the new Qty column to 21.

Magestore Adjust Stock feature for Magento 2.3 - adjust product quantity
Magestore Adjust Stock feature for Magento 2.3 – adjust product quantity

Step 4: Apply stock adjustment

In this step, after confirmation, the system will execute the stock adjustment and keep a record.

Other than the four steps mentioned above, you can also save a stock adjustment for later modification/execution. In case you no longer want to perform an unapplied adjustment, you can simply delete that stock adjustment from the system.

Managing stock adjustment history

In Magento 2.3, when a stock adjustment is complete, you can easily see the summary of the adjustment. You can also export a list of adjusted products.

Magestore Adjust Stock feature for Magento 2.3 - view stock adjustment detail
Magestore Adjust Stock feature for Magento 2.3 – view stock adjustment detail

You can see the list of all stock adjustment in your system, including completed and processing adjustment. Filters, custom view, and export functions are also available.

Magestore Adjust Stock feature for Magento 2.3 - view stock adjustment history
Magestore Adjust Stock feature for Magento 2.3 – view stock adjustment history

What’s the best stock adjustment method in MSI and Magento 2.3?

If you’re selling from both online and offline channels, Magestore Solution might be an ideal solution for you.

The Inventory Management system not only works well for your Magento backend and website, but also comes with a native Magento POS for your physical store.

With this solution, all data, such as product, promotion, inventory, will be synchronized seamlessly across your online and offline channels. When you adjust product quantity from Magento backend, the system will update the change to every POS system in your store.

If you’re considering a Retail Solution that allows you to manage your inventory and easily adjust stock level in Magento 2.3, don’t hesitate to book a consultation with us for more advice .

Happy selling!

Book a consultant from Magestore

How to Adjust stock in Magento MSI?
4 (80%) 1 vote

Leave a Reply

Your email address will not be published. Required fields are marked *