Vendor Barcode and tracking

[ThistleExchange]

Hello,

This may be confusing but i run a small buisness that sells vendor items that change often for the season. My vendors are wanting to be able to track there daily sales as well as go to a barcode system. Im having trouble find anything on square that works for this sort of thing. I know square has inventory and barcoding as ive used it for my own merchandise. But wasnt sure if there was away for the vendors to barcode there own items and track there daily sale through my square, or is there a program that syncs to square that would gather that information for them

[Candlestore]

@ThistleExchange ;

I am not sure of a way to export just a certain Vendors sales to that vender automatically daily.  Now if your vendor has a barcode on an item you can use that barcode for Square also.  Then you could do a report on what items sold by day, week or month and sort or filter by vendor.  

From your computer go to Squares Dashboard,  https://squareup.com/dashboard/ 

then Reports, then on the Left side Open the drop down for Inventory Reports - then Select Vendor Sales  Near the top right above the Graph there is a Tab you can open and select XYZ Vendor and you can export this as a csv.  Then email to your Vendor.  

Here are the headers from the csv file I just downloaded trying this out for you.

Item Name

Item Variation

SKU

Category

Gross Sales

Refunds

Discounts & Comps

Net Sales

Tax

Unit

Units Sold

Units Refunded

GTIN

When I did this download for Vendor XYZ only XYZ vendor showed up for these columns which sounds like what you want.  Now this might only be available for Square For Retail (paid) since that is what I am using and I know that has a few better reports than the Free Square for Retail.  Another thing to watch is that this report does show Gross sales and not the cost of the item.  But it does have the SKU (Barcode) and Units Sold and returned which is what your vendor really wants.  The thing with this is it is able to be done, but at a cost to you......Your Time depending how often they want this and how long it takes you to pull and email this report plus any editing to remove data you do not want your vendor having.  

For this vendor I pulled I use their Barcode for my SKU or GTIN.... Which ever Square asked me for when I scanned their item the first time.