Ideas Portal
We have an item that can be ordered in 2 standard sizes, but also can be ordered at a custom size. This way the customer can choose what he/she wants. Right now the custom size fields have to be visible and can be very confusing to the customer. Also, if they choose a standard size AND type in numbers in the custom size fields, the prices of the 2 are added together. No bueno!
Hi Jim - I'm happy to share a video showing how this can be accomplished. The links have expirations on them, however - so if you aren't able to reach the link, just reach out to me at proservices@aleyant.com and I'll be happy to change the expiration on the links at that time. The links are set to a company-wide expiration timeframe that I can't override.
Here's the Knowledge Base article on setting up a spreadsheet pricing engine:
https://support.aleyant.com/kb/a599/ch_-014_-creating-a-spreadsheet-method-pricing-engine.aspx
Also, you can download a sheet here:
spreadsheet calculator pricing engine example
I did use suppression, which I don't think is something covered in the KB article, but it is described . I just put a True statement in column C next to the size, so if the choice isn't shown in the list of sizes when the selection is made, it won't display the empty cells. I did this screencast for a specific user, so the ending is obviously pointed direct to the client.
Here is a screencast of me describing how the spreadsheet calculator above works
Lisa,
Trent mentioned that there are webinars explaining how this can be accomplished. Can you or he post a link to the webinars? Or is it only possible with the help of Professional Services?
Thanks, Lisa - good to hear from you! I'll check with Kevin about the Professional Services dept. I'm so anxious to know this that I may just foot the bill myself if I have to. :)
Hi Jim - I have been able to create suppression spreadsheet pricing engines, where choices appear based on another option. If you are still interested, please submit a ticket at support.aleyant.com, and choose the Professional Services department. We'd love to hear from you!
Trent,
You mention that this is capable in a Spreadsheet Pricing Engine. How can that be accomplished? I have a solid working knowledge of the Speadsheet method, but I have never seen anything about being able to hide/display options based on currently selected options. That would be awesome!
Hi Jim, in Pressero a Spreadsheet Pricing Engine has this ability. This is also a functionality of our MIS software, PrintJobManager (https://printjobmanager.com/) with the abiliy to use suppressions. Suppresions with PrintJobManger can allow you to have your pricing engines set up with a set of intelligent questions. So based on what option you choose, a second question could appear. We also have a couple of webinars that show that functionality.
I know not the best workaround but maybe possibly doing its own custom product , and one thats a standard size product option.