Thread: Size/Color Inventory Orphan Records

Is there a "proper" way to clean up orphaned records in the Inventory table?

Over the past couple of years, it has been a practice here to remove the size or color from an item when it is no longer available. We're changing our ways on this going forward, but there are currently a lot of records out there detached from their variants.

Part 2
We run the store allowing out of stock inventory to be shown, but would like to be able to disable certain sizes or colors without creating the orphans above. As a feature request perhaps we could add a "kill" character to the appconfigs that when found within the size color attributes, would cause that size or color not to be displayed for sale. For example

Red,Green,!Yellow,Blue

Yellow would not be displayed in the drop down or variants in table etc.

Incidentally this all came up because we are using the WSI interfaces for more maintenance and it is working great, but sometimes gives us insight into things we didn't realize were happening....

Thanks,
Rob

Perhaps if I rephrase the first part of the message above...

Can I safely delete records on the Inventory table which no longer have a corresponding entry in the Color or Size columns of the matching ProductVariant record?

Thanks,
Rob

Yes, its safe to delete those. In the next version those items should be cleaned up properly.


*Please ensure that you have a full, functioning backup before making any code modifications or file changes to your AspDotNetStorefront website, or running any ad-hoc queries against your database. Improperly making code modifications or running queries against your database can cause your website to be non-functional and/or your data to be permanently lost. As part of your disaster recovery plan, you should make regular backups of all files and data, and perform periodic checks to ensure your backups function properly. If you are not sure if your data is adequately protected, contact an IT professional or your hosting provider for assistance.

Perfect - Thanks!

Can this safely be done through a query? I am trying to create a total stock value overview. The orphaned records are shown in the list so I want to delete them.

Regards,
Marc