Exporting Components
How to take your Components 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 components.
Export Components
To download a list of your components:
Go to your Components list page.
In the table pagination area, click on the Export icon
- Save the .csv file to your computer or open the file with your preferred spreadsheet app.
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.
Available Data
In 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 component. |
SKU | The SKU of the component. |
Category | The category of the component. |
Description | A quick Description of the component. |
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. |