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

Hello In my current system I have more than 1000 locations imported but without location barcode. I don't want to import it with excel. Is there any way I can bulk generate location barcode within Odoo ?

Avatar
Discard
Best Answer

Hi,

Yes, we can do it using an Odoo Server Action. You can create a Server Action in Odoo to generate and assign barcodes to existing locations in bulk automatically.


1.Settings->Technical-> Action->Server Action

Type: Execute Code

Model : Inventory Location


'barcode': 'Loc' + str(rec.id)

This sets the barcode to a string starting with 'Loc' followed by the record's ID.

Example: If the location's id is 123, the barcode will be 'Loc123'.

You can change 'Loc' + str(rec.id) to anything that fits your business needs.


2. Then, select all locations from the tree view (Inventory > Configuration > Warehouse Management > Locations), click the Action button, and run the Location Barcode server action. You will see that barcodes are automatically assigned to the selected locations.

Result:


Hope it helps.

Avatar
Discard
Best Answer

Hi 👋,

In Odoo Online (SaaS), you can't run backend scripts, so the only way to generate location barcodes in bulk is by exporting the data, updating it in Excel, and re-importing it.

If you're using Odoo.sh or On-Premise, you can automate this using a Python script or the Odoo shell.

So:

  • Odoo Online → Use Excel import.
  • Odoo.sh / On-Prem → Automation via script is possible.
# Run in Odoo shell
locations = env['stock.location'].search([('barcode', '=', False)])
for loc in locations:
    loc.barcode = f"LOC-{loc.id:05d}"


Avatar
Discard
Best Answer

Yes, you can bulk generate location barcodes in Odoo by using a custom script or automation. You can create a scheduled action or a simple script using Odoo Studio or Python to automatically generate barcodes for each location. You’d need to use a barcode generation library (like python-barcode) and associate the generated barcode with the respective locations in Odoo.

Avatar
Discard
Related Posts Replies Views Activity
0
Aug 24
857
0
Apr 24
1161
0
Jan 24
1050
0
Feb 23
1350
3
Dec 22
3746