Best COGS and Inventory Management App

[BiscAccounting]

We have a retail business with more than 1,000 inventory products. We use Shopify for our cost pricing of our products and Better Reports to calculate Inventory and COGS. The issue though, is that Better Reports does not track historical inventory cost amounts so when an existing product has an inventory price change, the new price is applied to all prior inventory at the old price when the price is updated in Shopify. What do you use for your retail businesses to manage inventory and track historical costs so that a more accurate COGS amount can be applied that is weighted average, FIFO, or LIFO?

[MozzoERP]

Hi BiscAccounting,

We are just getting ready to launch on the Shopify app store, but have been around awhile. What app do you use for accounting (QuickBooks, etc)?

Our solution (http://MozzoERP.com) integrates with QuickBooks to publish inventory purchases and sales to calculate the average COGS based on history and average cost.

We plan to integrate with other financials systems as well, but currently work with QuickBooks online and desktop.

Of course, our solution does a lot of other things to support back end operations (full warehouse management, order management, inventory planning and procurement, and much more) which may or may not be something you need, but willing to discuss with you and now to get a solution to your problem.

[sfactor503]

I am looking for the same thing. 

I haven't switched to shopify POS for my brick and mortar stores because of issues like this. 

I am on the verge of using Lightspeed - but the thought of paying for the third party integration pains me. My business is almost one year old and 95% of my sales happen out of the Brick and Mortar location, but I use Shopify for web. Don't know if I made the right decision...BUT, if shopify can answer this question it would help.

I too have an item that I sometimes source from different suppliers and I may be 10 of an item from one and 10 from another at different times. In order to have an accurate read of my margin FIFO or cost averaging would work best, but no app seems to do this? Or is there one?

I am in the process of looking for a third party app for COGS / Inventory Management / Internal Purchase Orders

[BiscAccounting]

Let me know if you find something! How does Lightspeed work?

[MozzoERP]

@sfactor503 what financials system do you use?

[MozzoERP]

@BiscAccounting  which financials system do you use for your business?

[sfactor503]

I've shifted my entire store POS to lightspeed. They do all the things I need out of the box as their specialty is Brick and Mortar. I exhausted all POS systems including Square, Shopify, Vend, and Lightspeed. For us, on the fly creation of items as we create PO's was key and having multiple suppliers for an item. As a veteran of supply chain world and private label product it's common to have multiple vendors for products. I pay a little more for lightspeed than other vendors but it's got EVERYTHING we need to be better at reading and refining the area of our business that's excelling (the store). We are sticking with shopify online for now, but can't spend $100  amonth  on third party integration YET (as our online sales are minimal). That said, chances are we'll switch to Lightspeed to keep everything tidy. If someone can create an integration for $50 a month just for inventory updating that'd be rad but no one seems to do it.

[sfactor503]

We use Quickbooks

[MozzoERP]

@sfactor503 

Our solution works with QuickBooks (online or Desktop). It creates POs, pushes them to QB, and let's QB calculate the average COGs. We also integrate with Shopify and could push this value to Shopify. Note we may need to teak a couple of minor things based on your specific needs/work flows. Would you like to setup a short call to discuss?

[sfactor503]

I've decided to minimize the amount of parties into my mix and keep things
super simple. Less is more sometimes.

[Thomas_Lang1]

Hi sfactor, I could make this happen, I have an app that displays inventory on the frontend per location (in the App Store)

I created an interface for lightspeed retail because some plus stores used lightspeed in the physical locations. At this point it only displays the inventory per location on frontend, but I could add synchronization to update product stock levels in the Shopify store. Just need to make sure if the SKUs from Shopify and lightspeed match.

Let me know if this would be useful

[sfactor503]

Yes it would,

What is the monthly cost for this?

[Thomas_Lang1]

-

double post

[Thomas_Lang1]

Default shopify plans pay $6.99 monthly

Shopify Pus is $24.99 / monthly

If you want to synchronize inventory counts from lightspeed to shopify I can make a quote for customizing the app, then you would have a one time payment plus the monthly fee of the app.

You can send me an E-mail to discuss further info@tom-it.nl

You can find my app in the shopify app store

[Jill3]

Hi, we can help with this. We'll show historic stock levels and stock cost starting with the date you connect. Check out Inventory Planner here in the App Store. 

Glad to talk with you more about how to get the information you need.

Jill

[Anika_Hobbs]

What do you do to manage your online and b&m inventory?  Right now, we use Shopify online and Square for our store but they have the same inventory and not connected.  Is there something you use or do you have a separate inventory?

[axsuul]

@Anika_Hobbs You can use Trunk to centralize your inventory between Square and Shopify and keep it synced in real-time. All you need to do is make sure SKUs match between both:

https://trunkinventory.com

[Anika_Hobbs]

Awesome! Thank you.

[GhostApps]

Hi, my app Simple Purchase Orders https://apps.shopify.com/simple-po can definitely help you out. It allows you to set up suppliers and import products and their cost prices. You can then automatically generate purchase orders to reorder stock and transfer it into your Shopify inventory when it arrives.

Please check it out and let me know if you have any questions

[benlee]

We launched a Shopify Pack for Coda that's a 2-way sync integration and lets you use your data however you see fit.

https://community.shopify.com/c/Shopify-Apps/Coda-s-Shopify-Pack-2-way-Sync-between-Shopify-and-Coda...

We've seen some very unique use-cases with special requirements around inventory and our users are finding custom solutions with it! I've preferred this route because you can create solutions for any aspect of your store and it's all within Coda. It really keeps workflows consistent as well as custom to your business.