Introduction

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.

Bulk edit Barcode / Second UOM

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:


Product information

Information is entered in a specific panel during entering data for each product separately.

Barcode/Second UOM panel

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.

Bulk edit barcodes

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.

Set column value

There are two more useful options: “Auto – EAN/UPC” and “Auto – QRcode“.

Auto EAN UPC
Auto QR code

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 )

Auto EAN/UPC example
Auto QR code example

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.

Adding code with Blockly script

Example of the script where item SKU is assigned to the code.

Blockly script SKU assignment

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