Updating customer information, many customers at once

Updating customer information, many customers at once

Summary

Using the SWCS 4.2 Export Utility, Microsoft Excel and the SWCS 4.2 Import Utility, update information such as active status, shipping method, etc. for many customers at once.

More Information

The Solatech Window Covering Software allows you to edit only one customer at a time. If you need to change many customers at the same time, for example changing the active status from active to inactive or changing the shipping method for all customers in a specific zip code from FedEx to UPS, you would have to do it one by one.

Now, using the new SWCS 4.2 Export Utility and SWCS 4.2 Import Utility you can update information for many, or all, of your customers at the same time.

Note: To perform the steps in this article you will need to use Microsoft Excel to format the exported data prior to importing.

This Tips and Tricks article can be found here:

http://www.solatech.com/tipsandtricks/swcstt_bulkcustchange.pdf.

APPLIES TO

  • Solatech Window Covering Software 4.2

    • Related Articles

    • Importing customer information from 4.2 to SalesPRO

      Summary This article will step you through the process of exporting customers from your SWCS company database using the SWCS 4.2 Export Utility, updating the exported data in Microsoft Excel and then importing the customer information into SalesPRO. ...

    • Exporting Customers from SWCS

      Summary There may be times when you need to export some details about the customers you have in your Solatech Window Covering Software so that you can use that information in another application. For example if you want to get a list of e-mail ...

    • Setting up Customer Email Templates

      Summary Solatech allows users to set up personalized email templates that can be sent to customers from within the system.  Templates to send to users (Sales Reps and Installers) can also be created.  This knowledge base articles provide instructions ...

    • Customers with parent customers don't export to QuickBooks correctly

      Symptoms When a customer that has a parent customer is exported to QuickBooks the parent customer information is not included in the export file. Cause This is caused by a bug in the SWCS QuickBooks module. Workaround There is no known workaround at ...

    • Importing customers from external sources

      Summary Solatech Focus users have the ability to import customers from external sources, such a CRM systems. In order to do this, the data exported from the outside source must be formatted in a certain way before import.  This knowledge base article ...