NazarenkoDenis · December 12, 2025 16:58
diff --git a/chips.json b/chips.json
 [
  {
    "code": "top_customers",
    "label": "Top customers",
    "prompt": "'Sales by Customer' that helps identify the most loyal customers by showing each customer in a separate row with their complete sales performance.\nThe report displays sales data for the last 30 days, sorted by total sales in descending order (highest first) to highlight top performers.\nUse the 'orders' explore.\nInclude these fields: customer email, customer name, number of orders, total refund amount, total discounts, total net amount, total price, and average order value.\nAdd a date filter in the toolbar so users can adjust the time period."
  },
  {
    "code": "top_products",
    "label": "Top products",
    "prompt": "'Sales by Product' that shows each product in a separate row.\nThe report displays sales data for the last 30 days, sorted by units sold in descending order (highest first) to show the most popular products first.\nUse the 'sales_by_item' explore.\nInclude these fields: product image, product name, number of orders, units sold, gross sales, discount allocation, refund amount, net sales, tax amount, shipping price, and total sales amount.\nAdd a date filter in the toolbar so users can adjust the time period."
  },
  {
    "code": "top_collections",
    "label": "Top collections",
    "prompt": "'Sales by Collection' that shows each collection in a separate row with basic sales indicators to help identify which collections are selling best.\nThe report displays sales data for the last 30 days, sorted by number of orders in descending order (highest first).\nUse the 'sales_by_item' explore.\nInclude these fields: collection name, number of orders, units sold, gross sales, discount allocation, refund amount, net sales, tax amount, shipping price, and total sales amount.\nAdd a date filter in the toolbar so users can adjust the time period."
  },
  {
    "code": "top_vendors",
    "label": "Top vendors",
    "prompt": "'Sales by Vendor' that shows each brand or vendor in a separate row with basic sales indicators to identify which vendors are performing best.\nThe report displays sales data for the last 30 days, sorted by units sold in descending order (highest first).\nUse the 'sales_by_item' explore.\nInclude these fields: vendor name, units sold, gross sales, discount allocation, refund amount, net sales, tax amount, shipping price, and total sales amount.\nAdd a date filter in the toolbar so users can adjust the time period."
  },
  {
    "code": "average_order_value",
    "label": "Average order value",
    "prompt": "'Average Order Value Over Time' that shows how the average order value has changed over time, which can be grouped by days, weeks, months, or years.\nThe report displays data for the entire available history, sorted by number of orders in descending order (highest first).\nUse the 'orders' explore. Include these fields: month, number of orders, and average order value.\nAdd a date filter in the toolbar so users can adjust the time period."
  },
  {
    "code": "inventory_forecast",
    "label": "Inventory planner",
    "prompt": "'Inventory Planner' which is a business intelligence report for purchase planning and demand forecasting.\nThe forecast quantity shows how many units of each product will be purchased in the next period, and the replenishment quantity shows how many units you are missing (if the value is positive).\nThe report is sorted by replenishment quantity in descending order (highest first) to prioritize items that need immediate restocking.\nUse the 'product_variants' explore.\nInclude these fields: product name, variant name, total available inventory, sales velocity quantity, average stock coverage time in days, forecast quantity, and replenishment quantity."
  },
  {
    "code": "dead_inventory",
    "label": "Dead inventory",
    "prompt": "'Dead Inventory' which is a business intelligence report designed to identify stagnant products that are tying up capital.\nThe report shows products with available stock that have not been sold in the last 30 days or have never been ordered.\nThe report displays each product variant in a separate row with key inventory information.\nThe report is sorted by days since last order in descending order (oldest first).\nUse the 'inventory_items' explore.\nInclude these fields: product name, variant name, created date, first order date, last order date, days since last order, total available inventory, total cost, and total price.\nFilter to show only items where total available is at least 1 and days since last order is either -1 (never ordered) or greater than 30."
  }
 ]
	[
	{
	"code": "top_customers",
	"label": "Top customers",
	"prompt": "'Sales by Customer' that helps identify the most loyal customers by showing each customer in a separate row with their complete sales performance.\nThe report displays sales data for the last 30 days, sorted by total sales in descending order (highest first) to highlight top performers.\nUse the 'orders' explore.\nInclude these fields: customer email, customer name, number of orders, total refund amount, total discounts, total net amount, total price, and average order value.\nAdd a date filter in the toolbar so users can adjust the time period."
	},
	{
	"code": "top_products",
	"label": "Top products",
	"prompt": "'Sales by Product' that shows each product in a separate row.\nThe report displays sales data for the last 30 days, sorted by units sold in descending order (highest first) to show the most popular products first.\nUse the 'sales_by_item' explore.\nInclude these fields: product image, product name, number of orders, units sold, gross sales, discount allocation, refund amount, net sales, tax amount, shipping price, and total sales amount.\nAdd a date filter in the toolbar so users can adjust the time period."
	},
	{
	"code": "top_collections",
	"label": "Top collections",
	"prompt": "'Sales by Collection' that shows each collection in a separate row with basic sales indicators to help identify which collections are selling best.\nThe report displays sales data for the last 30 days, sorted by number of orders in descending order (highest first).\nUse the 'sales_by_item' explore.\nInclude these fields: collection name, number of orders, units sold, gross sales, discount allocation, refund amount, net sales, tax amount, shipping price, and total sales amount.\nAdd a date filter in the toolbar so users can adjust the time period."
	},
	{
	"code": "top_vendors",
	"label": "Top vendors",
	"prompt": "'Sales by Vendor' that shows each brand or vendor in a separate row with basic sales indicators to identify which vendors are performing best.\nThe report displays sales data for the last 30 days, sorted by units sold in descending order (highest first).\nUse the 'sales_by_item' explore.\nInclude these fields: vendor name, units sold, gross sales, discount allocation, refund amount, net sales, tax amount, shipping price, and total sales amount.\nAdd a date filter in the toolbar so users can adjust the time period."
	},
	{
	"code": "average_order_value",
	"label": "Average order value",
	"prompt": "'Average Order Value Over Time' that shows how the average order value has changed over time, which can be grouped by days, weeks, months, or years.\nThe report displays data for the entire available history, sorted by number of orders in descending order (highest first).\nUse the 'orders' explore. Include these fields: month, number of orders, and average order value.\nAdd a date filter in the toolbar so users can adjust the time period."
	},
	{
	"code": "inventory_forecast",
	"label": "Inventory planner",
	"prompt": "'Inventory Planner' which is a business intelligence report for purchase planning and demand forecasting.\nThe forecast quantity shows how many units of each product will be purchased in the next period, and the replenishment quantity shows how many units you are missing (if the value is positive).\nThe report is sorted by replenishment quantity in descending order (highest first) to prioritize items that need immediate restocking.\nUse the 'product_variants' explore.\nInclude these fields: product name, variant name, total available inventory, sales velocity quantity, average stock coverage time in days, forecast quantity, and replenishment quantity."
	},
	{
	"code": "dead_inventory",
	"label": "Dead inventory",
	"prompt": "'Dead Inventory' which is a business intelligence report designed to identify stagnant products that are tying up capital.\nThe report shows products with available stock that have not been sold in the last 30 days or have never been ordered.\nThe report displays each product variant in a separate row with key inventory information.\nThe report is sorted by days since last order in descending order (oldest first).\nUse the 'inventory_items' explore.\nInclude these fields: product name, variant name, created date, first order date, last order date, days since last order, total available inventory, total cost, and total price.\nFilter to show only items where total available is at least 1 and days since last order is either -1 (never ordered) or greater than 30."
	}
	]
No results found