Importing Pricing Data for Items
The way you import prices varies depending on the features enabled in your account. If your account uses Multiple Prices, Quantity Pricing, or Multiple Currencies, you use the Item Pricing sublist. Otherwise, your pricing data is fairly simple, and you map prices using the Purchase Price body field. This topic deals primarily with the Item Pricing sublist.
When using the sublist, be aware of the following:
-
The preferred column headers for item pricing in CSV files vary, depending on whether you plan to upload a single file or multiple files. For more information, see Formatting for Item Pricing CSV Files.
-
The Item Pricing sublist can be selectively updated based on key field values. The key fields vary depending on the pricing-related features that are enabled. For more information, see Keys for Item Pricing Sublist.
-
For multiple pricing levels, if the CSV file data includes a base price for an item, all discount or markup price levels are always calculated during import. You do not need to supply discount or markup price values, because the import process overrides any values specified in the CSV files.
-
If you are using both multiple price levels and quantity-based pricing, every quantity must have a price defined at every price level. For more details, including examples of how to set up your CSV files to accommodate these fields, see Imports Using Multiple Price Levels and Quantities Example.
-
For any items that have quantity pricing schedules applied to them, you need to specify only a price for quantity zero for the price levels that you are using. The import process calculates other quantity prices. If you try to specify a price for any quantity besides zero for an item with a pricing schedule, the import fails. For more details, including examples of how to set up your CSV files, see Imports Using Quantity Pricing Schedules Example.
-
For CSV updates to items with quantity-based pricing, base price updates do not result in updates to other price levels, unless import data specifies a quantity pricing schedule or schedules.
-
For multiple currencies, the Import Assistant calculates price levels for the base currency specified. The Currency field is required to be mapped for item pricing imports in accounts where the Multiple Currencies feature is enabled.
-
You shouldn't enable the Overwrite Sublists option for imports that include item pricing data. Enabling this option may result in errors when imported sublist data overwrites existing sublist values driven by body field values such as pricing schedule.
-
When multiple item-pricing fields (price level, currency, quantity, and price) are mapped for an import job, and a row has values for some of these fields but not for others, none of the values for pricing fields are imported for the row. The assumption is that the populated values for pricing fields are defaults, and the empty values in other pricing fields indicate that complete pricing data is not available and so pricing field values should not be imported at all.
Keys for Item Pricing Sublist
The import of pricing sublist data for items is supported when one or more of the following features are enabled: Multiple Currencies, Multiple Prices, or Quantity Pricing.
The Import Assistant can selectively update existing NetSuite records that match CSV file key field values. The key for this sublist's records is based on a unique field value or a unique combination of field values, depending on the enabled features. The following table describes possible key combinations.
Enabled Features |
Key Fields |
---|---|
Multiple Currencies only |
Currency |
Multiple Currencies, Multiple Prices |
combination of Currency, Level |
Multiple Currencies, Quantity Pricing |
combination of Currency, Quantity |
Multiple Currencies, Multiple Prices, Quantity Pricing |
combination of Currency, Level, Quantity |
Multiple Prices only |
Level |
Multiple Prices, Quantity Pricing |
combination of Level, Quantity |
Quantity Pricing Only |
Quantity |
Formatting for Item Pricing CSV Files
The formatting of CSV import files differs for multiple file and single file uploads of item pricing data. It may also vary depending on the features enabled in your account. To see how you might set up your files, refer to Imports Using Multiple Price Levels and Quantities Example and Imports Using Quantity Pricing Schedules Example.
Related Topics
- Items Import
- Item Record Types that Can Be Imported
- Item Sublists Available for Import
- Notes about Items Imports
- Selecting General Ledger Accounts for Item Imports
- Importing Demand Planning Data for Items
- Importing Related Items Groups
- Importing Matrix Options for Items
- Replacing the Bill of Materials Sublist with the CSV File