Advanced markup price

  • kchegwin

    (@kchegwin)


    10 years, 1 month ago

    Hey Guys,

    I need some Woo help!

    how can I best approach this, I would prefer to use a plugin.

    I have an XML feed from various vendors, some include TAX and some don’t. I would like to even the prices.

    Vendor A: Price -20% (Taking off VAT) + 8.5% (our commission)
    Vendor B: Price Same as feed + 8.5% (our commission)

    I can work out the first part of removing 20% using the markup field. However I couldn’t work out how to add 8.5% after that. The 8.5% varies, so it will sometimes be like 10%.

    any suggestions?

    https://ww.wp.xz.cn/plugins/woocommerce/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Mike Jolley

    (@mikejolley)

    10 years, 1 month ago

    How are you importing from the feed?

    Thread Starter kchegwin

    (@kchegwin)

    10 years, 1 month ago

    @mike Jolley

    I’m using WP All Import

    Plugin Contributor Mike Jolley

    (@mikejolley)

    10 years, 1 month ago

    And how do you determine if it’s -20 or left alone?

    You will need to look into data manipulation via custom functions http://www.wpallimport.com/tour/execute-php-on-data/ Then you can adjust values as needed.

    Thread Starter kchegwin

    (@kchegwin)

    10 years, 1 month ago

    And how do you determine if it’s -20 or left alone?

    Per vendor I can markdown by 20% using WP All Import
    http://screencast.com/t/2VwxDqzr

    I couldn’t work out the function to add an additional 8.5% after that.

    Plugin Contributor Mike Jolley

    (@mikejolley)

    10 years, 1 month ago

    yeah those fields are not enough. SO you can either use custom logic from the article I linked. You should also WP All Import for help with this.

    Your math is wrong anyway. If the prices include 20% tax already, 80% is not correct.

    Say its £100 and tax is 20%.

    The tax calc would be 100-(100/1.2) = 16.66

    So the end price would be 83.34, not 80 as our current % calc would give you.

    Thread Starter kchegwin

    (@kchegwin)

    10 years, 1 month ago

    The tax calc would be 100-(100/1.2) = 16.66

    ah yes you’re correct! This is a rebuild from our Magento version where we implemented that. So i think the calculation on the price would be

    100-(100/1.2) + 8.5%

    Will see if I can get a developer to help with a php function within WP All Import

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Advanced markup price’ is closed to new replies.

Tags