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

Start NOW

Read More

Related Posts

Custom document and Tesla Fleet API integration (DIY)

Custom document and Tesla Fleet API integration (DIY)

Today, the need for automation is increasing. The foundation of automation is machine-to-machine communication. Today this is achievable through API integrations (today it is the de facto industry standard). Transferring data from one system to another works through...

read more
ERPAG API – Tesla OAuth 2.0 authorization

ERPAG API – Tesla OAuth 2.0 authorization

Access to Tesla fleet API is via the OAuth 2.0 authorization type. For ERPAG to be able to communicate with Tesla's API, it is necessary to set up such access. You will set this up in the Automatization/Customization menu, under option API Authorizations. When you add...

read more
​ERPAG API – Dropbox OAuth 2.0 authorization

​ERPAG API – Dropbox OAuth 2.0 authorization

In this instruction blog, we will show you how to create OAuth 2.0 API keys on your Dropbox account. These are necessary to make API calls from ERPAG via Blockly scripts. The instructions show how the process itself currently looks. But in the meantime, the design of...

read more