Sales Copilot for Retail Business

Introduction

Discover how to create a birthday party planner using Copilot Studio and Microsoft Open AI in this blog. Learn to streamline party planning with AI-driven tools, from generating creative ideas to managing logistics, making your celebrations unforgettable with minimal effort and maximum efficiency. Let's dive in!

Overview Copilot studio

Copilot Studio is a tool from Microsoft that makes it easy to create intelligent apps and automate tasks. It combines AI capabilities with your existing systems, like Microsoft 365 or other platforms. Copilot Studio helps you design workflows, automate repetitive tasks, and even build chatbots that can interact with users naturally. It uses AI to assist in creating and managing processes, saving time and improving efficiency.

By combining Open AI and Power Automate with the easy automation and integration features of Copilot Studio, you can build smarter, faster applications. Whether you’re planning a birthday party or managing business tasks, these tools help you work more efficiently and achieve better results.

Setting Product Data

Your product data might be stored in various databases, such as MySQL, SQL Server, or Oracle. Power Automate offers powerful capabilities to fetch and organize this data in the format you need. For the purpose of this article, I’ll be using a SharePoint List.

I created a product database in SharePoint with the following columns: Title, Product Name, Theme, Price, Stock Quantity, and Rating. To demonstrate, I added 100 synthetic data entries for testing and showcasing the setup.

Product

Setup a Copilot Flow

Create a new copilot agent E-com sales agent and create a topic with trigger phases like-

“I want to plan birthday party for my son’s birthday.”

Let the copilot response with theme for selection using action “Ask question” and add available themes in your database. In my case I added themes - Princess, Superhero, Jungle, Space.

Now our flow is setup with trigger question and also getting response as theme selection now we need to use selected theme and product data to plan part.

Fetch Products

Create a Power Automate flow to fetch data from excel data sheet as I describe above best on your database you can change this flow to fetch product based on theme.

I create a power Automate flow where I am taking input as selected them and then filtering data and then converting it in Json and returning to copilot.

Call Power Automate flow in Copilot studio and store product list in variable “ProductList”.

Orchestration of Prompts

Now that we have the themes and corresponding products available in your database, it's time to organize them into a structured prompt for party planning.

Add action “Generative answers” in advance menu.

In input add “partyplanner” and edit data source there you can see options like Knowledge sources keep that option off.

The next option is “Classic data” turn this option on and below that you can see a input for box to give your prompt and use variables there use this given prompt and add variables.

Prompt

"You are a birthday party event planner. Help user to plan birthday party for a theme : [SelectTheme]. Using only the provided product list, create a creative and detailed plan for the party [ProductList]. Do not add any products, prices, or details not mentioned in the list. Explain how each product will be used to enhance the theme and create an unforgettable experience. Be imaginative while staying within the constraints of the provided products. Ensure the plan includes: Decorations: How to use the products for a stunning setup aligned with the theme. Activities: Fun and engaging ideas using the available items.

Food and Beverages: Suggestions for presenting or serving based on the listed items.Party Favors: Creative ways to use any relevant products for party giveaways.Setup Tips: Practical guidance on arranging everything to fit the theme seamlessly.Keep your suggestions practical, detailed, and tailored exclusively to the shared product list and theme. Let your creativity shine within these constraints"

It will look like this:

Below this input box you can see option “Adanced” expand that menu there you can see “Send a message” check it so reponse will be automatically go to user. And, in input box “Save LLM response” select “Text Only”. IF you want to save this, put in variable you can save like I saved in “response variable”.

Now you e-com party planner is ready for testing.

Testing

Once you run copilot and select a theme like I did and selected theme Princess. I am getting a perfect response now it’s your turn to test it.

Summary

This article explored how generative AI can transform the e-commerce industry by acting as a virtual salesperson to boost sales. By leveraging AI's ability to understand customer preferences, suggest personalized products, and provide real-time assistance, businesses can enhance the shopping experience and increase customer satisfaction. Generative AI can also analyze trends, recommend upsells, and streamline the buying process, helping businesses maximize revenue. With tools like Hugging Face and Copilot Studio, implementing AI-powered solutions is now more accessible, allowing e-commerce platforms to stay competitive and innovative in a fast-evolving market.