Exporting orders
How to take your orders out of Craftybase
Craftybase provides the ability to download your orders and order line items for further analysis via a spreadsheet.
In this article, we'll cover:
- Exporting your orders.
- Exporting your order line items
- Downloading the CSV file
- What fields are included in the order export
Exporting your Orders:
Go to your Orders list page.
In the table pagination area, click on the Export icon
- Wait for the file to download, then open the file in your spreadsheet program to edit.
Exporting your Order Line Items:
Go to your Orders list page.
In the Orders menu, select Order Line items
- In the table pagination area, click on the Export icon
- Wait for the file to download, then open the file in your spreadsheet program to edit.
If you would like to export specific data only, you can use the Filter Menu options on the left side of the page. Once you have made your selections, select Filter, and only the data from the selected categories will be displayed. From there, you can export it as explained above.
Downloading the CSV file
After clicking the Export Icon, 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.
Fields
| ID | Unique identifier for each order in the system. |
| Order Code: | A specific code assigned to the order for easy tracking. |
| Order Date | The date the order was placed. |
| Order Due Date: | The expected completion or delivery date for the order. |
| Receipt ID | The unique identifier for the receipt associated with the order. |
| Category | The category or type of order. |
| Source | The origin or platform where the order was placed (e.g., Etsy, Shopify). |
| Paid | Indicates whether the order has been paid for (Yes/No). |
| Cancelled | Indicates whether an order has been cancelled (Yes/No). |
| Manufactured | Indicates whether a manufacture is associated with the order line item (Yes/ No). |
| Shipped Date | The date the order was shipped to the customer. |
| SKU | The Stock Keeping Unit (SKU) associated with the order line item |
| Product Name | The name of the product being manufactured. |
| Variation Name | The specific variation of the order line item, such as size or color, if applicable. |
| Quantity | The number of units of the order line item sold to the customer. |
| Quantity Type | Specifies the unit of measurement used for the order line item, such as grams, ounces, or units. |
| Item Price | The total cost of the item in the order before tax, discounts, and shipping. |
| Item Shipping (Proportional) | The proportionate shipping cost associated with each order line item. |
| Item Discount (Proportional) | The proportionate discounted amount associated with each order line item. |
| Item Tax (Proportional) | The proportionate tax associated with each order line item. |
| Item Total Price | The final total amount for the order, including tax, discounts, and shipping. |
| Material Cost | The calculated cost of materials for each product in the order. This is costed when the order is marked as shipped. |
| Notes | Any additional notes or instructions related to the order. |
| Customer Name: | The name of the customer placing the order. |
| Customer Address Line 1 | The primary street address of the customer. |
| Customer Address Line 2: | Additional address information, such as an apartment or suite number. |
| Customer City | The city where the customer resides. |
| Customer State | The state or province of the customer's address. |
| Customer Postcode | The postal or ZIP code for the customer's address. |
| Customer Country | The country of the customer's address. |