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

[Candlestore · Accepted solution]

@MerrillG;

As I see this is your first post welcome to the Square users forum.

Square Does have a way to bulk upload inventory and edit it.  

The Best way to do this is enter an item called Sample Item Test in your Square for Retail App.

Enter as much information as possible, even if you do not think you use it now.  Once you save this new item goto your Square Dashboard and Download your Items Catalog as a CSV or Excel file.  This will have a Header for each Column you used and some that are entered by Square Automatically like Refrence Handle and Token.  When these are blank Square creates a new item.  If they have a value Square looks in the catalog to edit the item that the Refrence Handle and Token Match.  I know in the spreedsheet download files you can edit the Vendor alot quicker than in the App or on the Square Dashboard 1 by 1.

Here is more on the Bulk Import feature in Square.  5153-import-items-online 

I know it says for Square Online, but the App and your Dashboard are online to edit through Squares website.

Also realize that any Item that Sold with no vendor will show No vendor at the time of sale.  If you and Vendor XYZ, Square does not update yesterdays sales, but all future sales will report the Vendor Name you associated with the Item.