Each Product Discount Table

  • Resolved slimmz

    (@slimmz)


    5 years, 1 month ago

    Hello,

    I’ve been searching in this forum and found this topic similar to what I need

    I applied the solution there and successfully adding the Item Discount Ammount to the plugin but on the export, I don’t know why it’s not showing the amount of the discount.

    Here is what the export looks like
    Report. As you can see, it’s all 0

    Or, what table does the plugin actually pick from as the Product Discount value to be exported? how to set it up?

    Thank you, I really need this to work

    Regards,
    slimmz

Viewing 15 replies - 1 through 15 (of 26 total)
1 2
  • Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    Hello slimmz

    what pricing plugin do you use ?

    please, visit >WooCommerce>Orders, edit order and make the screenshot.
    I need only section Items/Totals.

    thanks, Alex

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    I tried to use the default sale price by woocommerce,

    Edit Order
    is this what you looking for?

    And planning to use this plugin:
    1. Conditional Discounts for WooCommerce by ORION

    Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    I don’t see discount on your screenshot.

    I applied coupon during checkout, look at results https://ibb.co/Zd8SbSN

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    Hmmm, how can I apply coupon on my site?
    Because I only tried to set the sale price and that was what i got

    Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    no,no.
    I meant your pricing plugin doesn’t show discount amount inside the order.

    You should contact to author of pricing plugin and ask about order item meta keys which he uses to remember discount amount.

    Use >Setup Fields>Product Order Items>Add Field to add this key to export.

    thanks, Alex

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    I see Alex,

    But in a simpler way, what plugin you use as it worked for you? maybe it fits my needs too?

    while I’m also going to figure the meta key which the discount saved

    regards,
    slimms

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    Hey @algolplus

    I tried to use a coupon instead and it works, but it shows the amount of price instead of the % of the discount while I need it to show the %.

    But, I need it to work with the plugin I mentioned, instead of the coupon.|
    So I need to contact the author first to know how their discounts stored?

    regards,
    slimmz

    Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    OK, we can calculate discount based on CURRENT price of the product.

    please, follow to https://docs.algolplus.com/algol_order_export/add-calculated-field-for-product/
    use meta key “discount_rate” and this php code

    add_filter(‘woe_get_order_product_value_discount_rate’, function ($value, $order, $item, $product,$item_meta) {
if($product) {
  $discounted_price = $order->get_item_total( $item );
  $normal_price = $product->get_regular_price();
  $value = round( ($normal_price - $discounted_price) / $normal_price * 100);
}
return $value;
}, 10, 5);

    thanks, Alex

    • This reply was modified 5 years, 1 month ago by algol.plus.
    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    Is this supposed to work with the coupon or the plugin I mentioned? I tried to play the price on both but none working, it’s not even printing anything (blank cell)

    I name the cell as Discount New
    https://ibb.co/P9J67SB

    regards,
    slimmz

    • This reply was modified 5 years, 1 month ago by slimmz.
    Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    1. please, turn off Summary Report mode
    2. mark “Enable debug output”

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    https://ibb.co/g6Zc8XP
    https://ibb.co/WkGxfww
    https://ibb.co/5G65mGf

    is this correct? what to do next?

    Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    yes, but I don’t see new field on last screenshot ?

    Plugin Author algol.plus

    (@algolplus)

    5 years, 1 month ago

    Could you upload your settings as new ticket to https://algolplus.freshdesk.com/ ?

    Use visit >WooCommerce>Export Orders>Tools to get them.

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    Sorry, my bad

    https://ibb.co/fn5tGJw I added it but still blank (Discount New)

    Thread Starter slimmz

    (@slimmz)

    5 years, 1 month ago

    Sure, I will do it now

    Edit: Ticket Sent

    • This reply was modified 5 years, 1 month ago by slimmz.
Viewing 15 replies - 1 through 15 (of 26 total)
1 2

The topic ‘Each Product Discount Table’ is closed to new replies.