- Knowledge Base
- Specs
- Import
-
Getting Help
-
12.3 Specific changes
-
Installation
-
Learn
- Business Activities
- Business Activity Manager
- Business Alerts
- Configuration
- Customer
- Database
- EDI
- General
- Inventory
- Manager Windows
- Mobile
- Picklists (Advanced Picking)
- Product
- Purchasing
- Purchase Order Manager
- QuickBooks & Acctivate Basics
- QuickBooks Desktop Sync
- QuickBooks Online Sync
- Reporting
- Sales
- Sales Order Manager
- Sales Tax
- Server
- Shipping
- Startup
- User Interface
- Webstore
-
Troubleshoot
-
Specs
-
FAQs
Importing in Product Prices
Import Product Prices
To import Price Codes, first create an Excel spreadsheet with your column headings for each field name you wish to import. Using Import Data, map the file location for your spreadsheet to the Filename, choose the correct worksheet if you have multiple sheets in your Excel file, name your import, then use the Columns tab in order to map each Column to its corresponding field. This import is for Price Codes only. For list price, please use the default Product import.
If you would like to add multiple Price Codes to one product, simply list the product ID on a new row for each code you are adding.
In order to import Product Prices go to File > Import Data > Product > Product Prices.
For more information on how Price Codes work in Acctivate click here.
- Required Fields:
- Product ID
- Price Type when assigning price codes.
- Price unit when using all price types besides the (List Price - %) and (List Price + Amount)
For a general guide on importing in data, please check out our docs page.