I figured out a way around this problem, but Square needs to make it possible to combine Full Counts. They limit a Full Count to only 1000 items. So, I had to do 4 Full Counts to count our whole inventory. And, you guessed it, everything that was not counted during a particular count was set to zero. Here's the workaround: Export Items before doing any Full Counts. Rename that file something like "Items Export Before 1st Full Count". Then do the 1st Full Count and submit. Do an Items Export and rename it to something like "Items Export after 1st Full Count". Do that for each Full Count.
When everything has been counted, Open one of the "Items Export After Full Count" and Save As "Items Export After All Combined Full Counts". Create a Column in that spreadsheet for each of the Full Counts. Go to the "Items Export After 1st Full Count" and copy the Quantity Column. Then paste it into the Combined Full Count spreadsheet under the Column you created for that Full Count. Do this for each Full Count. Then create another Column to Total all of the Full Counts. Once you have the total of all of the Full Counts, copy that Column and paste it into the New Quantity Column in the spreadsheet "Items Export Before 1st Full Count". Save As "Item Import after Combined Full Counts". Then import that file into Square.
Make sure that you don't change any items while doing a Full Count. Do not change anything other than the count. Otherwise (like I learned the hard way) the rows from each Items Export won't match up and the copy and paste won't work.
***Would be a lot simpler if Square would not limit the number of items in a Full Count!!!"
