Scenario
User needs to add Items and Price Level to the Customer Record > Financial tab > Item Pricing subtab via CSV Import.
For this example, we will use these 3 items with Internal IDs 1664, 1665 & 1672. We will be adding the NSC Price Level to the Customer CUS77 NSC Test Customer A with Internal ID: 1072.
Create the CSV File
For this Import, user must create a CSV File with at least the following fields:
- Internal ID (Customer)
- Internal ID (Item)
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 Items and Price Level should now be added in the Customer Record:
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: