Initial Inventory vs Sold Inventory Report

[AlliAndria]

I'm completely new to retail sales and would like a report on the amount of inventory of all products initially entered into the system and what was sold out of that for a certain time period.  I'm hoping to generate something more as products all together, as opposed to individually just viewing the inventory history. It would take forever to view initial inventory of everything one by one!  I tried searching everywhere in the community, hoping someone can help in some way!  Thank you!

[Anonymous]

HI

This is not available as such can be done using the api 

I am a shopify api expert and happy to help you

Email me makkysolutionsltd@gmail.com

[JohnDoherty]

Hi @AlliAndria,

Great question it is important being able to evaluate your sales against your inventory for demand planning. There is an app called TrueStock (https://apps.shopify.com/truestock) I've used would recommend checking out. It predicts your future sales using machine learning and plans your inventory ahead for you automatically. It syncs automatically daily too which is great and can alert you via slack also!

Hope this helps

[RBetterReports]

Hi @AlliAndria,

Rishika here from Better Reports.

Yes, I would recommend our app Better Reports for this.

We can show the all time sales of inventory by product / variant all together along with inventory. Trying to figure out how long the inventory was "sold out" in in x days out of the last month isn't possible as it requires historical inventory's API which isn't available. However, we can report on the current sold out inventory. 

You can also schedule this report to be sent automatically to your email or google drive at a regular cadence (like daily, monthly, etc.), so going forward you'll have an accurate record of Inventory as well.

It Is also possible to export the reports in CSV, Excel or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

Let me know how you go, and feel free to reach out if you have any further questions.

Disclaimer: I am part of Better Reports support team.

[Report-Pundit]

Hi @AlliAndria,

It's a good question. In fact, we have received a lot of queries on past Inventory. However, there is no availability of historical Inventory API, but we have an Inventory snapshot feature in Report Pundit.

When you enable this feature, it tracks end of the day Inventory levels from the day of enabling Inventory snapshot.

You will be able to know the Inventory flow like Day to day Opening Inventory, Units Sold, Units Returned, Units Restocked, Units Adjusted & Closing Inventory are tracked in the report.

The Inventory snapshot report helps you get Inventory on a particular date for accounting purpose.

 You can also analyze Inventory by each Location and know which product is performing well in each location & can plan your Inventory accordingly.

Contact us at support@reportpundit.com or our live support for help in creating reports.

Thanks,
John