Show Sale Price and Regular Price

[wsmike]

I am a site owner with very little code writing experience. I know a little html, but that's about it.
I recently had Miva install a dev store with a ready theme and had them install it with all files etc. from the existing store.
The existing store shows the regular price and the sale price. I think I remeber purchasing some kind of module, but I could be wrong, but for years we've been able to show a sale price, which was the price field, and a regular price, which was stored in the cost field. We didn't use the weight field, so we simply used that for the cost (wholesale or what we paid for the item).

On the dev site, that functionality seems to be gone. Anyone have a clue how I can get that back. Someone at Miva who was helping me set it up sent me a little ditty of code that said this should work, but I have no clue where to insert it. She also mentioned that I may need o set up a sales price group>... not sure what that means either.

Here is the code she sent:

<div class="product-price">
Price:
<span id="price-value-additional" style="text-decoration: line-through"></span>

<span id="price-value" class="bold">&mvt:product:formatted_base_price;</span>

<div id="product-discounts">
</div>
</div>

If someone could explain to me where to put the code, and what she means by a sales price group, I'd be very grateful. I asked her, but I think I've already asked too many questions and I sense I've worn out that welcome.

Mike

[Mark Hood]

Re: Show Sale Price and Regular Price

Try this and its not a module just template changes..

<mvt:if expr="l.settings:product:cost GT l.settings:product:price">
<p class="ctgy-price"><span id="price-value-reg"><s>Regular Price:&mvt:product:formatted_cost;</s></span></p>
<p class="prod-sale-price"><span id="prod-sale-price">Sale Price:&mvt:product:formatted_price;</span></p>        
<mvt:elseif expr="l.settings:product:price GT '0.00'">
<span id="price-value" class="bold">Price: </span>
    <span id="price-value-additional" style="text-decoration: line-through">
        <mvt:if expr="l.settings:product:base_price GT l.settings:product:price">    
           <span id="price-value" class="bold"> &mvt:product:formatted_base_price;</span>
        </mvt:if>
    </span>
    <span id="price-value" class="bold">&mvt:product:formatted_price;</span>
    <div id="product-discounts"></div>
</mvt:if>

I think the code that was sent to you may have been the default and had nothing to do with the cost field. You'll actually replace that with my example and see what you get.

[wsmike]

Re: Show Sale Price and Regular Price

Mark,
Thank you for supplying the code. At the risk of sounding stupid, into what template should I insert the cose, and where in the template. As you can tell, I'm pretty new at this.
Mike

[wsmike]

Re: Show Sale Price and Regular Price

Thank you Mark. It took a bit of trying to figure out which templates to put the code into, and where in the template, but it worked just fine. Thank you again!
Mike

[lesliekirk]

Re: Show Sale Price and Regular Price

Mark,

