Best way to backup and restore stock counts

rtam — Sat, 20 Sep 2025 11:24:37 GMT

I need advice on the most effective way to save, and if necessary, restore my stock counts using the Excel file export/import function. The reason I need this clarity is due to an issue I've run into with my BigCommerce sync somehow resetting many of my stocks to '0'. If this happens, I need a way to simply restore from a backup.

Thanks in advance for your suggestions.

Re: Best way to backup and restore stock counts

JJ_ — Mon, 11 Oct 2021 15:10:28 GMT

Hello @rtam 👋

Sorry to hear you have issues with the BigCommerce integration. I believe you may be able to use our Import and Export tool in the Item Library to constantly have a report or file that you use in case of this issue happening again.

To download an inventory report or make updates to your inventory in bulk:

Visit Items in your online Square Dashboard.
Click Actions > Export Library.
In this report, you are able to make updates or changes to your Inventory and then save the file. Note: At this time, Excel (.xlsx) and CSV (.csv) file templates are the only supported file types for bulk import. Custom templates aren’t supported.
Drag and drop your saved file to the Import Inventory window and click Upload > Confirm > Done.

To print this information for your records, Visit Item Library > click Actions > Export Library and follow the on-screen prompts.

Note: To bulk edit or create your item library, click Actions > Import Library.

I hope this information is helpful!

thread Best way to backup and restore stock counts in Orders, Menu Items, Catalog & Fulfilment

Best way to backup and restore stock counts

Re: Best way to backup and restore stock counts