跳至内容
菜单
此问题已终结
3 回复
1019 查看

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 ?

形象
丢弃
最佳答案

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.

形象
丢弃
最佳答案

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.

形象
丢弃
相关帖文 回复 查看 活动
1
6月 25
1409
0
4月 24
1468
0
1月 24
1439
0
2月 23
1646
3
12月 22
4300