Check out the Cloud Product Catalog
One of the most important tasks you have is building your product records. Use the Cloud Product Catalog to create Product records on demand as opposed to importing entire Supplier (Vendor) catalogs. Check out our articles, Ascend HQ - Cloud Product Catalog Set up and Products - Using the Cloud Product Catalog.
Importing products via spreadsheet is the most efficient way to add a large number of products to your system.
Always Verify Product information is Correct Before Importing
If you have obtained product data from Ascend ShareFile, those files are formatted correctly and ready for import into Ascend. If you have created a spreadsheet on your own, please be sure it is properly formatted with unique part numbers, descriptions, UPCs (if available) and you have checked for duplicates, etc.
If you're updating pricing for products already in your database, we encourage you to use our Ascend HQ - Price Update Tool. Pricing updates can also be done manually through Vendor (supplier) imports, Products - Handling Vendor/Supplier Price Changes (Updates).
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).
Considerations for items ordered in bulk (case quantity)
Some vendors/suppliers may provide MSRPs for only the entire case – not individual items. Always check pricing information for these products prior to importing.
- After downloading the appropriate vendor/supplier list, open the spreadsheet in Microsoft Excel (or other spreadsheet program) and sort the CaseQty column by Largest to Smallest values (this brings all “bulk” products to the top of the list).
- Note: Be sure to sort the entire spreadsheet – when prompted, select the Expand the selection option.
- For each product, verify the MSRP value is accurate for individual items.
- Adjust MSRP values as needed, or remove the row from the spreadsheet and update the product manually.
- Note: Be sure to remove the entire row – if there’s a blank row in the spreadsheet, the import will stop at that row, and any products after it will not be updated.
- Save and close the spreadsheet.
Importing vendor product lists
- Download the product spreadsheet from www.ascendrms.com. Numerous vendors provide Ascend with product information on a regular basis.
- Note: 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.
- Ensure the Import Only New feature is always checked in your app options before importing any spreadsheet, unless you intend to overwrite ALL products included in the spreadsheet.
- From the Ascend Desktop, select the File menu > Import > Vendor Products.
- Navigate to the location where you saved the file and double-click it.
- Click the appropriate vendor.
- Double-check your vendor selection, and then select OK.
- Select the fields you wish to import and click OK.
- On the confirmation prompt, click OK.
- 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.
KB22-109