Cannot upload SKU using template

Creation date: 30/10/2025 11:38    Updated: 30/10/2025 11:38   @excelsku @importsku
Question:

Monday September 15, 2025 12:08 PM
Created by: Johanna Castro


Hi,


We would like to seek your assistance regarding our concern on uploading new SKU using BAS_SKU template.




INCIDENT REPORT

IT WMS 25-16

Customer name: Noel Garcia
Issue Description: Cannot upload Package using template
Affected Environment: Test
Affected warehouse: Tunasan
Screenshots of error messages: < Attachment >
Time when issue occurred: 9/15/2025 11:58
Affected module: BAS_SKU Upload
Detailed description of issue: Cannot upload Location using template due to error " 
import.Info.RowResultE212"
Expected result: To upload in Location using the template
First level investigation/troubleshooting taken: created sku master error
Case replication in original warehouse: < Details of replicated case >
Sample Screenshot:

Answer:

Thursday September 18, 2025 11:50 AM
Commented by: Johanna Castro


The superuser informed CSO that upload was successful based on the provided information. Ticket can now be closed pending submission of customer satisfaction survey.


Tuesday September 16, 2025 1:54 PM
Commented by: Johanna Castro


INVESTIGATION:
  • Error is the same with Issue #90281894.
  • From initial investigation, the SKU upload template has some mandatory fields that are left blank.
  • Requested the user to fill up these mandatory fields and re-upload again to see if error will be the same.
  • Upon discussion with PSO consultant, there are columns that require data maintenance. These are pertaining to the SKU Group columns.

ROOT CAUSE:
  • import.Info.RowResultE212 is due to missing system code maintenance. The SKU upload template accomplished by the superuser utilized the SKU Group columns that require data maintenance.
  • Upload will fail as there are mandatory columns (those in red) left blank.

SOLUTION:
  • Cell format should be Text.
  • Provide data for the following mandatory columns:
    • Tare
    • Cube
    • Price
    • Reorder Qty
    • CHK SCN UOM
    • Copy Pack ID LOTATT12 TO
    • Kit Flag
    • QTY Min
    • QTY Max
    • Break CS
    • Break IP
    • Maintenance Type
    • First OP
    • Medicine Specical Control
    • Second SerialNO Catch
    • Print Medicine QC Report
    • SN ASN QTY
    • SN SO QTY
    • Scan When Case Picking
    • Scan When Piece Picking
    • Scan When Check
    • Scan When Receive
    • Scan When Putaway
    • Scan When Pack
    • Scan When Move
    • Scan When QC
    • SerialNO Catch
    • Tolerance
    • Free Pick Gift
  • Maintain the SKU Group data in the System Code module (note that the Code ID only allows maximum of 20 characters). The steps are as follows:
    • Go to System Code module.
    • In Code Type, you can search for the specific Code ID (i.e. SKU_GRP_3) or do a wildcard search to view all applicable results (i.e. querying SKU_GRP% will show SKU_GRP_1 to SKU_GRP_9).
    • Double click on the specific Code ID then click on the Details tab.
    • You can manually add the data here or upload via Import file.