Import Tier Pricing with Excel

Im using nopC 3.80 and I have price changes to deal with. All of my tier prices are already in Excel. Many products has up to 5 tier's.

Is there a way to import the tier prices that I have in excel? Are there any addon's that can do that?

Thanks if you can help! :)

2 years later and now using nop 3.90 I am still wanting to know the answer to this question.

How to export and change prices with tier pricing then import it in again.

I don't see a way from the UI. But if you have access to the database, you can update directly in the table TierPrice.

smartegicsys wrote:

Can I do that with the Free MySQL program?

I have not tried. But these are possible options.

https://alternativeto.net/software/sql-server-management-studio/?license=opensource

smartegicsys wrote:

Sorry to bother you, but which one do you recommend for nop? My sites are on a hosting providers server. appliedi.net.

I added new feature.
Export only tier prices.
https://www.nopcommerce.com/p/1930/price-manager-import-export-update-foxnetsoftcom.aspx

You can start with DBeaver. However, I would suggest to try foxnetsoft's product. I think it would help you on what you need to do.