Skip to Content
Menu
This question has been flagged
3 Replies
4278 Views

Hi Guys,


Need some advice on how to implement a 3PL warehousing solution for a company, the company itself is the 3PL provider, so It receives goods and stores them on racks until delivery is required.


The Problem: 

The issue is that when using the inventory and warehousing module on odoo v.15, all the goods that we receive to store are treated as sellable items which need to have buying price, selling price etc. BASICALLY the module is treating the goods stored in the correct way if they were in a retail company or something like that.

I need it to record type and qty received as well as the exact pallet rack position they are stored in and then to generate a picklist using which we can 'exit' the inventory (using barcodes).

In essence:

The best possible scenario for me would be to get a functioning 3PL module for odoo or something similar, If anyone can guide me on this, I'd really be thankful.

 


Avatar
Discard
Author

@Licia Portu, If you use the Basic 'Inventory' and 'barcode' Module, then I'd say Yes, you will face such issues when dealing with storing and 3PL.

BUT.

With a little bit of customization and the help of a good partner, we were able to resolve most of our critical issues and migrate our operations onto odoo with 90% of our issues resolved, the remaining 10% to be solved during the go-live period.

Are such issues common for 3rd party logistics and storing?

Are such issues common for 3rd party logistics and storing?

/I need the same exact thing for an 3pl warehousing, did you find any solution let me know. Thanks

Best Answer

In Odoo, a Warehouse is the actual building/place in which your items are stocked. You can setup multiple warehouses and create moves between warehouses.


Location, is a specific space within your warehouse. It can be considered as a sublocation of your warehouse, as a shelf, a floor, an aisle, etc. Therefore, a location is part of one warehouse only and it is not possible to link one location to multiple warehouses. You can configure as many locations as you need under one warehouse.

Locations are understood by the Barcode App and you can print barcodes for them, or enter the barcode for them if you already have barcodes on your Racks - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/barcode/setup/software.html#set-locations-barcodes

You can activate this feature from the Inventory App, Configuration --> Settings Menu:


Multi-step Routes support things like cross docking - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/routes/concepts/cross_dock.html


Storage Categories are useful if you have rules about where products are allowed to be stored, when they can be mixed, or need to know if a location is full BEFORE you try to put something there, and have an ALTERNATE location suggested instead. This is supported when your products can be created in advance (because you regularly receive them to REPLENISH quantities, perhaps because you are a third party fulfillment warehouse) - see https://www.cybrosys.com/blog/storage-categories-in-odoo-15


Packages are containers of products, like palettes or crates or totes, which also may (or may not) have separate barcodes. In addition to storing the location, you can store the package within the location. See https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/products/usage.html


A Consignment feature supports you assigning an Owner to each Receipt Transfer you receive - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/misc/owned_stock.html


Serial Numbers and Lots can optionally be recorded for high value products or those needing track and trace - see https://www.odoo.com/documentation/15.0/applications/sales/point_of_sale/shop/serial_numbers.html

 

Landed Costs can be added to the cost of the product if you charge per product fees or storage charges, etc. - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/reporting/integrating_landed_costs.html


We integrate with 3rd Party Shippers (UPS, FedEx, OnTrac, Deutsche Post, etc) to get labels and provide tracking information for shipments - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/shipping/setup/third_party_shipper.html


We support location based or task based inspections, with an audit trail of the inspection steps performed (and by whom) - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/delivery/inventory_flow.html and https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/manufacturing/management/quality_control.html


We have multi-company support (if you manage multiple LLC's or legal entities) - see https://www.odoo.com/documentation/15.0/developer/howtos/company.html


We have multi-currency support (if you work in multiple countries) see https://www.odoo.com/documentation/15.0/applications/finance/accounting/getting_started/main_concept.html


We have an Email Server (or can integrate with your email system), with all emails available from beneath the corresponding Receipt, Transfer, Return, Delivery, etc.  See https://www.odoo.com/documentation/15.0/applications/general/email_communication/email_domain.html


We have an integrated Order Management (Purchase Orders and Sales Orders) system - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/purchase.html and https://www.odoo.com/documentation/15.0/applications/sales/sales.html


Our Customer Portal gives your Customers a view into the status of their shipments. See https://www.odoo.com/documentation/15.0/applications/sales/sales/advanced/portal.html


Our Invoicing App manages your billing - see https://www.odoo.com/documentation/15.0/applications/finance/accounting.html

Avatar
Discard
Author

Hey Ray,

Thanks so much for your comment.

Even though what you have said is very helpful for someone who's "Dealing with 3PL's" but in our case, we are the 3PL ourselves.

So we need to:
1.) Track Incoming shipments
2.) Print barcodes and use them to track pallet locations on the Racks.
3.) Do storage invoicing for the stock kept in warehouse and send monthly recurring invoice.
4.) print Certain forms that go along with the goods as they exit our inventory.

