Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

How to add serial number to external MySQL database

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › How to add serial number to external MySQL database

Tagged: serial number

  • This topic has 5 replies, 2 voices, and was last updated 11 years, 2 months ago by wzp.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • March 13, 2014 at 2:37 pm #9886
    jrumo
    Member

    Hi there,

    Just purchased the plugin for my site: [www.focusme.co] and I love it! :)

    I have it working sending emails out to customer with the purchased product serial number – that’s working great.

    For my software activation I also need to add the serial number and customer name/email to an external MySQL database. Can anyone advise of how I can do that? I guess I need to run some kind of custom PHP.. but I don’t know how to get the information out of the plugin and into PHP when a customer makes a purchase.

    Any help would be much appreciated!! :)

    If this is outside the scope of the product, then I do apologise.

    Thanks!

    Jon

    March 13, 2014 at 3:13 pm #61569
    wzp
    Moderator

    Is the “external database” on the same, or a different system?

    March 13, 2014 at 4:26 pm #61570
    jrumo
    Member

    Hi, it’s on a different system. Many thanks!

    March 13, 2014 at 4:33 pm #61571
    wzp
    Moderator

    Okay, you sound like you might be able to “pull this off,” but it will require some PHP coding on both ends.

    What you want to do is intercept the information that is emailed to the buyer, that contains both the buyer’s email address and the serial number. You want to somehow BCC the “other system,” perhaps with a secret email address. On the other end, you can then parse out the information and add it to your database on that side.

    March 13, 2014 at 4:39 pm #61572
    jrumo
    Member

    Thank you wzp for the suggestion! I guess I might need to hire a freelancer to help me. :)

    What would your suggestion have been if the database was on the same system? As I might be able to relocate it..

    :)

    March 13, 2014 at 4:48 pm #61573
    wzp
    Moderator

    If the database were on the same system, you would try intercepting the information when the Thank You page is displayed. You’d then save the unique information required in another WordPress table and then periodically export that one table. This approach is less expensive than the first one.

    If you’d like, reference this thread and please complete the custom work order quote form, and someone will get back to you:

    https://support.tipsandtricks-hq.com/need-custom-work-done

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