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

How to bulk update price list using spreadsheet

This manual show the steps to bulk update the prices of a list via spreadsheet instead of doing item by item.

1. Click on "Navigator" icon on the top left corner.

1. Go to navigator

2. Then go to "More".

2. Then go to More

3. After that click on "Download Desktop Integration Installer" button.

3. After that click on Download Desktop Integration Installer

4. It will download a file.

4. It will download a file

5. Follow all the necessary steps to install it.

5. Follow all the necessary steps to install it

6. Finish the installation.

6. Finish the installation

7. After that go to Order Management -> Pricing Adminstration.

7. After that go to Order Management, Pricing Adminstration-1

8. Click on "tasks" icon and then on "Manage Price Lists".

8. Click on task icon and then on Manage Price lists.

9. Input Price List name and click on "Search".

9. Input Price List name and click on Search

10. Click on "Actions" and then on "Download Spdreasheet to Maintain Price List Data".

10. Click on Actions and then on Download Spdreasheet to Maintain Price List Data

11. Open the downloaded file.

11. Open the downloaded file

12. After opening the Excel file go to "Manage Pricing Charges" page.

12. Then go to Manage Pricing Charges page

13. It will show a window asking if you want to open an URL, click on "Yes/Sí".

13. It will show a window asking if you want to open an URL, click on Yes,Si

14. You will have to login Oracle again.

14 You will have to login again

15. After that go to "Maintain Price List Data/Mantener Datos de Lista de Precios" and then click on "Search".

15. After that go to Maintain Price List Data, Mantener Datos de Lista de Precios and then click on Search

16. You will have to input again the price list name. After that click on "Ok".

16. You will have to input again the Price List name. After that click on Ok

17. Wait while Price List is imported to the Excel file.

17. Wait while Price List is imported to the Excel file

18. When Price List is opened then update "Base Price/Precio Base" and then click on "Save" icon.

18. When Price List is opened update Base Price, Precio Base and then click on Save icon

19. Finally, click on "Create or Update/Crear o Actualizar" and close the file.

19. Finally, click on Cretae or Update, Crear o Actualizar and close the file

20. After that check the Price List in system to confirm is updated.

20. After that check the Price List in system to confirm is updated.