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:

  1. Go to your Orders list page.

  2. In the table pagination area, click on the Export icon

  3. Wait for the file to download, then open the file in your spreadsheet program to edit.

Exporting your Order Line Items:

  1. Go to your Orders list page.

  2. In the Orders menu, select Order Line items

  3. In the table pagination area, click on the Export icon
  4. 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.
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.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.