Reservations Center - Import a large number of Rental Products into Ascend

Written By Ascend knowledge base (Administrator)

Updated at September 6th, 2024

Table of Contents

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 the Retailer Portal linked from www.ascendrms.com directly via this link.
  2. Enter the following information as needed.
    1. 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. 
      Note: When sorting in Excel, be sure to sort ALL columns.
    2. Description: Leave this field blank to automatically generate a value based on the other fields in the file.
    3. Style: Enter the style or model name (e.g. FarleyCircuit WaveCel Road Bike Helmet).
    4. Size: Enter the product’s size (e.g. XL)
    5. Gender: If applicable, enter the gender for whom the product was designed.
    6. Color: Enter the color name.
    7. Year: Enter the model year.
    8. Brand: Enter the manufacturer’s brand name.
    9. Manufacturer Part Number: Enter the manufacturer’s part number for the product.
    10. UPC: Enter the UPC or EAN for the product.
    11. Rental SKU: Leave this field blank to automatically generate a value based on the other fields in the file.
    12. 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. 
      Note: 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. 
      Screenshot of Rental Item Import Template
  3. Save and close the file.
  4. Navigate to Database Explorer > Reservations > Rental Products in Ascend.
  5. On the toolbar, click the Import button. 
    Screenshot of the Rental Products window with Import button highlighted
  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. 
    Note: ID and Description are required and cannot be unchecked. 
    Screenshot of Select Columns pop up with Select All button highlighted
  8. On the Data elements will be updated prompt, click the OK button to confirm. 
    Screenshot of Data elements will be updated prompt with OK button highlighted
  9. On the Import process complete prompt, click the OK button. 
    Screenshot of Import process complete prompt with OK button highlighted

Additional Resources

KB22-212