[SOLVED]Conditional logic regarding the formula

[Stephane PISKORZ]

Hi,

I just purchased the WooCommerce Price Calculator this morning. I’m hoping to achieve one thing, using the conditional logic (I hope it is the right thing to do). Here’s what I’d like to obtain :
– the visitor chooses the cloth
– according to his choice, different fields appear below : dimension A and dimension B
– then the price is calculated according to the formula (problem is, the formula is changing according to the cloth previously chosen)

So far, I’ve managed to reach step 1 and 2, but I have trouble getting to the last one. I’ve attached my excel spreadsheet so that you can have a look. Really looking to read from you.

Best regards,

[Naidi]

Hi Stephane,

there must be just on cell that will contain the final price.
You can check in our site the real-world case to see how you can create an excel spreadsheet in order to use it with WooPrice.
Best cases : https://altoswebsolutions.com/live-demo/best-cases.
Documentation tutorial : https://altoswebsolutions.com/manual/woo-price-calculator/start
https://altoswebsolutions.com/manual/woo-price-calculator/creating-a-calculator-from-a-spreadsheet-file-pro

Best regards.
Naidi
AT957

[Stephane PISKORZ]

Hi Naidi,

Thank you for your reply. I took a close look at the different sheets from the “best cases”: it is interesting. However, when I take a look at my formula, I indeed need different output prices, as the formula is different according to the cloth chosen. I’m not sure that I should use this plugin to achieve that? Even with the SEARCHV function, I couldn’t manage to do it. I’ll try something else in the meantime beacuase I’m on a schedule and I wouldn’t want to fall behind. Best regards,

[Naidi]

Hi Stephane,

you can output different values at the same time using the output fields : https://altoswebsolutions.com/manual/woo-price-calculator/more-on-output-fields.
You can use the VLOOKUP /HLOOKUP with our software and it is very simple to do that. Here is our documentation link: https://altoswebsolutions.com/manual/woo-price-calculator/.

Best regards.
Naidi
AT957

[Author]

Posts