Guide to ask Assisty bot

Please follow this instruction to ask Assisty bot your data.

Ask overview reports

Sales figures

  • Daily sales
  • Weekly sales
  • Monthly sales
  • Sales by status
  • Sales by payment
  • Daily sales by payment
  • Daily gross sales
  • Daily net sales
  • Daily profit margin
  • Order count summary
  • Daily order count summary
  • Coupon summary

Customers

  • Daily customer summary
  • Cold customer overview
  • List cold customers last 30 days
  • Active customer overview
  • List active customers last 30 days

Inventory

  • Stock value
  • Inventory quantity
  • Slow moving stock
  • Slow stock sku last 30 days
  • Overstock overview

Purchasing

  • Items to purchase
  • Stock to order
  • Replenishment item summary

Sales performance

To improve your sales effectiveness and make informed data-backed decisions, you need to conduct sales analysis regularly.

  • Sales summary this month
  • Sales of channel website last month
  • Sales of store Tropicana
  • Sales last 30 days of category Apple
  • Top selling product of category “Remote Products” last 30 days
  • Sales by sku of product “Nestle”
  • Sales by sku of product “Nestle” from May 01 to May 31
  • List orders of product “XXX”
  • Sales summary by product of category “Apple” last 30 days
  • Gross sales of product “XXX” last week
  • Net sales of SKU “YYY” this month
  • Sales of customer group “VIP”
  • Sales of customer group “Gold”
  • Coupon usage of “COUPON_CODE”

Inventory Management

Did you lose out on business when items were out of stock? Or did you lose money due to excess stock?. I can help you to get your stock back on track!

  • Inventory quantity
  • Inventory quantity by subcategory of category “Apple”
  • Inventory quantity by SKU of category “HP”
  • Inventory quantity of product “XXX”
  • Inventory quantity by store
  • Inventory quantity by category
  • Inventory quantity by subcategory
  • Inventory quantity by sku
  • Stock value
  • Stock value by subcategory of category “Apple”
  • Stock value by SKU of category “HP”
  • Stock value of product “XXX”
  • Stock value by store
  • Stock value by category
  • Stock value by subcategory
  • Stock value by sku
  • Slow moving stock
  • Slow stock sku last 7 days
  • Slow stock sku last 2 week
  • Slow stock sku last 30 days
  • Slow stock sku last 2 months
  • Overstock overview

Replenishment Suggest

Know precisely the sales history, sales velocity, and the quantity need to order for every item.

  • Items to purchase
  • Items to purchase of vendor “Vendor Name”
  • Items to purchase of category “Category Name”
  • Items to purchase of subcategory “Subcategory Name”
  • Items to purchase of product “Product Name”
  • Items to purchase of sku “SKU”
  • Replenishment item summary
  • Replenishment item summary of vendor “Vendor Name”
  • Replenishment item summary of category “Category Name”
  • Replenishment item summary of product “Product Name”
  • Replenishment item summary of sku “SKU”

Replenishment Suggest

Transform your digital marketing with insightful customer segmentation and promotion.

  • Customer Overview
  • Active Customers
  • Cold Customers
  • Sales of customer group VIP
  • Sales of customer group Gold
  • Coupon usage of “COUPON_CODE”
  • Active customers of customer group Silver
  • Inactive customer of customer group “Gold” last 30 days
  • Customer detail “a customer email”
  • Active Promotions
  • Coupon Summary
  • Coupon Usage ‘a coupon’

Filter by date

  • Sales last week
  • Sales by day from 10th Oct 2020 to 15th Oct 2020
  • Sales by month Q1
  • Sales Q4 last year
  • sales Jun 2020
  • Sales by month this year
  • Sales by month 2020
  • Sales by month last quarter
  • Gross sales by month last 6 months
  • Gross sales by week last quarter
  • Net sales by day past week
  • Profit last month

Drilldown the report by dimensions

  • Sales summary by channel last 30 days
  • Gross sales by channel last 30 days
  • Sales by store this month
  • Sales by category last 7 days
  • Sales by subcategory last 2 weeks
  • Sales by sku this month
  • Sales by customer group
  • Sales by payment
  • Sales by status
  • Top gross sales by sku this October
  • Top gross sales by sku last 30 days
  • Profit by month
  • Order count summary by day
  • Order count summary by week
  • Order count summary by month
  • Customer summary by month
  • Customer summary by day
  • Customer summary by year
  • Inventory quantity by store
  • Inventory quantity by category
  • Inventory quantity by subcategory
  • Inventory quantity by sku

Lookup data of specific entity

  • Sales of channel website last month
  • Sales of store Tropicana
  • Sales last 30 days of category Apple
  • Top gross sales SKU of category “Remote Products” last 30 days
  • Sales summary by subcategory of category Apple” last 30 days
  • Gross sales of product “XXX” last week
  • Net sales of SKU “YYY” this month
  • Sales of customer group VIP
  • Sales of customer group Gold
  • Coupon usage of “COUPON_CODE”
  • Active customers of customer group Silver
  • Inactive customer of customer group “Gold” last 30 days
  • Customer detail “a customer email”
  • Inventory quantity by subcategory of category “Apple”
  • Inventory quantity by SKU of category “HP”
  • Inventory quantity of product “XXX”
  • Items to purchase of vendor “Central”
  • Item to purchase of category “Apple”

Ask sales order status

  • Status of order number 06731
  • Check order status of customer “John Smith”
  • Order status of customer with email customer.email@example.com
  • Order status of customer with umid 3586xxxx
  • Order status of customer with phone 734-764-xxxx
  • Order status of customer with phone 734936xxxx

Ask shipping status

  • Shipping status of order number 06731
  • Shipping status of order customer John Smith
  • Shipping status of order customer email customer.email@example.com
  • Shipping status of order customer with umid 3586xxxx
  • Shipping status of order customer with phone 734-764-xxxx
  • Shipping status of order customer with phone 734936xxxx

Ask product/ sku info

Ask stock availability of SKU

  • Real time stock quantity of SKU 153685
  • Check stock quantity of SKU 153686

Ask Estimated time arrival (ETA) of SKU

  • Check ETA of sku 512081
  • Check ETA of sku 152010
  • Check ETA of sku 147056

Ask price/discount of product

  • Top discount sku
  • Discount of sku 220619
  • Current price of SKU 424840

Ask sales history

  • List order of sku 500122
  • List order of sku 500122 this month
  • List order of sku “500122” last month

Ask active promotions

  • Active promotions
  • Promotions
  • Show promotions