Orders use an optimisation cache that updates automatically as data ages

Administrators can update the cache manually anytime from the sales order screen

Image Added

Soulfresh Global Pty Ltd 

  foreach (var c in excel.Columns)
 {
 if (c != null)
 {
 string col = c.ToLower();
 if (col.StartsWith("*"))
 {
 string profile = col.Substring(1);
 int? profileId = ItemProfile.GetByName(Session, profile, ItemProfile.Usages.ItemForSale);
 if (profileId.HasValue)
 {
 iProfiles.Add(i, profileId.Value);
 }
 else
 {
 Session.TextLog.add("Unknown custom profile " + col);
 }
 }
 else if (col == "category") iCat = i;
 else if (col.StartsWith("manufactur") || col == "supplier") iSupplier = i;
 else if (col == "brand") iBrand = i;
 else if (col == "range") iRange = i;
 else if (col == "name") iName = i;
 else if (col == "status") iStatus = i;
 else if (col == "uom") iUOM = i;
 else if (col.Contains("image") && col.Contains("url")) iImage = i;
 else if (col.Contains("warranty") && col.Contains("month")) iWarrantyMonths = i;
 else if (col.Contains("purchase") && col.Contains("multiple")) iPurchaseMultiple = i;
 else if (col.Contains("unit") && (col.Contains("qty") || col.Contains("quantity"))) iQtyUnit = i;
 else if (col.Contains("buy") && col.Contains("sell")) iBuySell = i;
 else if (col == "categorysku") iCatiSKU = i;
 else if (col.StartsWith("manufactur == "colour") ||  iColour = i;
 else if (col == "suppliersize") iSupplieriSize = i;
 else if (col == "brand") iBrand.Contains("group") && (col.Contains("size") || col.Contains("colour"))) iGroup = i;
 else if (col == "range.Contains("storage")) iRangeiStorage = i;
 else if ((col == "name.Contains("style") iName = i;
 else if (col == "status&& (col.Contains("group") iStatus = i;
 else if (|| col.Length < 10)) || col == "uomproductgroup") iUOMiStyleGroup = i;
 else if (col.Contains("image") && col.Contains("url")) iImage == "description") iDesc = i;
 else if (col.Contains("warrantyshort") && col.Contains("monthdescription")) iWarrantyMonthsiShortDesc = i;
 else if (col.Contains("purchaseweb") && col.Contains("multipledescription")) iPurchaseMultipleiWebDescription = i;
 else if (col.Contains("unit") && (col.Contains("qtyweb") || col.Contains("quantity"))) iQtyUnit = i;
 else if (col.Contains("buyhtml")) && col.Contains("sellfeatures")) iBuySelliWebFeatures = i;
 else if (col == "sku.Contains("purchasing") iSKU = i;
 else if (col == "colour") iColour&& col.Contains("notes")) iPurchasingNotes = i;
 else if (col == "size.Contains("sellprice")) iSizeiSellPrice = i;
 else if (col.Contains("group") && (col.Contains("size") == "costprice" || col.Contains("colour == "defaultbuyprice"))) iGroupiCostPrice = i;
 else if (col.Contains("cost") && col.StartsWith("storageav")) iStorageiavgCost = i;
 else if ((col.Contains("styleprice") && col.StartsWith("alt") && col.Contains("groupbuy")) || col.Length < 10)) || col == "productgroup") iStyleGroupiAltBuyPrice = i;
 else if (col.Contains("rrp")) iRRP = i;
 else if (col == "description".Contains("gst")) iDesciGSTMode = i;
 else if ((col.Contains("shorttheir") &&|| col.Contains("descriptionsupplier")) iShortDesc = i;
 else if (&& col.Contains("webpart") && col.Contains("descriptionnumber")) iWebDescriptioniSupplierRef = i;
 else if (col.Contains("supplier") && col.Contains("webname") ||&& (col.Contains("htmlitem")) &&|| col.Contains("featurespart"))) iWebFeaturesiSupplierPartName = i;
 else if (col.Contains("purchasing") && col.Contains("notes")) iPurchasingNotes = i;
 else if (col.Contains("sellprice")) iSellPrice == "extref" || col == "ext ref" || col == "xref" || col.StartsWith("import")) iExtRef = i;
 else if (col == "costprice" || if (col == "defaultbuypricedimunit") iCostPriceiDimUnit = i;
 else if (col.Contains("cost") && col.StartsWith("av")) iavgCost == "width") iWidth = i;
 else if (col.Contains("price") && col.StartsWith("alt == "height") && col.Contains("buy")) iAltBuyPrice iHeight = i;
 else if (col.Contains("rrp")) iRRP = i;
 else if (depth") && col.Contains("gstunit")) iGSTModeiUnitDepth = i;
 else if ((col.Contains("theirwidth") ||&& col.Contains("supplierunit")) &&  iUnitWidth = i;
 else if (col.Contains("partheight") && col.Contains("numberunit")) iSupplierRefiUnitHeight = i;
 else if (col.Contains("supplier == "depth") && col.Contains("name") && (col.Contains("item") || col.Contains("part"))) iSupplierPartName iDepth = i;
 else if (col == "massunit") iMassUnit = i;
 else if (col == "netmass") iNetMass = i;
 else if (col == "extrefgrossmass") ||iGrossMass col= ==i;
"ext ref"else ||if (col == "xref" || col.StartsWith("import.Contains("measure"))
 {
 if (col.Contains("unit")) iExtRefiMeasureUnit = i;  else if (coliMeasure == "dimunit") iDimUnit = i;
 i;
 }
 else if (col == "width") iWidth.Contains("sell") && col.Contains("rate")) iSellrate = i;
 else if (col == "heightbarcode") iHeightiBarcode = i;
 else if (col.Contains("depth") && col.Contains("unit")) iUnitDepth == "assembly") iAssembly = i;
 else if (col.Contains("width") && col.Contains("unitrepair")) iUnitWidthiRepairable = i;
 else if (col.Contains("heightserving") && col.Contains("unitsize")) iUnitHeightiServingSize = i;
 else if (col == "depth.Contains("name") iDepth = i;
 else if (col == "massunit") iMassUnit = i;
 else if (col == "netmass") iNetMass&& (col.Contains("pkg") || col.Contains("package"))) iPackageName = i;
 else if (col == "grossmass") iGrossMass.Contains("size") && col.Contains("pack")) iPacksize = i;
 else if (col.Contains("measurepacking"))  {
 if (&& col.Contains("unitfactor")) iMeasureUnitiPackingFactor = i;
 else iMeasure = i;
 }
 else if (if (col.Contains("serving") && col.Contains("sellper") && col.Contains("ratepack")) iSellrateiServPerPack = i;
 else if (col == "barcode".StartsWith("ingredients")) iBarcodeiIngredients = i;
 else if (col == "assembly") iAssembly = i;
 else if (col.Contains("repair")) iRepairable = i;.StartsWith("certification") || col.StartsWith("lifestyle"))
 {
 certifications.Add(i, col.Replace("certification", string.Empty));
 }
 else if (col.ContainsStartsWith("servingclaims") &&)
 {
 dietaryClaims.Add(i, col.ContainsReplace("sizeclaims", string.Empty));
iServingSize =}
i;  else if (col.ContainsStartsWith("namenip") && (!col.Contains("pkgserve") ||)
 {
 int p = col.ContainsIndexOf("package("))) iPackageName = i;
 else if (col.Contains("size") && col.Contains("pack")) iPacksize = i;
 else if (col.Contains("packing") && col.Contains("factor")) iPackingFactor = i;
 else if (col.Contains("serving") && col.Contains("per") && col.Contains("pack")) iServPerPack = i;;
 if (p > 0)
 {
 col = col.Substring(0, p - 1);
 }
 string text = col.Replace("nip", string.Empty).Replace(":", string.Empty).Trim();
 int nipId = ArticleNIPItem.IdForText(Session, text);
 if (nipId > 0) iNIP.Add(i, nipId); else Session.TextLog.add("No NIP item found for " + text);
 }
 else if (col.StartsWith("ingredientsinner"))
iIngredients ={
i;  else if (col.StartsWithContains("certificationqty") || col.StartsWithContains("lifestylequantity"))
 {
 certifications.Add(i, col.Replace("certification", string.Empty))iInnerQty = i;
 }
 else if (col.StartsWithContains("claimssell"))
 {
 dietaryClaims.Add(i, col.Replace("claims", string.Empty));iInnerSellPrice = i;
 }
 else
 {
 iInnerBuyPrice = i;
 }
 }
 else if (col.StartsWith("nipcarton") && !)
 {
 if (col.Contains("serveqty"))  {
 int p = || col.IndexOfContains("(quantity");
 if (p > 0)
 {
 col
= col.Substring(0, p - 1) iCartonQty = i;
 }
 stringelse textif = (col.ReplaceContains("nip", string.Empty).Replace(":", string.Empty).Trim();
 int nipId = ArticleNIPItem.IdForText(Session, text);
 if (nipId > 0) iNIP.Add(i, nipId); else Session.TextLog.add("No NIP item found for " + text);sell"))
 {
 iCartonSellPrice = i;
 }
 else
 {
 iCartonBuyPrice = i;
 }
 }
 else if (col.StartsWith("innerpallet"))
 {
 if (col.Contains("qty") || col.Contains("quantity"))
 {
 iInnerQtyiPalletQty = i;
 }
 else
 {
 iPalletBuyPrice = i;
 }
 else if (col.Contains("selldepth"))  {
 iInnerSellPrice && col.Contains("carton")) iCartonDepth = i;
     }  else  {  iInnerBuyPrice = i;  }  }  else if (col.StartsWith("carton"))  { else if (col.Contains("qtywidth") ||&& col.Contains("quantitycarton"))  {
 iCartonQty = i;
 }
 else if (iCartonWidth = i;
                        else if (col.Contains("height") && col.Contains("sellcarton")) iCartonHeight {= i;
iCartonSellPrice = i;  }  else  {  iCartonBuyPrice = i;  }  }  else if (col.StartsWith("pallet"))  {  else if (col.Contains("qtybarcode") ||&& col.Contains("quantitycarton")) iCartonBarcode {
 iPalletQty = i;
 }
 else
 {
 iPalletBuyPrice = i;
 }
 }
 else
 {
 Session.TextLog.add("Column ignored: " + c);
 }
 }
 i++;
 }