Change price of items with $ or %

Version 4 V4 Request
1

Dear @Emre, I have to change my whole menu price list. some items will have a fixed amount increase and others will have a percentage.

Is there any way to do this without going thru all menus and changing them manually?

Thanks!!!

G.

2

Nope, but you can use Products > Price List Editor to help speed things up.

Theoretically, you could do it in SQL as well, but your Products would need to be very well grouped/categorized for it to be efficient.

@emre, speaking of the Price List Editor, can you possibly add a columns for GroupCode and Tag? It would help with searching, sorting and filtering for more efficient editing.

1 Like
3

I do use Price List Editor… but its a lot of work… I have a lot of items and 2 price lists…
Having a tool to do this would be a GREAT feature…

G.

4

Ok @gerlandog, so what would this tool be able to do that is not already covered by the Price List Editor? What are the details of the Tool that you would like to see? What extra functionality does it have? How can @emre build a the Tool that you want without an understanding of what it is that it is supposed to be able to do?

5

I would like to see a screen where you have X textboxes:

Product:
Portion:
Group:

Fixed Amount
Percentage

So if you complete any of those, calculate the new price.

for example:

Product (blank)
Portion: Grande
Group: Pizza

Fixed Amount: 1;00
Percentage: 10%

that would add to ALL PIZZAS THAT HAVE A GRANDE PORTION $1 and 10% to the price

Product: Sandwich
Portion: (blank)
Group: (blank)

Fixed Amount: 1;00
Percentage: 10%

That would add to ALL PRODUCTS THAT HAVE HE WORD SANDWICH $1 and 10% to the price

Thanks!!!

G.

1 Like
6

Look at your Products, Portions, and Prices:

USE [SambaPOS4]

SELECT
 mi.[Id]
,mi.[Tag]
--,mi.[CustomTags]
,mi.[GroupCode]
,mi.[Name]
,mp.[Name] as [PortionName]
,p.[Price] as [PortionPrice]
--,p.[PriceTag]
FROM [MenuItems] mi
left join [MenuItemPortions] mp on mp.[MenuItemId]=mi.[Id]
left join [MenuItemPrices] p on p.[MenuItemPortionId]=mp.[Id]
WHERE 1=1
AND p.[PriceTag] is null
ORDER BY mi.[GroupCode], mi.[Name], mp.[Id]

Update to Add 1 dollar:

UPDATE pri SET pri.[Price] = pri.[Price] + 1
FROM [MenuItems] prod
left join [MenuItemPortions] por on por.[MenuItemId]=prod.[Id]
left join [MenuItemPrices] pri on pri.[MenuItemPortionId]=por.[Id]
WHERE 1=1
AND pri.[PriceTag] is null
AND prod.[GroupCode]='Pizza'
AND por.[Name]='Grande'

Update to Add 10%:

UPDATE pri SET pri.[Price] = pri.[Price] + (pri.[Price] * 0.1)
FROM [MenuItems] prod
left join [MenuItemPortions] por on por.[MenuItemId]=prod.[Id]
left join [MenuItemPrices] pri on pri.[MenuItemPortionId]=por.[Id]
WHERE 1=1
AND pri.[PriceTag] is null
AND prod.[GroupCode]='Pizza'
AND por.[Name]='Grande'

Modify as required…
Are you adding 1 then applying 10% to the +1 price? Run the queries in the order shown.
Or do you want 10% applied, then plus 1? Run the queries in reverse.

1 Like
7

ja… the last two times Ihad to do a massive change of prices, was that way… but since all pos in pos industry do have it, I tought that it would be a good idea to get a change price tool…

Thanks!!!

G.

8

So as we have Ask Question action what we need is an action that can run parameterized sql queries?

9

I was not execting this answer…LOL
I was tinking more like a back ofice tool, some kind of panle in the PRICE LIST EDITOR screen…
this will not be a daily basis use tool…

Thanks!!!

G.

10

Yes I’ve already added your request in my todo list. I was just brainstorming for a quicker solution. I thought if it can be a feature useful for other things.

1 Like