Saturday, September 8, 2018

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:

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

1 comment:

  1. I wish more writers of this sort of substance would take the time you did to investigate and compose so well. I am exceptionally awed with your vision and knowledge. kobe jersey for sale

    ReplyDelete