We have a file which we keep of different customer groups. (e.g wholesale & retail).
We want to display different prices depending on the group.
I know this is possible by individually going into each product and assigning customer group prices but we have 1000's of products and would be too time consuming.
Is there a way to do this more efficiently? Possibly by a csv upload or some other method?
Hi @chrisbraga0be0 ,
Can you please check the below link. I hope it helps you.
https://docs.magento.com/user-guide/system/data-advanced-price.html
Thanks!
Problem Solved! Click 'Kudos' & Accept as Solution.
Hi @chrisbraga0be0
kindly follow below steps:
1. Go to Admin > System > Data Transfer > click on "Import"
2. Select Entity type "Products"
3. Download Sample file [for reference]
4. Create your own csv for your products in which you want to update field value.
5. Now move to "Select File to Import" and upload your csv.
It will help you to resolve issue.
If issue resolve, please click on 'Kudos' & Accept as Solution!
First, notice that you have your regular product price entered in the first tab under Prices.
However, we need to set up Group Price.
Click on the orange button that says Add Group Price.
You will see new tabs appear and they will let you determine to which customers (which website and customer group) will the prices apply.
Lastly, you have a tab where you should type in your new price.
Also, notice that by repeatedly clicking Add Group Price orange radio button, you are able to enter different prices for as many different customer groups as you wish (see the screenshot above).
It can be quite a handy option since for sure you don’t want to limit your product to be available to only one customer group under a special price.
So, if you wish, go ahead and determine as many different prices for as many different groups as you want.
Next, we will show you how to add Tier price.
Tier price allows you to set discount price based on the number of products purchased.
It can be done by using the same method as the one that we used when we were setting up group prices.
First, click on the orange Add Tier button.
Again, similar to the previous example, you will have the option to choose who will benefit from the discount.
So, choose the website and, once more, choose a customer group from the dropdown menu.
Now, pay attention – you need to set up the quantity.
Set up the lowest quantity that will provide a discount for the customer and enter the price.
Again, if you want to add more tiers, click red radio button and continue adding customer groups, quantities and prices.
In the end, all you need to do is click Save orange button in the upper right part of the screen and you’re done!
Welcome your different customers, offer them special prices and ensure bright future for your online business!
Various tools are available, like Mass Importer Pro, which will import prices, even group prices, in no time. It's one of the quickest price import tool available for Magento.