From cec24d3ee583b316266d22a9a48d1b791dc0d742 Mon Sep 17 00:00:00 2001
From: Vincent Vanwaelscappel <vincent@cubedesigners.com>
Date: Tue, 8 Oct 2019 18:28:31 +0200
Subject: [PATCH] fix #3118 @3

---
 js/libs/fluidbook/special/wescosales.js | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/js/libs/fluidbook/special/wescosales.js b/js/libs/fluidbook/special/wescosales.js
index 7ff3ecbc..3267802f 100644
--- a/js/libs/fluidbook/special/wescosales.js
+++ b/js/libs/fluidbook/special/wescosales.js
@@ -78,6 +78,9 @@ function setWescoSalesPanel(ref, e, updateOnly) {
     }
 
     var r = getWescoRef(ref);
+    if (r.ref === undefined) {
+        return;
+    }
     var rref = r.ref;
     var activeCountry = $("#wescosalesselect").val();
 
@@ -139,6 +142,9 @@ function getAllRefs() {
             var sheet = DATAS.basketReferences[country];
             for (var linenum in sheet) {
                 var line = sheet[linenum];
+                if (line[0] === null) {
+                    continue;
+                }
 
                 try {
                     var r = normalizeRef(line[0].toString());
@@ -255,6 +261,7 @@ function wescoLinksReady() {
 function normalizeRef(oref) {
     if (normalizeRefCache[oref] == null) {
         ref = oref.toString().replace(/\s*/g, '');
+        ref = ref.replace(/,/g, '');
         if (ref.length < 5) {
             var pad = "00000"
             ref = pad.substring(0, pad.length - ref.length) + ref;
@@ -275,6 +282,9 @@ function getWescoRef(ref) {
             var l = line0.length;
             for (var linenum in sheet) {
                 var line = sheet[linenum];
+                if (line[0] === null) {
+                    continue;
+                }
                 var r = normalizeRef(line[0].toString());
                 if (r != ref) {
                     continue;
-- 
2.39.5