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