Loading...

Build intelligence in your eCommerce applications using Azure Open AI

Build intelligence in your eCommerce applications using Azure Open AI

Whenever I shop online, checking the reviews of the products is a tedious task. Sometimes the low-rated reviews are based on delivery, packaging... whereas a few high-rated reviews might be on cost but not on quality. Generally, reviews/ratings are displayed without any context which results in customers needing additional time and effort to get the most value out of it. Hence, we built this prototype using Azure Open AI to present the consolidated information from all the reviews of a product.

 

Azure-Open-AI.png

 

We fed all the reviews of a specific product to GPT-3 text-davinci-003 model with a prompt to classify the text based on the three categories – Cost, Quality, and Delivery. Prompt is where user provide the English text command which the API endpoint of the model will use to generate the completions. 

 

classify_prompt = f'Classify the following review into 1 of the following categories: categories: [Cost, Quality, Delivery]\n\unreview: {s}\n\nClassified category:' response = openai.Completion.create( engine="text-davinci-003", prompt=classify_prompt, temperature=0, max_tokens=100, top_p=1, frequency_penalty=0, presence_penalty=0, best_of=1, stop=None)

 

 

Similarly, we classified the sentiment of the text using the same model on three categories - Positive, Neutral, and Negative.

 

sentiment_prompt = f'Identify the sentiment in the following review into 1 of the following categories: categories: [Positive, Neutral, Negative]\n\nreview: {s}\n\nClassified category:' response = openai.Completion.create( engine="text-davinci-003", prompt=sentiment_prompt, temperature=0, max_tokens=100, top_p=1, frequency_penalty=0, presence_penalty=0, best_of=1, stop=None)

 

 

Here is the sample result after the category classification and sentiment detection of the review text.

 

ReviewSummarizationDF.png

 

As you notice, we are using the pre-trained model available in Azure Open AI service as is above. There are three main approaches for in-context learning: Few-shot, one-shot and zero-shot. In this case, we didn’t provide any examples to the model and only the task request is provided hence it’s zero-shot learning. Based on your requirement or pilot testing, you shall consider fine tuning the model using one of the available models for fine tuning.

 

Above category classification and sentiment detection job needs execution only once per review text and store the results for future use. Existing data shall be analyzed using one of the batch processing design options and real time events shall be analyzed using one of the real-time processing design options in Azure Architecture Center.

 

Now when a user requests for review intelligence, make an API call to Azure Open AI service to summarize the reviews per category as shown in the following command.

 

response = openai.Completion.create( engine="text-davinci-003", prompt=review_text, temperature=0.7, max_tokens=100, top_p=1, frequency_penalty=0, presence_penalty=0, best_of=1, stop=None)

 

 

Also consolidate the results from sentiment column per category to show the review intelligence summary below.

 

ReviewIntelligenceOutput.png

 

Another use case where Open AI service can bring value is on product search. First, get the embeddings of the product description text using get_embedding API with test-davinci-search-doc-001 model and store the result in a separate column named davinci_search.

 

df['davinci_search'] = df['product_description'].apply( lambda x : get_embedding(x, engine = 'text-davinci-search-doc-1'))

 

 

Below is the sample data frame after including the embeddings.

 

SearchEmbeddingsDF.png

 

Now using ordinary questions like text and using cosine similarity and text-search-davinci-query-001 model, we will retrieve the top four most relevant items as shown below.

 

def search_docs(df, user_query, top_n=3, to_print=True): embedding = get_embedding( user_query, engine='text-davinci-search-1' ) df['similarities'] = df.davinci_search.apply(lambda x: cosine_similarity(x, embedding)) res = ( df.sort_values('similarities', ascending=False) .head(top_n) ) return res res = search_docs(df, "feel good ear phone with good sound quality", top_n=4)

 

 

The above search request will return the results like the one shown below.

 

SearchOutput.png

 

Jupyter Notebook for this demo is available in this GitHub repo.

 

Below is an approach to extract data from your own knowledge base, create embeddings and use prompts to find the best answer to your customers.

Search-OpenAI.png

 

Conclusion:

In this post we have seen a demo of how easy it is to use Azure Open AI service to bring intelligence to your eCommerce Portal and provide better experience to your customers.

 

Citation:

In this demo, we used the dataset published as part of the following paper.

Justifying recommendations using distantly-labeled reviews and fined-grained aspects
Jianmo Ni, Jiacheng Li, Julian McAuley
Empirical Methods in Natural Language Processing (EMNLP), 2019

 

Published on:

Learn more
Azure Developer Community Blog articles
Azure Developer Community Blog articles

Azure Developer Community Blog articles

Share post:

Related posts

November Patches for Azure DevOps Server

Today we are releasing patches that impact our self-hosted product, Azure DevOps Server. We strongly encourage and recommend that all customer...

12 hours ago

Configuring Advanced High Availability Features in Azure Cosmos DB SDKs

Azure Cosmos DB is engineered from the ground up to deliver high availability, low latency, throughput, and consistency guarantees for globall...

1 day ago

IntelePeer supercharges its agentic AI platform with Azure Cosmos DB

Reducing latency by 50% and scaling intelligent CX for SMBs This article was co-authored by Sergey Galchenko, Chief Technology Officer, Intele...

4 days ago

From Real-Time Analytics to AI: Your Azure Cosmos DB & DocumentDB Agenda for Microsoft Ignite 2025

Microsoft Ignite 2025 is your opportunity to explore how Azure Cosmos DB, Cosmos DB in Microsoft Fabric, and DocumentDB power the next generat...

5 days ago

Episode 414 – When the Cloud Falls: Understanding the AWS and Azure Outages of October 2025

Welcome to Episode 414 of the Microsoft Cloud IT Pro Podcast.This episode covers the major cloud service disruptions that impacted both AWS an...

5 days ago

Now Available: Sort Geospatial Query Results by ST_Distance in Azure Cosmos DB

Azure Cosmos DB’s geospatial capabilities just got even better! We’re excited to announce that you can now sort query results by distanc...

6 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy