N8N Expert Wanted - Open AI - MySQL - WooCommerce Integration

Hello.

Im searching for an expert N8N developer to help me create a number of workflows that will use Open AI chat to make database queries about a clients previous orders and then make suggestions about products that we will then automatically add to a new order for a client.

Ideally Open AI chat will trigger a workflow that will engage with the database to get previous orders and previously ordered products and use this as the basis for product recommendations.

Where no previously ordered products match a new request we will use a number of priority settings based on product categories, available stock and relationships between products to suggest best matching products and to add these to a suggested product list for a client. Once accepted by our administrator we will use this product list to create or update a pending order for the client.

I have created a chat relationship with a table database using Zapier which outputs the right sort of data from a set of data in a table… but require integration with larger data sets and functionality which i hope to achieve with N8N.

From my early testing it seems that this type of workflow should be possible but i need help getting it up and running.

Please message me your thoughts about this and your hourly / project rate if its something you can help me create.

thank you.

1 Like

hello , that would be interesting task. i cannot say i have done this, but i work with woocommerce a lot. challenge would be to train AI to use mysql database.

Thank you. Would you not be able to link Open AI directly to the mySQL database containing the orders, customer data and products and then run a series of workflows and data queries based on the chat… so for example … first check if the client has previous orders based on their email address. If so… get a list of this clients products and match them to the clients request, if the client has no previous orders then look for products based on current stock levels, and if they are in a featured product category and add these product items to our list of products for inclusion in a new order. Then … we would create a new step in the flow to update this list based on our communications and output a final order ready for approval and to be sent to Woo Commerce from a manual trigger.

Hi Tristan,

I’d be happy to help you create these workflows using N8N and Open AI chat. Your concept sounds like a great application of automation, and I’m confident I can help you bring it to life.

With my experience in n8n, I think we can create a seamless workflow that meets your requirements. I’d love to discuss the project further and provide a customized quote based on your needs.

You can reach out to me on my email here

Colin

Hi Tristan

I’m an automation & AI expert with a ton of experience in n8n and Open AI’s API, I be happy to have a chat to see if I can help.

I will send you a DM, you can also contact me at [email protected], check out my website at www.nocodecreative.io

Cheers,
Wayne