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 the link labeled Export.
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 menu along the left side of the page, under the Tools heading, click Export Order Items.
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 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.

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.
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.
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.
Made	Shows whether the items in the order have been manufactured or assembled.
Shipped Date	The date the order was shipped to the customer.
Items Total	The total cost of the items in the order before tax, discounts, and shipping.
Tax	The tax amount applied to the order.
Discount	Any discount applied to the order.
Shipping	The shipping cost associated with the order.
Adjustment	Any manual adjustment made to the order total.
Grand Total	The final total amount for the order, including tax, discounts, and shipping.
Order Purchases Total	The total cost of any materials purchased for the order.
Order Labour Total	The total labor cost involved in fulfilling the order.
Order Material Total	The total material cost used in the order.
Order Items	The specific items included in the order.
Order Notes	Any additional notes or instructions related to the order.
Cancelled Date	The date the order was canceled.
Cancelled Reason	The reason provided for canceling the order.