Why Are Transaction Dates Important When Importing Transaction Data?

Let's say you upload a CSV file with records like this:

As you can see, there is no date column. So, if you wanted to calculate January commissions, we would not know if those sales would apply since there is no effective date column we can use.

In this case, you can either:

• Add a date column and re-import               OR
• Specify an effective date which will be applied to all imported sales  

If you do not have a data within your data, Sales Cookie will offer you to provide an effective date which will then be applied to all imported transactions.

• Related Articles

• Why Are Unique IDs Important When Importing Transaction Data?

  If you use a CRM or Accounting system, each record already has a unique ID. This article only applies to customers whose data source does NOT already provide a unique ID. Let's say you upload a CSV file with records like this: When you upload this ...

• Understanding Dates and Time Zones

  Storing Vs. Displaying Dates All dates are stored in UTC format with millisecond accuracy. However, dates are automatically converted to your time zone when displayed to you. For example, a stored UTC date of 2022-01-01T00:00:00 may be displayed as ...

• How Can I Credit Multiple Users For One Transaction?

  You may want to issue commissions to multiple users over the same sales transaction. This may be necessary when multiple users contribute to a sale, or because you have a multi-level commission structure (ex: override commissions). There are two ways ...

• I Have Accidentally Deleted Data - Can It Be Recovered?

  We provide a warning confirmation for all deletion actions to make sure it was intended. It is important that all confirmation messages be reviewed very carefully to avoid problems. If you deleted the data recently (48 hours ago or less), we might be ...

• How Can I Duplicate A Transaction?

  In most cases, you should update your source data (ex: CRM system, accounting system, CSV file, etc.) to include missing records. However, in some rare cases, you may need to add another transaction within Sales Cookie only. To do this: Select ...