How do I search and order consecutive phone numbers?

Follow

Chase Greiser

Updated

When ordering multiple phone numbers in the Bandwidth Dashboard, you may prioritize your search for consecutive ones using our Consecutive Number Searching feature. While we can't guarantee that we have a stock of consecutive phone numbers in our available inventory, the Consecutive Number Searching feature helps you locate those groups of consecutive phone numbers that may be available.

Note: We want to ensure that all users abide by our community guidelines and best practices, so please take a few minutes to review how to be a good steward of consecutive phone number ordering.

How do I use the Consecutive Number Searching feature?

  1. Log into the Bandwidth Dashboard.
  2. In the top navigation bar, click Numbers and select Buy Numbers.
  3. Under Phone number type, select Regular.
    • Note: This feature only supports regular phone numbers at this time.
  4. Under Any preferences?, select Only show groups of consecutive numbers.
  5. Under Minimum quantity, specify the minimum quantity of consecutive numbers that you want to see.
    • Note: The maximum quantity is limited to 100 phone numbers per search.
  6. Under Type to select your search criteria, enter the criteria you want to search the number by. You can search by area code (NPA), rate center, city, state/province, ZIP/postal code, or LATA. 
  7. Click Search

Screen_Shot_2020-10-14_at_12.35.50_PM.png

  1. Under Available Consecutive Phone Numbers, navigate to the group(s) of consecutive phone numbers you'd like to choose from. To select numbers, you can either click on each number individually or click on one number and drag your cursor to select multiple at once.  
  2. All selected numbers will be added to your cart. Click Continue to proceed to the Place & Purchase page.
    • Note: Back orders cannot be placed for consecutive group(s) of numbers.

Screen_Shot_2020-10-14_at_12.38.36_PM.png

  1. Once you’re on the Place & Purchase page, choose your Sub-account and Location where you want your numbers to reside. You can also enter an optional Order description and Customer Order ID.
  2. Click Purchase to complete your order.

Screen_Shot_2020-10-14_at_12.57.43_PM.png

How do I use the spreadsheet?

Note: This is a legacy method for searching and ordering consecutive phone numbers, but it’s still available for you to use.

  1. Log into the Bandwidth Dashboard.
  2. In the top navigation bar, click Numbers and select Buy Numbers.
  3. Under Phone number type, choose Regular.
    • Note: This feature only supports regular phone numbers at this time.
  4. Under Any preferences?, select Only show groups of consecutive numbers.
  5. Under Minimum quantity, specify the minimum quantity of consecutive numbers that you want to see.
    • Note: The maximum quantity is limited to 100 phone numbers per search.
  6. Under Type to select your search criteria, enter the criteria that you want to search the number by. You can search by area code (NPA), rate center, city, state/province, ZIP/postal code, or LATA. 
  7. Click Search.
  8. Select Export Results at the bottom of the page. This will download the Excel file into your web browser. 
    • Note: If you don’t see the file, please make sure your browser is set to allow pop-ups from the Bandwidth Dashboard and try again. If you still can’t locate it, check the Downloads section in your browser or the Downloads folder on your computer.
  9. In the Excel file, highlight cell B3, navigate to the Formulas tab, and click Insert Function.
  10. In the Formula Builder sidebar, select IF and click Insert Function.

Screen_Shot_2020-10-14_at_2.26.39_PM.png

  1. Next, enter the following:
    • Under logical_test: A3-A2=1
    • Under value_if_true: Yes
    • Under value_if_false: No
  2. Click Done.

Screen_Shot_2020-10-14_at_2.25.24_PM.png

  1. In cell B3, double click the small square in the bottom right corner to apply the formula to the entire spreadsheet.
    • Note: This function will populate YES by each of the consecutive phone numbers. Please rearrange your spreadsheet so that it only contains the phone numbers you want to order on your account.

To upload your saved CSV file, perform the following steps:

  1. Return to the Bandwidth Dashboard.
  2. In the top navigation bar, click Numbers and select Buy Numbers.
  3. Click Upload a .CSV link located right below the top navigation bar. This will bring up an Upload & Buy Numbers window. 

Screen_Shot_2020-10-14_at_1.06.14_PM.png

  1. Drag and drop your saved CSV file into the File field or click Browse to search and upload it from your computer.
  2. Select your Sub-account and Location.
  3. Click Upload.

Questions? Please open a ticket with your Bandwidth Support Team or hit us up at (855) 864-7776!

Article is closed for comments.