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

Hello Everyone,

Now I'm stuck at importing barcode for each of Products variants. My company have product and Products variants about thousands list, Now I'm enter barcodes directly through the Odoo system one by one it's giving me a headache. It's there another way that don't have to enter barcodes one by one?  (Odoo16)


Thank you for the advice

Avatar
Discard
Best Answer

Hi Aunchalee, 

I think this module can help you: https://apps.odoo.com/apps/modules/16.0/vks_import_excel

Demo: https://www.youtube.com/watch?v=etMYrOJyaiU&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=2

Avatar
Discard
Best Answer

Hii Aunchalee,

Yes, you can import product variants barcode by using importing excel. Odoo provides an option to update the existing records bulk data by using its external id. You can follow the steps to update the barcode.

Step 1 : Select all Product Variants -> Action -> Export

A wizard will generate and the left side you will get the all the fields that you have in your variant model. on the right side you can choose which fields you want to update.

For the understanding you can choose 

  • External ID - This is Mandatory (In the case of updating  a record)
  • Name
  • Internal Reference
  • type
  • Barcode

You can choose any other fields if you have to update. After updating the excel you can import the excel 

Step 2: Open product Variant -> Favorites -> Import Records

Don't Forget to connect the external_id with the corresponding field in import screen

You can upload the excel and Test and Import the records. 

Avatar
Discard
Related Posts Replies Views Activity
0
Feb 25
1191
0
Dec 24
46
0
Dec 24
1051
1
Oct 24
2322
2
Aug 24
1555