Customer experience | Sales, Customer Insights,...

Exporting price list items from multiple lists to update manually in Excel

(0) Share

Report

Posted on by A Doecke

Hi All

I need to do a price adjustment to products in multiple price lists that is not consistent as a dollar value or percentage across all products. I believe there is a way to adjust all products by a fixed percentage or value, but that isn't the solution I need.

I have struggled to find a way to export out the necessary data from price lists to be able to edit it in Excel and then reimport.

Is there an easy way?

Cheers

Andrew

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Exporting price list items from multiple lists to update manually in Excel

Hi,

You can find Price List Item in Table:

Then click Data:

Click here to export data:

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Frank Gong

Was this reply helpful? Yes No
A Doecke 65 on at

Like (0)

Report

RE: Exporting price list items from multiple lists to update manually in Excel

Thanks Frank

That gives me a clear process, although it seems like i can only do one price list at a time that way? We have about 30 price lists I need to update.

Is there a way to get more data into the export (for instance product code, price list name columns etc) so that it is easier to identify which data you are working with in Excel?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Exporting price list items from multiple lists to update manually in Excel

Hi,

You can first click Export Price List Items:

Select Static Worksheet to export data:

The exported data looks like this:

Change the data you want, here is Percentage.

Click Settings, select Data Management:

Select imports:

Click import data:

Select the Excel you want to import, click Next, until it is finished

You can observe the successful import

The percentage data has been successfully changed:

If you only want to change some of the specified data, you only need to check the check box in front of the data.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Frank Gong

Was this reply helpful? Yes No