Using a CSV import to update a large volume of records may greatly amplify any errors in field mappings or field values.
It is best you test this on one record first or on your Sandbox account (if applicable).
-
Create a CSV Import Template.
-
Note: The CSV template should contain the information of all Qty columns that you would like to retain. Using the example above the CSV Import template should contain the following column headings:
-
Internal ID of the Item
-
Item Pricing 1 : Price
-
Item Pricing 1 : Price Level
-
Item Pricing 1 : Quantity (The column value should be 0)
-
Item Pricing 2 : Price
-
Item Pricing 2 : Price Level
-
Item Pricing 2 : Quantity (The column value should be 5)
-
-
Update the Item through CSV Import to remove the last Qty column heading:
-
Navigate to Setup > Import/Export > Import CSV Records
-
Select Items in the Import Type field
-
Select Record Type
-
Select the CSV File
-
Click Next
-
Select Update in Data Handling
-
Click Advanced Options
-
Put a check mark on Overwrite Sublists
-
Click Next
-
Type the Import Map Name
-
Click Save & Run
-
-
Create a CSV Import Template. The CSV template should contain the information for the new Qty column heading
-
Internal ID of the Item
-
Item Pricing 1 : Price
-
Item Pricing 1 : Price Level
-
Item Pricing 1 : Quantity (The column value should be 20)
-
-
Update the Item through CSV Import to add the new Qty column heading:
-
Navigate to Setup > Import/Export > Import CSV Records
-
Select Items in the Import Type field
-
Select Record Type
-
Select the CSV File
-
Click Next
-
Select Update in Data Handling
-
Click Next
-
Type the Import Map Name
-
Click Save & Run
-