Focus Areas
Advanced Prompt Library
5 Expert PromptsAs a Parts Salesperson, create a list of products in stock based on a given SKU database, prioritize items with 99% or greater stock levels and sort products by category.
Given a historical sales dataset, identify the top three products that have had the most frequent inventory replenishments in the past quarter and predict the number of replenishment orders for the upcoming quarter.
Write a JavaScript code snippet that updates an object 'customer_order' with 'product_name', 'quantity', and 'total_cost' based on user input, and generate a corresponding 'invoice' based on the total cost including tax at 8% and shipping at 5%.
Design a SQL database schema to store product information (including stock levels), customer orders, and sales data. Ensure the database includes foreign key relationships between tables, and indexes to improve query efficiency.
As a Parts Salesperson using a conversational interface, calculate the average order value for a given list of products and present the top three products with the highest average order values to the customer, along with product descriptions and recommended quantities for purchase.