Inventory Optimisations

Importing inventory or updating a product with a large number of inventory locations was causing slow performance. This enhancement optimises how inventory data is processed and queried to improve speed.

This release adds

• Updated product create, edit, and inventory commit logic to use product IDs as parameters when processing queries, reducing unnecessary data processing.

• An updated inventory commit service that only loads existing keys for the products being imported, avoiding a full table scan on inventory.

• An updated Get Stock query to use product IDs for more targeted and efficient lookups.

Benefits for the you

• Faster inventory imports – Large inventory imports will now complete significantly faster. Previously, importing stock across many inventory locations could be slow and time-consuming, especially for merchants with large or complex stock setups. This improvement means your team spends less time waiting for imports to finish.

• Smoother stock management – Updating products with many inventory locations is now much more efficient. Whether you are managing stock across multiple warehouses or store locations, updates will process more quickly and with less strain on the system.

• Reduced risk of timeouts or delays – By avoiding unnecessary full table scans during inventory processing, the system is less likely to experience slowdowns or timeouts during busy periods, giving merchants greater confidence when running large stock updates.