Printavo's data export allows you to analyze your data on your terms
Printavo does have some built-in analytics, but, occasionally, shops prefer to use an external system like Microsoft Excel, Google Sheets, or Numbers (by Apple) to run their numbers. With a single click, you can generate a .CSV spreadsheet from a date range of your choice that gets sent directly to your inbox.
Where to do this: My Account > Import/Export Data
Click the below links to see what column headers are included in each export. We've also attached sample exports to the bottom of this page.
What's included in the "Customers" export?
- Customer ID
- First Name
- Last Name
- Company
- Phone
- Fax
- Full Billing Address
- Billing Address - Address 1
- Billing Address - Address 2
- Billing Address - City
- Billing Address - State
- Billing Address - Zip
- Billing Address - Country
- Full Shipping Address
- Shipping Address - Address 1
- Shipping Address - Address 2
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Zip
- Shipping Address - Country
- Tax Exempt?
- Tax Resale No.
- Created
- Owner Email
- Owner Name
- Default Payment Term
- Default Payment Term Days
Return to the top of the article
What's included in the "Quotes/Invoices" export?
- Invoice #
- Nickname
- Created Date
- Custom Created At
- Production Due Date
- Customer Due Date
- Invoice Date
- Payment Term
- Payment Term Days
- Payment Due Date
- Customer Full Name
- Customer Email
- Customer Company
- Customer Id
- Customer Notes
- Production Notes
- Total Quantity
- Sales Tax
- Total Untaxed
- Amount Paid
- Amount Outstanding
- Item total (Order total without fees)
- Fees (Displaying as each individual fee name)
- Total
- Total Expenses
- Paid?
- Invoice Status
- Delivery Method
- PO #
- Tags
- Owner
- Public Invoice View URL
- Invoice URL
- Billing Address 1
- Billing Address 2
- Billing City
- Billing State
- Billing Zip
- Billing Country
- Shipping Address 1
- Shipping Address 2
- Shipping City
- Shipping State
- Shipping Zip
- Shipping Country
- Exported to QuickBooks (shown as True/False)
- Last time exported to QuickBooks
Return to the top of the article
What's included in the "Payments/Expenses" export?
- ID
- Created Date
- Transaction Date
- Payment Processor
- Payment Transaction ID
- Name
- Category
- Amount
- Invoice #
- Invoice URL
- Invoice Owner
- Invoice Created Date
- Invoice Payment Due Date
- Invoice Customer Due Date
- Invoice Production Due Date
- Customer First Name
- Customer Last Name
- Customer Company Name
- Customer ID
- Sales Tax Percentage
- Sales Tax
Return to the top of the article
What's included in the "Products" export?
Note: The Products export will provide a list of your custom products.
- Style Number
- Brand
- Style Description
- Color
- Size
- Price Per
- Dozens Price
- Case Price
- Created
Return to the top of the article
What's included in the "Deposits" export?
Note: The Deposits export will provide a list of your deposits and their associated transactions.
- Order ID
- Type
- Deposit ID
- Customer / Store
- Transaction ID
- Cardholder Name
- Cardholder Address 1
- Cardholder City
- Cardholder State
- Cardholder Zip
- Net Amount
- Currency Code
- Created Date
- Gross Amount
- Total Fees
Return to the top of the article
NEXT: 6.8 Cash-Basis & Accrual Accounting Tax Data
PREVIOUS: 6.6 Expense Tracking
Comments
Please sign in to leave a comment.