Inventory / Sales analysis

we would like to use our ERP data (which would include wholesale sales data), our e-commerce platform sales data, return data, drop data (when this goes online), our social media ad data (ad performance and visuals), email/SMS data, and potentially our web analytics data for additional sales insights, plus our manufacturer production time data.

We want to track sales trends (online and wholesale, and wholesale back orders) against our on-hand inventory and on-order inventory. We need the system to regularly monitor this data and alert us when sales trends indicate we might only have 6 weeks of inventory remaining while our manufacturer reorder takes 8 weeks... essentially alerting us before we're in a shortage situation.