Automatically dynamic pages from external SQL product database

  • Hello

    Is it possible within WordPress to automatically create dynamic pages based on a local product database? This database is on a local server here in our company and is SQL. We want to renew our outdated website but keep the existing work structure and database.

    Some more context and explanation:

    We currently have a website that acts more like an online catalogue for our products(vebim.com). Since we only work with quotation requests and no real online sales, it is not a fully-fledged webshop, so we prefer to call it an online catalogue. Now, our website is still written in ASP.NET and is rather outdated, and we ourselves want to start focusing on content: blogs, tips and tricks, testimonials, videos, buying guides, etc. We are therefore looking for a CMS that can meet our requirements. Because, the product pages are automatically generated via our local SQL server. Our entire inventory is entered on this via Access. Every night, the website is synchronised with our server and our products are automatically placed on our website via MySQL.

    But please note that our quotation system also works via this server. When visitors request a quote for one or more machines (our products) on the website, a list is automatically sent to our Access interface, where all information is filled in automatically in predefined fields, the product info is retrieved from the server and our employees only have to assign a price and additional costs and click send. As a result, a graphically pleasing e-mail is automatically drawn up and sent with PDFs of the machines in question attached. The process is thus fairly well automated and ensures a very fast processing of quotations. So we don’t want to move away from this quickly. We therefore realise that it is no child’s play to integrate this into a CMS or to integrate a CMS into our existing system/website. However, renewal and modernisation is necessary! Therefore, my question, is this possible in WordPress? What is the best answer to this? I am looking forward to your suggestions!

    Thanks in advance!

    [ Signature deleted ]

    • This topic was modified 2 years, 11 months ago by Jan Dembowski. Reason: wMoved to Fixing WordPress, this is not a Requests and Feedback topic

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    If the WP server is able to connect to the DB server and the DB is mySQL compatible, then data can be queried and displayed on a WP page. WP connects to its own DB using the $wpdb global object of class wpdb. You can use this class to instantiate a different object that connects elsewhere. Class methods can then be used to query this other DB.

    This would most likely all need to be custom coded, but it is certainly feasible within the WP environment. For the record, we could query non-mySQL DBs as well, it’s just that it would involve native PHP functions since wpdb class is mySQL specific.

Viewing 1 replies (of 1 total)
  • The topic ‘Automatically dynamic pages from external SQL product database’ is closed to new replies.