Feature Requests: Provide 'price lists' catering for groups of customers

[nella]

Following on from another post (link below), an improvement on Coupons in this example are Price Lists. These would allow an item to have a standard price (which is the default price list for customers) but then one or more other price lists, each one for a specific group of customers as determined by the user. 

This would be beneficial for retailers who run rewards program for their most valued customers. For example, an item has a standard price of £100. This is the price that is shown for all customers unless they belong to one of groups that has its own price for this product, e.g. "for customer Group X, the price of this item is £90". This therefore does not require the customer to enter a coupon code during checkout, instead he is shown the discounted price on the product page before he adds it to his bag.

For the user, the price list for the product can be updated from the product page or from the Customer Groups page, e.g. "for this item, this group of customers receive 10% discount", or "for all items in this item category, this group of customers receive 10% discount".

Thank you.

https://www.sellercommunity.com/t5/Questions-How-To/Is-there-a-way-to-restrict-Coupons-to-specific-c...

[tranguyen]

Hey @nella, thanks for sharing this! This does sound like a really nifty feature. I'd love to get a bit more information so I can share it with the Product team as well. Would the discounted price only be shown to particular group of customers, i.e., they'd need to be sign in/login in order to see these? And should this look different from the current variation setup? 

[nella]

Hi @tranguyen 

Yes, the discounted price would be shown to the particular customer group only so yes, they would need to sign in/login first in order to see these discounted prices. Before they login they would see the standard price like everyone else.

The current variation setup allows for a unique price for each variation but only one per variation. This is the "standard" price I am referring to. What I am suggesting is that each item can have multiple price lists, so yes, this would be to the variation level as well.

As well as being able to manually write in the price for each variation for each price list, there should be a way to quickly calculate and apply prices to each variation in a particular price list, e.g. "all variations of this item for this price list are 10% less the standard price".

Thank you. 

[tonydow]

If you change the price of an element of a modifier, it will be reflected in all items that use this modifier. 

[nella]

An idea related to this post is prices of items could be managed centrally and linked to batches of items rather than managed from within each item and affecting that item alone. This would allow for very quick updating of prices for multiple items. For some retailers who have many hundreds or thousands of variations of each item with similar prices across items, it is necessary to have a centrally located pricing mechanism as it saves hours when updating prices. Yes, imports from spreadsheets can be done but in our experience, the mechanism outlined below is quicker and leads to fewer errors. 

The way it works is there is a table of price points, which the seller defines, for example like this:

Price point	A	B	C	D	E
Group 1	£ 10	£ 15	£ 20	£ 25	£ 30
Group 2	£ 19	£ 25	£ 29	£ 35	£ 39
Group 3	£ 29	£ 35	£ 39	£ 45	£ 49
Group 4	£ 39	£ 45	£ 49	£ 55	£ 59

Each item is assigned to a 'Group' and each of its variations a 'Price Point'. (The table can have as many rows and columns as the seller wants and there can even be more than one table should they wish it.) This means that the table feeds the item the prices of each variation. The major benefit of working like this is that it is not the large number of items that need to be updated one at a time every time prices are set to rise, but it is the central table that is updated. There is only one table so there is only one update that needs to be done and all items are automatically updated with the latest table information. 

The next time the table is updated, it might look like this:

Price point	A	B	C	D	E
Group 1	£ 19	£ 25	£ 29	£ 35	£ 39
Group 2	£ 29	£ 35	£ 39	£ 45	£ 49
Group 3	£ 39	£ 45	£ 49	£ 55	£ 59
Group 4	£ 49	£ 55	£ 59	£ 65	£ 69

As each item when it was created was assigned to a 'Group', the prices in all the item variations are instantly and automatically updated every time the values in the table are updated. 

The same principle can be applied to Item Modifiers too.

This 'prices of items could be managed centrally' idea is separate to but also works in conjunction with, the 'price lists catering for groups of customers' idea, as per the original post.  

Thanks,