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).
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).
Sherpa tip: 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
Sherpa tip: 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.
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 firstname.lastname@example.org.
- 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
- 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.