[SOLVED] Use product price as input in Excel

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED] Use product price as input in Excel

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #5027
    Jens Hagman
    Participant

    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]

    #5029
    Enrico
    Participant

    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

    #5028
    Jens Hagman
    Participant

    That worked. Thank you!

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