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 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. )

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:

Read More

Related Posts

ERPAG Change log 08-04-2023

ERPAG Change log 08-04-2023

It's the peak of the summer heat, but that doesn't stop us from improving ERPAG! Here is the list of our newest updates: You can now list the "Additional info" information as a column in your Manufacturing report: 2. Exploded view is now available in the multi-level...

read more
JSON / XML Designer

JSON / XML Designer

JSON/XML Designer in ERPAG is a visual tool that will allow users to transform data from the ERPAG database into JSON or XML format. This can be further used for future integration with API services. This tool provides a user-friendly interface where users can define...

read more
Change log 05/29/2023

Change log 05/29/2023

The biggest change we developed is Automatization and Customization. This change is a huge milestone for us, and we will publish individual instructions for using the new features in the upcoming period. This module is divided into individual wholes: JSON Designer -...

read more