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 ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
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.
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}"
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.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
0
Aug 24
|
857 | ||
|
0
Apr 24
|
1161 | ||
|
0
Jan 24
|
1050 | ||
|
0
Feb 23
|
1350 | ||
|
3
Dec 22
|
3746 |