search-icon

Implemented
20K SKU limit?!

started a topic almost 7 years ago

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.

Stephen


10 people like this idea
  • Hi All, We have recently made some improvements which might allow us to remove the 20k SKU limit. Still currently in testing phase and should the limit be increased we will notify you all asap. Thank you

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


    2 people like this
  • Hi All,


    Thank you for your patience, after successfully testing the improvements, the SKU limit has been increased to 100,000. We hope this will be sufficient to cater to your needs in near future. Please let us know if you would like to discuss further.


    Thank you


    DEAR Support


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


    1 person likes this
  • DEAR Limitations? 100,000 SKU's.

    I am currently looking at implementation of the DEAR Inventory System to a client. My only concern is the way this client works is to have all of their suppliers stock lists on their system so that they can look up a part for a customer, and order from the system. This means that they want to maintain all of their suppliers [which are several] catalogues on the system, even though they would never [or be unlikely to] stock all of the suppliers products. Is there a way to implement this in DEAR, particularly with 100,000 max SKU's? 

    Currently they upload each suppliers catalogue of parts, so they can lookup whatever a customer wants from their POS system, and order it in from the supplier, for the customer. Their current system will only add the item to stock when it is "actually ordered".

    Is this currently possible, without exceeding the limitations in DEAR [ie 100,000 SKUs]

    I look forward to your earliest reply,

    Thanks

    Peter


    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

    1 person likes this
  • This really isn't good enough. This limit needs to be increased and I don't see why it can't be.
  • 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
  • We recently had a DEAR deployment where the client had 26,000 products, and only discovered this issue after importing the 21st CSV file during pre-deployment.

    We ended up needing to agree on which parts to exclude for the time being, and imported 19,400 products, with any products not in the system to be created "on the fly".

    They deal in automotive spare parts, for many of the parts, they may only order in as required, but because each part has a unique code pertaining to a particular make, model and year of car it is vital to have all of these items in the system to be able to be searched by staff and to provide information to customers.

    They are planning on expanding their range to supply parts from other car brands, but with the 20,000 SKU limitation, there is no room for them to grow/expand. We understand there may be associated performance issues with a higher amount of SKUs, as the system is loading slower than normal with the 19,000 products in there already, but the current 20,000 SKU limit is very restrictive for some clients' needs.

  • Yup... no one will get back to you though...had I known there was that limit, would have gone with something else and in a few months will likely have to, due to that limit.
  • Thanks for point that out. That is very limiting indeed.

  • And silence on this topic as per most.
  • And still no one from DEAR bothers to comment. We are 4 months in and on 13500 items already. Means we will likely have to move off in 4 months
  • We also need an answer to Peter's question.

Login or Signup to post a comment

10 people like this idea
Log in or Sign up to post a comment