Importing and Exporting Serial Products in Tagrain

Importing and Exporting Serial Products in Tagrain

Serial and Batch products  can be created by activating the "Serial and Batch Product Management" plugin.

Introduction

Serial Products are products that have a unique serial number attached to them. For example, all electronic items are serial controlled. A Serial Number is required when receiving items into stock or when selling a product. Each Serial Number must be unique for a product.
In this article we are using the demo data in the template as a reference to import Serial products. We will consider Women’s Watches as serial-controlled products.

V-Motif Black Strap Watch
Diamond-Accent Rose Gold Watch
Charles Saddle Leather Strap Watch
Quartz Bracelet Watch
Gold Mesh Bracelet Watch
Collins Navy Leather Strap Watch



Steps to Import Serial Products in Tagrain



The Excel template downloaded from the Product List view is common for all types of products. To create Serial Products, mark the product by specifying its Product Type = 1 in the template.

Once the upload template is properly filled and you are ready to import, click the import button on the Product Master Screen. Navigate to the location where your Product.xls file is saved. Select the file and click OK. 

The application will indicate when the data upload starts in the notification center. Once the data is uploaded, the application will again notify for the successful data import.



In case the import is not successful, the application will again notify for the unsuccessful import.



The notification center will mention that there has been an error in the upload.



Click on the notification error to download the uploaded file. The downloaded file will clearly specify the error(s) at the end of every row in the excel sheet.



Steps to Export Serial Products in Tagrain



The steps to export Product Data using the excel template are listed below:

Click on the “Export” symbol on the Product Master Screen. It will give you the option to include Stock Information as part of the download.



This will download the entire Product Master Data into an Excel sheet. This downloaded data can be utilized for further analysis.


Suggested Readings

Importing and Exporting Batch Controlled Products in Tagrain
Importing and Exporting Composite Products in Tagrain
Importing and Exporting Variant Products in Tagrain

    • Related Articles

    • Importing and Exporting Standard Products in Tagrain

      Introduction Standard Products are products that will not have any variants. In this article we are going to use the demo data in the template as a reference to import Standard products. We will consider the following products as Standard products ...
    • Importing and Exporting Composite Products in Tagrain

      Variant and Composite products can be created by activating the "Variant and Composite Product Management" plugin. Introduction Composite Products are created by combining two or more products and are sold as one single unit. It allows you to package ...
    • Importing and Exporting Variant Products in Tagrain

      To be able to Import and Export Variant products in Tagrain, you must subscribe to and activate the Variant and Composite Products Management plugin. Introduction Variant products are those products that have an attribute, or a set of attributes ...
    • Importing and Exporting Batch Controlled Products in Tagrain

      Serial and Batch products can be created by activating the "Serial and Batch Product Management" plugin. Introduction Batch controlled products are those products which have a shelf life. For example, all pharmaceutical and food & beverage products ...
    • Importing and Exporting Customer Information

      Introduction Tagrain allows you to Import and Export customer information. You can use this feature to add new customers. Adding a single Customer record in Tagrain is quick and simple. What if you have to add multiple customer records. Adding one ...