Usually, during the first phase of using a new system, the Products and Services list contains basic data.
In most cases, those are SKU, Description, Tax Category, Selling price, etc… As the users get along with the system and master basic functions & conditions until the next phase is met.
One of the next phases during the implementation of the system for Inventory / Manufacturing is “Labeling” (some call it “Barcoding”) of physical products. In theory that should be implemented in early phases, although theory and practice are pretty much different as usual.
In most cases “Labeling” of the items are implemented later on(once management realizes it requires much more effective control of the process), this is where a problem occurs. If there are already hundreds & thousands of items, it is highly impractical to change them individually. For that reason, we implemented “Bulk Edit Barcode” feature in ERPAG. Also, the change of the standards (for example change from Barcode to QR code) also requires great changes. The “Bulk edit barcode” feature will make it possible with a lot less effort.
Labeling and adding Barcodes in ERPAG can be done via importing data in the Products and Services list, or using Label Designer
More information about Label Designer can be found on the following blog:
Information is entered in a specific panel during entering data for each product separately.
Note: This panel besides data required for labeling, also contains data about the eventual “Second Unit of Measure” option.
More information about “Second Unit of Measure” can be found on this following blog:
Via Bulk edit, each item is shown as a separate row, while making these changes on the item level, they are shown as separate grouped columns.
Entering data in Bulk edit
Entering data works like in any other table; you can add columns, do a copy/paste method from a spreadsheet, etc…
There is also a “Set column value” option that can be quite useful (can be found by clicking on the column heading), it allows us to assign a value on all items for that column.
There are two more useful options: “Auto – EAN/UPC” and “Auto – QRcode“.
These options automatically populate values if there is no data entered in the “EAN/UPC” column.
If we choose “Auto EAN/UPC” that data will be generated as increment in a group that starts with number “2” (for example “2000000000091”), and with type EAN13.
While choosing “Auto – QRcode” GUID(random data that can’t be repeated) will be generated. https://en.wikipedia.org/wiki/Universally_unique_identifier )
Advanced assignment of Barcode / QRcode
If there is a requirement to set up a special logic operation while generating codes (for example QR code contains the SKU of the item as well), it can be done with the Blockly Script.
Example of the script where item SKU is assigned to the code.
Note: Blockly Script integration requires a certain level of understating visual programing. More information can be found on the ERPAG Youtube channel: https://www.youtube.com/channel/UCv5Iypb5TCgIdEjKdaXp-yw/videos