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 for making large-scale changes to existing inventory. 

There are different options depending on what changes you'd like to make.

*This feature is included on the Standard plan and up.

To learn more about our plans and upgrade, click here.

On this page


Accessing Bulk Uploads

If a Bulk Upload option is available, it will be found by clicking the "Actions" button on the page. You will find the Bulk Upload option in different sections of the site including the Inventory, Invoicing (under the Customer tab), Vendors, and Purchase Orders pages.


Inventory

Create Products and Variants

  • Create new products and variants in a spreadsheet. 

  • Assign SKU and barcodes, set location-specific prices, costs, and inventory quantities.

  • NOTE: There is a limit of 10,000 rows that can be added at a time. If you have more to add, simply submit the first 10,000 and then generate another Create Products and Variants spreadsheet to input the rest.

Edit Products

  • Edit existing products in a spreadsheet. 

  • Allows editing product name, categories, description (plain-text only), and shipping information.

  • NOTE: An item must be enabled at all selected locations in order to appear on this spreadsheet.

Edit Variants

  • Edit existing variants in a spreadsheet. 

  • Allows editing variant name, SKU, and barcode, PAR and reorder quantities, location-specific price, default cost, and inventory quantities.

  • If you clear a cell's contents, that data will be deleted from the variant, with the exception of the Quantity In Stock column -- these blank/empty cells will be ignored.

    • Pro-Tip: If you are working on this spreadsheet during business hours (and actively selling), we recommend deleting the values in the Quantity In Stock column to avoid importing old information. Rest assured, if you delete the quantities in that column and leave the cells blank, we will not override the current quantities. Here's a quick video 🎥 outlining that process.

  • NOTE: An item must be enabled at all selected locations in order to appear on this spreadsheet.

Edit Variants Default Price

  • Edit existing variants default prices in a spreadsheet. This will generate a sheet for all existing variants.

  • Only the price field is editable on the spreadsheet

  • If you have Use Defaults disabled for a location, this spreadsheet will not override the location-specific price, only the price in found in the Variant and Defaults box as shown here:

    • NOTE: To update Location-specific pricing, generate an Edit Variant spreadsheet and update the price column with the location name.

Edit or Reconcile Inventory Quantities

  • Edit inventory quantities and default costs at each location for each variant. 

  • Inventory counts will be adjusted to match the spreadsheet. 

  • Fields can be left blank to skip importing costs or quantities for a variant/location. No changes will be registered for blank fields.

  • NOTE: An item must be enabled at all selected locations in order to appear on this spreadsheet.

Receive Inventory

  • Receive inventory for each variant at each location. 

  • Quantities received will be added to existing quantities. (For example, if I had 10 on the shelf and receive 5 via this Bulk Upload option, my total is 15)

  • Fields can be left blank to skip receiving any quantities.

  • NOTE: An item must be enabled at all selected locations in order to appear on this spreadsheet.


Purchase Orders

Create Purchase Orders

  • Create purchase orders for any location and one vendor.

  • If multiple locations are selected, this will create a draft purchase order for each location selected.

  • Fields can be left blank to skip adding quantities to the created purchase orders.


Vendors

Create Vendors

  • Create vendors that can fulfill Purchase Orders at your locations. 

  • A vendor will be created and associated with your selected locations.

  • This will only create the Vendor entry. 

  • Items still have to be assigned to their corresponding Vendors in the Vendors page on Thrive Inventory. Learn more


Invoicing

Bulk Create Customers

  • From the Customers tab, create customers that you can send invoices to for an easier Invoicing process.

  • This will only create new customers. To edit an existing customer, you will need to click on the customer and make your edits there.


The Bulk Upload Process

Select your option (see above) and then Thrive Inventory will automatically generate a Google Sheets® spreadsheet for you to edit. You may copy/paste from an external spreadsheet program like Microsoft Excel, Numbers, or LibreOffice.

Once you have made your changes, you can submit the spreadsheet to upload it into Thrive Inventory.

(The submit link is found at the top of column D in the spreadsheet,
don't forget that 2nd click!)


Things to note:

  • Images cannot be added via Bulk Upload. Google's spreadsheet API only allows for text-based information.

  • No Google account is required.

  • Uploads cannot be undone! Make sure you read descriptions closely before proceeding as there is no option to undo.

  • If you're having issues with leading Zeros disappearing or SKU/Barcode numbers being converted to scientific notation, check out this article: Spreadsheet Bulk Upload Issues

  • The Bulk Edit Inventory Quantities option will overwrite whatever is there. It's not recommended if sales are actively going through during the upload.

  • If you are using any of the EDIT options at multiple locations, then only items enabled at every selected location will appear on the spreadsheet for editing.

  • To create multiple Categories, separate each Category using a comma (e.g.: "Category 1, Category 2, etc.)

  • All errors displayed on import must be corrected before Thrive Inventory can import the spreadsheet.


Still have questions? We are here to help!

Start a chat with us by clicking the chat bubble at the bottom-right of this page.

Did this answer your question?