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

    • 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 ...
    • 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. ...
    • Customers with parent customers don't export to QuickBooks Desktop correctly

      Symptoms When a customer that has a parent customer is exported to QuickBooks Desktop (QBD) the parent customer information is not included in the export file. Cause This is caused by a bug in the SWCS QBD module. Workaround There is no known ...
    • 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 ...
    • Creating mailing labels for your SWCS customers

      Summary Using the SWCS 4.2 Export Utility and Microsoft Word, create mailing labels for the customers in your Solatech Window Covering Software. More Information Microsoft Word has powerful mail merge capabilities that can be used to easily create ...