Skip to main content

Search

Welcome to Telgoo5 Support

Adding Inventory: SIMs in Bulk

Gather Inventory Data & Download the Template

  1. Locate the email containing the inventory spreadsheet with tracking numbers and your physical SIM lists.


 

  1. Log into Telgoo5 and navigate to Inventory > Manage Inventory.


 

  1. Select the Add Bulk Unit tab.


 

  1. Click Download template to download the CSV upload template.


 

Format and Populate the CSV File

Open your downloaded template in Excel and configure the columns as outlined below:


 


 

Column Mapping & Field Instructions:

  • Product ID (Column A): Delete any placeholder data. To find the correct Product ID, click the bold Product ID link under the upload box in Telgoo5 to view the Product List. 

  • Locate ID #1 (SIM Card for all devices SIM).


 

  • Excel Tip: To quickly fill down consecutive data or static values, enter your data in the first row, then double-click the tiny square (fill handle) in the bottom-right corner of the cell box to drop the info down the column.
  • IMEI (Column B): Leave blank.
  • SIM (Column C): Delete the top sample SIM. Highlight the entire column, right-click, choose Format Cells, and change the formatting to Text. This ensures long numbers paste correctly without scientific notation errors. 

  • Copy and paste your SIM numbers from your SIM spreadsheet into Column C.



 

  • Excel Tip: Click the top cell of a column, press Ctrl + Shift + Down Arrow, then copy/paste to quickly grab only populated rows.


 

  • Assign to Agent (Column D): Set to Corporate_Master (this can be dropped down from what’s already in the sample file).

  • Carrier (Column E): Set to BLUECONNECTSATT (ensure you remove /TAL if present before dropping information down).

  • PUK 2 (Column F): Fill in if available; otherwise, leave blank.
  • PO Number (Column G): Input the PO number found in your inventory email confirmation.
  • Reserve for portin (Column H): Input N and drop down

  • Plan Code (Column I): Leave blank.
  • Zip code (Column J): Leave blank.
  • Activate (Column K): Input N and drop down

  • Telephone Number (Column L): Leave blank.
  • ACP Co-Pay Amount (Column M): Leave blank.
  • ACP Device Reimbursement Amount (Column N): Leave blank.
  • Device Retail Price (Column O): Leave blank.
  • Is e-SIM (Column P): Input N for physical SIMs (use Y if uploading eSIMs).

  • UICCID (Column Q): Leave blank.


 

Save as CSV & Upload to Telgoo5

  • In Excel, go to File > Save As, and choose CSV (Comma delimited) as the file type.
  • Save it in an easily accessible folder like Downloads.
  • Close the spreadsheet and return to the Add Bulk Unit screen in Telgoo5
  • Click inside the Click or Drag file upload box.

  • Locate and select your saved CSV file from your computer and click Open.


 


 

  • Click the green Upload button to initiate the background process.


 

Verify the Upload

  1. Once uploaded, a status tracker will appear at the bottom of the page indicating that the file is In Queue.


 

  1. Allow a few moments for processing (you can safely refresh your browser tab). The status will update to green Complete with your total successful records matching the file count.


 

  1. Double-Check: Copy any uploaded SIM number from your inventory file, paste it into the global customer/inventory search bar at the top of Telgoo5, and select Inventory Search. Verify that the status reads Free and is assigned to CORPORATE MASTER.