QuickBooks® Inventory
Control and Business
Management Software

Update Vendor Prices with the Data Import Feature
Need to mass-update product prices from a CD? Let ACCTivate! do it for you!

ACCTivate! users may not know of the powerful time-saving capabilities found in the Data Import feature.

This feature, which is included for free in the base ACCTivate! module, allows you to mass-update product information (such as Product Prices) without need for manual data-entry.

You can quickly and easily update product specific prices of already existing products in ACCTivate! with an Excel file or a standard CSV file that contains products you already have in ACCTivate!.

How does it work?
The five step process is detailed in the ACCTivate! Help Files.

The first step begins the process of the import. On this screen you select the type of import that you want to complete and select (or create) the mapping that you want to apply to it.

The second step involves the mapping editor and selecting the document to import data from. When a document is selected, the section will be populated with the previously saved mappings for that type.

New and unsaved mapping allow you to configure the fields that are mapped together (see image below) and then save this as a mapping type.



The third step begins when you click Begin Import and it verifies that the data will be properly imported into ACCTivate!. Each row is listed line-by-line with the imported columns and the data that occupies each record.

The fourth step actually does the work of importing. You can review the information in the statistics, then click the finish button. The import will now begin after you have been prompted to backup your database. Again, it is strongly recommended that you backup before each import.

The fifth and final step is designed to show you relevant information about your import, or if any errors have occurred. Along with the statistics, you can also see the records that were created and updated.

Summary:
ACCTivate! allows you to bypass the long and arduous task of manually importing all vendor price changes to each database.

The Data Import Feature permits you to quickly and easily change all product prices in your system saving you time and a considerable amount of effort.

Back to top