Importing Item label for print using Excel

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

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

    • Item Label not able to print and save from Store Admin Role

      Problem statement Item Label not able to print and save from Store Admin Role. Environment Ivend 6.6 Symptoms Item Label not able to print and save from Store Admin Role even after access right was set “Label Printing = Yes” under Designer/Label in ...

    • Updating problem in Importing Loyalty Customer Excel.

      Environment: 6.6 Short Description: Updating problem in Importing Loyalty Customer Excel. Product Query:  The data for BirthDate and LoyaltyCustomerCountries is not updated in iVend during the import procedure Resolution/Work Around: For BirthDate, ...

    • Customer Not Showing at POS when importing through excel sheet

      Product version: 6.5 Update 6 Problem Statement: Customer Not Showing at POS when importing through excel sheet Proposed Solution/Workaround: There is a possibility that the customer record was imported with wrong values in iVend. So one can first ...