We are still working though the issues that we are facing, specially with storage invoicing.

Please do let me know if you have any thoughts on this.

Thanks.

I don't have a good solution for storage invoicing without customization. The Sales Order is the place where a record of which locations are used each month can be managed, and Invoicing would be automated. The challenge is the trigger to update each "location" (product) and increment the quantity "delivered". If someone uses location A each month you simply increment the quantity delivered each month and that line becomes invoiceable. I would start there with a manual process and learn which parts would be automatable and what the edge cases were.

Author

Thanks for your reply ray,

It is indeed a complex problem with many different scenarios.

We are still trying to work on a solution, here's where we are at the moment:

in its simplest form the entire quantity that comes in goes out all together on a single day... so we can simply use the formula { quantity x Days x Rate per day } and that works.

but the problem arises later on when we go into the more complex scenarios,

eg: half the shipment goes out on day # 10 and the rest goes out in multiple different pieces over the course of the next few days, so how does the system calculate the number of days (per in document or per qty delivered)

in another case, some customers need to be given a variable number of free days, after which the system should start calculating the storage of remaining quantity automatically.

Best Answer

As a dropshipper since 2 years my suggested 7 major points for your instant solution are:

1. Activate Advanced Inventory Features

  • Go to Inventory, Configuration, Settings
  • Under Warehouse, turn on Multi-Step Routes and Storage Locations.
  • Save.

2. Set up Your Rack Locations

  • Go to Inventory, Configuration, Locations.
  • You’ll see a top-level “WH/Stock” location. Under that, click New to create each pallet rack (e.g., “Rack A1”, “Rack B3”).
  • Give each a short code (like A1) and make its Parent Location your main stock location.

3. Create Your Products

  • Go to Inventory, Products, and click New.
  • Give it a Name and set Product Type to Stockable (so Odoo will track quantities).
  • Skip the Sales Price field entirely if you’re not selling these items—Odoo won’t complain if you leave it blank.
  • Under the Inventory tab, you can add a default Purchase Price so cost reporting still works.

4. Enable Barcodes

  • Go to Inventory, Configuration, Settings.
  • Under Operations, enable Barcode Scanning.
  • Save, then go back to your Products and Locations and click into each one to assign a unique barcode (you can type or scan them).

5. Define Putaway Rules (optional but handy)

  • In Inventory, Configuration, Putaway Rules, create a rule so that when goods arrive, Odoo will suggest putting them into the right rack location automatically.

6. Receive Stock

  • Go to Inventory, Operations, Receipts, click New, select your Vendor, add your stockable products and quantities.
  • Validate the receipt. Odoo will create an internal transfer to move items from “Receipts” to your storage racks—follow its suggestion or scan the rack barcode to confirm.

7. Pick Stock Out

  • When you need to pull something out, go to Inventory, Operations, Transfers (or Delivery Orders, if you’ve set one up).
  • Open the pick list, hit Print or use the Barcode app on your tablet/phone:
    • Scan the rack location barcode (tells Odoo “I’m at Rack A1”)
    • Scan the product barcode (tells Odoo “I’m removing Product X”)
    • Enter the quantity, then validate.
  • Odoo will deduct the exact qty from that rack.

If you’d like a turnkey, click-and-scan experience with less setup, Phase V offers a ready-made Odoo add-on that:
Automatically maps pallets to rack codes
Builds clean, printable pick lists
Gives you a mobile barcode interface (no extra config!)
Adds dashboard reports showing exactly who picked what, when, and from where

Avatar
Discard
Author Best Answer

Hi JNZ, yes, we have found a solution, In our case, we took the standard Inventory and Barcode module and modified it heavily to suit our needs. each rack location had to be inputted as both a source and destination location and we had to manually link the barcodes on our physical racks to the virtual locations.


It's been a little long and tedious process but we now have the system working well enough to suit our needs, although it does require a little more work to make it perfect.

Feel free to reach out again if you need more info, maybe we can exchange information for mutual benifit.


Avatar
Discard

Could you please share more information that what exactly you customized? And what was the strategy.

Related Posts Replies Views Activity
3
Jan 24
18424
2
Mar 23
4036
3
Mar 16
4684
0
Feb 25
717
0
Dec 24
45