x

How to delete multiple items?

We created over a period of time too many items which we don't use anymore. Is there a way to clean it up massively instead of one by one?

60,799 Views
Message 1 of 75
Report
1 Best Answer
Square

Best Answer

While we don't have a "bulk delete" button, I have a work around that may work! You'll just need to update the items CSV from your Dashboard by exporting it, making your changes then importing the updated CSV back into your Dashboard. Here’s how:

 

First Export:

  1. Sign in to your dashboard and click Items.
  2. Click ActionsImport/Export at the top-right of the page> Export Items

Make the necessary edits to you item library by delete the item rows that you do not need.

 

Import Updated CSV:

  1. Visit Items in your online Square Dashboard.
  2. Click Import Items at the top right of dashboard.
  3. Select Replace Item Library and click Next.
  4. Drag and drop your updated .CSV template file into your Dashboard.
  5. Click Upload.
  6. Review your changes and click Confirm Import.

View Best Answer >

72,426 Views
Message 2 of 75
Report
74 REPLIES 74

What you have to do is, export your inventory out, delete all rows except for 1 item, and then save and import with the replace option.  Once you do this, all items will be deleted except the 1 item you left on the import.  You can then manually delete the 1 item.

7,085 Views
Message 43 of 75
Report

This is not working, I have followed exactly...

square inventory errors.jpg

6,645 Views
Message 44 of 75
Report

Hey @vbinn, have you doubled checked your CSV file, to make sure all of your items have names? 

6,738 Views
Message 45 of 75
Report

Thats the exact same issue I have. I am trying to delete all inventory as i trippled up when setting up Bigcommerce. Why is it that they say you do this this and this but nothing works. I deleted all but 1 in the csv file and same errors. Come on you guys, give us an actual correct answer not something from script.

Screenshot_5.png

6,606 Views
Message 46 of 75
Report

@Chad I am trying to delete everything as well. If I give every line a name, I still have over 8000 line items i have to delete one aty a time. This is ridiculous. How do I erase all my files. FIX THIS!

6,268 Views
Message 47 of 75
Report
Admin

I'm so sorry for the frustration this is causing @reloaders and @LowLifeStyle! It would be great if you could contact our Support Team directly who can review your individual .CSV files and help you fix this ASAP. 

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
5,882 Views
Message 48 of 75
Report

"Go into the excel file and leave just ONE item. Upload that excel file with that one item left in it and then just manually delete the one item that's left."

 

I just tried this technique and it worked for me! Thanks so much!

5,819 Views
Message 49 of 75
Report
Admin

Sounds good @DJD! Welcome to the Seller Community! 🎉

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
5,752 Views
Message 50 of 75
Report

Helen,

 

all the items I want delete come from bigcommerce thru an external aplication. I will cancel the bigcommerce web site and the app, so When this happen all this items from them now on my square will delete automatic ?

 

I try to delete with the steps above but I can't, and do it individual will be crazy 8,000 items .

 

Thank you,

OG

5,571 Views
Message 51 of 75
Report
Square Community Moderator

Hi @OGSPORTS

 

You'll want to delete the items from your Square Dashboard using the steps listed in the Best Answer

 

While you'll need to check with BigCommerce directly for clarification, deleting your website and your BigCommerce app shouldn't impact your Square item library. 

5,561 Views
Message 52 of 75
Report

I have tried EVERYTHING. 

 

I exported what I had in my library, and added in the boxes that were filled in with new inventory, and TRIED to import, but all it shows is everything that was already there, nothing new.

 

This is frustrating, not only to me, but to what looks like A LOT of people judging by this thread.   PLEASE fix this issue.

 

Thank you!

5,634 Views
Message 53 of 75
Report
Admin

I'm very sorry for the frustration @RhondaConrad! Our Support team can take a closer look at your inventory and help you to update it. When you get a chance please call —or let me know here and I'll ask Support to reach out to you by email. Thanks for your patience with all of this! 

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
5,569 Views
Message 54 of 75
Report

I have the same problem I need delete 5,000 items, you fix the problem?

5,485 Views
Message 55 of 75
Report

This worked for me too, was able to delete thousands of items in seconds.

 

At first, I was getting an error that my excel sheet had empty lines, I fixed it by selecting all rows after the first one and deleting them.

 

Thanks @DJD!

5,238 Views
Message 56 of 75
Report

Can you delete multiple "items" or do they have to be done one by one?

 

just sold a lot of my inventory to a fellow collector. How do i delete multiple items instead of having to go through one by one? i have over 2000 items to go through. thanks

 

5,606 Views
Message 57 of 75
Report
Admin

This reply was created from merging an existing thread: Can you delete multiple "items" or do they have to be done one by one?

 

@amberstoychest If you need to completely delete multiple items Kelly's Best Answer on the first page of this thread has the steps to do this. I've moved your post here so you could see her answer but let me know if you have any questions about this! 

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
5,631 Views
Message 58 of 75
Report

Why not update the app and dashboard with an option to select multiple items and delete them? 

5,506 Views
Message 59 of 75
Report
Admin

Hello @thegrindhouston! I'm sorry for the frustration, I agree it would be handy to be able to edit your item library that way. I'll share your request with the Item Library team and we'll keep you in the loop if there are any updates! 

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
5,504 Views
Message 60 of 75
Report

Thanks. I actually used the method that Kelly posted, and it worked. It would be better had there been options to select multiple items and delete them. 

In my case, if deleting a category would delete the items in it, that would have been good. 

5,505 Views
Message 61 of 75
Report

I have used Kelly's method many times.  I think it is faster to manipulate (or delete) 5000 items in Excel than with a checkbox to select multiple items.  There are a few things that seem to cause trouble for me:

-  Be aware that the item list is location dependant

-  I always delete the SQUARE-generated item numbers before importing (may not be necessary)

-  Any error messages give the line number that caused a problem, so it it says a line had no name, but appears to be blanks, delect the entire row in the spreadsheet and delete it.  Sometime there are stray blanks or unprintable characters, especially if you export as a CSV and then use Excel.  (Thanks, BTW for making the Excel export work!)

 

So my workflow when I have multiple updates....

1)  Export as Excel - Save a copy

2)  Select every row after the header and ONE item record (in Excel, click on the rown number for the first row to delete, then hold the Shift and Ctrl keys and hit the down arrow.  This selects all the records.  The right click on one of the row numbers and select Delete).

3)  Save the file

4)  Import the file using the replace option

5)  Confirm that just the one item remains, then delete it

6)  Starting from the copy, or just the header row, add all the items rows. making sure the data aligns with the headers (item numbers are blank)

7)  Save the file, then import it using the replace option.

 

I only have one location, but I suspect if you have more than one you need to do this for each one.

5,475 Views
Message 62 of 75
Report

I am working on purging my inventory of OOS items (item's that I will probably not be restocking any time soon). Is there a way to easily remove said 100s of items without having to download the database and attempt to reupload it? Had trouble with this at the beginning of the year with inventory. Or without having to go through each individual item in inventory manager and delete? 

 

Guess what I am asking is, does square have a fun feature of deleting the OOS items?

5,371 Views
Message 63 of 75
Report