# Mass movement does not fetch all products

**URL:** <https://www.dolibarr.org/forum/t/mass-movement-does-not-fetch-all-products/19460>\
**Category:** CRM/SRM Modules\
**Created:** [August 26, 2020, 5:35pm UTC](https://www.dolibarr.org/forum/t/mass-movement-does-not-fetch-all-products/19460 "2020-08-26T17:35:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iosif.garleanu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/iosif.garleanu/32/541_2.png) [@iosif.garleanu](https://www.dolibarr.org/forum/u/iosif.garleanu)\
**Post date:** [August 26, 2020, 5:35pm UTC](https://www.dolibarr.org/forum/t/mass-movement-does-not-fetch-all-products/19460/1 "2020-08-26T17:35:01Z")

</div>

Hello,

Dolibarr version: 10.0.0

At the moment of writing this post my database contains 1115 products.  
I use the mass transfer ( i.e. mass movement, mass stock transfer) _/htdocs/product/stock/massstockmove dot php_ feature quite a lot now days.  
My issue is that when I try to search for products that are in alphabetical order close to the end of the list, the combobox for _Product ref._ simply says “No result found”.  
I right-clicked the combobox, hit inspect, found the unordered list, check the last list item and I see that its ref starts with S. But I do have products whose ref. start with T, V and so on until the end of the alphabet.

I copied the unordered list into a text editor and I counted the list items and it turns out that only the first 1001 products are shown.

Ofcourse that there are workarounds for stock transferring but I would like to also fix the problem described as using mass transferring is way more time efficient than transferring each product individually.

Can anyone help me understand the cause of the issue and maybe offer a solution?

Best regards, Joseph.

---

<div class="post-metadata">

**Author:** ![iosif.garleanu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/iosif.garleanu/32/541_2.png) [@iosif.garleanu](https://www.dolibarr.org/forum/u/iosif.garleanu)\
**Post date:** [August 28, 2020, 6:33am UTC](https://www.dolibarr.org/forum/t/mass-movement-does-not-fetch-all-products/19460/2 "2020-08-28T06:33:53Z")

</div>

I figured it out!

In the _llx\_const_ table there is an entry with the name “PRODUIT\_LIMIT\_SIZE”. It was set to 1000.  
I modified the value so it would fit my needs and now all the products are fetched.

Best regards, Joseph.

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [August 28, 2020, 9:07pm UTC](https://www.dolibarr.org/forum/t/mass-movement-does-not-fetch-all-products/19460/3 "2020-08-28T21:07:22Z")

</div>

Hi,

This field is available on the configuration panel