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 included in the order export

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 address.
Customer Postcode The postal or ZIP code for the customer address.
Customer Country The country of the customer 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 (Yes/No).
Made Indicates whether the order has been manufactured (Yes/No).
Shipped Date The date the order was shipped to the customer.
Items Total The total cost of items before tax, discounts, and shipping.
Tax The tax amount on the order.
Discount Any discount applied to the order.
Shipping The shipping amount charged on the order.
Adjustment Any manual adjustment amount on the order.
Grand Total The total order amount including all charges.
Order Purchases Total The total cost of purchases associated with the order.
Order Labour Total The total labour cost across all line items in the order.
Order Material Total The total material cost across all line items in the order.
Order Items A summary list of the products and quantities in the order.
Order Notes Any notes recorded against the order.
Cancelled Date The date the order was cancelled, if applicable.
Cancelled Reason The reason the order was cancelled, if applicable.
Created At The date and time the order was created in Craftybase. Displayed in your account time zone.
Updated At The date and time the order was last updated in Craftybase. Displayed in your account time zone.

Fields included in the order line items export

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.
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 (Yes/No).
Cancelled Indicates whether the line item 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.
Variation Name The specific variation, such as size or colour, 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 before tax, discounts, and shipping.
Item Shipping (Proportional) The proportionate shipping cost associated with this line item.
Item Discount (Proportional) The proportionate discount amount associated with this line item.
Item Tax (Proportional) The proportionate tax associated with this line item.
Item Total Price The final total amount for the line item including all charges.
Material Cost The calculated cost of materials for this line item. 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 address.
Customer Postcode The postal or ZIP code for the customer address.
Customer Country The country of the customer address.
Created At The date and time the order line item was created in Craftybase. Displayed in your account time zone.
Updated At The date and time the order line item was last updated in Craftybase. Displayed in your account time zone.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.