Inventory & Overstock location Management

[DinaLRosenberg]

Yesterday we were cleaning out a closet in our shop and found 5 "gratitude' candles with a burn by date of 11/2021.... whellppppp... 

There goes that inventory.

This is just a real world example of how difficult it is to manage overstock location with square items/inventory. There is no place for us retailers to memorialize where items are located within the store and where overstock is. I understand we can create a spreadsheet with that information.. and I know many retailers on here that are incredibly tech proficient that have done that.

However, if Square is to be a robust retail ecosystem- they MUST solve for this. 

[TCSlaguna]

Long time feature request badly needed. Hope it gets some love and attention this year. 

[sacredheart926]

This literally would be a game changer for my store!!!

[Leobernardes]

This would be a great feature! Also, being able to have the same item in multiple locations inside the same store - I'm not sure how the system would know which section of the store the item was in before the sale.

[evieWG]

Totally agree. My workaround is a Custom attribute on items called "Qty in Stock Room" and my staff knows to update that number when moving in and out of storage.

It's working decently well for us but we are a small enough store that it is easy to notice when things are missing...

[greenlotusdream]

I'll have to try this. We have stock in the immediate storage along with an off site storage and it makes it difficult to track true inventory counts without having to have a "2nd location".

I have not used the custom attribute fields for anything yet. Have you noticed any issues or quirks? I'm assuming this attribute is only applied to specific items you have located in the storage?

Thank you!

[evieWG]

Yes, only applied to specific items. Honestly, that's the most challenging part -- having to add the attribute to items and other views.

This is maybe more info than you're looking for but my process is this:

• Inventory received needs to go to stock room
• Add custom attribute to item(s) and put quantity that will go to stock room
• At end of shift, bring items to stock room (which is in the basement and creates some headaches to go down during a shift...not a Square problem, but worth noting)
• Once a week, I filter my items in Square by Custom attribute>Qty in Stock Room> Greater than 0
• Export library (Only filtered items)
• Print document
• Walk sales floor to check what's needed to be brought up from storage
• Restock to desired qty on floor
• Bulk edit custom attribute to reflect change in stock

This would be 100% easier if Square export included custom attributes, but alas.

[JTPets]

You could have claude write you a script to export your catalog and Include the custom attributes. Have it export on a schedule to a google sheet running a google apps script with a square token.

80% of whst you need is in my github with a few minor modifications