[SOLVED] Use product price as input in Excel

[Jens Hagman]

Hi
I’d like to use the product price (“360,05” in the image) as a variable for calculation in the Excel document. The other values should be calculated depending on the product price (“Uträkning…” in the image)
How can I do that?
[attachment=420]wc1.jpg[/attachment]

[Enrico]

Dear Jens Hagman,

If “360,05” is the Product Regular Price (The regular price which you can find inside the WooCommerce Product), you can map a cell in your Excel file with the “Base Price”.

Just a simple example:

– In cell A1 in your Excel file, you map with WPC the “Base Price” (Regular Price) [See screenshot below]
– In cell B1 you write a formula like “=A1+300” in your Excel file and you map with WPC the Final Price

So the results will be REGULAR_PRICE+300

More information on Excel calculators here:

https://altoswebsolutions.com/manual/woo-price-calculator/creating-a-calculator-from-a-spreadsheet-file-pro

Kind Regards,
Enrico
AT1325

[Jens Hagman]

That worked. Thank you!

[Author]

Posts