Answered

Assigning bar codes to items

(0) Share

Report

Posted on by ImMikeD

Is there a way to bar code items en mass? Like by category or even a Shift + Click method? Trying to assign bar codes to 60 thousand different items is a pain.

All responses (4)

Answers (1)

Community member 19 on at

Like (0)

Report

Assigning bar codes to items

Hello Hasan,

I do have an excel list with all the items' $InventTable_1.ItemId$ and $InventItemBarcode_1.itemBarCode$ (I generated the barcode numbers separately with a UPC-A app) but how do I mass upload them? From Data Management? how?
ImMikeD 70 on at

Like (0)

Report

RE: Assigning bar codes to items

Once I found the correct string to enter, this worked perfectly. Thank you!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Assigning bar codes to items

Do u already have a list of those barcodes in Excel with 2 columns (ItemLookupCode and barcode)? or u need to generate non-existing barcodes from scratch then assign them to items?

If u already have the list, then it's easy, just confirm then I will tell u how to import them into a temp table then with a simple query we can do the assignment

A Hassan

RMS Leaders
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Assigning bar codes to items

Thsi would need to be done with a SQL query