Facebook
Twitter
Pinterest
ISSUU
System: products
Stock Search False List Heads
Item Properties Item Properties Item Properties
Stockstk:282
blsearch:False
varSearchTxt:
strSearch:
strWhereSQL: CategoryID = '282'
varID: 282
varSearchTxt:
strSearch:
strWhereSQL: CategoryID = '282'
varID: 282
Search FalsevarCatID:282
varExtID:Gift Tokens
strPhotoName:categories/cat_282
varExtID:Gift Tokens
strPhotoName:categories/cat_282
Gift Tokens
Clayman Gift Tokens can be used online or in our Potter's Shop. When completing your purchase you will have the option to print the token to give to whoever you want or email it to the lucky recipient. Tokens bought online are supplied a unique gift token code.
List HeadsstrProdListSQL: WHERE ProductCategories.CategoryID = 'Gift Tokens' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> ''
varProductsTotalCount: 3
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 = 'Gift Tokens' 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: 3
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 = 'Gift Tokens' 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: 3
Item PropertiesUnitPrice:5, DisplayPrice:5, ExchPrice:5, RoundPrice:5.00
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10605, CATID:, ExCat:900
strPhotoName: products/giftvoucher.jpg
Image: giftvoucher
StrPhoto: /dbimages/products/giftvoucher.jpg
Fragile : False
TaxCode : Z
LineItemTax : 0
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(900.5,XWEB)
2 - 009 fn categoryDiscount:(900.5,XWEB)
3 -
3 - 016 fn getStockDiscount: (900.5,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=900.5
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:900.5
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:(900,XWEB)
8 - 009 fn categoryDiscount:(900,XWEB)
9 -
9 - 016 fn getStockDiscount: (900,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=900
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:900
11 - 008b fn getcat=900
11 - 014a blnTopCat1:(True)
11 - 014a varParentCat1:(900)
12 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10605, CATID:, ExCat:900
strPhotoName: products/giftvoucher.jpg
Image: giftvoucher
StrPhoto: /dbimages/products/giftvoucher.jpg
Fragile : False
TaxCode : Z
LineItemTax : 0
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(900.5,XWEB)
2 - 009 fn categoryDiscount:(900.5,XWEB)
3 -
3 - 016 fn getStockDiscount: (900.5,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=900.5
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:900.5
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:(900,XWEB)
8 - 009 fn categoryDiscount:(900,XWEB)
9 -
9 - 016 fn getStockDiscount: (900,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=900
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:900
11 - 008b fn getcat=900
11 - 014a blnTopCat1:(True)
11 - 014a varParentCat1:(900)
12 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Item PropertiesUnitPrice:35, DisplayPrice:35, ExchPrice:35, RoundPrice:35.00
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10602, CATID:, ExCat:900
strPhotoName: products/giftvoucher.jpg
Image: giftvoucher
StrPhoto: /dbimages/products/giftvoucher.jpg
Fragile : False
TaxCode : Z
LineItemTax : 0
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(900.5,XWEB)
2 - 009 fn categoryDiscount:(900.5,XWEB)
3 -
3 - 016 fn getStockDiscount: (900.5,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=900.5
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:900.5
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:(900,XWEB)
8 - 009 fn categoryDiscount:(900,XWEB)
9 -
9 - 016 fn getStockDiscount: (900,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=900
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:900
11 - 008b fn getcat=900
11 - 014a blnTopCat1:(True)
11 - 014a varParentCat1:(900)
12 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
13 - START NEW
13 - 021 Call sub setStockDiscounts:(900.35,XWEB)
14 - 009 fn categoryDiscount:(900.35,XWEB)
15 -
15 - 016 fn getStockDiscount: (900.35,XWEB)
15 - 016b fn getStockDiscount: BandA|0|BP
15 - 010 result:(BandA|0|BP)
15 - 012 result1:Category=900.35
15 - 013 result1:blnTopCat=False
16 - 008a fn getcat:900.35
17 - 008d fn getcat:BLANK
17 - 014a blnTopCat1:(False)
17 - 014a varParentCat1:()
18 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
19 - START NEW
19 - 021 Call sub setStockDiscounts:(900,XWEB)
20 - 009 fn categoryDiscount:(900,XWEB)
21 -
21 - 016 fn getStockDiscount: (900,XWEB)
21 - 016b fn getStockDiscount: BandA|0|BP
21 - 010 result:(BandA|0|BP)
21 - 012 result1:Category=900
21 - 013 result1:blnTopCat=False
22 - 008a fn getcat:900
23 - 008b fn getcat=900
23 - 014a blnTopCat1:(True)
23 - 014a varParentCat1:(900)
24 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10602, CATID:, ExCat:900
strPhotoName: products/giftvoucher.jpg
Image: giftvoucher
StrPhoto: /dbimages/products/giftvoucher.jpg
Fragile : False
TaxCode : Z
LineItemTax : 0
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(900.5,XWEB)
2 - 009 fn categoryDiscount:(900.5,XWEB)
3 -
3 - 016 fn getStockDiscount: (900.5,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=900.5
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:900.5
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:(900,XWEB)
8 - 009 fn categoryDiscount:(900,XWEB)
9 -
9 - 016 fn getStockDiscount: (900,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=900
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:900
11 - 008b fn getcat=900
11 - 014a blnTopCat1:(True)
11 - 014a varParentCat1:(900)
12 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
13 - START NEW
13 - 021 Call sub setStockDiscounts:(900.35,XWEB)
14 - 009 fn categoryDiscount:(900.35,XWEB)
15 -
15 - 016 fn getStockDiscount: (900.35,XWEB)
15 - 016b fn getStockDiscount: BandA|0|BP
15 - 010 result:(BandA|0|BP)
15 - 012 result1:Category=900.35
15 - 013 result1:blnTopCat=False
16 - 008a fn getcat:900.35
17 - 008d fn getcat:BLANK
17 - 014a blnTopCat1:(False)
17 - 014a varParentCat1:()
18 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
19 - START NEW
19 - 021 Call sub setStockDiscounts:(900,XWEB)
20 - 009 fn categoryDiscount:(900,XWEB)
21 -
21 - 016 fn getStockDiscount: (900,XWEB)
21 - 016b fn getStockDiscount: BandA|0|BP
21 - 010 result:(BandA|0|BP)
21 - 012 result1:Category=900
21 - 013 result1:blnTopCat=False
22 - 008a fn getcat:900
23 - 008b fn getcat=900
23 - 014a blnTopCat1:(True)
23 - 014a varParentCat1:(900)
24 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Item PropertiesUnitPrice:125, DisplayPrice:125, ExchPrice:125, RoundPrice:125.00
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10592, CATID:, ExCat:900
strPhotoName: products/giftvoucher.jpg
Image: giftvoucher
StrPhoto: /dbimages/products/giftvoucher.jpg
Fragile : False
TaxCode : Z
LineItemTax : 0
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(900.5,XWEB)
2 - 009 fn categoryDiscount:(900.5,XWEB)
3 -
3 - 016 fn getStockDiscount: (900.5,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=900.5
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:900.5
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:(900,XWEB)
8 - 009 fn categoryDiscount:(900,XWEB)
9 -
9 - 016 fn getStockDiscount: (900,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=900
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:900
11 - 008b fn getcat=900
11 - 014a blnTopCat1:(True)
11 - 014a varParentCat1:(900)
12 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
13 - START NEW
13 - 021 Call sub setStockDiscounts:(900.35,XWEB)
14 - 009 fn categoryDiscount:(900.35,XWEB)
15 -
15 - 016 fn getStockDiscount: (900.35,XWEB)
15 - 016b fn getStockDiscount: BandA|0|BP
15 - 010 result:(BandA|0|BP)
15 - 012 result1:Category=900.35
15 - 013 result1:blnTopCat=False
16 - 008a fn getcat:900.35
17 - 008d fn getcat:BLANK
17 - 014a blnTopCat1:(False)
17 - 014a varParentCat1:()
18 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
19 - START NEW
19 - 021 Call sub setStockDiscounts:(900,XWEB)
20 - 009 fn categoryDiscount:(900,XWEB)
21 -
21 - 016 fn getStockDiscount: (900,XWEB)
21 - 016b fn getStockDiscount: BandA|0|BP
21 - 010 result:(BandA|0|BP)
21 - 012 result1:Category=900
21 - 013 result1:blnTopCat=False
22 - 008a fn getcat:900
23 - 008b fn getcat=900
23 - 014a blnTopCat1:(True)
23 - 014a varParentCat1:(900)
24 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
25 - START NEW
25 - 021 Call sub setStockDiscounts:(900.125,XWEB)
26 - 009 fn categoryDiscount:(900.125,XWEB)
27 -
27 - 016 fn getStockDiscount: (900.125,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 010 result:(BandA|0|BP)
27 - 012 result1:Category=900.125
27 - 013 result1:blnTopCat=False
28 - 008a fn getcat:900.125
29 - 008d fn getcat:BLANK
29 - 014a blnTopCat1:(False)
29 - 014a varParentCat1:()
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
31 - START NEW
31 - 021 Call sub setStockDiscounts:(900,XWEB)
32 - 009 fn categoryDiscount:(900,XWEB)
33 -
33 - 016 fn getStockDiscount: (900,XWEB)
33 - 016b fn getStockDiscount: BandA|0|BP
33 - 010 result:(BandA|0|BP)
33 - 012 result1:Category=900
33 - 013 result1:blnTopCat=False
34 - 008a fn getcat:900
35 - 008b fn getcat=900
35 - 014a blnTopCat1:(True)
35 - 014a varParentCat1:(900)
36 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10592, CATID:, ExCat:900
strPhotoName: products/giftvoucher.jpg
Image: giftvoucher
StrPhoto: /dbimages/products/giftvoucher.jpg
Fragile : False
TaxCode : Z
LineItemTax : 0
UnitWeight : 1
Discount Tracker :
1 - START NEW
1 - 021 Call sub setStockDiscounts:(900.5,XWEB)
2 - 009 fn categoryDiscount:(900.5,XWEB)
3 -
3 - 016 fn getStockDiscount: (900.5,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=900.5
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:900.5
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:(900,XWEB)
8 - 009 fn categoryDiscount:(900,XWEB)
9 -
9 - 016 fn getStockDiscount: (900,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=900
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:900
11 - 008b fn getcat=900
11 - 014a blnTopCat1:(True)
11 - 014a varParentCat1:(900)
12 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
13 - START NEW
13 - 021 Call sub setStockDiscounts:(900.35,XWEB)
14 - 009 fn categoryDiscount:(900.35,XWEB)
15 -
15 - 016 fn getStockDiscount: (900.35,XWEB)
15 - 016b fn getStockDiscount: BandA|0|BP
15 - 010 result:(BandA|0|BP)
15 - 012 result1:Category=900.35
15 - 013 result1:blnTopCat=False
16 - 008a fn getcat:900.35
17 - 008d fn getcat:BLANK
17 - 014a blnTopCat1:(False)
17 - 014a varParentCat1:()
18 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
19 - START NEW
19 - 021 Call sub setStockDiscounts:(900,XWEB)
20 - 009 fn categoryDiscount:(900,XWEB)
21 -
21 - 016 fn getStockDiscount: (900,XWEB)
21 - 016b fn getStockDiscount: BandA|0|BP
21 - 010 result:(BandA|0|BP)
21 - 012 result1:Category=900
21 - 013 result1:blnTopCat=False
22 - 008a fn getcat:900
23 - 008b fn getcat=900
23 - 014a blnTopCat1:(True)
23 - 014a varParentCat1:(900)
24 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
25 - START NEW
25 - 021 Call sub setStockDiscounts:(900.125,XWEB)
26 - 009 fn categoryDiscount:(900.125,XWEB)
27 -
27 - 016 fn getStockDiscount: (900.125,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 010 result:(BandA|0|BP)
27 - 012 result1:Category=900.125
27 - 013 result1:blnTopCat=False
28 - 008a fn getcat:900.125
29 - 008d fn getcat:BLANK
29 - 014a blnTopCat1:(False)
29 - 014a varParentCat1:()
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
31 - START NEW
31 - 021 Call sub setStockDiscounts:(900,XWEB)
32 - 009 fn categoryDiscount:(900,XWEB)
33 -
33 - 016 fn getStockDiscount: (900,XWEB)
33 - 016b fn getStockDiscount: BandA|0|BP
33 - 010 result:(BandA|0|BP)
33 - 012 result1:Category=900
33 - 013 result1:blnTopCat=False
34 - 008a fn getcat:900
35 - 008b fn getcat=900
35 - 014a blnTopCat1:(True)
35 - 014a varParentCat1:(900)
36 - 022 Output sub arrStockDiscount: 0 - Band = BandA
END
Found items: 3
