@CoastalHobbies, I have moved your post and the response to a new topic. You may have experienced this problem while trying to suppress item names on sales invoices or sales orders, but the issue is different from the topic where you posted. This is a Batch Update problem of items possibly disappearing, not difficulty adjusting displayed content.
This suggests a problem with the UUIDs (the Key column). You may have juggled keys while manipulating the spreadsheet to make your updates. Or you might have somehow introduced errors in the keys. (If a key in the updated spreadsheet does not match one already in the database, that line of the spreadsheet will be ignored.)
Batch updates have nothing to do with Form Defaults. Form Defaults are used to preformat transactions.
Why do you mention “new ones?” New items cannot be entered during a Batch Update. You can only update existing ones, because the program must first have assigned a key. If you are adding new items while also updating old ones, you will need to use Batch Create for the new items. The keys will be assigned when the batch is created.
I meant that when selecting the form default, there should be a way of making it work for all items in the system already as well as new ones, added into Manager at a later date, when raising an invoice.
I was hoping there was a way to change the default setting on all existing items other than doing a batch update. I have had issues in the past where the spreadsheet has changed SKUs etc to items such as a date due to what the SKU was and have avoided doing batch updates since.
The only change I made was changing the FALSE to be TRUE, then copied and pasted back into manager.
Maybe Excel has made a change to something. It’s not an entire column, only 5 items are missing when I compare the number of items. I don’t know which ones and to go through and compare each line would most likely take me as long as manually changing each item one by one in Manager.