# Available stock is much less than Stock after migration from SW5 **URL:** \ **Category:** Shopware 6 (English)\ **Tags:** general\ **Created:** [22. Oktober 2021 um 17:39 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049 "2021-10-22T17:39:05Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [22. Oktober 2021 um 17:39 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/1 "2021-10-22T17:39:05Z")
After migrating from SW5 to SW6, we discovered, that Available stock is much less than Stock. This causes Product 404 error. We can’t edit this field directly. Anyone knows the solution? Looks like we need to reset Available stock to match Stock for some Products. Cheers ---
**Author:** ![sportsshop](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sportsshop](https://forum.shopware.com/u/sportsshop)\ **Post date:** [26. Oktober 2021 um 09:04 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/2 "2021-10-26T09:04:12Z")
In SW6 every order will block the ordered items from stock. So available stock is stock minus ordered items. You have to set every order to status closed. ---
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [26. Oktober 2021 um 13:14 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/3 "2021-10-26T13:14:55Z")
thank you for the reply sportshop! In our setup, when we change Order to Closed, tis happens: Stock decreases: from 5 to 4 Available stock stays the same: -3 Maybe someone can give a tip? 🙂 ---
**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\ **Post date:** [26. Oktober 2021 um 13:27 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/4 "2021-10-26T13:27:07Z")
Buy an article: available stock -1 (Ship an article) and complete order: stock -1 // updated this line. If available stock ist -3 than you have sold more that you had in your stock. Just set it to the correct amount manually. ---
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [26. Oktober 2021 um 13:48 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/5 "2021-10-26T13:48:56Z")
Thank you Max! But Available stock field is not editable via the backend, check the screenshot please. Is there a way to work this out without direct database edit? So manager can handle it. Anyone knows maybe: ![Screenshot 2021-10-26 at 15.42.51](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/1/1a57b1ac18d57f1b16a6b955e79e32b1c8a727c9.png) ---
**Author:** ![sportsshop](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sportsshop](https://forum.shopware.com/u/sportsshop)\ **Post date:** [26. Oktober 2021 um 14:29 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/6 "2021-10-26T14:29:38Z")
@shopwarer1638 when stock is 4 and available stock is -3 there should be 7 items sold! the shipping status does not take effect … you have to set the order status to completed! the available stock is calculated stock minus non completed orders (shipping status independend!) ---
**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\ **Post date:** [27. Oktober 2021 um 11:18 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/7 "2021-10-27T11:18:36Z")
My bad, you are right. It is not shipped order, it is order completed/closed. ---
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [27. Oktober 2021 um 13:13 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/8 "2021-10-27T13:13:04Z")
Thank you for the clarification! Closing the Order we can make Stock and Available stock equal. Any tip to update Available stock? It is non-active (greyed out) ---
**Author:** ![sportsshop](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sportsshop](https://forum.shopware.com/u/sportsshop)\ **Post date:** [27. Oktober 2021 um 13:31 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/9 "2021-10-27T13:31:47Z")
you only can update the stock not available stock. I think you should set all orders to status closed and the update stock. The order status can only be set one by one I think. Not so cool but no other way avalable at present. I don´t know if you can set the orders status automatically to closed when the order is shipped, sorry. ---
**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\ **Post date:** [28. Oktober 2021 um 10:39 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/10 "2021-10-28T10:39:23Z")
There is a plugin in the store for free that does that. ---
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [30. Oktober 2021 um 21:47 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/11 "2021-10-30T21:47:22Z")
thanks for the orders update tip and the plugin suggestion, it works well! Also SW6 introduced bulk orders edit in recent version, so we were able to do some. But it sends e-mails to customers without an option (as it works on single order edit, where we can disable sending notifications). Anyone have an idea of how to skip sending e-mail notifications to customers in this case? ---
**Author:** ![FabianU](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/fabianu/32/16680_2.png) [@FabianU](https://forum.shopware.com/u/FabianU)\ **Post date:** [4. Juli 2022 um 20:23 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/12 "2022-07-04T20:23:14Z")
> [@shopwarer1638](#): > > thanks for the orders update tip and the plugin suggestion, it works well! which one might that be? ---
**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\ **Post date:** [5. Juli 2022 um 08:07 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/13 "2022-07-05T08:07:12Z")
We were talking about this plugin: [Bestellstatus abgeschlossen | Shopware Store](https://store.shopware.com/ecomw30373539151f/bestellstatus-abgeschlossen.html?c=1001) ---
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [5. Juli 2022 um 15:24 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/14 "2022-07-05T15:24:22Z")
yes, this one: [Bestellstatus abgeschlossen | Shopware Store](https://store.shopware.com/ecomw30373539151f/bestellstatus-abgeschlossen.html?c=1001&_gl=1%2A1p42qis%2A_gcl_aw%2AR0NMLjE2NTQwMDgzMzUuQ2owS0NRanctZGFVQmhDSUFSSXNBTGJralNaSGszYjFvdXZpM0NFTDhvTVYxQUdwQUprcjV1cnd1N0h5OXpkRDZ4WkczaEc3MlRfa2tsMGFBZzQxRUFMd193Y0I.&_ga=2.23946170.1284498530.1657032874-44923382.1654107260) Also SW6 introduced bulk orders edit in recent version, so we were able to do some. But it sends e-mails to customers without an option (as it works on single order edit, where we can disable sending notifications). Anyone have an idea of how to skip sending e-mail notifications to customers in this case? ---
**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\ **Post date:** [5. Juli 2022 um 15:38 UTC](https://forum.shopware.com/t/available-stock-is-much-less-than-stock-after-migration-from-sw5/91049/15 "2022-07-05T15:38:36Z")
If it is possible, then in the Flow Builder.