*This feature is included on the Standard plan and up.
To learn more about our plans and upgrade, click here.
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.
There are different options depending on what changes you'd like to make. In addition, check out our articles on tips and best practices for bulk uploads, and troubleshooting.
Use the links to jump to the section you want to learn about, or continue scrolling:
Inventory
Create Products and Variants
Add new products and variants to your inventory. Choose to include: categories, descriptions, SKUs, barcodes, vendors, vendor IDs, and quantities. Price, default cost, PAR Level, and Reorder Quantity can be set for the entire product or made location-specific.
Descriptions are product-level, but on the spreadsheet, you'll have the option to enter a description for each variant. Only the first description will be accepted and applied to the product (and the corresponding variants).
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
Change existing product names, categories, descriptions (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
Alter existing variant names, SKUs, barcodes, vendors, vendor IDs, and quantities. Price, default cost, PAR level, and Reorder Quantity can be set for the entire product or made location-specific.
If you're using Location-specific fields for your product and want to go back to Using Defaults (read more) this can be accomplished using this bulk upload sheet.
Input values within the location-specific columns match the Use Default numbers (Price, Cost, PAR, Reorder) exactly.
Submit the spreadsheet.
If done correctly, when you submit the spreadsheet, the "Use Defaults" setting/toggle will be ON and the location-specific info will be gone for those items.
Variant Names of attributes (created using the "Generate Variants" button or otherwise) cannot be edited on this spreadsheet and will be greyed out. To make edits to those variant names, you will need to edit them directly on the specific product page.
NOTE: An item must be enabled at all selected locations in order to appear on this spreadsheet.
Edit Variants Default Price
Adjust or add default prices for your products and 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
Update quantities and location-specific default costs.
NOTE: An item must be enabled at all selected locations in order to appear on this spreadsheet.
Receive Inventory
Enter newly received quantities and have them automatically added to existing totals. Any cost entered will be the lot cost for the products received.
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. Only items that are 1) assigned to the vendor and 2) enabled for the selected location(s) will show up when the bulk spreadsheet generates.
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.
Once your vendor is created, assign products to it as shown here.
Edit Vendors
Edit existing Vendor information, including Vendor Name, Address, Tags, Website, Phone Number, Contact Name, Contact Email, Contact Fax, Order Email, Order Fax, Average Fulfillment Days, and Average Shipping Days with this spreadsheet.
The Vendor must be enabled at all selected locations in order to appear on this spreadsheet.
Invoicing
Bulk Create Customers
From the Customers tab, create customers in bulk to invoice for an easier overall process.
This bulk spreadsheet is exclusively for creating new customers. To edit an existing customer, you must click on the customer and make your edits there.
Related Articles
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.