Use dimensional data from WooCommerce Products inside FORMULAS

cubefree

#101641

We would LOVE LOVE LOVE to get the dimensions from WooCommerce, e.g. width, length, height
AND use them in a formula.

We sell saunas. So if we could use the W, L and H
then we could create formulas like for ALL sauna Sizes:

FLOORING (Add flooring to the sauna space)

• Add Cedar flooring to entire floor — FORMULA: W x L x $Price/Square Inch^
• Add Cedar flooring ONLY to the Walking Area — FORMULA: (W-18) x (L-18) x $Price/Square Inch*

* in this case, 18 inches is the depth of a sauna bench

^ NOTE this brings up another idea.
$Price/Square Inch could be a CONSTANT TYPE FIELD !!!!

IF I can use a Constant (as a global variable field) within formulas, then next year IF I have to raise prices,
I simply change the Field value from say 10 Cents / square inch to 12 cents AND
EUREKA All my prices are perfectly updated with very little work.

Please add. Thank you!!

Attachments:

You must be logged in to view attached files.

cubefree

#102074

You must be logged in to see this reply.