Hello! I am wondering if anyone has solved my problem of managing consignment and wholesale inventory. We currently use Stitch inventory management, however, that system does not allow you to run reports of current inventory status by designer. You can only run reports on sales, not what you have in stock by designer, or you can download ALL inventory in one massive CSV.
The CSV I can get includes a column containing "Product Name (Color, Size, Designer)" all in one cell. We have over 40 designers and I need a way to separate our consignment and wholesale accounts. Because of the way the the file exports, with the product information and designer all in the same cell, I don't know how to filter the data in a way that is helpful, without having to go through the file row by row and delete the consignment product rows.
Has anyone else run into this? Any creative ideas on how to solve the problem, or experience with an inventory system that can run inventory reports by designer?