Stock List Cleanup and Reconciliation by SKU and ShelfStock List Cleanup and Reconciliation by SKU and Shelf
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Would you merge two stock rows with the same SKU?
In this fictional stock list, Shelf B holds four rolls of tape and Shelf C holds six. Both rows use TB-002. Keep both and you can find all ten rolls. Remove duplicates by SKU alone and one shelf disappears from the count.
The packing boxes are a different case. The same count was entered twice for Shelf A, so the agreed rule keeps one row with 12 boxes. The label packs have a blank count, which stays open for someone to check.
My first question before cleaning a stock sheet is what one row represents. Here, the shelf matters as much as the product code.

contra.com

Stock list cleanup and reconciliation for up to 500 rows by James Frost

Read more about Stock list cleanup and reconciliation for up to 500 rows by James Frost on Contra.

Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started