*Important: Note that CSV Import is irreversible. When performing CSV Import, we highly suggest to initially import/update 1 record as a test to ensure that the expected outcome will happen and will not cause issues to numerous records.
A. Create CSV File
1. Primary File (You can just use Internal ID as the key and leave all the other columns blank) - I suggest to use Internal ID instead of External ID but you can use either as long as you are sure that you have the correct number.
You can find the Item's Internal ID in the URL when you view the Item record (see highlighted):
2. Secondary File - Item Pricing (all of these columns are required, enter your new/updated Price in the Price column)
B. Perform CSV Import
1. Go to Setup > Import/Export > Import CSV Records
2. In the Scan & Upload CSV File step, set the following (upload your primary and secondary/item pricing file by clicking the Select... button)
3. Click Next
4. In the Import Options step, select Update and under Advanced Options, make sure that Overwrite sublist checkbox is not ticked:
5. Click Next
6. In File Mapping, select Internal ID for both Primary File Key Column and Column:
7. Click Next
8. In the Field Mapping step, map the following (no need to map the other fields when only updating price):
9. Click Next
10. In Save mapping & Start Import step, enter Import Map Name (so you can use the template next time)
11. Click Save & Run