I have set up multiple Price definitions for Cost and Trade Price.
Is there a tag I can use so I can show the default, cost and trade prices of a product?
{PRICE:X} is not a valid tag.
How are you figuring your cost and what is Trade Price?
Yes I understand that I was just giving an example of what I’m trying to do.
These prices are configured as price definitions.
I would like to be able to check cost price on the fly so i never give too much of a discount and end up loosing money.
I will not be tracking inventory that is why I am using this method
I tried that method first but I could not retrieve these values using SQL to generate a Costs and Profit report
Tags are stored in this format [{“TN”:“TradePrice”,“TV”:“1.99”},{“TN”:“CostPrice”,“TV”:“1.00”}]
whereas the price definitions are stored individually which makes them easier to select
Id MenuItemPortionId PriceTag Price
51 2 CostPrice 1.50
52 3 CostPrice 2.00
You can get them with SQL. You just couldn’t figure out how?
Yes I have tried before to extract Entity CustomData, specifically e-mail addresses and I could not figure it out. I managed to get it to work when customers had an e-mail address but when it was NULL it gave me errors. That is why I tried to avoid it this time round and the price definitions achieved this for me except for a tag to call them
You can use JSON to get this information. You can also use Custom Report Tags to get it.
This is supported in REPORT ORDER DETAILS tags.
MT.<tag name> Menu Item Custom Tag Value
Price definitions were not meant to be used this way. They were meant for setting prices. Custom Product Tags were meant for this type of thing not exactly but its similar.[quote=“silentbob, post:7, topic:9582”]
Yes I have tried before to extract Entity CustomData, specifically e-mail addresses and I could not figure it out.
[/quote]
This also can be done with JSON or simple REPORT TAGS. Is there a reason you must use SQL?
I may spend a few days learning JSON.
For the minute I will just update the price to cost price and then go back and apply standard or trade price
No reason I just have a good grasp of sql and no experience using JSON or using report tags.
This is the report I built with one sql query.
Would it be possible to achieve this using report tags?
Some customers will have Trade Prices assigned to them by default so this is another reason why i chose to use price definitions.