Skip to content
English
View your tickets
  • There are no suggestions because the search field is empty.

How to bulk update List Price

This manual show you how to bulk update the List Price of items using a template.

I. Edit Item import template section.

1. Open the "Halo_item_import" template.

1. Open the template.

 
2. Go to "EGP_SYSTEM_ITEMS_INTERFACE" tab and input the following information:
 
Transaction Type column should have "UPDATE" value.
In "BATCH ID" column input the corresponding ID.
Also input the corresponding value in "Batch Number" column.
In "Item Number" column input the corresponding item code.
OUTSIDE_PROCESS_SERVICE_FLAG" has the default "N" value.
In "Organization Code" input the corresponding organization.
 
In this example we are going to update the List Price of 3 items: 
 
0400665-NOBC-SUB in MAST_HALO
BLIN in MIM1-OI
LUGS in MIM2-OI
2. Go to EGP... Tab and input the following informaiton...

3. Finally, input the new list price in the "List Price" column (it is in the IA column).

3. finally input the new list price (is in the IA column)

4. Now go to "Instructions and CSV Generation" tab and click on "Generate CSV file".

4. Go to instructions tab and click on Generate CSV file.

5. Input the name and save it.

5. Input name and save it .

6. It will show a message saying file has been created. Click on "ok" or "Aceptar".

6. it eill show a essage click on acepta.r

II. Load Interface File for Import section.

7. Now go to Tools -> Scheduled Processes.

7. Now fgo to tools, scheduled processes.

8. Click on "Schedule New Process".

8. Click on schedule new process.

9. After that click on the more options icon and then on "Search".

9, click on more optiosnicon and then on search

10. Input "Load Interface File for Import" and click on "Search".

10. input load interface file for import and then on search

11. Select it and click on "ok".

11. select it and click on ok

12. It will change the window. Click again on "ok".

12. click again on ok

13. It will change again the window. In the "Import Process" field select the more options icon and click on "Search".

13. iN the import process field select the more options icons adn clck on search

14. Input "Item Import" and then click on "Search"

14. input item import and then click on search

15. Select it and click on "ok".

15. Select it and click on Ok

16. You'll go back the previous window. Now in the "Data file" field select the more options icon and then on "Upload a new file".

16. now in the data file field selet the more optiosn icon and then on upload a new file

17. Click on "select file" or "Elegir archivo".

17. click on select file or elegir archivi.

18. Select the zip file you created and click on "open" or "Abrir".

18. selet the zip fiel you created and clikc on abrir or open

19. Now click on "ok".

19. now click on okm

20. You'll go back to the previous window. After that click on "Submit".

20. and click on submit.

21. It will show you the process ID. Click on "ok".

21. it will show you the porcess ID, click on ok

22. Wait until the process is succedeed.

22. wait unitl proes is succedeed.

III. Import Item section.

23. Now is necessary schedule a new process.

23. now is necesary schedule a new proces.

24. The steps are the same:

24. the steps re the same

25. Now input "Item Import" and click on "Search".

25. now input imte improt and click on search

26. Select it and click on "ok".

26. select it and click on ok

27. Click again on "ok".

27. clikc on ok

28. Input the batch ID and click on "Submit".

28. input the atch id and click on submit.

29. It will show the process ID. Click on "ok".

29. it will show the process id, click on ok.-1

30. Wait until process is succeeded.

30. wai until is succeeded.

IV. Check updated information section. We will check if List Price is updated for the 3 items we selected. Let's start

31. Now go to Product Management -> Product Information Management.

31. now got o prodyct management, product iformaiton managemetn.

32. Click on tasks icon and after that on "Manage Items".

32. click on tasjs iscon and manage items

33. Input item code for the first item and click on "Search".

33. input item code and click on search

34. Click on it.

34.. click on it

35. Go to "Specifications", "Purchasing" and check that "List Price" field is updated.

35. go to specificaitons, purchaing and finally you can check list price is updated.

36. Now we'll check the same information for BLIN item in MIM1:

36. BLIN in mim1

37. "BLIN" List Price is correct.

37. BLIN is correct

38. And finally let's check "LUGS" item in MIM2:

38. now lets check LUGS in mim2

39. "LUGS" also is ok.

39. LUGS alsi is ok.