Import Transactions and Orders into BizStackPro via CSV Files

What This Import Does

CSV imports let you bring historical Transactions and Orders into BizStackPro so your payment history is centralized and reporting is more complete. Import files separately (one CSV for transactions, one CSV for orders) and use the preview step to catch issues before committing.

• Seamless migration: Upload historical records in bulk.
• Contact linking: Records match to existing contacts when customer data aligns.
• Accurate reporting: Imported records can contribute to dashboards and totals.
• Validation + preview: Review and fix issues before final import.
• Linked records: Orders can connect to related transactions when data matches.

Step 1: Prepare Your CSV Files

Create two separate CSV files: one for transactions and one for orders. Use the platform’s sample templates if available so your headers and formats match expected fields.

• Include complete customer details for best contact matching (name, email, phone when possible).
• Confirm your dates are valid and consistently formatted.
• Double-check amount fields for currency formatting and decimals.
• Keep identifiers consistent so orders can associate with related transaction data (when applicable).

Step 2: Go to the Correct Import Area

Open the Payments section in your BizStackPro dashboard and choose the import flow based on what you’re uploading:

• Payments → Transactions (for transaction CSV imports)
• Payments → Orders (for order CSV imports)

Step 3: Upload and Validate

Upload your CSV using the import option. BizStackPro will validate formatting and required fields before moving forward.

• If validation fails, review the errors and correct the CSV.
• Common issues include missing required fields, invalid dates, or unexpected formatting.
• Re-upload the corrected file until validation passes.

Step 4: Preview and Confirm

The preview screen is your safeguard. Confirm the data looks correct before finalizing—especially customer details, amounts, dates, and item/product fields.

• Confirm the right columns mapped to the right fields.
• Check a handful of rows for accuracy (not just the first row).
• If anything looks wrong, cancel, fix the CSV, and re-upload.

Step 5: Finalize the Import

Once confirmed, finalize the import. BizStackPro will add the records, connect them to contacts when possible, and reflect the data inside your Payments history and reporting views.

• Transactions and orders appear in their respective tabs after import.
• Imported records can be edited manually if you need to correct a detail later.
• Validate your totals by filtering a date range and comparing against your source system.

Pro Tips for Cleaner Imports

• Keep formatting consistent: Don’t mix date formats within the same file.
• Standardize customer identifiers: Email is usually the most reliable match.
• Import in batches: Smaller files are easier to troubleshoot.
• Use preview like a checklist: Amounts, dates, and customer fields first.