Cost field populated on item sales CSV

[OdinsOutfitters]

I can't be the only one frustrated with this. I'm trying to do some margin analysis on my products using the item sales CSV. Everything is great, but Square doesn't seem to populate the CSV with the COST field, just the PRICE field. I've gone so far as to try and use the ITEM library and join it with the ITEM SALES table, but I can't get the pivot table to populate correctly.

It just makes sense that they would have the COST field, along with the PRICE field in the ITEM SALES CSV

[TheRealChipA]

Hi @OdinsOutfitters.  I see you posted this in the Square Point of Sale board.  Item costing, profit margin reports, and inventory value are not included in the basic, free POS.  To do these things, you would need to be on Square for Retail, and subscribed to the paid Retail Plus tier.  Square includes CoGS and profit margin reports as part of this.  Here’s a link to the Square for Retail Plans help document.

Regards,

[OdinsOutfitters]

You are correct... I WAS subscribed to the Plus Plus, until I discovered that my main reason for assigning a cost to an item was not workable... 

If you re-read my post, you will see that I specifically said that the cost field was NOT in the ITEM SALES CSV. Without that item, I can't do my own margin calculations and variations, which was the primary reason I subscribed to the Plus version.

If that field WAS in the ITEM SALES CSV, I could do profit/loss, margin calculations based on sales, and all kinds of other slices and dices that are not available in the regular Square reporting.

[TheRealChipA]

@OdinsOutfitters I did read your post, and I understood your issue very well.  I missed where you said in your original post that you used to be a Retail Plus subscriber.  Sorry for not noticing that part of your original post, or I wouldn’t have said what I did, obviously.

If you want to put a formal feature request into the Square POS Team for them to consider, you can do so on this board.  They will review it and determine if it is something they want to put on the product roadmap.  But this will take time.  They will review your request and let you know their decision.

You can also request that they tweak whatever is missing in Retail Plus costing so that it works for whatever use case is not workable for you right now.  If you go that route, you’d want to be very specific in your feature request to the Retail Team about what you are trying to do and why you can’t do it currently.