Pull products from external database with custom search

  • Resolved kerushanreddy15

    (@kerushanreddy15)


    4 years, 5 months ago

    I am designing a website for an automotive company.
    The problem i am facing is that the company has their own database filled with their parts (each part has a name, descrip, what type of part (brake pad, wipers, engine pistons), part id for store, part id of it in relative to another store and so on), thus i would like to pull these items from this database to be display onto the woo commerce page product page. Because their are 50k+ parts, thus cannot pull all from the database.

    Therefore I am implementing a custom search/ filter, such as the user can search by entering their car’s make, model,year, and part category (engine,brakes, electrical,accessories) and then displaying the necessary products that fall under those categories. The user also has option of entering their car’s VIN number and all the parts that fit their car will be displayed. And finally a third normal search feature where user can search with key words.
    Because these search features are complicated. The database has a lot of tables to accommodate this. So when the search happens. All the tables have to be link to find the necessary parts required.

    I could not find any documentation that could help me with this.
    What do i need/ how can I make this all possible?

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

  • Hi @kerushanreddy15,

    That’s going to be a pretty complex task. It’ll depend on how the old database can be accessed. Do they have an API that can be used to pull this information?

    If so, you’ll need to write a plugin that can query for parts based on what the customer searches for. Then you’ll need to create products in WooCommerce based on the results. This will be very specific to this site, so you’re not likely to find an off-the-shelf plugin that can do this for you.

    If you need someone to create this for you, you could take a look at our WooExperts. They are experienced developers and agencies who could create an integration like this for you.

    Best

    Hello @kerushanreddy15,

    We have not heard from you in a while so I’m marking this thread as resolved. If you do have more questions, please open up a new topic and we’ll be happy to help you out.

    Cheers

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Pull products from external database with custom search’ is closed to new replies.