Functions:
- Mass Modify UPC/TPC
- Search Mass Modify UPC/TPC
Existing product in Vendor Portal can be modified using this function.
Common scenarios whereby product is to be modified
1) Change of retail price
2) Change of product concessionaire margin, i.e. product is currently mapped to Tangs' Regular SKU and during certain sales period the product can be remapped to a Tangs' Offer SKU.
For example:
Sales period starting on 01-Jan-2019 to 15-Jan-2019
You can advance setup 2 UPC/TPC modify requests.
- The first request will effective your product's SKU mapping from Regular SKU to Offer SKU starting on 01-Jan-2019 for the start of the sales period.
- The second request will effective your product's SKU mapping back from Offer to Regular SKU on 16-Jan-2019 when the sales period ends.
Step 1: On the left menu, look under Concessionaire Inventory. Click on UPC/TPC Modify (Mass Upload)
Step 2: Click “Download Template” link to download latest E23 excel template for data entry of UPC/TPCs for modification.
Optional:
- Click “Download Guide” link to download guide on how to fill up the template.
- Click “Download Colors” link to download valid TANGS system colors list.
- Click “Download Sizes” link to download valid TANGS system sizes list.
Step 3: Open E23 excel template and fill up UPC/TPCs details to be updated. Once data entry is complete, save excel template..
- Refer to Appendix A guide on filling up E23 template.
Step 4: Select an effective date for this UPC/TPCs modification. Effective date must be at least 3 weekdays in advance as of current date.
Note: Upload must be done at least 3 weekdays in advanced prior to the effective date to allow TANGS Merchandising time to review and approve your upload.
Step 5: 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 6: Using the Windows file selector, browse to the directory that contains the saved E23 excel template and select the file for upload.
Step 7: Click the "Open" button and the selected file path for upload will be shown in the “Input File” field.
Step 8: 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 requesting 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 9.
Step 9: Click “VALIDATION REPORT” to download validation report to check for error/s if any.
- Refer to Appendix B guide on validation report.
Step 10: Optional step, Click “EMAIL FOR APPROVAL” to send an email to TANGS Merchandising to inform them to review and approve your upload. (“EMAIL FOR APPROVAL” will appear only when the Status is “PENDING APPROVAL”)
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”
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 that is 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
- Effective Date
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.
Note: Header columns in Red are mandatory to be filled up.
Note:
- For each UPC/TPC entered, you are only required to fill in data in the respective column if there is change pertaining to that UPC/TPC detail field.
- Columns (SKU, CHANGE UPC-SKU MAPPING(Y/N)) are related. Define a new SKU and select “Y” if you want to map the UPC/TPC’s SKU to this new SKU.
1. Look for errors in column A (ERROR). In above example, for row #1 there are 2 errors (E5, E10).
2. Go to Error Code List sheet in the “Validation Report”. Match the errors (E5, E10) against the error code list. It will provide you the cause of the error.
3. Amend the error/s in your original uploaded E23 – excel template file and redo the upload. Repeat this process if there are errors found again in the “Validation Report”.