I was looking into this today and found a small issue that was causing the hits not to be recorded. Affiliates were still being tracked and orders were being assigned affiliate ids properly, but the inserts into the affiliate tracking table were failing. Essentially we were passing the time for the affiliate referral into the database when we should have been allowing the database itself to be setting the time of the referral.

Here is a modification to the affiliate referral insert stored procedure that will fix the issue. This is only a temporary fix and will be fixed in the code in SP2, but currently we cannot release a hotfix for this issue.

If you do not have direct database access then please contact your ISP so that they can run this sql against your database.

Thanks,
Justin

set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[bvc_AffiliateReferral_i]

@AffiliateId varchar(36),
@ReferrerUrl nvarchar(1000),
@TimeOfReferral datetime = null

AS
BEGIN TRY
SET @TimeOfReferral = GetDate()

DECLARE @ReferralCount As int

SET @ReferralCount = (SELECT COUNT(*) FROM bvc_AffiliateReferral WHERE DATEDIFF(second, TimeOfReferral, @TimeOfReferral) < 2)

IF @ReferralCount = 0
BEGIN
INSERT INTO bvc_AffiliateReferral (id, AffId, ReferrerUrl, TimeOfReferral)
VALUES (NewId(), @AffiliateId, @ReferrerUrl, @TimeOfReferral)
END
END TRY
BEGIN CATCH
EXEC bvc_EventLog_SQL_i
END CATCH