Exporting materials
How to take your materials outside of Craftybase.
Supported file formats
Export file formats include:
- CSV (openable in Excel, Numbers, and Google Sheets)
Note: Images and attachments are not included when exporting materials.
Export materials
To download a list of your materials:
Go to your Materials list page.
In the table pagination area, click the link called Export.
Your export file will be generated. It will be available for download in your Notifications area when it is ready.
If you would like to export specific data only, you can use the Filter Menu options on the left side of the page. Once your selections are made, select Filter, and only the data from the selected categories will be displayed. From there, you can export it as explained above.
After clicking Export, you can click the bell icon on the upper right-hand side of the screen. This will access your notifications tab and provide a link to download the CSV file.
Available Data
On the exported file, you will find a comprehensive set of valuable information. This information will provide a detailed insight into the specs of your materials.
ID | The ID of the material. |
SKU | The SKU of the material. |
Category | The Category of the Material. |
Description | A quick Description of the material. |
BIN Location | Material physical location is segmented by zone, section, and position. |
Inventoriable | Yes or No. Inventoriable materials hold a quantity and value that increases and decreases based on stock changes. |
Stock On Hand | The calculated quantity of stock on hand for this material. |
Stock On Order | The calculated quantity of stock committed for this material. |
Total Purchased | The calculated quantity of material purchased. |
Tracking Unit | Unit of measurement used to measure this material. |
Purchase Unit | Unit of measurement used when purchasing this material. |
Purchase to Tracking Conversion | Convert your purchase unit to your tracking unit when increasing material stock |
Stock Status | Indicates if your materials are in stock or low-stock status. |
State | The material is active or archived |
Unit Cost | Your Unit Cost is the cost of purchasing a single unit of your material. |
Low Stock Limit | Amount that indicates you're running out of material stock. |
Currency | The actual currency in which you process your purchases |
Stating Quantity | The stock units on hand as of your account start date. |
Starting Unit Cost | The unit cost of all stock on hand as of your account start date. |
Preferred Vendor | Vendor where you frequently purchase the material. |
Last Stocktake Date | Date when the material was included in a stocktake. |
Want to learn more?
- For more information on how to import your materials back please visit the following article - Importing Materials.
- If you have any questions about your materials, feel free to take a look at the Materials Section.
- Are you encountering any issues with a Material? Feel free to reach out to us via email at help@craftybase.com or click here.