Inventory Management provides commands to manage inventory data and configuration settings.
These commands include:
- Checking and resolving reservation inconsistencies affecting salable quantity
- Adding geocodes for the Distance Priority algorithm
Resolve reservations inconsistencies
Reservations place a salable quantity hold for product SKUs per stock. When you ship, add products, cancel, or refund an order, compensation reservations enter to place or clear these holds.
Inventory Management provides two commands to check and resolve reservation inconsistencies:
What causes reservation inconsistencies?
Inventory Management generates reservations for key events:
- Order placement (initial reservation)
- Order shipment (compensation reservation)
- Refund order or issue a credit memo (compensation reservation)
- Order cancellation (compensation reservation)
Reservation inconsistencies may occur when Inventory Management loses the initial reservation and enters too many reservation compensations (overcompensating and leading to inconsistent amounts), or correctly places the initial reservation but loses compensational reservations.
The following configurations and events can cause reservation inconsistencies:
- Upgrade Magento to 2.3.x with orders not in a final state (Complete, Canceled, or Closed). Inventory Management will create compensational reservations for these orders, but it will not enter or have the initial reservation that deducts from the salable quantity. We recommend using these commands after upgrading to Magento v2.3.x from 2.1.x or 2.2.x. If you have pending orders, the commands correctly update your salable quantity and reservations for sales and order fulfillment.
- You do not manage stock then later change this configuration. You may start using 2.3.x with Manage Stock set to “No” in the Magento configuration. Magento does not place reservations at order placement and shipment events. If you later enable the Manage Stock configuration and some orders were created at that time, the Salable Qty would be corrupted with compensation reservation when you handle and fulfill that order.
- You re-assign the Stock for a Website while orders submit to that website. The initial reservation enters for the initial stock and all compensational reservation enter to the new stock.
- The sum total of all reservations may not resolve to
0. All reservations in the scope of an Order in a final state (Complete, Canceled, Closed) should resolve to
0, clearing all salable quantity holds.
List inconsistencies command
list-inconsistencies command detects and lists all reservation inconsistencies. Use the command options to check only completed or incomplete orders, or all.
1 bin/magento inventory:reservation:list-inconsistencies
--complete-orders- Returns inconsistencies for completed orders. Incorrect reservations may still be on hold for completed orders.
--incomplete-orders- Returns inconsistencies for incomplete orders (partially shipped, unshipped). Incorrect reservations may hold too much or not enough salable quantity for the orders.
--raw- Raw output.
-r return in
- Order ID indicates the scope of the inconsistency.
- SKU indicates the product with the inconsistency.
- Quantity sets the amount to enter for the reservation compensation.
- Stock ID defines to scope for stock, which uses the reservations to calculate salable quantity.
1 2 3 4 5 bin/magento inventory:reservation:list-inconsistencies Inconsistencies found on following entries: Order 172: - Product bike-123 should be compensated by +2.000000 for stock 1
1 2 3 bin/magento inventory:reservation:list-inconsistencies -r 172:bike-123:+2.000000:1
If no issues are found, this message returns: No order inconsistencies were found.
Create compensations command
create-compensations command creates compensation reservations. Depending on the issue, new reservations are created to either place or release a hold on salable quantity.
To create reservations, provide compensations using the format
<ORDER_INCREMENT_ID>:<SKU>:<QUANTITY>:<STOCK-ID> such as
1 bin/magento inventory:reservation:create-compensations
--complete-orders- Creates reservations for completed order inconsistencies.
--incomplete-orders- Creates reservations for incomplete order inconsistencies.
--raw- Returns raw output.
--dry-run- Simulates reservation creation without applying reservations.
If the format of the request is incorrect, the following message displays: A list of compensations needs to be defined as argument or STDIN.
As the command creates reservations, it displays messages indicating the updates by SKU, order, and stock.
1 2 3 4 bin/magento inventory:reservation:create-compensations 172:bike-123:+2.000000:1 Following reservations were created: - Product bike-123 was compensated by +2.000000 for stock 1
You can run both commands by piping
create-compensations to detect inconsistencies and immediately create compensations. Use the
-r command option to generate and submit the raw data to
1 bin/magento inventory:reservation:list-inconsistencies -r | bin/magento inventory:reservation:create-compensations
1 2 3 4 5 bin/magento inventory:reservation:list-inconsistencies -r | bin/magento inventory:reservation:create-compensations Following reservations were created: - Product bike-123 was compensated by +2.000000 for stock 1 - Product bikehat-456 was compensated by +1.000000 for stock 1
After updates complete, run the list command to verify:
1 2 3 bin/magento inventory:reservation:list-inconsistencies -r No order inconsistencies were found.
Inventory Management provides the Distance Priority algorithm, which helps determine the best option for shipping a full or partial order. The algorithm uses GPS information or geocodes to calculate the distance between the source (a warehouse or other physical location) of each item in an order and the shipping address. Based on those results, the algorithm recommends which source should be used to ship out each item in the order.
The merchant selects the provider of the GPS or geocode data required to calculate distances:
Google MAP uses Google Maps Platform services to calculate the distance and time between the shipping destination address and source locations. This option requires a Google billing plan and may incur charges through Google.
Offline calculation calculates the distance using data downloaded from geonames.org and imported into Magento with a command. This option is free of charge.
To import geocodes for offline calculation
Enter the following command with a space-separated list of ISO-3166 alpha2 country codes:
1 bin/magento inventory-geonames:import <country code> <country code> ...
1 bin/magento inventory-geonames:import us ca gb de
The system downloads and imports the geocodes data to your database, then displays the message
Importing <country code>: OK.