Import sales transactions

General instructions and tips on preparing import files can be found on the Docs → Account → File imports page of the support centre.

During the run of a sales transaction sync file, matches will be found based on the ID.

Due to the quantity of data being stored it’s not possible to run the file import in ‘delete mode’. If you need to delete information, re-upload the transactions with the Transactions and Value zero’d.

ColumnField NameData TypeLength LimitExampleDescription
AID*String40INV-10001A unique identifier for the sales transaction/s. An ID can be comprised of text and/or numbers up to 40 characters in length. We recommend using the invoice or order number. If you don't have a unique ID, consider joining the date, time and area together to create one (but be careful if you process multiple transactions per second).
BDate*Date2015-10-25The date the transaction took place.
CTime*Time14:00:00The time the transaction took place in hh:mm:ss format. If you're sending multiple transactions in one record this should be the start time of the period being sent.
DEnd timeTime14:15:00This field only needs populating if you're sending multiple transactions in one record. For example, if you're sending the total transactions that took place between 14:00:00 and 14:15:00 you would set this field as '14:15:00'. If you're sending transactions one-by-one then this field can be left blank.
ETransactions*Number10,220The total amount of transactions that took place in the time period. If you are sending single transactions this should be set as '1'.
FValueNumber10,2370.00The total value of the transaction/s you are sending. If you're using 'transaction mode' for your sales feed then this field doesn't need to be populated.
GArea ID*ReferenceSTORE1The ID of the area the sale transactions belongs too. This allows you to attach different sales data to each area in your account. If the ID doesn't match a predefined, non-deleted area ID OR it it's left blank then the sales data will be shared by all area's in your company.
HContact IDReferenceEMP105The ID of the staff the sale transaction/s belong too.

* Mandatory   1 Enterprise Only

Was this article helpful?

Import sales transactions
3 of 2 votes