How Can I Import Transactions?

How Can I Import Transactions?


For programmatic import options, click here.

You can use the following methods to add transactions:
  • Manually or automatically from CSV files
    • Manually upload CSV files containing sales transactions
    • Automatically by having us fetch CSV files from FTP sites
  • Manually or automatically from systems such as QuickBooks, HubSpot, SalesForce, Stripe, Chargebee, Xero, Dynamics, etc.
    • Choose entities and we will ingest the data
    • Choose whether to import transactions once, or make the import automatic (recurrent)
  • Manually or automatically from any Sales or Accounting System via a Web Endpoint
    • A Web Endpoint is a secure web page you implement, allowing us to fetch sales transactions from any sales / accounting system
    • Choose whether to import transactions once, or make the import automatic (recurrent)

Here are the steps to add transactions:
  • Login to your workspace
  • On the left pane, click on "Transactions > Add Transactions"
  • Select the type of import you want (ex: CSV, SalesForce, etc.)
  • Provide requested data
    • CSV file - upload your CSV file
    • SalesForce - enter a CRM query / view name 
    • Dynamics CRM - enter a CRM query / view name
    • HubSpot - select a record type
    • QuickBooks - select a record type
    • Stripe - select a record type
    • Web Endpoints - no additional data required
    • FTP website - enter a file path
  • Decide if you want to make the import a one-time action, or automated (recurring)
    • Learn more about automated imports here
  • Wait for the analysis to complete
    • Wait for sample data retrieval and analysis to complete
    • This operation typically takes from 10 seconds to 3 minutes
  • Carefully review proposed data mappings
    • Update mappings as needed (a guess is provided)
    • Your mappings will be remembered for your next import
  • Finalize the operation
    • Transactions will be added to your workspace
    • This is done as a background job

To learn more about the meaning of "transaction", click here.
To learn more about why importing transactions is needed, click here.
To learn more about connections, click here.

Import Duration
Importing transactions is quite fast, but not instant as the data must be analyzed and indexed. Transaction import essentially runs as a background job.

    • Related Articles

    • Why Do I Need To Import Transactions?

      In order to efficiently determine sales performance and calculate incentive rewards, Sales Cookie requires sales transactions to be imported. For each incentive plan you design, you can specify a saved query, which will filter imported transactions ...

    • How Can I Use the Simplified Transaction Import Rest API?

      This article is about the simplified transaction import REST API. Click here for more options. Importing Sales Transactions To import transaction data, follow these 2 steps: Step 1 - Get your API key Step 2 - Import transactions by making a POST call ...

    • How Can I Use the Full Transaction Import Rest API?

      This article is about the full transaction import REST API. Click here for more options. Importing Sales Transactions To import transaction data, follow these 3 steps: Step 1 - Get your API key Step 2 - Prepare for import by mapping your fields to ...

    • How Can I Automate My Transactions Imports?

      Applicability This article applies to the following situation: You have been performing manual transaction imports using CSV files You have a source sales or accounting system with sales transactions You want to automate transaction import into Sales ...

    • How Can I Programmatically Import Sales Transactions?

      For non-programmatic import options, click here. Three options are available: You can use a Web Endpoint. Using this model, you deploy a web page, from which we securely pull transaction data. We will query your web page at least every hour. You can ...