Import a large number of Rental Products into Ascend

If you have a large number of Rental Products to add to your system, you can easily import them into Ascend instead of creating each one manually.

  1. Download the Rental Product Import Template from www.ascendrms.com.
  2. Enter the following information as needed.
    a. ID: If you are importing new Rental Products, leave this field blank. If you exported your Rental Product list to edit your existing list, DO NOT edit this column.
    Sherpa tip: When sorting in Excel, be sure to sort ALL columns.
    b. Description: Leave this field blank to automatically generate a value based on the other fields in the file.
    c. Style: Enter the style or model name (e.g. Farley EX 9.8, Ballista MIPS Road Bike Helmet).
    d. Size: Enter the product’s size (e.g. 17.5, XL)
    e. Gender: Enter the gender for whom the product was designed.
    f. Color: Enter the color name.
    g. Year: Enter the model year.
    h. Brand: Enter the manufacturer’s brand name.
    i. Manufacturer Part Number: Enter the manufacturer’s part number for the product.
    j. UPC: Enter the UPC or EAN for the product.
    k. Rental SKU: Leave this field blank to automatically generate a value based on the other fields in the file.
    l. Collection: Enter the name of the Collection to which the product belongs. If you wish to assign this product to an existing Collection, enter the name exactly as it appears in Ascend. If no match is found for the value entered, a new Collection is created.
    Sherpa tip: Any new Collections created using the Rental Product import process are assigned the $0 SYSTEM DEFAULT RATE.
    m. Non-Itemized: Enter TRUE if you do not wish to track individual Rental Items. If this field is left blank, the default value of FALSE is used.


  3. Save and close the file.
  4. Navigate to Database Explorer > Reservations > Rental Products in Ascend.
  5. On the toolbar, click the Import button.


  6. Navigate to the location where the spreadsheet is saved and double-click it.
  7. In the Select Columns dialog box, check the fields you wish to import and click the OK button. To select all fields, click the Select All button. To clear all selections, click the Select None button.
    Sherpa tip: ID and Description are required and cannot be unchecked.


  8. On the Data elements will be updated prompt, click the OK button to confirm.


  9. On the Import process complete prompt, click the OK button.

Feedback and Knowledge Base