Start a new topic

20K SKU limit?!

I was trying to get started with Dear to use for my physical store and Shopify website that have a shared inventory. Through the process I was told there is a 20,000 sku limit. We are just a small children's clothing boutique in a 1000 sq foot location, yet we go through about 15,000 sku's pre season. You guys are starting this new POS system which based on website images of the POS with displaying clothing items, and offering laybuy that you certainly want this to be used in the clothing industry. It seems like your maximum LIFETIME sku limit is a severe hindrance to what kind of clothing store could use your system.  There is no way to delete sku's because they are used transactions and need to stay anyway for historical reporting.

It seems like any retail store that has seasonal inventory will not be able to use your system for very long before hitting 20,000 sku's

I don't know if raising the sku limit is considered a "feature" or not, but I would like to suggest that it be increased to a great extent and also a module for easily bulk deleting old products (maybe being able to sort by the last time they were sold). OR keeping them for reporting purposes but bulk mark them as inactive so that the system can just ignore them except for when someone is doing old history reports, that way they aren't a constant drain on the database.

I really want to try to use Dear but my initial import would be around 15,000 sku's (many of which are 0 qty) and I will be adding another 15,000 or so through July and August.

Thanks so much! I hope to be able to use Dear one day, its the only system that has specific functions related to Shopify that I need.


3 people like this idea

This is great to know. I wasn't aware of this limit and could prove problematic. 

1 person likes this
Jonathan, I was sprites as well, I felt like this info should be out in the open on the pricing table. I just finished removing over 10k inactive sku's from my shopify so they don't import into Dear. But I will be lucky if I can get 2 full years our of Dear before I hit the limit and have to shop around all over again. Hopefully they will change it to 20k active sku's or have a purge method that removes items from inventory but archives them to retain the financial data for reporting. This way I don't outgrow it in 2yrs (or less). 20k individual sku lifetime limit is very low for the apparel industry

I hope it will be possible to have over 20,000 SKUs in DEAR in the future. Meanwhile what you can consider to do if you approach the limit is to merge the SKUs that are no longer in use. For example you can create a generic product like "summer 2016 collection" and merge the old apparel so you could have space for your new collection. Merging will replace the old products with the primary product all across the board - in all the transactions like sales etc. So before merging the products you might want to export sales by product details report to backup this data.

Thank you for the work around Valiantsina. The Dear support team did mention this too me as a work around, however I really would prefer not to do that because I believe it messes up the ability to run detailed reports. We like to run reports to see what brands and/or sizes sold best for similar periods in prior years. Wouldn't we loose that ability by merging products? I know you mentioned exporting some reports to excel but it just wouldn't work for what we need because often we do this for unusual dates. Like if we want to run a sale this week we may look back at prior years to see what sold best last time we ran the same sale. So it's not always specific reports that we can create ahead of time. Thanks! Stephen

That is correct, merging products will remove the ability to see the breakdown for those products in the reports. That is why you can create a sales report and add all the dates and all the additional fields you use - like categories, brands etc. So that you can use Excel tools to get the data you need from such export.

I know this is not an ideal solution but unfortunately it is the only solution I can think of at this moment.

This really isn't good enough. This limit needs to be increased and I don't see why it can't be.

We really need feedback on this from DEAR. 20K limit is ridiculous in an Inventory management system. 

2 people like this
Login or Signup to post a comment