Scenario
User needs to add a Sales Price to a New Price Level for several Item Records via CSV Import.
For this example, we will use these 3 items with Internal IDs 1664, 1665 & 1672. We will be adding a Price for the NSC Price Level.
Create the CSV File
For this Import, user must create a CSV File with at least the following fields:
Perform the CSV Import
- Go to Setup > Import/Export > Import CSV Records
Step 1: Scan & Upload CSV File
Step 2: Import Options
Step 3: File Mapping (Skip -- not necessary since we only have 1 file)
Step 4: Field Mapping
Step 5: Save Mapping & Start Import
Check the Job Status:
The Price in NSC Price Level should now be updated in the Item Records:
Note: It is suggested that users try doing the import for a few items first (maybe 1-5 items) as a test before doing all an import for items.
-----
If you find this information useful, let us know by reacting or commenting on this post!
Related Discussion: