While we do have a dedicated Analytics page exporting your Printavo data makes it easier to analyze sales, track production trends, review customer activity, and build custom reports outside of the platform. This article walks through the different export options available in Printavo and explains how to use your data in spreadsheets or reporting tools to better understand and grow your business.
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.
- Customers
- Quotes/Invoices
- Payments/Expenses
- Products
- Transactions/Deposits
- Click here for export samples
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 "Transactions/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
Comments
Please sign in to leave a comment.