Update the Price Levels on Matrix Items Through CSV Import

To update Item Price Level on Matrix Items via CSV import, perform the following steps:

     1. Create the CSV file with the following columns:

• Internal ID
• Item Name/Number
• Price Level
• Qty
• Price
• Sample CSV file:

Internal ID	Item Name/Number	Price Level	Qty	Price
64	Jersey : LA Lakers 09 : LA Lakers 09-L-Y	Base Price		59.99
64	Jersey : LA Lakers 09 : LA Lakers 09-L-Y	Base Price	15	69.99
64	Jersey : LA Lakers 09 : LA Lakers 09-L-Y	Base Price	20	79.99
64	Jersey : LA Lakers 09 : LA Lakers 09-L-Y	Alternate Price 1		25
64	Jersey : LA Lakers 09 : LA Lakers 09-L-Y	Alternate Price 1	15	35
64	Jersey : LA Lakers 09 : LA Lakers 09-L-Y	Alternate Price 1	20	45

    
     2. Navigate to Setup > Import/Export > Import CSV Records.
     
     3. Select Item in the Import Type field.
     
     4. Select the Record Type (e.g. Inventory Item).
     
     5. Click Select.
     
     6. Locate the CSV file, then click Open.
     
     7. Click Next.
     
     8. Select Update for Data Handling.
     
     9. Click Next.
     
     10. In the Field Mapping section, set the following:

     
       11. Click Next.
     
     12. Provide Import Map Name.
     
     13. Click Save & Run.