how to make an invoice and inventory in google sheets

Mark Items as Sold OutĮven if you don't track inventory, you can mark an item or item variation as sold out, in the case that it's unavailable for sale. Note: You can also update your inventory alert settings at any time from Email Notifications in your online dashboard. Keep in mind, if you have multiple locations, inventory is established, edited, and tracked on a per-location basis.

You can also go straight to step 3 by pressing and holding an item from your in-app items grid. To adjust stock, tap the stock amount > select a reason > enter amount to be adjusted. Tap More from the navigation bar at the bottom of your screen and select Items > All Items.Įnter a stock amount under the item details or tap Prices, Sizes, or SKUs to add stock to an item with multiple variations. Selecting Inventory Re-Count will show your current stock amount - just enter in your new stock amount to update.Įnable Alerts - if your stock drops below the alert threshold, a stock alert will be generated. If you select Stock Received or Restock Return, your stock count will increase for the amount entered. If you select Damage, Theft, Loss, the amount entered will automatically deduct from your current stock count for that location. Under Stock Action, enter the reason for adjusting your stock. To edit inventory by item variation, you can click on the variation row. Visit Item Library in your online Square Dashboard.

With inventory enabled, you can receive alerts in your Dashboard for low-stock or sold out items, so you’ll know when to reorder and restock. For instance, you are able to add or remove stock and assign reasons such as Stock Received, Inventory Re-Count, Damage, Theft, Loss, and Return. Stock actions allow you to adjust stock levels and apply reasons. Manage Inventory on Item Editor Stock Actions Need more robust inventory management features? Explore Square for Retail. Seller Community: Ask questions, get answers, and hear how other Square sellers are using inventory management. It just read and write cells ranges or named cellsįinally it generates a PDF link but i didnt manage to remove the cells borders spreadsheet 'facture' : the invoice model spreadsheet 'inputs' : list all your customers/sells by row send an email with a PDF invoice generated from a google spreadsheet

How to make an invoice and inventory in google sheets