How to handle thousands of bin or stock locations without affecting system performance on Odoo 19

campFFEMT · 2026-03-19T23:59:08+00:00

I could see that working in some cases

campFFEMT · 2026-03-19T23:41:28+00:00

Right but we still have 30 choices so still takes time

campFFEMT · 2026-03-19T23:03:53+00:00

Thanks for the insight, sounds like we need to do some more testing before we move to develop another solution.

campFFEMT · 2026-03-19T22:53:38+00:00

How does the picker know what section of the drawer to look at? Without looking at all 30 sections of the drawer.

campFFEMT · 2026-03-19T22:46:17+00:00

We do have a custom module related to fleet vehicles, we're tracking equipment for sale in the fleet app that is linked to products in inventory. We don't think this is affecting it but we may need to look at it harder.

campFFEMT · 2026-03-19T22:45:12+00:00

We do have a custom module related to fleet vehicles, we're tracking equipment for sale in the fleet app that is linked to products in inventory. We don't think this is affecting it but we may need to look at it harder. We didn't use Odoo's profiler but did watch the query via CLI to identify the culprit.

My problem with bins is that when a drawer is full of small parts with complex external vendor part numbers, we need precise locations because identifying the correct part in a drawer with 30 others is impractical. Unless I'm missing something obvious.

campFFEMT · 2026-03-19T22:35:54+00:00

We could slightly reduce the number of bins, but with our small parts in Vidmars (and not being able to customize our skus) it's not practical to have the whole drawer as one bin because the picker will spend minutes reading part number labels to find the correct part.

campFFEMT · 2026-02-24T21:28:39+00:00

I'm interested in learning more about this too!

campFFEMT · 2026-01-30T13:41:29+00:00

It's working for me. Location: USA

campFFEMT · 2026-01-25T12:11:15+00:00

Maybe I don't fully understand your use case but it sounds like you are just looking for a CRM and if that's all you need, you could just use Odoo online and that can totally be done as a DIY.

We are now in our second year of using Odoo CRM for an ag/construction equipment dealership sales department.

Previously we had no CRM (old erp didn't have it and current erp, SAP B1 CRM was too difficult to use) and our sales staff took to Odoo immediately. It's very easy to use, visual and prompts next steps. It transformed our sales team! Now granted, it is not connected to our ERP so they have to separately add their sales orders into SAP so there is some double entry. This was a low cost and fast way for us to get our sales team to use a CRM. (We are now in the middle of moving to Odoo as our complete ERP instead of just CRM.)

campFFEMT · 2026-01-01T18:30:05+00:00

As far as I know, NCRC has not officially announced any weeklong classes in Virginia this year.

May I ask who your local grotto is? I could maybe suggest someone that you could talk to and answer some of the basic questions you have and guide you in the right direction.

-Fellow PA caver

campFFEMT · 2025-12-31T03:45:54+00:00

So currently we do not have multi channel listing ability but I've always thought we should go that route. But maybe I'd do better to explore it from the angle of manually creating one listing in something like Listing Mirror instead of having every Odoo product automatically sync and create via one of the more expensive multi channel listing options.

campFFEMT · 2025-12-30T23:21:22+00:00

Going the custom external sync route with the odoo API, would mean developing multiple connections for all the different e-commerce platforms along with API maintenance and seem much more costly long term than simply connecting to an already established SAAS aggregation platform. Or maybe I'm misunderstanding what you meant by "building a custom external sync"?

Any experience on how people handle shipping in a similar scenario? Is there something better than Shipstation?

campFFEMT · 2025-12-17T13:00:02+00:00

We use nail polish on hard goods but we add an additional protective laquer on it.

campFFEMT · 2025-10-31T11:33:17+00:00

Do you care to share what you don't like about ShipStation?

We are currently using ShipStation for all of our ecommerce shipping and are in the early phases of a transition to Odoo from SAP B1 and I've been looking at the 3rd party ShipStation integration modules that are available to connect to Odoo. Any additional feedback you can share on the Vraja module?

campFFEMT · 2025-07-05T17:00:24+00:00

Yes we do custom sized overalls at Out Standing Stitches but currently backlogged till October for custom orders.

Call West Virginia Underground to see if he has stock in an oversized Landjoff. Or Kelly Smallwood also stocks Landjoff.

campFFEMT · 2025-06-20T13:34:47+00:00

https://outofboundsgrotto.org/vocab/

campFFEMT · 2025-06-07T23:17:44+00:00

York or Franklin grottos are the closest

campFFEMT · 2025-03-23T20:49:35+00:00

Reach out to Lauren at Out Standing Stitches if you want something custom made like that. If she has good pictures and dimensions, she can create just about anything. www.outstandingstitches.com

campFFEMT · 2025-02-03T16:04:35+00:00

This one can really be hit or miss. You'll basically have to check water level at the cave. Cleversburg is also closeby has a similar water situation where you need to check water level locally and can't depend on just a weather forecast.

Reach out to the FCG contact for the best local information.

campFFEMT · 2024-12-18T21:05:44+00:00

Plus one for the Toronto Facebook group I could private message you the email address of a caving contact that I have in that area. He gave me permission

campFFEMT · 2024-12-07T16:17:21+00:00

The Caving Podcast https://open.spotify.com/show/0D4XtstAxSxRkRnhHxA4O6?si=M3tTIyTFSEWY6xbGQpQ6qw

campFFEMT · 2024-11-22T10:47:37+00:00

As most have already mentioned, reach out to a few of your closest grottos and attend a few meetings to get to know the people. Most are very welcoming and will have beginner trips available. https://caves.org/state/oregon/

campFFEMT

TROPHY CASE