custom sales report

cascott — Sat, 20 Sep 2025 09:44:41 GMT

I need to add a sort feature to my monthly sales report to separate my vendors by name, assigned color, or assigned number all of which I have entered to each of their items listed in my inventory.

We are a small gift shop consisting of handmade gift items. At this time I have 4 separate vendors

and need to pay them at the end of the month for their sales. I do not charge a commission only charge a monthly space rent. And I collect and pay all sales tax.

Re: custom sales report

Summer2024 — Tue, 11 Mar 2025 13:39:15 GMT

Hi @cascott ! Welcome to the Square Community! We are so happy you're here!

I have listed some different ways to possibly achieve this.

Set Up Categories for Each Vendor:

Go to items > categories
Create new.category for each vendor
Name them clearly (Vendor-Jane Doe; Vendor-JD)
Run the category sales report
1. Filter by date
2. Select "Categories"
3. Export to CSV/Excel

Create Custom Attribute for Vendors:

Item > item options
Custom Attributes
Add "Vendor Name" or "Vendor ID"
Assign to all items
Generate custom report
1. Export items report
2. Filter by custom attributes
3. Sort by vendor information

Best Practices for Vendor Management

Item Naming Convention:
1. Format: {Vendor-ID] - [item name] Example "V1-Handmade Scarf" or "JANE-Pottery"
Color Coding System:
- Use Categories with consistent naming
- Add vendor color in item notes
- Include in SKU system

I hope this helps!

thread Re: custom sales report in Orders, Menu Items, Catalog & Fulfilment

custom sales report

Re: custom sales report