Identify Sale Items

  • Hi Ewout,

    Not sure if you can help!

    I’m hoping to be able to identify on the invoice or packing slip if a product is a SALE item?

    i.e. we have some products on the store that between certain dates are at a reduced price.

    When the warehouse get the item for customer, they need to identify if sourced at regular price or sale price?

    Is this possible with the plugin (either free or premium)? Just need something on there that indicates discounted or not.. not necessary a field value etc…

    The Woo fields in question are sale_price_dates_from, sale_price_dates_to and _sale_price

    Many thanks!

    Dave

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Ewout

    (@pomegranate)

    Hi Dave,
    You can add extra data below the product title with the wpo_wcpdf_after_item_meta action hook. Where exactly are these sale_price_dates_from etc fields stored? Is that in the item meta or in the product meta?

    Thread Starter dlaslett

    (@dlaslett)

    Hi Ewout,

    Thanks for the quick reply!

    It’s part of the PRODUCT DATA > GENERAL area of Woocommerce (underneath the price field).

    Essentially there is a SALE PRICE, with a start and end date and between those 2 dates it lowers the price before reverting back (it also adds a SALE tag onto the product at front end) (essentially I was going to try and add something to invoice that says “if between these dates, AND sale price populated, add text that says SALE item (or show price with a line through it and sale price or something)

    Here are some screen shots if helpful :

    https://www.builders-superstore.co.uk/wp-content/uploads/2018/08/sale_price_ewout.jpg

    And here’s the item itself…

    https://www.builders-superstore.co.uk/sale-items/

    I’ll have a look at how to add data using hooks etc. (I’m a bit rusty!)

    Thanks Ewout,

    Dave

    • This reply was modified 6 years, 7 months ago by dlaslett.
    Plugin Contributor Ewout

    (@pomegranate)

    I see – the problem with data from the product is that it can be changed independently from the order or item meta. This means that if you have sold an item that had a sale price but doesn’t anymore by the time the item has shipped (because you have had a fresh delivery and it’s already available in the shop), the dates read from the product are not applicable. WooCommerce also does not store any information in the order regarding the sale price itself, it just stores it as if that was the regular price (contrary to discounts).
    To overcome this you will need to copy this information to the item meta at the time the order is place. Unfortunately that’s quite an advanced customization…

    Thread Starter dlaslett

    (@dlaslett)

    Ahhh OK thank Ewout! You’ve given me food for thought there at any rate!

    I’ll see if there’s a workaround from an operational perspective!

    D

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Identify Sale Items’ is closed to new replies.