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 Codes, 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.
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.
|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.|
|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|