# [SOLVED] Show Unit Cost and Override Calculator Function

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED] Show Unit Cost and Override Calculator Function

Viewing 2 posts - 1 through 2 (of 2 total)
• Author
Posts
• #5421
Theodis Butler
Participant

[b]Issue 1[/b]
I am trying to show the unit price. What is the best way to do this? I have the quantity field available in php using custom theme.

This is what I have in a custom wooprice calculator theme:

INSTANT QUOTE: get_price_html(); ?>

Unit Cost:\$0.00 (cost here)

[b]Issue 2a[/b]
I have a blue print with dimensions, color, and quantity.

If “Full Color” is specified, I need to dynamically update the price but it is not a calculation but rather a static number. I’m not using spreadsheets.

For example:
12 x 18, B&W = \$1.25
12 x 18, Color = \$4

[b]Issue 2b[/b]

If quantity is more than 100, then the dimension price should change (override).

#5422
Paul
Participant

Hello
issue 1
I think you can use an output field. But you need to use an excel file. You should write on your excel file the unit price and map it with the output field.

issue 2a

I think you will need this: https://altoswebsolutions.com/manual/woo-price-calculator/creating-a-calculator-from-a-spreadsheet-file-pro , in particular the Overwrite Quantity funcionality.

The dynamic update can be configured using an excel file.
Create a table with combination of options and prices. Use dimensions, color, and quantity filled by user as key to search for the right price. To manage the update of prices you probably will need to use some excel functions as MATCH and INDEX.

issue 2b

You can solve this with the solution of the issue 1a and using the function IF of Excel

Let us know if you have more questions.

Best Regards
Paul
AT721

Viewing 2 posts - 1 through 2 (of 2 total)
• You must be logged in to reply to this topic.