Vendors not showing up on report?

[mamashappy]

We just set up a couple items with variations (Liter and Sample).  Both we added a Vendor.  When we go into Inventory Management/Vendors, we see the items in the Item Library assigned to this vendor.

We did several test sales and then ran the Vendor Sales report under Inventory Reports section.  It shows the sales, but continues to say "No Vendor" as the vendor.  If you click on the vendor filter, it is say "No Vendor".

[mamashappy · Accepted solution]

So I have since found out that you need to always include a quantity and a cost for each item in addition to choosing the vendor in order for it to show up on the vendor sales report. It is also not retroactive. So if you go in and add a vendor or quantity or cost to an item after it has sold it will not update to appear on the report

[isabelle]

Hey @mamashappy!

Thanks for posting in the Seller Community.

Have you sold the items after adding the vendor to them? Because the Vendor Sales report would not be retroactive, meaning it won't backdate and show you the vendors associated with previously sold items/sales. This means that you can only view vendor sales for items/sales that have been sold after a vendor has been added for the item. 

I'd take a look at your recent transactions since adding the vendor to the items and ensure that your sales are including the items that have vendors associated with them. Please let me know if you have any questions about this. 

[mamashappy]

No.  We added the vendor and then sold the product.  In fact, we have been using the square app all week.  We have 43 sales across multiple different products and none are showing the vendor.  

[isabelle]

Okay @mamashappy.

That doesn't sound right. Please call our Square for Retail Team so they can identify where these missing reports are, or file a ticket with our Engineering team to locate them. 

Really sorry about this inconvenience, and hopefully we'll get this resolved today. 

[artisanspei56]

I am having the same problem with No Vendor items on vendor sales report. New to Square, I entered all my inventory in regular plain Square. I realized after the fact that I should be using Square Retail because I wanted Vendor Mgmt. I upgraded to Retail and attached a vendor to every item. We had sold products prior to the upgrade / addition of vendors. So now when I print a vendor sales report I do get a list of vendors with accurate sales info but at the top I always have a No Vendor list of various products even though I know they have a vendor attached. I really need this fixed, how do I do it? thanks 

[mamashappy · Accepted solution]

So I have since found out that you need to always include a quantity and a cost for each item in addition to choosing the vendor in order for it to show up on the vendor sales report. It is also not retroactive. So if you go in and add a vendor or quantity or cost to an item after it has sold it will not update to appear on the report

[artisanspei56]

Thank you, I am beginning to realize leaving a unit cost out (because of variations in commission) was a big mistake. Trying to figure out how to enter bulk costs at 0.00 instead of entering over 600 products manually 🤯

[mamashappy]

They really do need to have the ability to choose default settings for bulk product uploads, Or fix the requirement that the cost field be populated in order for an item to show up on the vendor sales report.

[mamashappy]

I am not sure if entering a cost of zero will fix the problem. You’ll have to try it. We just put .01 in the  cost field if it’s an item we’re not wanting/needing to track the margin on.

[TheMeadowsEly]

Did this resolve your problem? I added costs and quantities.. sold an item today and it still shows up with no vendor on the vendor report. 

In the item library every item is associated with a vendor. They've got quantities, prices, and costs.. and still not showing up in that vendor report. 

Any one else been through this?

[Lou8]

Hi @TheMeadowsEly, thanks for posting on this thread.

I'm sorry to hear you're running into the same issue. Are you checking your vendor report though your Dashboard in Reports > Inventory Reports > Vendor Sales ? Can you share a screenshot of what you're seeing on the screen ?

[angie24]

When I pay a vendor how do I record it?

[ashc]

Heya @angie24 and welcome to the Community.

I moved your post to an existing thread that goes over vendor reporting.

By visiting the Vendor Sales Report in your online Square Dashboard, you can view which items are sold in a given time frame, sorted by vendor. To do so:

1. Navigate to Reports > Inventory Reports > Vendor Sales in your online Square Dashboard.

2. Use the date selector at the top-left corner to choose the date range you’d like to view, or enter custom dates.

3. If you have more than one location, select which ones you’d like to see.

Read more about Square for Retail reporting.

[FriedmanFound]

My vendors are not showing up on my vendor reports, it's only reporting items with no vendor which is most items because they are our items. There's a drop down choice only for Top Vendors by Net Sales and Top Vendors by Net Units Sold. How can i see a report of all my vendors?

[JJ_]

This sounds like a good question for our Retail team, @FriedmanFound

They can take a look at your account with you to help shine a light here, as they can look at your account alongside you to pinpoint what's going on here with your Vendor Report. Please reach out by phone or email when you have a moment by logging into your Square account and heading here.

P.S. Welcome to the Seller Community

[sscs]

I have called Square for Retail regarding POS and how to print a report for a specific vendor month to month- basically I have consignors and I need to pay them a percentage for their monthly sales, Although they say it's something that they should have available, they do not. I cannot imagine that being the case. I used Quickbooks POS and could easily print their sales for them at any given time...don't most businesses want to know how much they are making selling for a specific vendor?? Help!!

[nika]

Sorry for any confusion @sscs. Take a look at this thread to make sure everything is set up correctly through your account with vendors and item sales first. I'm hoping this helps you out.

[sscs]

Thank you. I just am not impressed with all these "little" inconsistencies that keep appearing after buying Square for Retail. It should allow you to "fix" a vendor and then do a prior report if it said no vendor. Isn't that the point? Also, why is it that we didn't know that you needed cost and whatever other thing they say you need now in order for a report to be accurate. Isn't it possible to fix something that errors? There's no sense in changing anything (like someone mentioned 600 items) if it's not going to backdate it and allow you to then do the reports you need. Mine is an issue with companies loading your purchases and not including item cost and vendors & also from changing from another program and pulling my info over---none of it loads perfectly and now I just keep spending my time trying to "fix" things the way I need them so they will do accurate reports. But if it only fixes it from the date you change it forward, what is the sense in fixing all those items? Very frustrating. But I'm still not getting the reports I need...

[sscs]

Totally agree. The point is to fix errors — then have the ability to do the reports you need. It should back date & FIX the issue so reports you need are possible. I have found this Square For Retail not user friendly for retail. Square is great & easy & consistent but Square for Retail needs some major updates — talk with retailers & adjust or fix past problems. 

[ylferguson1964]

Hello,

I have used Square for retail for 4 months now with very few problems. However, I have just stating adding products for online sales and am finding that certain items are now showing up as No Vendor. I have made sure the items have the vendor name and tracking is turned on but not sure why it will not show up under that vendors sales. Please advise.

[MerrillG]

I too have discovered this issue which seems to be fairly common and has been ongoing and not resolved by Square for at least two years now. I have thousands of products. I have just switched over to Square for Retail Plus (I'm paying extra for the inventory tracking option and it is less than stellar!). 

There should be a way for bulk editing. There should also be a standard practice to have the all items entered in with a vendor to be applied to that vendor unless another vendor is entered. I have spent hours and hours and hours both trying to set up my inventory and now I have discovered I will have to go through EVERY SINGLE ITEM to now check and see if all the items are entered and reflect the correct vendor. Even though when I pull up the item in my inventory I can see the appropriate vendor listed. This is BEYOND FRUSTRATING!