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

Hi,

Refer to the following link
https://www.odoo.com/it_IT/forum/assistenza-1/importing-products-with-variants-including-internal-reference-and-barcode-per-variant-160219

Hope it helps you

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.