Step 1
Head to Import/Export under Global Settings. Here, the six tabs show data areas that you can import and export in bulk.
Go to the materials tab to do a bulk import of material items.
Step 2
Download the empty template by clicking Template CSV File. Open this file on your device to edit it.
Step 3
The headers along the top row relate to material item fields in TidyStock. See the module Set up your material items to learn more about these fields.
Some of these are mandatory fields, (indicated by "reqd" after the header title). An error will appear in TidyStock if you do not fill these mandatory fields.
Step 4
Your Codes can comprise of numbers, uppercase letters, hyphens, and/or dashes, up to 25 characters long.
Step 5
Enter the name of your stock item under the Material Name column.
This is a required field.
Step 6
Under Material Category, enter the category that this item falls under. It must be a category that you have already set up in Tidy.
This is a required field.
Step 7
You can put in a Suggested Supplier. This must be a supplier that you have already set up in TidyStock beforehand.
Step 8
Next, enter the Usage Unit and Pricing Unit of the item. The unit options are: ITEM, m, cm, mm, m2, cm2, mm2, m3, cm3, mm3.
These are required fields.
Step 9
Add the Cost Currency and Charge Currency. The cost currency is the currency that you buy from suppliers in and the charge currency is what you sell to customers in.
Use the ISO code of a currency that you have already set up in Tidy beforehand.
These are required fields.
Step 10
Enter your Unit Cost and Charge Price.
The Unit Cost is the price you pay suppliers, while the Charge price is what you charge to your customers.
These are required fields.
Step 11
Under Managed, you can choose whether to make this a managed or unmanaged material item.
Type Y to make it a managed item, or N to make it unmanaged. This is a required field.
Step 12
You can also add the current Stock Level.
Step 13
You can put in a Location. This must be a location that you have already set up in TidyStock beforehand. This is a required field.
Step 14
Add the Catalogue Price Currency. This is the currency that will be used if Catalogue Pricing is enabled. This is optional.
Step 15
Once you have filled out the required fields and any optional fields for all items, save your spreadsheet document. Then go back to TidyStock.
Step 16
Select Choose file to upload the spreadsheet we’ve just created, then click Import Materials.
Step 17
If we go to our list of materials now, the five new items we’ve imported have appeared.
Want to learn more? Check out these related guides.
If your business trades internationally, it's helpful to set different tax rates to fulfil regional requirements. In this module, learn how to add sales tax rates, to your TidyStock account. Please note that the multiple tax rates option is only available under certain plans.
Users are the people in your organisation who will be using TidyStock. In this module, learn how to set up their logins and permissions. Also learn how to act on behalf of other users.
When setting up your users, you must select which roles and permissions they have. In this module, learn about different users roles and what areas they can view or edit in TidyStock.
In TidyStock, stock items are referred to as Material Items. Sometimes, they're simply called "materials" or "items". In this module, learn how to set up and add material items to your TidyStock account. You'll use them to make sales, purchases, create assemblies, and more.
In this module, learn how to add suppliers to your TidyStock account. These are the people or organisation's that you purchase stock from.
In this module, learn how to add new material locations. Locations are where your material items or stock is stored. These might be distribution centres, warehouses, retail stores, or something else.
Company settings are general settings that will affect what you see in your TidyStock account. In this module, learn how to set up your organisation settings, understand the sales and purchases settings, and learn about automatic numbering.
When initially signing up for TidyStock, you selected a base currency. This is the currency that you transact and do business in. If you trade internationally, it is useful to set up additional currencies. Please note that multiple currencies are only available under certain plans.
In this module, learn how to add customers to your TidyStock account. These are the individuals or companies who purchase stock from you.
When creating a customer or supplier, you can add countries to their information profile. In this module, learn how to set up your countries available for selection.
Tidy's integration with Xero accounting means that when you make sales, purchases, and adjustments to your stock in Tidy, your Xero financial records are automatically updated. In this module, learn how to set up the connection to Xero from your Tidy account.
Learn how to create custom templates for sales quotes, packing slips, project proposals, project quotes, and purchase orders. Use our template codes to add fields to your document template.
Previously, we learnt how to add suppliers to your account manually. However, this can be very time consuming if you have a lot of data to enter. In this module, learn how to import suppliers to your TidyStock account in bulk.
Previously, we learnt how to add customers to your TidyStock account, manually. However, this can be very time consuming if you have a lot of data to enter. In this module, learn how to import customers to your TidyStock account in bulk.
The Stock Level Warnings Screen displays current stock levels, sales and purchases on order, and calculates recommended reorder levels for you. Purchase orders can be quickly created from here, which simplifies reordering and prevents stock shortages.
Material categories are used to group and help identify material items. In this module, learn how to set them up and use them to track materials. Also learn how material categories are linked to the chart of accounts in your Xero accounting system.
Batches are groups of items created from the same production run. The batch function in Tidy enables you to assign batch numbers against material items, assign batch numbers when receiving items, and sell items with a batch number.
When you create a purchase order for a managed item, the price you pay to suppliers may differ from the current unit cost. This allows you to use the current supplier price at the time of purchase. You can also use catalogue pricing to edit the currency when you buy items in foreign currencies.
If you store stock in more than one location, you may need to move material items between them for sales. In this module, learn how to transfer materials between locations.
Learn how to use the stock adjustment tool. This can be used to complete stock adjustments in bulk if you have done a stock take and need to update a list of stock levels for material items.
Barcodes are used in TidyStock to quickly search for and identify material items. In this module, learn how to add items by scanning the barcode, search for items using their barcode, and add items to sales using barcodes.
In this module, learn how to disable, archive, and delete material items. If you are no longer selling or keeping stock of certain items, you can choose to archive or disable them. If there is no sales or purchase history against a specific item, you can also delete it.
Stock on hand reports show you the stock levels of your material items. They show a breakdown and total cost value of current stock on hand.
An assembly is a top-level finished product compromised of individual material item components. They can also be referred to as a "bill of materials". In this module, learn how to set up an assembly, how to use them, and what wastage in an assembly is.
In this module, learn how to complete a stock adjustment. Stock adjustments are done to manually modify the stock level or value of managed items.
Service expenses are third-party landing costs which are allocated to purchase orders and distributed across the items within those purchase orders. These costs are added to the items' unit cost. They also affect the value of stock on hand in Xero.
In this module, learn how to add quantity breaks to materials. This is a type of custom pricing where discounts are given to customers based on the quantity of an item purchased. This is particularly useful when customers make bulk purchases.
In this module, learn how to send an invoice without dispatching stock. You will be able to send an invoice and take payment from the customer first, then order the goods in and dispatch the stock to the customer later.
In this module, learn how to credit a sale when customers return items they have purchased from you, or ask for a refund
Backorders are created when you want to enter a sale, but not invoice the customer at this stage. You can also create backorders to just get the sale into the system for further details to be added later.
Sale orders are created when you want to sell stock to a customer. In this module, learn how to create a new sales order and what different sales order statuses mean.
In this module, learn how to set up pricing levels. These are used when you want to sell items at different prices to the unit charge you set up in the material items' details
Previously, we created and sent a purchase order to a supplier. In this module, learn how to receive the items on the purchase order when stock has arrived. Once the items have been received, a bill payable is created in your connected Xero account.
You can credit/refund Purchase Orders that have been receipted. This takes the goods out of stock and returns them to the supplier. A Supplier Credit Note is also created in Xero to that Supplier.
Purchase orders are created when you want to purchase stock from a supplier. In this module, learn how to create a new purchase order and what different purchase order statuses mean.
If you want to purchase components to create an assembly, the "Purchase Order from Assembly" feature in Tidy makes it easy to ensure you order all of the material items required. In this module, learn how to create and receive purchase orders from an assembly.