How Can I Import Sales Transactions Via FTP
The FTP connection allows you to upload CSV files as transactions within Sales Cookie.
Here are the steps to add an FTP connection:
- Login to your workspace
- On the left pane, click on "Settings > Connections"
- Click on "FTP Server"
- Enter your server name, user, and password
Using secure FTP is recommended and supported. We recommend you provide an FTP server which meets your own security, user access, and backup requirements. If you cannot provide an FTP server, contact support.
Once you have added an FTP connection, you can drop CSV files with specific names, under specific file paths. You can then go to Transactions > All Transactions and import from FTP once, or setup a hourly recurring import job. You will be asked to provide a file path when importing transactions from FTP.
You can import data from multiple data sources from the same FTP server. For example, you could import AE opportunities and SDR calls using two separate CSV files. You should use consistent names when dropping files (ex: do not include a date in the file name).
Related Articles
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 ...
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 ...
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 ...
Which Format Do You Support When Importing Transactions?
We do not have a pre-defined, preferred format. We provide different ways to ingest sales transactions - from CSV files, from CRM and accounting systems (ex: QuickBooks, HubSpot, SalesForce, Stripe, Chargebee, Xero, Dynamics, etc.), from FTP, from ...
What Are Some Pre-Requisites For Using Sales Cookie?
There are no pre-requisites to using Sales Cookie. We do NOT require any of the following: Provisioning servers Setting up new permissions in your environment Purchasing additional software / hardware Providing a credit card at sign up You can start ...