Logistics & Marketplace Ops

Marketplaces, eCommerce shops, and business with logistics/coordination-heavy functions use LogicLoop to manage day to day operations. Your company is growing and operations is the first to go underwater. LogicLoop empowers operations people to quickly set up rules on top of company data to trigger alerts and workflows. Without LogicLoop, operators are often stuck refreshing dashboards and manually copy and pasting excel spreadsheets.

To get started, you'll first want to connect your company's data sources. This could be production databases like Postgres or MySQL, warehouses like Snowflake, Redshift or Big Query, or APIs. Once connected, you can use sample industry templates below as guidance to bootstrap your program. Contact us at [email protected] to access our full suite of templates.

Order volume drop

Detect if order volume is beneath a certain minimum threshold.

SELECT
  count(*)
FROM
  orders
WHERE
  created_at > current_data - interval '60 minutes'
HAVING
  count(*) < 10

Fire a PagerDuty alert for someone on your team to investigate.

Restock your inventory

Detect if inventory levels are low for any particular SKU.

SELECT
  *
FROM
  inventory
WHERE
  stock_count < 100

Then, automatically call your supplier's API to order more.

Alert if warehouse conditions are not optimal

Detect if the temperature or other conditions inside a warehouse are not optimal.

SELECT
  temp
FROM
  warehouse_stats
WHERE
  temp > 80

Fire a Slack alert for a manager to review and adjust.

Expired stock or upcoming expiry

Detect if any stock is expiring soon.

SELECT
  *
FROM
  items
where
  expiry_date < now() + '30 days'

Then, email a manager to enact a discount or make plans for discarding expiring stock.

Alert customers of shipping delays

Select customers whose orders are delayed.

SELECT
  *
FROM
  orders
WHERE
  shipped_at < now() - '5 days'
  AND status = 'in_transit'

For each customer, send them a text informing them shipping has been delayed but rest assured their order is on the way.

Adjust ad spend to balance supply and demand

Detect if supply or demand in any given area is low.

SELECT
  *
FROM
  cities
WHERE
  demand > supply * 2

Automatically call the Facebook Ads API to increase ad spend in that area to boost supply or demand.