The purpose of this report is to allow the retailer to allocate single-use coupon sales amount received to the central merchant account (HQ), to the stores where usage has happened.
For a given period the report will show single-use coupon codes that are: Used in the reporting period, Expired in the reporting period, Active at report period end (purchased before or on period end, but not used or expired at report end). The shop transaction report only shows transactions for a specific date/period (processing date), whereas the shop settlement report will show all used/expired/active codes for the date/period report generated.
Report details: “Code status”: “Used” or “Expired” – or “Active” if not used or expired. “Store ID”: If Code status = Used, column show StoreID, If Code status = Expired, column show StoreID of shopper’s local (home) store, If Code status = Active, column is blank. “DateTime”: show the local time of usage or expiration time. If Code status = Used, time of coupon usage, If Code status = Expired, expiration time, If Code status = Active, the column is blank.
|Code||ID of the content that was issued as result of the purchase of the shop offer||Number|
|Store ID||Store identifier||Number|
|DateTime||Local time of usage||String|
|DateTimeUTC||UTC time of usage||String|
|Internal ID||Liquid Barcodes internal transaction id||String|
|Shop offer ID||Unique Id for the shop offer. Shop offer is a product customers can buy in the web shop / in app.||Number|
|Shop offer name||Name of the shop offer||String|
|Processing date||Date when shop offer was purchased||String|
|Processing date UTC||Date when shop offer was purchased in UTC||String|
|User reference||Unique identifier of the user.||String|
|Merchant remuneration||Store compensation per purchased shop offer.||Number|
|Retail price||Price paid by customer for the shop offer.||Number|
|Payment ref||Transaction reference from the payment provider||String|
|Payment provider name||Name of the payment provider||String|
|Payment method||Description of the payment method used to buy the shop offer||String|
|Member ID||Unique identifier of the user.||String|
|Tax Amount||The tax amount paid by customer for the shop offer||Number|
|Promo code||Code used by customer on purchase of shop offer, giving a rebated price||String|