Import Product Prices

Below are the fields available for Product Price imports and updates. This import is used to make Price Codes available for each Product ID listed on your spreadsheet. To import Price Code pricing levels, go to File > Import Data > Product > Product Prices. For more information on how Price Codes work in Acctivate click here.

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. Check out this article for step-by-step instructions on importing prices.

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.

Data Field Type(Length) Notes
Product Price
Contract ID Text(25)
Currency Text(3) Predefined list from QuickBooks when multi-currency is in use
Customer ID Text Must match existing CustomerID (customer name) in Acctivate Used for customer specific pricing.
Effective Date Date(MMDDYYYY) Used for date specific pricing, example a special running for one month. This would be the beginning date.
Expiration Date Date(MMDDYYYY) Used for date specific pricing, example a special running for one month. This would be the ending date of promotion.
High Quantity Number This field would be used for pricing based on the quantity of product purchased. The high quantity would be the maximum number for that price or discount.
Low Quantity Number This field would be used for pricing based on the quantity of product purchased. The low quantity would be the minimum number for that price or discount.
Note Text
Price Number Should be exact price, dollar variance or percent depending on the price type selected.
Price Code Text(3) User defined in configuration manager.
Price Type Text(2) Price(P), List + Price (L$), List – % (L%), Mgmt Cost + %,(S%) Mgmt Cost + $ (S$), Avg Cost + % (C%), Avg Cost + $ (C$), Last Cost + % (M%), Last Cost + $ (M$)
Price Unit Text(5) UOM defined in configuration manager. This would be the unit you are applying the price or discount to. (Ex: Cs gets price code B; Ea gets price code A)
Product ID Text Existing Product ID in Acctivate