thread Re: How do I do a bulk inventory update without it creating multiple prices for every item? in Archived Discussions (Read Only)

How do I do a bulk inventory update without it creating multiple prices for every item?

Bellandwhistle — Thu, 01 Feb 2018 18:54:42 GMT

Every time I try to do a bulk inventory adjustment (every time I buy supplies) it creates multiple prices for each item. I then have to go in and manually delete the extras. I know I’m missing a step because there’s no way this should be this hard.

Also, can I update inventory on my desktop while my POS is running at my shop?

Thanks for any help!

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

EJ_ — Fri, 02 Feb 2018 18:55:23 GMT

Hi @Bellandwhistle

Welcome to the Seller Community 🙌🏼

Were you using the basic inventory features or were you using Square for Retail?

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

Bellandwhistle — Fri, 02 Feb 2018 19:15:06 GMT

Basic

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

EJ_ — Fri, 02 Feb 2018 22:00:40 GMT

Thanks for clarifying @Bellandwhistle

When you were making these adjustments, were you using the bulk import spreadsheet? Or were you making these changes one by one?

The spreadsheet template should allow you to specify prices and variations, or remove them individually.

You can do this while your Point of Sale app is running, as everything is done on the backend through your Square Dashboard.

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

Bellandwhistle — Fri, 02 Feb 2018 22:08:17 GMT

I was using the square template. Should I be selecting update or replace current items?

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

EJ_ — Mon, 05 Feb 2018 19:17:01 GMT

@Bellandwhistle You should use the "Modify" option, as it allows you to alter existing items and add new ones.

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

NV_Rue_Cler — Tue, 19 Jul 2022 16:40:51 GMT

If I wanted to replace all the items in an entire category, here is the process I'm planning:

I would download the catalog,
I would delete all the items I no longer want
I would enter all the new items in that category
I want to add quantity, do I will enter that in New Quantity Rue Cler (not Current Quantity Rue Cler)
I do not want to change any other category , so I will leave them the same
I would import that catalog using "replace"

That would net me all the items I want to keep along with my entire category replaced.

How does this process sound?

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

JJ_ — Thu, 21 Jul 2022 14:43:04 GMT

Yes, this process looks accurate @NV_Rue_Cler. If you encounter any trouble, you can reach out to our support team so they can take a look at your file and confirm all looks good.

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

NV_Rue_Cler — Thu, 28 Jul 2022 15:59:08 GMT

@JJ_

If I wanted to perform a combination of Updating and creating new items, here is the process I would follow:

I would download the catalog,
I would delete all the items I no longer want
I would keep the items I did still want
I would enter all the new items in that category (leaving token blank)
I want to add quantity, do I will enter that in New Quantity Rue Cler (not Current Quantity Rue Cler)
I do not want to change any other category , so I will leave them the same
I would import that catalog using "modify"

What I'm looking for is keeping all of the items that still are in stock and at the same time removing items that are out of stock and replacing them with new items.

The biggest question is about Tokens and whether the OOS items will remain in the item catalog. This seems important because I'm assuming that the Tokens are what link the items to the menus that servers use to interact with the POS.

The goal would be to keep some things the same and remove/replace others.

If I'm just modifying, will it leave the old items in there if I don't replace their

Re: How do I do a bulk inventory update without it creating multiple prices for every item?

JJ_ — Thu, 28 Jul 2022 19:50:42 GMT

At this time the Square Inventory Bulk action is able to add and/or remove items. However, if you are looking to replace items you may encounter problems when importing a file if you are "reusing" an existing line item. As I mentioned before our support team should be able to receive your import file to confirm if you have properly formatted the document.

Also, the token column indicates a unique ID for that item and it's not related to Menus but how Square Inventory is organized.

I hope this information is helpful!