# Old Products do not appear in left search and in proposal / orders / invoices after import of new products via import tool

**URL:** <https://www.dolibarr.org/forum/t/old-products-do-not-appear-in-left-search-and-in-proposal-orders-invoices-after-import-of-new-products-via-import-tool/18523>\
**Category:** PM modules\
**Created:** [February 7, 2020, 11:36pm UTC](https://www.dolibarr.org/forum/t/old-products-do-not-appear-in-left-search-and-in-proposal-orders-invoices-after-import-of-new-products-via-import-tool/18523 "2020-02-07T23:36:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vmamet](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/vmamet/32/27_2.png) [@vmamet](https://www.dolibarr.org/forum/u/vmamet)\
**Post date:** [February 7, 2020, 11:36pm UTC](https://www.dolibarr.org/forum/t/old-products-do-not-appear-in-left-search-and-in-proposal-orders-invoices-after-import-of-new-products-via-import-tool/18523/1 "2020-02-07T23:36:26Z")

</div>

I manually created 80 products with pictures, etc …  
Everything was working fine.  
Then I received the full price list from my supplier with 2000 products.  
So I imported them from a CSV file.  
I imported the buying price  
I imported the selling prices with 3 price levels  
But now when I try to create a proposal etc … the old existing products do not appear anymore.  
I’ve tried to clone one adding a “b” at the end of the product, erase the old product and removing the “b” on the new cloned product … and it does not appear either.  
Looks like an indexing issue in the database.  
Can anyone help ?

I’m on Dolibarr 10.0.6

Regards

Vincent

---

<div class="post-metadata">

**Author:** ![vmamet](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/vmamet/32/27_2.png) [@vmamet](https://www.dolibarr.org/forum/u/vmamet)\
**Post date:** [February 8, 2020, 12:22am UTC](https://www.dolibarr.org/forum/t/old-products-do-not-appear-in-left-search-and-in-proposal-orders-invoices-after-import-of-new-products-via-import-tool/18523/2 "2020-02-08T00:22:55Z")

</div>

Ok found the solution 😄  
Thanks to [ariffidaali](https://www.dolibarr.org/forum/u/ariffidaali)

The products list must be limited to 1000. You can change that in:  
Home-\>Modules-\>Products

I’ve put 0 for unlimited.

And “TADA” !!! it is working fine now.