Facebook
Twitter
Pinterest
ISSUU
System: products
Stock Search False List Heads
Item Properties Item Properties
Stockstk:484
blsearch:False
varSearchTxt:
strSearch:
strWhereSQL: CategoryID = '484'
varID: 484
varSearchTxt:
strSearch:
strWhereSQL: CategoryID = '484'
varID: 484
Search FalsevarCatID:484
varExtID:484
strPhotoName:categories/cat_484
varExtID:484
strPhotoName:categories/cat_484
Storage
List HeadsstrProdListSQL: WHERE ProductCategories.CategoryID = '484' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> ''
varProductsTotalCount: 2
lastProdID: 0
rsPsql: SELECT Products.ProductID, SKU, ProductName, Products.LongDescription, Products.SupplierID, Products.CategoryID, OnSpecial, SpecialPrice, PromoText, BandA AS UnitPrice, LineItemTax, UnitsInStock, ProductPicture, ProductThumb, Specifications, UnitWeight, Keywords, Products.ColID, BandA AS TradePrice, Products.RestockDate, Products.PriceOptions, Products.Display, Products.BuyButton, Products.UnitSize, Products.UnitColour, Products.BandA, Products.BandB, Products.BandC, Products.BandD, Products.BandE, Products.BandF, Products.BandG, Products.BandH, UnitsInStock AS wh1_stock, 0 AS wh2_stock, CostPrice, ProductNameCustom, ProductDescriptionCustom, Products.Fragile, Products.TaxCode, Products.NonStockItem, Products.SampleAvailable, Products.ProductPicture AS ProdPic, Products.ParentID, Products.ExternalCatID, Products.QuantityPerUnit, Products.stUser3,Products.Barcode, Products.ShortDescription, Products.stUser2,Products.stUser5,Products.stUser6,Products.ProcessType, Products.stUser10,Products.ShowImgOverlay,Products.ImgOverlayText,Products.OnSpecial_Cat, (SELECT OfferPercent FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Percent, (SELECT OfferText FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Text, (SELECT Active FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Active, Products.ShowProductGroups, Products.stStockType FROM dbo.ProductCategories INNER JOIN Products ON Products.SKU COLLATE Latin1_General_CS_AS = ProductCategories.ProductID COLLATE Latin1_General_CS_AS WHERE ProductCategories.CategoryID = '484' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> '' AND Products.ProductID > 0 ORDER BY Products.DisplayOrder, Products.SKU
varProductsTotalCount: 2
lastProdID: 0
rsPsql: SELECT Products.ProductID, SKU, ProductName, Products.LongDescription, Products.SupplierID, Products.CategoryID, OnSpecial, SpecialPrice, PromoText, BandA AS UnitPrice, LineItemTax, UnitsInStock, ProductPicture, ProductThumb, Specifications, UnitWeight, Keywords, Products.ColID, BandA AS TradePrice, Products.RestockDate, Products.PriceOptions, Products.Display, Products.BuyButton, Products.UnitSize, Products.UnitColour, Products.BandA, Products.BandB, Products.BandC, Products.BandD, Products.BandE, Products.BandF, Products.BandG, Products.BandH, UnitsInStock AS wh1_stock, 0 AS wh2_stock, CostPrice, ProductNameCustom, ProductDescriptionCustom, Products.Fragile, Products.TaxCode, Products.NonStockItem, Products.SampleAvailable, Products.ProductPicture AS ProdPic, Products.ParentID, Products.ExternalCatID, Products.QuantityPerUnit, Products.stUser3,Products.Barcode, Products.ShortDescription, Products.stUser2,Products.stUser5,Products.stUser6,Products.ProcessType, Products.stUser10,Products.ShowImgOverlay,Products.ImgOverlayText,Products.OnSpecial_Cat, (SELECT OfferPercent FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Percent, (SELECT OfferText FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Text, (SELECT Active FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Active, Products.ShowProductGroups, Products.stStockType FROM dbo.ProductCategories INNER JOIN Products ON Products.SKU COLLATE Latin1_General_CS_AS = ProductCategories.ProductID COLLATE Latin1_General_CS_AS WHERE ProductCategories.CategoryID = '484' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> '' AND Products.ProductID > 0 ORDER BY Products.DisplayOrder, Products.SKU
Found items: 2
Item PropertiesUnitPrice:14.54, DisplayPrice:14.54, ExchPrice:14.54, RoundPrice:14.54
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:11486, CATID:, ExCat:560.05
strPhotoName: products/6906-110.jpg
Image: 6906-110
StrPhoto: /dbimages/products/6906-110.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(6906/110,XWEB)
2 - 009 fn categoryDiscount:(6906/110,XWEB)
3 -
3 - 016 fn getStockDiscount: (6906/110,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=6906/110
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:6906/110
5 - 008d fn getcat:BLANK
5 - 014a blnTopCat1:(False)
5 - 014a varParentCat1:()
6 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
7 - START NEW
7 - 021 Call sub setStockDiscounts:(560.05,XWEB)
8 - 009 fn categoryDiscount:(560.05,XWEB)
9 -
9 - 016 fn getStockDiscount: (560.05,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=560.05
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:560.05
11 - 008c fn getcat=560
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(560)
12 -
12 - 016 fn getStockDiscount: (560,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(560)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=560
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:560
14 - 008b fn getcat=560
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(560)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:11486, CATID:, ExCat:560.05
strPhotoName: products/6906-110.jpg
Image: 6906-110
StrPhoto: /dbimages/products/6906-110.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(6906/110,XWEB)
2 - 009 fn categoryDiscount:(6906/110,XWEB)
3 -
3 - 016 fn getStockDiscount: (6906/110,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=6906/110
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:6906/110
5 - 008d fn getcat:BLANK
5 - 014a blnTopCat1:(False)
5 - 014a varParentCat1:()
6 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
7 - START NEW
7 - 021 Call sub setStockDiscounts:(560.05,XWEB)
8 - 009 fn categoryDiscount:(560.05,XWEB)
9 -
9 - 016 fn getStockDiscount: (560.05,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=560.05
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:560.05
11 - 008c fn getcat=560
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(560)
12 -
12 - 016 fn getStockDiscount: (560,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(560)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=560
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:560
14 - 008b fn getcat=560
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(560)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Item PropertiesUnitPrice:15.63, DisplayPrice:15.63, ExchPrice:15.63, RoundPrice:15.63
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:11488, CATID:, ExCat:560.05
strPhotoName: products/6906-46.jpg
Image: 6906-46
StrPhoto: /dbimages/products/6906-46.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(6906/110,XWEB)
2 - 009 fn categoryDiscount:(6906/110,XWEB)
3 -
3 - 016 fn getStockDiscount: (6906/110,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=6906/110
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:6906/110
5 - 008d fn getcat:BLANK
5 - 014a blnTopCat1:(False)
5 - 014a varParentCat1:()
6 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
7 - START NEW
7 - 021 Call sub setStockDiscounts:(560.05,XWEB)
8 - 009 fn categoryDiscount:(560.05,XWEB)
9 -
9 - 016 fn getStockDiscount: (560.05,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=560.05
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:560.05
11 - 008c fn getcat=560
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(560)
12 -
12 - 016 fn getStockDiscount: (560,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(560)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=560
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:560
14 - 008b fn getcat=560
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(560)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
16 - START NEW
16 - 021 Call sub setStockDiscounts:(6906/46,XWEB)
17 - 009 fn categoryDiscount:(6906/46,XWEB)
18 -
18 - 016 fn getStockDiscount: (6906/46,XWEB)
18 - 016b fn getStockDiscount: BandA|0|BP
18 - 010 result:(BandA|0|BP)
18 - 012 result1:Category=6906/46
18 - 013 result1:blnTopCat=False
19 - 008a fn getcat:6906/46
20 - 008d fn getcat:BLANK
20 - 014a blnTopCat1:(False)
20 - 014a varParentCat1:()
21 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
22 - START NEW
22 - 021 Call sub setStockDiscounts:(560.05,XWEB)
23 - 009 fn categoryDiscount:(560.05,XWEB)
24 -
24 - 016 fn getStockDiscount: (560.05,XWEB)
24 - 016b fn getStockDiscount: BandA|0|BP
24 - 010 result:(BandA|0|BP)
24 - 012 result1:Category=560.05
24 - 013 result1:blnTopCat=False
25 - 008a fn getcat:560.05
26 - 008c fn getcat=560
26 - 014a blnTopCat1:(False)
26 - 014a varParentCat1:(560)
27 -
27 - 016 fn getStockDiscount: (560,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 014 blnTopCat1:(False)
27 - 014 getCat1:(560)
27 - 014 result1:(BandA|0|BP)
27 - 012 result2:Category=560
27 - 013 result2:blnTopCat=False
28 - 008a fn getcat:560
29 - 008b fn getcat=560
29 - 014a blnTopCat2:(True)
29 - 014a varParentCat2:(560)
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:11488, CATID:, ExCat:560.05
strPhotoName: products/6906-46.jpg
Image: 6906-46
StrPhoto: /dbimages/products/6906-46.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(6906/110,XWEB)
2 - 009 fn categoryDiscount:(6906/110,XWEB)
3 -
3 - 016 fn getStockDiscount: (6906/110,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=6906/110
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:6906/110
5 - 008d fn getcat:BLANK
5 - 014a blnTopCat1:(False)
5 - 014a varParentCat1:()
6 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
7 - START NEW
7 - 021 Call sub setStockDiscounts:(560.05,XWEB)
8 - 009 fn categoryDiscount:(560.05,XWEB)
9 -
9 - 016 fn getStockDiscount: (560.05,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=560.05
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:560.05
11 - 008c fn getcat=560
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(560)
12 -
12 - 016 fn getStockDiscount: (560,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(560)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=560
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:560
14 - 008b fn getcat=560
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(560)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
16 - START NEW
16 - 021 Call sub setStockDiscounts:(6906/46,XWEB)
17 - 009 fn categoryDiscount:(6906/46,XWEB)
18 -
18 - 016 fn getStockDiscount: (6906/46,XWEB)
18 - 016b fn getStockDiscount: BandA|0|BP
18 - 010 result:(BandA|0|BP)
18 - 012 result1:Category=6906/46
18 - 013 result1:blnTopCat=False
19 - 008a fn getcat:6906/46
20 - 008d fn getcat:BLANK
20 - 014a blnTopCat1:(False)
20 - 014a varParentCat1:()
21 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
22 - START NEW
22 - 021 Call sub setStockDiscounts:(560.05,XWEB)
23 - 009 fn categoryDiscount:(560.05,XWEB)
24 -
24 - 016 fn getStockDiscount: (560.05,XWEB)
24 - 016b fn getStockDiscount: BandA|0|BP
24 - 010 result:(BandA|0|BP)
24 - 012 result1:Category=560.05
24 - 013 result1:blnTopCat=False
25 - 008a fn getcat:560.05
26 - 008c fn getcat=560
26 - 014a blnTopCat1:(False)
26 - 014a varParentCat1:(560)
27 -
27 - 016 fn getStockDiscount: (560,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 014 blnTopCat1:(False)
27 - 014 getCat1:(560)
27 - 014 result1:(BandA|0|BP)
27 - 012 result2:Category=560
27 - 013 result2:blnTopCat=False
28 - 008a fn getcat:560
29 - 008b fn getcat=560
29 - 014a blnTopCat2:(True)
29 - 014a varParentCat2:(560)
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Found items: 2