Have you tried this code? (I ask because I can't seem to get it to work)

<mvt:if expr="l.settings:product:base_price GT l.settings:product:price">					<p><strong class="strike">&mvt:product:formatted_base_price;</strong><strong class="red">&mvt:product:formatted_price;</strong></p>
				<mvt:else>
					<p><strong>&mvt:product:formatted_price;</strong></p>
				</mvt:if>

I've got the higher price in the Cost Field but it doesn't seem to work as I think it should.

[Mark Hood]

Re: Show Sale Price and Regular Price

Mark,

Have you tried this code? (I ask because I can't seem to get it to work)

<mvt:if expr="l.settings:product:base_price GT l.settings:product:price">                    <p><strong class="strike">&mvt:product:formatted_base_price;</strong><strong class="red">&mvt:product:formatted_price;</strong></p>
                <mvt:else>
                    <p><strong>&mvt:product:formatted_price;</strong></p>
                </mvt:if>

I've got the higher price in the Cost Field but it doesn't seem to work as I think it should.

The code I shared works for me but the code you shared doesn't say "cost" anywhere?...
My code is checking for cost greater than price first and the full code with toolkit savings is

<mvt:if expr="l.settings:product:cost GT l.settings:product:price"><p class="ctgy-price"><span id="price-value-reg"><s>Regular Price:&mvt:product:formatted_cost;</s></span></p>
<mvt:if expr="l.settings:product:inv_level NE 'out'">
<mvt:if expr="l.settings:product:cost GT l.settings:product:price">
<mvt:item name="toolkit" param="math_subtract|difference|l.all_settings:product:cost|l.all_settings:product:price" />
<mvt:item name="toolkit" param="math_divide|result|difference|l.all_settings:product:cost" />
<mvt:item name="toolkit" param="sassign|value2|100" />
<mvt:item name="toolkit" param="math_multiply|times|result|value2" />
<mvt:item name="toolkit" param="math_round|times|times|2" />
<p class="savings">
Savings: &mvt:global:times;%
</p></mvt:if></mvt:if>
<p class="prod-sale-price"><span id="prod-sale-price">Sale Price:&mvt:product:formatted_price;</span></p>		
<mvt:elseif expr="l.settings:product:price GT '0.00'">
<span id="price-value" class="bold">Price: </span>
    <span id="price-value-additional" style="text-decoration: line-through">
        <mvt:if expr="l.settings:product:base_price GT l.settings:product:price">    
           <span id="price-value" class="bold"> &mvt:product:formatted_base_price;</span>
        </mvt:if>
    </span>
    <span id="price-value" class="bold">&mvt:product:formatted_price;</span>
    <div id="product-discounts"></div>
</mvt:if>

[wsmike]

Re: Show Sale Price and Regular Price

I had to play with the placement of the code, but got it to work. Here is the code on my Category Display Page and in the Category Product List Layout section. About three quarters of the way down you'll see Start Custom Code, and end custom code, which is where I placed the code to make it work. Good luck. Please let me know if it worked out for you. Maybe we can help each other. I'd love to talk to other's attempting to do some of this stuff on their own. Share ideas, problems etc.

<div class="row bg-white bottom-shadow filter-items-container">
<div class="column whole medium-half large-one-third sorting">
<mvt:if expr="l.settings:category_listing:products_on_page _count GT 1">
<form method="get" action="&mvte:global:sessionurl;" class="inline-labeling nm">
<input type="hidden" name="Screen" value="&mvte:global:Screen;" />
<input type="hidden" name="Store_Code" value="&mvte:global:Store_Code;" />
<input type="hidden" name="Category_Code" value="&mvte:global:Category_Code;" />
<input type="hidden" name="Product_Code" value="&mvte:global:Product_Code;" />
<input type="hidden" name="Search" value="&mvte:global:Search;" />
<input type="hidden" name="Per_Page" value="&mvte:global:Per_Page;" />
<label for="l-sort-by" class="medium uppercase">Sort By</label>
<select name="Sort_By" id="l-sort-by" class="input-medium" onchange="this.form.submit();">
<mvt:if expr="ISNULL g.Sort_By">
<option value="disp_order" selected="selected">Sort By&hellip;</option>
<mvt:else>
<option value="disp_order">Sort By&hellip;</option>
</mvt:if>
<mvt:if expr="g.Sort_By EQ 'newest'">
<option value="newest" selected="selected">Newest</option>
<mvt:else>
<option value="newest">Newest</option>
</mvt:if>
<mvt:if expr="g.Sort_By EQ 'bestsellers'">
<option value="bestsellers" selected="selected">Best Selling</option>
<mvt:else>
<option value="bestsellers">Best Selling</option>
</mvt:if>
<mvt:if expr="g.Sort_By EQ 'price_asc'">
<option value="price_asc" selected="selected">Lowest Price</option>
<mvt:else>
<option value="price_asc">Lowest Price</option>
</mvt:if>
<mvt:if expr="g.Sort_By EQ 'price_desc'">
<option value="price_desc" selected="selected">Highest Price</option>
<mvt:else>
<option value="price_desc">Highest Price</option>
</mvt:if>
<mvt:if expr="g.Sort_By EQ 'name_asc'">
<option value="name_asc" selected="selected">Name Ascending</option>
<mvt:else>
<option value="name_asc">Name Ascending</option>
</mvt:if>
<mvt:if expr="g.Sort_By EQ 'name_desc'">
<option value="name_desc" selected="selected">Name Descending</option>
<mvt:else>
<option value="name_desc">Name Descending</option>
</mvt:if>
</select>
<noscript><input type="submit" value="go" title="go" /></noscript>
</form>
<!-- end sorting -->
</mvt:if>
</div>
<nav class="column whole medium-half large-three-twelfths medium-align-right large-align-left per-page">
<mvt:if expr="l.settings:category_listing:products_on_page _count GT 1">
<ul>
<li class="medium uppercase">View</li>
<mvt:if expr="g.Per_Page EQ 12">
<li><a href="&mvte:global:sessionurl;Screen=&mvte:global: Screen;&Store_Code=&mvte:global:Store_Code;&Catego ry_Code=&mvte:global:Category_Code;&Product_Code=& mvte:global:Product_Code;&Search=&mvte:global:Sear ch;&Sort_By=&mvte:global:Sort_By;&Per_Page=12" data-selected="selected">12</a> &#47;</li>
<mvt:else>
<li><a href="&mvte:global:sessionurl;Screen=&mvte:global: Screen;&Store_Code=&mvte:global:Store_Code;&Catego ry_Code=&mvte:global:Category_Code;&Product_Code=& mvte:global:Product_Code;&Search=&mvte:global:Sear ch;&Sort_By=&mvte:global:Sort_By;&Per_Page=12">12</a> &#47;</li>
</mvt:if>
<mvt:if expr="g.Per_Page EQ 24">
<li><a href="&mvte:global:sessionurl;Screen=&mvte:global: Screen;&Store_Code=&mvte:global:Store_Code;&Catego ry_Code=&mvte:global:Category_Code;&Product_Code=& mvte:global:Product_Code;&Search=&mvte:global:Sear ch;&Sort_By=&mvte:global:Sort_By;&Per_Page=24" data-selected="selected">24</a> &#47;</li>
<mvt:else>
<li><a href="&mvte:global:sessionurl;Screen=&mvte:global: Screen;&Store_Code=&mvte:global:Store_Code;&Catego ry_Code=&mvte:global:Category_Code;&Product_Code=& mvte:global:Product_Code;&Search=&mvte:global:Sear ch;&Sort_By=&mvte:global:Sort_By;&Per_Page=24">24</a> &#47;</li>
</mvt:if>
<mvt:if expr="g.Per_Page EQ -1">
<li><a href="&mvte:global:sessionurl;Screen=&mvte:global: Screen;&Store_Code=&mvte:global:Store_Code;&Catego ry_Code=&mvte:global:Category_Code;&Product_Code=& mvte:global:Product_Code;&Search=&mvte:global:Sear ch;&Sort_By=&mvte:global:Sort_By;&Per_Page=-1" data-selected="selected">All</a></li>
<mvt:else>
<li><a href="&mvte:global:sessionurl;Screen=&mvte:global: Screen;&Store_Code=&mvte:global:Store_Code;&Catego ry_Code=&mvte:global:Category_Code;&Product_Code=& mvte:global:Product_Code;&Search=&mvte:global:Sear ch;&Sort_By=&mvte:global:Sort_By;&Per_Page=-1">All</a></li>
</mvt:if>
</ul>
<!-- end per-page -->
</mvt:if>
</nav>
<div class="column hide large-show large-five-twelfths align-right page-links">
<mvt:if expr="l.settings:category_listing:page_links:last_ page GT 1">
<span class="page-links-container">
<mvt:if expr="l.settings:category_listing:page_links:curre nt_page NE 1">
<a href="&mvte:category_listing:page_links:prev_link; " class="page-links-previous rt-icon-arrow-left"></a>
<mvt:else>
<span class="page-links-previous page-links-deactivated rt-icon-arrow-left"></span>
</mvt:if>
<mvt:if expr="NOT l.settings:category_listing:page_links:contains_fi rst">
<a href="&mvte:category_listing:page_links:first_link ;" class="page-links-inactive">1 &hellip;</a>
</mvt:if>
<mvt:foreach iterator="pages" array="category_listing:page_links:pages">
<mvt:if expr="l.settings:category_listing:page_links:curre nt_page EQ l.settings:pages:page_num">
<span class="page-links-active">&mvte:pages:page_num;</span>
<mvt:else>
<a href="&mvte:pages:link;" class="page-links-inactive">&mvte:pages:page_num;</a>
</mvt:if>
</mvt:foreach>
<mvt:if expr="NOT l.settings:category_listing:page_links:contains_la st">
<a href="&mvte:category_listing:page_links:last_link; " class="page-links-inactive">&hellip; &mvte:category_listing:page_links:last_page;</a>
</mvt:if>
<mvt:if expr="l.settings:category_listing:page_links:curre nt_page NE l.settings:category_listing:page_links:last_page">
<a href="&mvte:category_listing:page_links:next_link; " class="page-links-next rt-icon-arrow-right"></a>
<mvt:else>
<span class="page-links-next page-links-deactivated rt-icon-arrow-right"></span>
</mvt:if>
</span>
<!-- end page-links -->
</mvt:if>
</div>
</div>
<!-- end filter-items-container -->
<div id="js-product-list" class="row bg-white bottom-shadow category-product-layout">
<mvt:foreach iterator="product" array="category_listing:products">
<mvt:if expr="l.settings:product:customfield_values:custom fields:product_flag NE 'none'">
<mvt:assign name="l.settings:product:flag" value="'flag--' $ tolower(l.settings:product:customfield_values:cust omfields:product_flag)" />
</mvt:if>
<div class="column half medium-one-third category-product">
<a href="&mvte:product:link;" title="&mvte:product:name;">
<span class="flag &mvt:product:flag;">
<mvt:if expr="NOT ISNULL l.settings:product:imagetypes:main">
<img src="&mvte:product:imagetypes:main;" alt="&mvte:product:name;" title="&mvte:product:name;" />
<mvt:else>
<img src="../images/img_no_thumb.jpg" alt="&mvte:product:name;" title="&mvte:product:name;" />
</mvt:if>
<mvt:if expr="l.settings:seo_settings:sl_active">
<span class="button button-square bg-yellow white uppercase quick-view" data-product-link="&mvte:product:link;?show=quickview">Quick View</span>
<mvt:else>
<span class="button button-square bg-yellow white uppercase quick-view" data-product-link="&mvte:product:link;&show=quickview">Quick View</span>
</mvt:if>
</span>
<span class="breaker"></span>
<p>&mvte:product:name;</p>
<mvt:if expr="l.settings:product:base_price GT l.settings:product:price">
<p><strong class="strike">&mvt:product:formatted_base_price;</strong><strong class="red">&mvt:product:formatted_price;</strong></p>
<mvt:else>
<p><strong>&mvt:product:formatted_price;</strong></p>



















<!-- start custom code -->
<mvt:if expr="l.settings:product:cost GT l.settings:product:price">
<p class="ctgy-price"><span id="price-value-reg"><s>Regular Price:&mvt:product:formatted_cost;</s></span></p>
<!-- <p class="prod-sale-price"><span id="prod-sale-price">Sale Price:&mvt:product:formatted_price;</span></p> -->
<mvt:elseif expr="l.settings:product:price GT '0.00'">
<span id="price-value" class="bold">Price: </span>
<span id="price-value-additional" style="text-decoration: line-through">
<!-- <mvt:if expr="l.settings:product:base_price GT l.settings:product:price"> -->
<!-- <span id="price-value" class="bold"> &mvt:product:formatted_base_price;</span> -->
</mvt:if>
</span>
<span id="price-value" class="bold">&mvt:product:formatted_price;</span>
<div id="product-discounts"></div>
</mvt:if>
<!-- end custom code -->




















</mvt:if>
</a>
</div>
</mvt:foreach>
</div>
<!-- end category-product listings -->
<mvt:if expr="l.settings:category_listing:page_links:last_ page GT 1">
<div class="row bg-white bottom-shadow filter-items-container bottom-pagination">
<mvt:if expr="l.settings:category_listing:page_links:last_ page GT 1">
<div class="column whole align-center medium-align-right page-links">
<span class="page-links-container">
<mvt:if expr="l.settings:category_listing:page_links:curre nt_page NE 1">
<a href="&mvte:category_listing:page_links:prev_link; " class="page-links-previous rt-icon-arrow-left"></a>
<mvt:else>
<span class="page-links-previous page-links-deactivated rt-icon-arrow-left"></span>
</mvt:if>
<mvt:if expr="NOT l.settings:category_listing:page_links:contains_fi rst">
<a href="&mvte:category_listing:page_links:first_link ;" class="page-links-inactive">1 &hellip;</a>
</mvt:if>
<mvt:foreach iterator="pages" array="category_listing:page_links:pages">
<mvt:if expr="l.settings:category_listing:page_links:curre nt_page EQ l.settings:pages:page_num">
<span class="page-links-active">&mvte:pages:page_num;</span>
<mvt:else>
<a href="&mvte:pages:link;" class="page-links-inactive">&mvte:pages:page_num;</a>
</mvt:if>
</mvt:foreach>
<mvt:if expr="NOT l.settings:category_listing:page_links:contains_la st">
<a href="&mvte:category_listing:page_links:last_link; " class="page-links-inactive">&hellip; &mvte:category_listing:page_links:last_page;</a>
</mvt:if>
<mvt:if expr="l.settings:category_listing:page_links:curre nt_page NE l.settings:category_listing:page_links:last_page">
<a href="&mvte:category_listing:page_links:next_link; " class="page-links-next rt-icon-arrow-right"></a>
<mvt:else>
<span class="page-links-next page-links-deactivated rt-icon-arrow-right"></span>
</mvt:if>
</span>
</div>
</mvt:if>
</div>
<!-- end filter-items-container bottom-pagination -->
</mvt:if>

[lesliekirk]

Re: Show Sale Price and Regular Price

Mark, the code I'm trying to use and cannot get to work is part of the Iron & Wool ReadyTheme. I was thinking it would "know" that the &mvt:product:formatted_base_price; is the Cost Field since there doesn't seem to be any Base Price Field for the product. I truly do not know what I'm doing wrong and I'd really like to use the native code:

<mvt:if expr="l.settings:product:price GT 0">					<div id="js-price-value" class="h3 charcoal nm" data-base-price="&mvt:product:price;">&mvt:product:formatted_price;</div>
				<mvt:else>
					<div id="js-price-value" class="all-hidden" data-base-price="&mvt:product:price;"></div>
				</mvt:if>
				<mvt:if expr="l.settings:product:base_price GT l.settings:product:price">
					<p>Normally: <s id="js-additional-price">&mvt:product:formatted_base_price;</s>
				<mvt:else>
					<br />
				</mvt:if>

				<div id="js-product-discounts"></div>

When I look at the generated page the data-base-price is the product price and it looks like the Product Cost field is being ignored. I took a look at the token list variables and the value for &mvt:product:formatted_base_price; is the Product Price.

I have even tried switching to the Point & Click mode but I'm not sure what should be selected for the Displayed Price: and what should be selected for the Additional Price Display:. I've tried a number of combinations and don't get anything except a screwed up layout.

[Mark Hood]

Re: Show Sale Price and Regular Price

&mvt:product:formatted_base_price; is NOT Cost. I'm not sure what you mean by native code since it never used the cost field in the first place?
&mvt:product:formatted_base_price; is now used with marketing ability to change price.

You need this just like what you've always used except now if you so choose you could have cost > price/use marketing for timed sales as well (this is where base_price comes into play I believe). Of course if you also use the specific price marketing you have a field on the product setup page which I have not explored.

<mvt:if expr="l.settings:product:cost GT l.settings:product:price"><p class="ctgy-price"><span id="price-value-reg"><s>Regular Price:&mvt:product:formatted_cost;</s></span></p>
<p class="prod-sale-price"><span id="prod-sale-price">Sale Price:&mvt:product:formatted_price;</span></p>        
<mvt:elseif expr="l.settings:product:price GT '0.00'">
<span id="price-value" class="bold">Price: </span>
    <span id="price-value-additional" style="text-decoration: line-through">
        <mvt:if expr="l.settings:product:base_price GT l.settings:product:price">    
           <span id="price-value" class="bold"> &mvt:product:formatted_base_price;</span>
        </mvt:if>
    </span>
    <span id="price-value" class="bold">&mvt:product:formatted_price;</span>
    <div id="product-discounts"></div>
</mvt:if>

[lesliekirk]

Re: Show Sale Price and Regular Price

The code I'm trying to use is what is part of the Iron & Wool Theme which I guess is also adding these choices in the Point & Click mode:



So what you are saying is that the Cost field can't be used with this code, that it's only for the Marketing stuff? Then that would mean even additional code it going to need to be crafted to allow the store to use the Cost field on a daily basis and then the Marketing discounts as needed?

I'll change the code to get the usage of Cost fields back in play...this is like two steps back.

Oh vey!

[Pamela Hazelton]

Re: Show Sale Price and Regular Price

Out of curiosity - any reason you aren't using the built-in feature using a Price Group?

[Brennan]

Re: Show Sale Price and Regular Price

The cost field was never intended to be used as MSRP field. You're still able to do it, but you will need to add the code to the page template to display it.

The better way to do it (in Version 9) is to use the built in price groups, specifically specific sale price to all both the MSRP and the sale price to show.

[lesliekirk]

Re: Show Sale Price and Regular Price

Store owner with thousands of parts that has used the Cost Field for the Retail Price and the Price Field for the Sale price for YEARS now.

Is there an export/import method to assign all to products and their sale prices into the Price Groups? Keep in mind, store owners that have been using this method found it extremely convenient to use the cost field.

[Mark Hood]

Re: Show Sale Price and Regular Price

I'm going to continue using my cost field for a few reasons. The prices are next to each other on the adding of a product page. They are also next to each other on import/export. Last but not least I fear that if someone ever accidentally deleted the price group the prices would be all poof gone (REAL BAD DAY)

I have no idea why my code works just fine for me.. I assume you simply copy and pasted it to your page as a test and it still did not work. Must be something different with your installation but as it stands I can use the cost/price method as well as marketing tools to display pricing on my prod/ctgy/srch screens with that code. Nothing with the Ready themes or version 9 makes it so you can't.

[Pamela Hazelton]

Re: Show Sale Price and Regular Price

Store owner with thousands of parts that has used the Cost Field for the Retail Price and the Price Field for the Sale price for YEARS now.

Is there an export/import method to assign all to products and their sale prices into the Price Groups? Keep in mind, store owners that have been using this method found it extremely convenient to use the cost field.

I was talking about a new setup. I certainly wouldn't change what's already in place. But, the answer to your question is yes on the import of the sale prices.

I have not tried importing price group assignments, but if a product is assigned and the "sale price" custom field is equal to or higher than the product price, it won't do anything.