Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Version Requirements can be found in Reporting Release Documentation.

Import of stamps

(TFS: 168533)

To keep track of stamp card campaigns we now import stamp cards from Chain Web.

...

  •   CampaignReference - Campaign reference from DimCampaign.

  •   MemberNumber - Member number

  •   StampCardKey - Id for stamp card in Chain Web.

  •   TransactionDate - Timestamp for stamp card transacton

  •   StampCardTransactionTypeName - Type of stamp card transaction.

  •   Value - Number of stamps used in transaction.

  •   InstanceNumber - Which instance. E.g. Every 5. item for free. First 5 items had instance 1, next 5 items has instance 2.

  •   ReceiptID - Receipt id from cash register, if available.

  •   Comment - Comment on transaction, if available.


Coupon information from Chain Web

(TFS: 168541)

When fetching coupon information from Chain Web we now also include TransactionID from used coupons when available.

...

Info

Note: Upgrade script will delete all existing coupons, they will be imported again next time N-job runs.


Campaign detail

(TFS: 169114)

To show more detail from campaigns, we now fetch price rules and offer details from Chain Web.

...

  • CampaignReference - Campaign reference

  • OfferNumber - Offer number

  • Name - Offer name

  • OfferStart - Start date on offer

  • OfferStop - Stop date on offer


New view for member sales data

(TFS: 171445)

3rd party is able to use this view to fetch data on members who have recently made a purchase in a store and can use this data to conduct a customer survey.

...

Info

To create comma separated list of items which should be excluded from Sum and quantity of items. Alter view and edit this line: 

  AND da.EAN NOT IN ('EAN1','EAN2','EAN3') -- List of EANs for plastic bags to be excluded from amount/qty

...

Improvements

Modules

Description

Member

Lookup member from POSLog (TFS: 158811)

We have made improvements when doing lookup on members from POSLog. If LoyaltyNumber is available we always use this for lookup before checking identificators.

Member Campaigns

Import of coupons (TFS: 164210)

The performance of importing coupons from Chain Web has been significantly improved.