Importing Item label for print using Excel Along with Serial\Batch Number

Introduction

In Retail Business, the item label information is changing frequently and retailers should always be ready to print the updated labels and attach them to their items and the shelves as required.

In iVend there are multiple places where the user can print the labels (Item Label Printing, Shelf Label Printing and the Inventory Transaction Receiving screens). In this Article, we are going to explain how to use Excel to import labels.

Excel Preparation

We need to prepare the Excel sheet with the following columns with the exact names as they are shown here:

· ID

· QuantityToPrint (Note that there are no spaces in this column heading)

· Price

· Weight

.SerialBatchNumber

Importing the Excel sheet

Once the Excel sheet has been completed and filled in with all the required labels that need to be printed, the user can import it in the Management Console form the following locations:

· Reports > Designer / Label > Item Label printing

· Reports > Designer / Label > Shelf Label Printing

Once successfully updated, items will be imported and displayed on the screen, ready for printing.

In earlier versions of iVend such as version 6.4.2, while using the Item Label Printing feature with the [Import Record] button in the Management Console, if there is no sheet in the Excel Import file with the name, “Sheet” then the system throws an error “'sheet$' is not a valid name”, therefore make sure the import sheet in the file is named appropriately.

• Related Articles

• Importing Item label for print using Excel

  Introduction In Retail Business, the item label information is changing frequently and retailers should always be ready to print the updated labels and attach them to their items and the shelves as required. In iVend there are multiple places where ...

• Importing Item label for print using Excel

  Introduction In Retail Business, the item label information is changing frequently and retailers should always be ready to print the updated labels and attach them to their items and the shelves as required. In iVend there are multiple places where ...

• Serial and Batch Management

  Serial and Batch Management Serial and Batch Management is added to the inventory operations. This option is available for iVend Un-Plugged version. The option is available in the HO and Store. In HO the data of all store will be displayed based on ...

• iVend POS - Label Report

  iVend POS - Label Report This article provides the basic steps for creating a Label Report in iVend Retail. In iVend, the user can design their own label(s) using the following two options: · Thermal Label Setup · Report Designer Label Report Thermal ...

• Good Receipt Format for Import Batch item with batch expiry date.

  Product version: iVend 6.5 update 6 Problem Statement: Customers need to import Batch Managed item on Store MC-->Goods Receipt screen, with batch expiry date. Proposed Solution: Suggested to import the data in the following format using the delimiter ...