Bulk uploads are used for mass inventory updates, changes, or additions via a Google Sheets spreadsheet. It is helpful for initially setting up a large inventory or making large-scale changes to existing inventory.

The option to generate a bulk upload is found under the "Actions" button on the Inventory, Invoicing (under the Customer tab), Vendors, or Purchase Orders pages.

Check out our articles on bulk upload spreadsheets and troubleshooting for more information.

Protected columns are in grey to indicate that you cannot edit the field directly. Make any edits in the corresponding "New" column as shown here:

Any information added to the "New" column will replace the existing data. You will not see the "New" column when bulk-creating products, vendors, customers, etc, but those changes are coming soon. If a column is left blank, nothing will happen to that product, and will not be updated.

With so much information in the spreadsheet, it can take time to pinpoint the information you want to edit. Sorting will help that!

Here's a quick video🎥 from our Customer Care Team on the different ways to sort.

To Paste from another spreadsheet, use Ctrl+Shift+V (or Cmd+Shift+V on Mac) to avoid removing data validation columns and potentially causing errors. Pasting this way will remove the possibility of bringing over any unnecessary formatting from another spreadsheet.

On bulk uploads where you are making edits, there are new instructions on how to delete information. To clear, delete, or remove information, enter %REMOVE% into the corresponding "New" column to remove its contents upon upload. This is also noted at the top of spreadsheets when applicable.

Depending on which columns (or rows) you are working on, it can be helpful to have the column/row heading available to you, no matter how far down on the spreadsheet your product is.

To keep scrolling down to a minimum, you can freeze columns and rows on your Google Sheets by selecting the column or row you want to freeze and clicking View > Freeze on the toolbar (as shown above).

Here are more specifics from Google directly.

Keyboard shortcuts like Control+F (or Command+F) allow you to quickly search for a word or phrase in the spreadsheet. That means, if you're only looking to make edits to the products with "Muffin" in the product title, you can quickly and easily pinpoint them, make your edits, and import them!

Once you have made changes to your spreadsheet, you can submit the spreadsheet to upload it into Thrive by clicking the link as shown below:

Once the spreadsheet is submitted, click the "Import this spreadsheet" button, and we will comb through the spreadsheet for any errors.

Any errors will be isolated in the following pages so you can make corrections. If you'd like to read more about errors, you can check out this article on troubleshooting.

On the Bulk Uploads page, you can recall active spreadsheets (under 120 days old) that can still be submitted.

Recall the spreadsheet and make additional edits or additions by clicking the pencil icon shown below:

A spreadsheet becomes "Completed" when it's been successfully imported. Once it's "Completed," it will not be editable and cannot be undone.