--- title: Updating Vendor Prices via the Import Data feature. description: You can find the Vendor Price import under File > Import Data to open Select Import Type > Products from the Inventory folder --- [Skip to content](https://hub.acctivate.com/articles/update-vendor-prices-via-import#main-content) [Go to Customer Portal](https://hub.acctivate.com/tickets?hsLang=en) ![Acctivate - A CAI Solution](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg) - [Knowledge Base](https://hub.acctivate.com/articles) Open main navigation Close main navigation - [Knowledge Base](https://hub.acctivate.com/articles) - [Go to Customer Portal](https://hub.acctivate.com/tickets) - [Support Resources / Create Ticket](https://acctivate.com/support) [Support Resources / Create Ticket](https://acctivate.com/support) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://hub.acctivate.com/articles?hsLang=en) 2. [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en) 3. [Costing](https://hub.acctivate.com/articles/inventory?hsLang=en#costing) April 10, 2025 # Updating Vendor Prices via the Import Data feature. ## You can find the Vendor Price import under File \> Import Data to open Select Import Type \> Products from the Inventory folder The **Import Data Feature** permits you to quickly and easily change vendor prices in your system saving you time and a considerable amount of effort. This feature, which is included for free in the base Acctivate module, allows you to mass-update product information (such as Vendor Prices) without need for manual data-entry. You can quickly and easily update product specific vendor prices of existing products in Acctivate with an Excel or a standard CSV file. ### **Select Import Type \[1/5\]** 1. Select **File \> Import Data** to open **Select Import Type,** the first of five windows in Import Data. 2. Click **Products** from the **Inventory** folder in the **#1** **Select Document Type** window. 3. If you’re creating a new template, click **Create Mapping** on the right side of the screen in **#2** **Select Mapping**. It is necessary to create a new mapping profile for the first time that you import a file. When modifying an existing template to use a different spreadsheet, select the specific mapping and click **Edit Mapping**. ![Vendor-Price](https://hub.acctivate.com/hubfs/Vendor-Price.jpg) ### **Mapping Editor \[2/5\]** 1. Choose the Excel (xls, xlsx) spreadsheet or CSV file you wish to import in the **Filename** box within the **Source Spreadsheet** section. After selecting the file to import, the information listed in the file will be displayed in the **Preview** window on the right-hand side of the screen. Each column will be labeled A, B, C, and so on, depending on how many columns there are in your file. 2. If the file contains multiple tabs, select which one you want to import by using the drop-down menu in the **Worksheet** field. 3. Check or uncheck the **First row of spreadsheet contains field names** checkbox depending on the values of the first row on the worksheet. If the first row contains the titles of each column, check the box to view the titles as they are in the file. These titles will not be used in the import process, but rather as a reminder of what information is listed in each column. 4. In the **Summary** section, give the template an **ID**, **Name**, and **Description** to identify what you’re importing, as well as marking the mapping as **Active** (or unchecking the Active box to make it Inactive). Use relevant, unique information for easy recognition in case you wish to go back and reopen the saved mapping at another time. If you’re editing an existing map, you won’t need to specify this information unless you simply want to update it. ![Vendor-Price-Map](https://hub.acctivate.com/hubfs/Vendor-Price-Map.jpg) 5. To map the spreadsheet columns to fields in Acctivate, start by selecting the **Columns** tab. It’s best to name the columns in your spreadsheet as something relatable to the field it will be imported into on the Product Information window. The **Preview** section of the mapping editor shows you which column has been mapped to each field in Acctivate. The top row shows your spreadsheet headers and the second row shows the field it’s mapped to. 6. Click on the specific **Acctivate field** you wish to map to make that row active and choose the column from your spreadsheet in the **Mapped field** section. ![Vendor-Price-Map-Columns](https://hub.acctivate.com/hubfs/Vendor-Price-Map-Columns.jpg) 7. Repeat this process until you have mapped all fields in your spreadsheet you wish to import. - For creating or updating Vendor Prices, map the following fields: **Product ID** in the Product section; **Vendor Name, Price,** and **Price Unit** in the Product Supplier section. If you have information on **Vendor Product ID, Last Price, Lead Time,** or want to add a Vendor **Note**, map those fields, as well. 8. Most customers can leave the **Options** tab as is. These advanced options tell Acctivate how to handle duplicate and missing information. For more information about these options and how they affect the import, check out the [Advanced Import Options article](https://hub.acctivate.com/articles/setup/imports/what-are-the-advanced-import-options?hsLang=en). 9. Once the mapping has been completed/updated, click the **Save Mapping** button. 10. Click the **Begin Import** button, after you have reviewed the information in the **Preview** window for approval. ### **Data Editor \[3/5\]** 1. The third window, called the **Data Editor** will open. 2. Depending on what you want to view in the **Data to Import** data grid, check or uncheck the checkbox near the top that reads **Show Only Invalid Rows**. 3. Near the bottom of the window in the **Statistics** section, the number of passed and failed rows will be shown, as well as a total row count. Please review this information and act accordingly. ![Vendor-name-error](https://hub.acctivate.com/hubfs/Vendor-name-error.jpg) 4. If rows failed, an explanation of the error will be displayed in the **Errors** section, as you select each line. 5. There are a few options for resolving errors: 1. Edit the data from this window. This will not update your spreadsheet, but it will allow you to edit the data in order to import the failed rows. 2. Click the **Back** button, click on the Acctivate field with the error, and **Show Conversions.** This gives you the ability to “convert” values in the spreadsheet from incorrect to correct data. Based on the error shown above, we can setup a conversion for Vendor Name in the previous screen: 3. \[easingslider id="20146"\] 6. Close the Import Data utility, update your spreadsheet, and start the import over. 7. **Note:** Acctivate can create a spreadsheet with all the rows that failed the import (this step is detailed in the Importing \[5/5\] window section, step 2). 8. If the error is not in the source file, the error could have been made when mapping. If this is the case, click the **Back** button and in the **Columns** Tab review your mapping. Re-save if changes are made. 9. When ready, click the **Next** button. ### **Import Confirmation \[4/5\]** 1. The fourth window, **Import Confirmation** will open. ![Vendor-Price-Confirmation](https://hub.acctivate.com/hubfs/Vendor-Price-Confirmation.jpg) 2. Before actually importing the data, review the statistics given in this window. 3. If you approve the provided statistics, Click the **Finish** button. To correct failed rows, see step 5 of the Data Editor \[3/5\]. 4. You will be prompted to backup your database before importing. **Database backup is** *strongly* **recommended.** 5. Click the **Start Backup** button. ![Backup-before-import](https://hub.acctivate.com/hubfs/Backup-before-import.jpg) 6. You will see a “\[...\]Do you wish to proceed?” prompt. Select **Yes**. ### **Importing \[5/5\]** 1. The **Importing** window will open. This window is where the actual data is being imported into Acctivate. A progress bar will show progress as the data is imported into Acctivate. Importing may take a considerable amount of time depending on the size of the file being imported and the speed of your system. Never end task on an import. There could be a large list of rows causing it to seem locked up or frozen or an exception spreadsheet being created for any errors. 2. If there were errors, you will be prompted to create an exceptions spreadsheet. This spreadsheet can be used to cleanup any bad data and re-imported without having to manipulate the original spreadsheet. Each row in the exception spreadsheet will list the specific error that caused it to fail. Click **Yes** and select a location to save it. 3. A pop-up window will appear when the Import process is complete. Click **OK** on this pop-up window. 4. Statistics (as described in the previous steps), as well as, the number and types of records created and updated in Acctivate will be given in the window. If a spreadsheet was created with the failed rows, the Directions Section will appear in this window. It tells the user where the file was saved so it can be opened in another program (i.e. Excel) to make your changes and import the modified spreadsheet. Click the **Open** button and the spreadsheet will open with all the failed rows, which will include the row number as it relates to the your original spreadsheet and exceptions (a brief explanation of why each row failed the import). 5. Click the **Close** button. 6. Open the **Product Information** window in Acctivate verify the **Vendors** tab shows the new/updated vendor prices. - [Getting Started](https://hub.acctivate.com/articles/getting-started?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/getting-started?hsLang=en#basics) - [User Interface](https://hub.acctivate.com/articles/getting-started?hsLang=en#user-interface) - [Manager windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#manager-windows) - [List windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#list-windows) - [Transaction windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#transaction-windows) - [License and Users](https://hub.acctivate.com/articles/getting-started?hsLang=en#license-and-users) - [Email](https://hub.acctivate.com/articles/getting-started?hsLang=en#email) - [Getting Help](https://hub.acctivate.com/articles/getting-started?hsLang=en#getting-help) - [Installation](https://hub.acctivate.com/articles/installation?hsLang=en#main-content) - [Acctivate](https://hub.acctivate.com/articles/installation?hsLang=en#acctivate) - [Database Server](https://hub.acctivate.com/articles/installation?hsLang=en#database-server) - [Mobile WMS Setup](https://hub.acctivate.com/articles/installation?hsLang=en#mobile-wms-setup) - [Software Updates](https://hub.acctivate.com/articles/installation?hsLang=en#software-updates) - [Email Setup](https://hub.acctivate.com/articles/installation?hsLang=en#email-setup) - [Remote Access](https://hub.acctivate.com/articles/installation?hsLang=en#remote-access) - [Configuration](https://hub.acctivate.com/articles/configuration?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/configuration?hsLang=en#basics) - [Users](https://hub.acctivate.com/articles/configuration?hsLang=en#users) - [Company Info](https://hub.acctivate.com/articles/configuration?hsLang=en#company-info) - [Customers](https://hub.acctivate.com/articles/configuration?hsLang=en#customers) - [Sales Orders](https://hub.acctivate.com/articles/configuration?hsLang=en#sales-orders) - [Inventory](https://hub.acctivate.com/articles/configuration?hsLang=en#inventory) - [Custom Fields](https://hub.acctivate.com/articles/configuration?hsLang=en#custom-fields) - [Email Message Templates](https://hub.acctivate.com/articles/configuration?hsLang=en#email-message-templates) - [Services](https://hub.acctivate.com/articles/configuration?hsLang=en#services) - [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en#main-content) - [Products](https://hub.acctivate.com/articles/inventory?hsLang=en#products) - [Costing](https://hub.acctivate.com/articles/inventory?hsLang=en#costing) - [Prices and Units](https://hub.acctivate.com/articles/inventory?hsLang=en#prices-and-units) - [Warehouses and Locations](https://hub.acctivate.com/articles/inventory?hsLang=en#warehouses-and-locations) - [Lot Numbers](https://hub.acctivate.com/articles/inventory?hsLang=en#lot-numbers) - [Inventory Manager](https://hub.acctivate.com/articles/inventory?hsLang=en#inventory-manager) - [Receipts](https://hub.acctivate.com/articles/inventory?hsLang=en#receipts) - [Assemblies](https://hub.acctivate.com/articles/inventory?hsLang=en#assemblies) - [Kits and Assortments](https://hub.acctivate.com/articles/inventory?hsLang=en#kits-and-assortments) - [Landed Cost](https://hub.acctivate.com/articles/inventory?hsLang=en#landed-cost) - [Transfers](https://hub.acctivate.com/articles/inventory?hsLang=en#transfers) - [Adjustments](https://hub.acctivate.com/articles/inventory?hsLang=en#adjustments) - [Counts](https://hub.acctivate.com/articles/inventory?hsLang=en#counts) - [Reports](https://hub.acctivate.com/articles/inventory?hsLang=en#reports) - [Purchasing](https://hub.acctivate.com/articles/purchasing?hsLang=en#main-content) - [Purchase Orders](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-orders) - [Purchase Order Manager](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-order-manager) - [Purchase Invoices](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-invoices) - [Vendors](https://hub.acctivate.com/articles/purchasing?hsLang=en#vendors) - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#main-content) - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#customers) - [Locations](https://hub.acctivate.com/articles/customers?hsLang=en#locations) - [Credit & Terms](https://hub.acctivate.com/articles/customers?hsLang=en#credit-terms) - [Pricing](https://hub.acctivate.com/articles/customers?hsLang=en#pricing) - [Broadcast Email](https://hub.acctivate.com/articles/customers?hsLang=en#broadcast-email) - [Sales](https://hub.acctivate.com/articles/sales?hsLang=en#main-content) - [Orders](https://hub.acctivate.com/articles/sales?hsLang=en#orders) - [Sales Order Manager](https://hub.acctivate.com/articles/sales?hsLang=en#sales-order-manager) - [Picking](https://hub.acctivate.com/articles/sales?hsLang=en#picking) - [Drop Shipments](https://hub.acctivate.com/articles/sales?hsLang=en#drop-shipments) - [Sales Tax](https://hub.acctivate.com/articles/sales?hsLang=en#sales-tax) - [Packaging](https://hub.acctivate.com/articles/sales?hsLang=en#packaging) - [Shipping](https://hub.acctivate.com/articles/sales?hsLang=en#shipping) - [Invoices](https://hub.acctivate.com/articles/sales?hsLang=en#invoices) - [Payments](https://hub.acctivate.com/articles/sales?hsLang=en#payments) - [Credits](https://hub.acctivate.com/articles/sales?hsLang=en#credits) - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#main-content) - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-activities) - [Business Alerts](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-alerts) - [QuickBooks](https://hub.acctivate.com/articles/quickbooks?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/quickbooks?hsLang=en#basics) - [QuickBooks Online](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-online) - [QuickBooks Desktop](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-desktop) - [Mobile WMS](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#basics) - [Picking](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#picking) - [Receiving](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#receiving) - [Counts](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#counts) - [Assemblies](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#assemblies) - [Web Store Integrations](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#basics) - [Templates and Options](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#templates-and-options) - [EDI](https://hub.acctivate.com/articles/edi?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/edi?hsLang=en#basics) - [Orders - 850](https://hub.acctivate.com/articles/edi?hsLang=en#orders-850) - [Shipments - 856](https://hub.acctivate.com/articles/edi?hsLang=en#shipments-856) - [Invoices - 810](https://hub.acctivate.com/articles/edi?hsLang=en#invoices-810) - [Warehouse - 940/945](https://hub.acctivate.com/articles/edi?hsLang=en#warehouse-940-945) - [Reports](https://hub.acctivate.com/articles/reports?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/reports?hsLang=en#basics) - [Standard Reports](https://hub.acctivate.com/articles/reports?hsLang=en#standard-reports) - [Crystal Reports](https://hub.acctivate.com/articles/reports?hsLang=en#crystal-reports) - [Excel](https://hub.acctivate.com/articles/reports?hsLang=en#excel) - [Database](https://hub.acctivate.com/articles/database?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/database?hsLang=en#basics) - [Backup & Restore](https://hub.acctivate.com/articles/database?hsLang=en#backup-restore) - [Microsoft SQL Server](https://hub.acctivate.com/articles/database?hsLang=en#microsoft-sql-server) - [Imports](https://hub.acctivate.com/articles/database?hsLang=en#imports) - [Troubleshoot](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#main-content) - [General](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#general) - [Installation](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#installation) - [Inventory](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#inventory) - [Purchasing](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#purchasing) - [Sales](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#sales) - [Shipping](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#shipping) - [QuickBooks Desktop](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-desktop) - [QuickBooks Online](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-online) - [Mobile WMS](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#mobile-wms) - [Web Store Integration](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#web-store-integration) - [EDI](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#edi) - [Reports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#reports) - [Database](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#database) - [Imports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#imports) - [Email](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#email) - [Integrations](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#integrations) [![Acctivate Inventory Software](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg "Acctivate Inventory Software")](https://acctivate.com) Acctivate Knowledge Base [mailto:support@acctivate.com](mailto:support@acctivate.com) Copyright © 2025, Alterity, LLC