Insert row in another table after purchase

  • Hi everyone!

    Perhaps a strange question, but can’t find the answers on this forum. Who can point me in the right direction?

    I need the following: when a product is sold in WooCommerce, a serial code will be generated in the plugin WC Serial Numbers (a digital giftcard). When the transaction is completed, I want a part of that data (the serial code and soms static info) also inserted in another table in WordPress (a booking plugin). So when the purchase is completed, the sold code will be inserted in the booking plugin coupon section, to be used when actually creating the booking.

    Hope anyone knows a good plugin or solution for this!

    Thanks in advance!

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

  • Hi there!

    I recommend asking at WooCommerce forums so the plugin’s developers and support community can help you with this.

    Thread Starter Bouke Koning

    (@boukekoning)

    Did that already, but was also hoping for some kind of advice or plugin suggestion that insert data in a 2nd table when inserted in a main table. I can imagine that sometimes one wants to insert data in more tables for some user cases. So don’t hesitate for everyone to spoil me with more suggestions.

    Thanks!

    Your request requires individual programming. There will be nothing ready-made plugin for this. The reason is that you are trying to enter a value generated by a plugin for a specific event in a table of another plugin. Theoretically, the event would have to be triggered by a WooCommerce function. The booking plugin you are using (whose exact name you have unfortunately not mentioned here) may have something ready for this – ask their support about it. Otherwise, you should look for someone who can programme this for you individually: https://jobs.wordpress.net – we can’t give you a ready-made solution here in the forum as we don’t know your booking plugin.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Insert row in another table after purchase’ is closed to new replies.

Tags