Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Item price within order

Avatar

Level 1

I appreciate any help the group can provide.

 

I'm interested in a method to identify the price of an individual item within an order total and then return the number of orders where the item in order was $x.

 

We have items generally for sale on the site, but depending on a promo code applied, discount, etc. that individual item could be $19.99 in the cart or sell for $24.99 for example. Even though the order total could include accessories, warranty, and assembly I'd like to know if the SPECIFIC ITEM in the order sold for $19.99 or not.

 

Custom segment, metric using a canned formula, other ideas?

1 Reply

Avatar

Community Advisor

You could use merchandising eVars in your product notation to store things like promo code applied, discount, actual purchase price, etc. Setting these eVars up to stored as text, you would be able to break down the individual values per product separate from the revenue collected as a whole.