thread Re: Start Tracking Item Inventory Bulk Select in Archived Discussions (Read Only)

Start Tracking Item Inventory Bulk Select

HallowedTree — Tue, 05 Jul 2016 21:55:44 GMT

I love that I can track my inventory and sales, but is there a way to bulk select "Start Tracking Inventory" via the spreadsheets that you can export/import (rather like bulk selecting the tax rate)?

This would be immensely helpful since right now I have to go into each item in my store and select that button individually (and we have over 200 items)...

Any help if I have missed something would be greatly appriciated...and if I haven't missed something, could it be added to the list of possible updates?

How do we add more then 1 item so that we can keep track of how many we have in stock?

RunawayQuilters — Wed, 06 Jul 2016 02:35:32 GMT

We have been trying to figure out how to add just how many of an item we have in stock. We can not figure it out. We have the updated version but there is NO where to add how much inventory we have of a specific item.

Re: Start Tracking Item Inventory Bulk Select

Kelly — Sun, 16 Jun 2019 17:56:48 GMT

Yep! You can use the Inventory Import/Export tool to adjust all of your location inventory at the same time! When you import you new stock levels, your Dashboard will automatically turn on the "Start Tracking Inventory". Follow the steps below:

Sign in to your dashboard and click Items. (If you’re using multiple locations, navigate to the location specific library you’d like to modify. To do so click All Locations at the top of the Items page > select a location/multiple locations.)
Click Actions > then click Export Inventory from the drop-down menu.
Update the values under Alert Threshold and New Quantity > save the CSV report.
Drag and drop your saved file to the Import Inventory window> click Upload.
Click Confirm Import > Done.

Re: How do we add more then 1 item so that we can keep track of how many we have in stock?

Kelly — Wed, 06 Jul 2016 16:32:00 GMT

@RunawayQuilters Check out the information above to help get you started on entering your stock levels!

can i import quikbooks file to square inventory

Tim1 — Thu, 14 Jul 2016 20:13:36 GMT

Tim

Re: can i import quikbooks file to square inventory

Kelly — Sun, 17 Jul 2016 17:33:38 GMT

@Tim1 Check out my answer above to get started importing your Quickbooks inventory into Square Inventory.

Low Stock Alerts as CSV download

HouseofSwank — Fri, 22 Jul 2016 13:59:26 GMT

We're considering migrating back to Square, but a huge sticking point us is the low stock alerts. We're using Vend now, and we can actually set up automatic restock levels based on low inventory, so coming up with a workaround is a must with 1000's of SKUs.

Right now, the low stock alerts just come in a non-sortable text field in an email, which is basically useless. We really need to be able to download this report in a CSV file, perferably pre-set up so we can just add the new inventory stock and re-upload to square. Barring that, just getting the report as a CSV would be a start.

Any ideas? This is probably a dealbreaker for us coming back, so hopefully someone's come up with something.

Re: Low Stock Alerts as CSV download

Kelly — Sun, 24 Jul 2016 19:07:58 GMT

You can export you inventory to a CSV file! Check out the information above to learn how to import and export your inventory levels.

If you need more advanced inventory tracking, we do offer integrations with third party apps like ShipStation, Intrakr and many more! Check out your Square Dashboard for a full list of the third party options that we offer.

Re: Low Stock Alerts as CSV download

UsborneMichelle — Mon, 25 Jul 2016 00:33:35 GMT

I am searching for a way to import my inventory list. I keep seeing that if we go to Items there should be an "import/export" option but I simply cannot find it.

Any help is greatly appreciated!

What happened to importing an item file?

21x20 — Mon, 25 Jul 2016 17:22:33 GMT

On the "Items" tab, you used to be able to import a CSV of your items...

This appears to be gone.

What happened? Where did it go?

Thanks!

Re: What happened to importing an item file?

21x20 — Mon, 25 Jul 2016 17:29:04 GMT

Screenshot from https://squareup.com/help/us/en/article/5115

This... Is GONE.

Re: Low Stock Alerts as CSV download

Kelly — Tue, 26 Jul 2016 15:26:26 GMT

@UsborneMichelle Sounds like you may be using our locations feature, which admittedly can hide the "import/export" button. You'll first need to navigate to the location specific library you’d like to modify. To do so, click an item in your library then click Select a Location under Inventory and click Go.

If you run into any trouble check out this thread for step by step instructions.

Re: Low Stock Alerts as CSV download

UsborneMichelle — Tue, 26 Jul 2016 15:46:32 GMT

@Kelly Thank you!!!!

Re: What happened to importing an item file?

Kelly — Tue, 26 Jul 2016 16:41:50 GMT

@21x20 Sounds like you might be having the same problem as UsborneMichelle, check out my answer above.

Re: What happened to importing an item file?

21x20 — Tue, 26 Jul 2016 16:54:25 GMT

Well, partially solved. That works for me... but I'm also trying to assist folks setting up their item inventory for the first time. Here's what that screen looks like... Even if I use your trick to find it on my own, that trick doesn't work for them.

So it looks like they have to create a mock-item first in order to have the option to import?

Either way, it's all very not user friendly. The system used to be sooooo simple. It's a disappointing update to say the least.

Re: What happened to importing an item file?

Kelly — Wed, 27 Jul 2016 16:23:43 GMT

@21x20 I'd love to take a closer look at the account that you are having trouble with, that screenshot doesn't look quite right to me. Have them reach out to our Support Team to help out. I've included a screenshot of what the items tab should look like.

How do I add multiples to my inventory

Kelliekub — Mon, 08 Aug 2016 16:04:47 GMT

I am just adding inventory to my library and cannot figure out how to add quantity. Like if I have 2 or 3 of the same item in the exact same size. There has got to be an easier way than imputing each one

Re: How do I add multiples to my inventory

Tom — Wed, 10 Aug 2016 18:20:30 GMT

Hey @Kelliekub, thanks for bringing this up. A few other sellers had a similar request not too long ago. Have a look at Kelly's reply and let us know if you have any other questions. Hope it helps! 🙂

Re: Start Tracking Item Inventory Bulk Select

Freya11 — Fri, 28 Oct 2016 19:53:47 GMT

Hi there!

I uploaded exactly 4295 item variations correctly. All of them had a new quantity of stock, which also got uploaded everywhere.

The Stock Alert column in my database was enabled with "Y" and the Stock Alert Count was set to "0" on each item variation. All three were related to the same correct (one and only) location.

But only part of the items obviously turned on the "Track Stock" feature correctly, and this was done also only after refreshing the page.

The other items won't turn on "Track Stock" automatically like promised on uploading from the database. I tried it a couple of times more, refreshed the page, nothing made them Tracking the existing amount of stock.

I could hook the "Track Stock" feature directly on the app, but this seems to be stupid with this amount of item variations.

How can I trigger the remaining items to show "Track Stock"?

Thanks for your help!
I run already your app successfully for my two ice cream cafes for a year with no problems, now with a huge amount of items for my x-mas shop and the desired stock tracking this seems to be a bit harder 😞

Re: Start Tracking Item Inventory Bulk Select

Sean — Sun, 30 Oct 2016 18:50:43 GMT

@Freya11 - We'd be happy to dig into this more closely, but we'll need you to reach out directly so we can get a copy of your .CSV file. If you'd prefer to wait until tomorrow, you can just give us a call. Our phone lines are open Monday - Friday, 6AM to 6PM PT. 👍