Simple products
Cost, price and quantity. That’s it.
An artificial piece keeps the useful parts of a product: SKU, name, category, description, size, photos, location, supplier, quantity and pieces, plus a cost price and a sale price. It prints on the same barcode tags and is found with the same scanner.
Selling part of a quantity drops the count on the same row, so twelve pairs of earrings stay one product until the last pair sells.