Understanding Demand

Demand is where your sales history will populate in ForecastRx. Most users won't need to change the data in Demand but read on to understand Demand and its uses. 

Demand For Amazon Companies

Amazon orders will populate here per SKU and customer order. Amazon orders include all FBA and FBM sales, along with MCF orders. These sales are synced automatically from Seller Central when a sync is initiated in ForecastRx and will display in ForecastRx with the Date of Sale corresponding to the Order Date in Seller Central. To check if orders are syncing properly to ForecastRx, match up the Order ID shown in ForecastRx with the Amazon Order ID in Seller Central. If you have the "Add Pending Orders" toggle on in Company Details, pending customer orders display in Demand and are counted towards your units sold valuation. 

Demand for Amazon companies also syncs removal orders since they are processed in Amazon as orders. Since removal orders are not actual sales, you will want to hide them from Demand. This can be done by filtering the Order ID column for known removal orders and selecting "Hide Demand" or by selecting the "Filter Removal Orders" button and entering the minimum number of units on a removal order to find multiple orders at once and hide them. You may also want to hide abnormal sales orders such as bulk orders using the Hide Demand feature as well.  For more information on filtering removal orders and hiding demand, click here. 

Demand For QuickBooks Companies:

Demand is synced from your sales orders and invoices in QuickBooks each time you initiate a data sync to ForecastRx. Demand will populate per item and order, and includes final sales as well as open sales orders. The Sales Order Qty will be applied to your sales history based on the Date of Sale, and the Open Sales Order Qty will influence your purchase order recommendations by adding on inventory needed to cover open sales orders. To check if sales are syncing properly to ForecastRx, match up the Reference Number shown in ForecastRx to your sales orders and invoices in QuickBooks. If you notice both a sales order and an invoice for the same transaction are being counted in ForecastRx, please contact ForecastRx support. 

If you have any abnormal sales such as wholesale orders that you would like to exclude from influencing your forecast, you can hide demand by checking off the sales and selecting "Hide Demand". For more information on hiding demand, click here. 

Demand For CSV Companies:

Users of CSV companies need to upload their previous 4 years of sales history as well as maintain current sales entries in Demand. This process can be simplified by uploading the total sales per SKU, for each month, as a single entry since the sales history will roll up per month for the monthly forecasts. You should upload the SKU, Sales Order Qty, Open Sales Order Qty, and Date of Sale for each entry, Reference Number is optional. If you are entering the month's sales, we recommend entering the Date of Sale as the first day of the month for consistent tracking. If you are uploading an Open Sales Order Qty, please make sure to update the quantity to 0 once the sales order is closed. 

For more information on maintaining Demand records for CSV companies, click here.

________________________________________________________________________________________________________________

If you would like to schedule a meeting with a member of the team—let us know, we are here to help!