UPC/TPC Create (Mass Upload)

Guide

UPC/TPC Create (Mass Upload)

Functions:
- Mass Create UPC/TPC
- Search Mass Create UPC/TPC

New product or product that does not exist in Vendor Portal can be created using this function.

Vendor Portal uses the UPC (Universal Product Code) barcode found on the product packaging or Tangs issued TPC (Tangs Product Code) barcode as the product identity.

Vendor portal accepts UPC–A or EAN–13 barcode standard. The barcode must be 13 digits and if your barcode is 12 digits please append "0" in front of the 12 digits. Example "01234567890123".

To create the product in Vendor Portal, you need to get ready the products' UPC and the following information:
1) Tangs SKU
2) POS Description
3) Retail Price

Refer to Appendix A - E21 Excel Template for more information on how to obtain TPC code if your product does not have a UPC barcode.

UPC/TPC Create (Mass Upload)

Step 1: On the left menu, look under Concessionaire Inventory. Click on UPC/TPC Create (Mass Upload)

Step 2: Click "Download Template" link to download latest E21 excel template for new UPC/TPC creation.
- Optional: Click "Download Guide" link to download guide on how to fill up the template.

Step 3: Open the downloaded E21 excel template and fill in new UPC/TPCs details. Once data entry is completed, save and close excel template.
- Refer to Appendix A guide on filling up E21 template.

Step 4: Click “Browse” button if you are using Internet Explorer or "Choose File" button if you are using Google Chrome Browser and a Windows file selector will pop-up.

Step 5: Using the Windows file selector, browse to the directory that contains the saved E21 excel template and select the file for upload.

Step 6: Click the "Open" button and the selected file path for upload will be shown in the “Input File” field.

Step 7: Click “UPLOAD” button to proceed with the upload. Once upload is complete, a Batch Id will be generated.

The status will changed from WORKSHEET to either one of the following:
1) PENDING APPROVAL - Upload is successful, an email is automatically sent to Tangs Merchandising for approval.

2) FAILED – CHECK ERROR - Upload is not successful, amend the error/s in the upload file and redo the upload. Instructions on how to check for the errors in Step 8.

Step 8: Click “VALIDATION REPORT” to download validation report to check for error/s if any.
- Refer to Appendix B guide on validation report.

Note: The upload will not be approved immediately. It depends on when TANGS Merchandising process your upload. Once TANGS Merchandising has approved your upload, the Status will change to “APPROVED”.

- Upload will be approved within 3 weekdays upon upload.

- If upload is not approved after 2 weekdays, kindly check with TANGS Merchandising.

- You can request TANGS Merchandising to cancel the upload if the upload is not yet approved. Cancelled upload status will be changed to “CANCELLED”

Search UPC/TPC Create (Mass Upload)

You can use this function to find your previous uploads to view for:
- Upload Status (Whether it is approved by TANGS Merchandising)
- Or if you wish to recall the data you have uploaded.

Step 1: Click “< BACK” button on top right hand of the screen to load search screen.

Step 2: Filter search by:
- Batch Id
- Status

Step 3: Click “SEARCH” to proceed with the search. The search results will be listed in the search result table.

Step 4: Double click on one of the record in the search result table to load the upload details.

Appendix A - E21 Excel Template

Note: Header columns in Red are mandatory to be filled up with exception to UPC/TPC column.

If your product does not have a UPC barcode, Tangs Product Code(TPC) is the alternative. All you have to do is fill up all the required fields in a row leaving the UPC/TPC column empty, system will auto assign a TPC for that row when upload is done successfully.

You need to take note of the auto-generated TPC in the Validation Report in Appendix B.

Note: Using TPC has its downside as a UPC/TPC price tag has to be printed and tag onto each product as a barcode identification for sales at our POS terminal.

Appendix B - Validation Report

1) Look for errors in column A (ERROR). In above example, for row #1 there are 2 errors (E1, E4). Upload will only pass if all rows are clear of error.

Do take note of the UPC/TPC column for system generated TPC code if you are not using UPC barcode. It is advisable to save a copy of the validation report to your computer for easy reference in future.

2) Go to Error Code List sheet in the “Validation Report”. Match the errors (E1, E4) against the error code list. It will provide you the cause of the error.

3) Amend the error/s in your original uploaded E21 - excel template file and redo the upload. Repeat this process if there is error found again in the “Validation Report”.