Import a large number of vendor products into Ascend

Importing products via spreadsheet is the most efficient way to add a large number of products to your system.

Choose which vendor products to import carefully. For every 1,000 products imported, your database size increases by approximately 1MB. Larger database sizes can significantly impact performance.

Always verify product information is correct before importing. And if you're updating pricing for products already in your database, you must uncheck the Import Only New Option before importing your spreadsheet. Please remember to re-enable this option after the import is complete to avoid unwanted changes.

Make sure to create an Ascend database backup before importing any spreadsheets. Some critical information cannot be recovered without it!

If your shop is part of a multi-store chain, make sure the spreadsheet is only imported once from a single location (using any workstation).  

  1. Download the product spreadsheet from www.ascendrms.com. Numerous vendors provide Ascend with product information on a regular basis.
    Sherpa Tip: If a current spreadsheet is not available, ask the vendor(s) to participate in Ascend's Vendor Update program. For more information on the program, email lists@ascendrms.com.
  2. Ensure the Import Only New feature is always checked in your app options before importing any spreadsheet.  
  3. From the Ascend Desktop, select the File menu > Import > Vendor Products.
  4. Navigate to the location where you saved the file and double-click it.
  5. Click the appropriate vendor.
  6. Double-check your vendor selection, and then select OK.
  7. Select the fields you wish to import and click OK.
  8. On the confirmation prompt, click OK.
  9. The import progress displays. Click OK when complete.
If your shop is part of a multi-store chain, contact your other locations to verify changes if you suspect an issue after importing a spreadsheet.

Feedback and Knowledge Base