Effective and safest method to mass update item data

supremo

Good day!

We need to update the ff. for multiple items:
-vendor catalog
-item price/vendor
-item standard costs

What is the most effective and safest way to update those data? How do I use dataport to accomplish this?

Thank you so much.

prakashveer

Hi,

this will be better if you use the data migration tool, instead of data port, you can do the following steps.

a. create the template
b. export the data
c. modify the data
d. import the modified excel sheet.

make sure that there should not be any change in the item code.

supremo

Thank you prakashveer! Any idea about the table ID no. of the Purchase Prices?

Kishorm

Table 7012 is "Purchase Price" table

supremo

thank you Kishorm!