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?
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
@sfactor503 what financials system do you use?
@BiscAccounting which financials system do you use for your business?
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.
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?
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 email@example.com
You can find my app in the shopify app store
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?
@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:
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
We launched a Shopify Pack for Coda that's a 2-way sync integration and lets you use your data however you see fit.
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.