Topic: Changing conditions in groups

Does anyone know how I could update the conditions of all my cards in a certain group at one time? Like all my Onslaught cards, or anything older than 8th edition. It'd be nice if I could change all of whatever I've filtered for

Last edited by mynameisballs (2016-12-17 07:38:55)

Re: Changing conditions in groups

You can't do this via the Deckbox interface, except when you're first adding the cards (you can Add From List with the Default Values set for condition).

The easiest way to do it with an existing inventory is by editing the CSV file and replacing your inventory with it. That's the short version, for the more tech-savvy.


For anyone who might want more steps, do the following:

  1. Export your inventory to a CSV file (under Inventory > Tools > Export).

  2. Copy the exported file (just in case something goes wrong, then you can restore your inventory from the original export).

  3. Open the copied CSV file in Excel.

  4. Turn on Filter from the Data tab in the ribbon (or right click on a column heading to filter).

  5. Filter/sort as needed to group the desired subset of cards together.

  6. Mass-apply the new condition:

    1. Select all of the Condition column cells for the cards you want to change

    2. Press the F2 key

    3. Delete the current condition

    4. Type in the new condition

    5. Press the keys Ctrl+Enter -- this should fill the entire selection

  7. Save. Excel will ask if you're sure you want to save in that format -- click Yes.

  8. Close Excel. Excel will ask if you want to save first -- click Don't Save. The file successfully saved in the previous step. Trust me. smile

  9. Delete your current inventory on Deckbox (under Tools > Delete).

  10. Upload your edited inventory via the Add From CSV File option.


Note 1: Ensure you type the correct condition, watching for spelling. An unrecognized condition is the easiest way to receive an error. For instance, you have to type "Good (Lightly Played)", not just "Good" or "Lightly Played".

Note 2: If you encounter some other error when adding from the edited CSV file, don't fret. Step 1 -- add your inventory back from the unedited CSV file (the originally exported file). Step 2 -- ask the community for assistance!

Note 3: Mobile users -- I've had issues trying to edit CSV files in the various mobile versions of Excel. Deckbox doesn't like the resulting file. I think the apps introduce some non-CSV file data to the file that throws Deckbox's importer off. I'd stick with Excel if possible.

Note 4: There are dedicated CSV editors, and some people would tell you to avoid using Excel. However, I have never encountered an issue with Excel, as long as I only use CSV files originally exported from Deckbox (as opposed to creating my own CSV file), and as long as I save the file as described above. Don't "Save As" to a new CSV file.

Re: Changing conditions in groups

Very in depth man thank you. I will try this as soon as i can

Re: Changing conditions in groups

Well, I learned the hard way.... by experimentation. Haha. That's the sort of in-depth post that I'm always happy to come across. So I'm glad to return the favor when I can. smile