Is it possible to display a "Starting at" price on the CTGY Page that is pulled from the Inventory Variant (if there is one)?
Announcement
Collapse
No announcement yet.
Starting at pricing using Inventory Variants
Collapse
X
-
Starting at pricing using Inventory Variants
Leslie Kirk
Miva Certified Developer
Miva Merchant Specialist since 1997
Previously of Webs Your Way (aka Leslie Nord leslienord)
Email me: [email protected]
www.lesliekirk.com
Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr
Tags: None
-
If your not using (or need to account for) customer discounts, what we do is stuff the lowest price (from) into a product custom field. You can populate that field by creating a product listing page that has protected access and run through the product/attribute listing then save it to the product custom field. This has the advantage of reducing processing time on the Category Page.
Bruce Golub
Phosphor Media - "Your Success is our Business"
Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
phosphormedia.com
-
Originally posted by Bruce - PhosphorMedia View PostIf your not using (or need to account for) customer discounts, what we do is stuff the lowest price (from) into a product custom field. You can populate that field by creating a product listing page that has protected access and run through the product/attribute listing then save it to the product custom field. This has the advantage of reducing processing time on the Category Page.Leslie Kirk
Miva Certified Developer
Miva Merchant Specialist since 1997
Previously of Webs Your Way (aka Leslie Nord leslienord)
Email me: [email protected]
www.lesliekirk.com
Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr
Comment
-
Originally posted by lesliekirk View Post
Yeah, I need to account for that "stuff" too.Highly caffeinated
http://www.coffeehouseexpress.com
Comment
-
Originally posted by William Davis View PostLeslie Kirk
Miva Certified Developer
Miva Merchant Specialist since 1997
Previously of Webs Your Way (aka Leslie Nord leslienord)
Email me: [email protected]
www.lesliekirk.com
Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr
Comment
-
I've done this sort of thing for a couple of clients, as part of a custom module. But a module isn't always needed; I can write some template code to pull the number from the store's DB. As Bruce mentioned, this could slow down the page load somewhat. But I know some shortcuts to improve the performance, as long as the number of products per page isn't too high, and the products don't have large numbers of variants. You can PM or email me for details.Kent Multer
Magic Metal Productions
http://TheMagicM.com
* Web developer/designer
* E-commerce and Miva
* Author, The Official Miva Web Scripting Book -- available on-line:
http://www.amazon.com/exec/obidos/IS...icmetalproducA
Comment
-
Here is an code sample to calculate the high/low range for a product:
https://docs.miva.com/code-samples/variant-price-range
Keep in mind this is an "expensive" calculation to make since you're loading and looping though all variants. If a product has 10 variants its not an issue. If a product has 1000 variants its will add some load time to a page. If you're doing this dynamically on a category page with a lot of products there is going to be a negative impact on load time,
The better method I would recommend would be to have a feed that has this code and calculates the lowest price or range then saves that value back to a custom product field. Then you can load that data on any page you need it and set the feed to re-run nightly.
Comment
-
he better method I would recommend would be to have a feed that has this code and calculates the lowest price or range then saves that value back to a custom product field.Bruce Golub
Phosphor Media - "Your Success is our Business"
Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
phosphormedia.com
Comment
Comment