Support » Plugin: PW WooCommerce Gift Cards » Gift card does not appear on invoice?

  • Resolved RwkY

    (@rwky)


    Hi there,

    We’ve been using gift cards for a while, but our accountant just told us that the gift card does not display on the invoice.

    I’ve checked settings, nothing that supports that, any idea why this?

    p.s. using this as main pdf generator, tested as well with this

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author pimwick

    (@pimwick)

    We store the redeemed gift cards as WooCommerce Order Line Items. The data is available to all third party plugins so you should be able to contact the developer of that plugin to find out how to add custom Order Line Items to the invoice.

    RwkY

    (@rwky)

    I’ve contacted both of the developers, both complain that the data is not stored with easy accesibility and that they need to do extra work in order to get this field into the invoice.

    This is not good for me at all, it involves problems with my accountant and each invoice that is generated from the system, has to be updated so it can show the discount properly.

    p.s. just to be clear, the plugin itself works without a problem, a little too many limitations for light, but eh, it works. The main problem is that if you generate invoices from WooCommerce via a 3rd party, most of the 3rd party do not know how to get this data easily because it’s not saved as product/coupon code, it’s saved as separate item, needing extra coding.

    Plugin Author pimwick

    (@pimwick)

    We store the gift card number as a separate line item following the built-in WooCommerce Order Line Item functions. There shouldn’t be the need for custom programming to pull this data if it gathers the information the same way that WooCommerce does.

    WooCommerce stores the order data in the following tables:

    wp_posts - contains the Order data.
    wp_postmeta - contains the Order meta data.
    wp_woocommerce_order_items - contains the order line items.
    wp_woocommerce_order_itemmeta - additional meta information for the order line items.

    When a PW Gift Card is redeemed it will be an Order Line Item in the wp_woocommerce_order_items table. As best practice the Invoice plugin should pull all of the order_items since that is what WooCommerce displays on the Order page. Other plugins may also add additional order_items which could help down the road.

    Hope this clarification helps, if your developers need any additional information just let us know!

    Plugin Author pimwick

    (@pimwick)

    Marking this thread as resolved but let us know if you need further help. Best of luck with your store!

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