System: products

Stock

Search False

Whats New & Offers

We call this department What's New.& Offers Here we will display items new to our range. Also you will find items to clear or on special offer. Make sure you keep checking back as you may find something interesting.

List Heads

strProdListSQL: WHERE ProductCategories.CategoryID = '367' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> ''
varProductsTotalCount: 4
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 = '367' 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: 4

Item Properties

FLASH
SALE

Stock Code: 4030

Herculite 2

High strength for display pieces

Sizes

Stock

Price

25kg

12

£25.91

Details & Buy

Item Properties
UnitPrice:10.1, DisplayPrice:10.1, ExchPrice:10.1, RoundPrice:10.10
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10781, CATID:, ExCat:521.31
strPhotoName: products/PC-35-473.jpg
Image: PC-35-473
StrPhoto: /dbimages/products/PC-35-473.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 0.77
Discount Tracker :

1 - START NEW
1 - 021 Call sub setStockDiscounts:(4030/25,XWEB)
2 - 009 fn categoryDiscount:(4030/25,XWEB)
3 -
3 - 016 fn getStockDiscount: (4030/25,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=4030/25
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:4030/25
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:(576.02,XWEB)
8 - 009 fn categoryDiscount:(576.02,XWEB)
9 -
9 - 016 fn getStockDiscount: (576.02,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=576.02
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:576.02
11 - 008c fn getcat=576
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(576)
12 -
12 - 016 fn getStockDiscount: (576,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(576)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=576
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:576
14 - 008b fn getcat=576
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(576)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

16 - START NEW
16 - 021 Call sub setStockDiscounts:(PC-35/473,XWEB)
17 - 009 fn categoryDiscount:(PC-35/473,XWEB)
18 -
18 - 016 fn getStockDiscount: (PC-35/473,XWEB)
18 - 016b fn getStockDiscount: BandA|0|BP
18 - 010 result:(BandA|0|BP)
18 - 012 result1:Category=PC-35/473
18 - 013 result1:blnTopCat=False
19 - 008a fn getcat:PC-35/473
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:(521.31,XWEB)
23 - 009 fn categoryDiscount:(521.31,XWEB)
24 -
24 - 016 fn getStockDiscount: (521.31,XWEB)
24 - 016b fn getStockDiscount: BandA|0|BP
24 - 010 result:(BandA|0|BP)
24 - 012 result1:Category=521.31
24 - 013 result1:blnTopCat=False
25 - 008a fn getcat:521.31
26 - 008c fn getcat=521
26 - 014a blnTopCat1:(False)
26 - 014a varParentCat1:(521)
27 -
27 - 016 fn getStockDiscount: (521,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 014 blnTopCat1:(False)
27 - 014 getCat1:(521)
27 - 014 result1:(BandA|0|BP)
27 - 012 result2:Category=521
27 - 013 result2:blnTopCat=False
28 - 008a fn getcat:521
29 - 008b fn getcat=521
29 - 014a blnTopCat2:(True)
29 - 014a varParentCat2:(521)
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

TO
CLEAR

Stock Code: PC35

Oil Spot

Firing Range: 1200-1240°C (Cone 5-6)

Sizes

Stock

Price

473ml

0

£10.10

Details & Buy

Item Properties
UnitPrice:10.32, DisplayPrice:10.32, ExchPrice:10.32, RoundPrice:10.32
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:11637, CATID:, ExCat:521.31
strPhotoName: products/PC-39-473.jpg
Image: PC-39-473
StrPhoto: /dbimages/products/PC-39-473.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 0.77
Discount Tracker :

1 - START NEW
1 - 021 Call sub setStockDiscounts:(4030/25,XWEB)
2 - 009 fn categoryDiscount:(4030/25,XWEB)
3 -
3 - 016 fn getStockDiscount: (4030/25,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=4030/25
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:4030/25
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:(576.02,XWEB)
8 - 009 fn categoryDiscount:(576.02,XWEB)
9 -
9 - 016 fn getStockDiscount: (576.02,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=576.02
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:576.02
11 - 008c fn getcat=576
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(576)
12 -
12 - 016 fn getStockDiscount: (576,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(576)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=576
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:576
14 - 008b fn getcat=576
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(576)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

16 - START NEW
16 - 021 Call sub setStockDiscounts:(PC-35/473,XWEB)
17 - 009 fn categoryDiscount:(PC-35/473,XWEB)
18 -
18 - 016 fn getStockDiscount: (PC-35/473,XWEB)
18 - 016b fn getStockDiscount: BandA|0|BP
18 - 010 result:(BandA|0|BP)
18 - 012 result1:Category=PC-35/473
18 - 013 result1:blnTopCat=False
19 - 008a fn getcat:PC-35/473
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:(521.31,XWEB)
23 - 009 fn categoryDiscount:(521.31,XWEB)
24 -
24 - 016 fn getStockDiscount: (521.31,XWEB)
24 - 016b fn getStockDiscount: BandA|0|BP
24 - 010 result:(BandA|0|BP)
24 - 012 result1:Category=521.31
24 - 013 result1:blnTopCat=False
25 - 008a fn getcat:521.31
26 - 008c fn getcat=521
26 - 014a blnTopCat1:(False)
26 - 014a varParentCat1:(521)
27 -
27 - 016 fn getStockDiscount: (521,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 014 blnTopCat1:(False)
27 - 014 getCat1:(521)
27 - 014 result1:(BandA|0|BP)
27 - 012 result2:Category=521
27 - 013 result2:blnTopCat=False
28 - 008a fn getcat:521
29 - 008b fn getcat=521
29 - 014a blnTopCat2:(True)
29 - 014a varParentCat2:(521)
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

31 - START NEW
31 - 021 Call sub setStockDiscounts:(PC-39/473,XWEB)
32 - 009 fn categoryDiscount:(PC-39/473,XWEB)
33 -
33 - 016 fn getStockDiscount: (PC-39/473,XWEB)
33 - 016b fn getStockDiscount: BandA|0|BP
33 - 010 result:(BandA|0|BP)
33 - 012 result1:Category=PC-39/473
33 - 013 result1:blnTopCat=False
34 - 008a fn getcat:PC-39/473
35 - 008d fn getcat:BLANK
35 - 014a blnTopCat1:(False)
35 - 014a varParentCat1:()
36 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

37 - START NEW
37 - 021 Call sub setStockDiscounts:(521.31,XWEB)
38 - 009 fn categoryDiscount:(521.31,XWEB)
39 -
39 - 016 fn getStockDiscount: (521.31,XWEB)
39 - 016b fn getStockDiscount: BandA|0|BP
39 - 010 result:(BandA|0|BP)
39 - 012 result1:Category=521.31
39 - 013 result1:blnTopCat=False
40 - 008a fn getcat:521.31
41 - 008c fn getcat=521
41 - 014a blnTopCat1:(False)
41 - 014a varParentCat1:(521)
42 -
42 - 016 fn getStockDiscount: (521,XWEB)
42 - 016b fn getStockDiscount: BandA|0|BP
42 - 014 blnTopCat1:(False)
42 - 014 getCat1:(521)
42 - 014 result1:(BandA|0|BP)
42 - 012 result2:Category=521
42 - 013 result2:blnTopCat=False
43 - 008a fn getcat:521
44 - 008b fn getcat=521
44 - 014a blnTopCat2:(True)
44 - 014a varParentCat2:(521)
45 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

TO
CLEAR

Stock Code: PC-39

Umber Float

1180-1240°C - 473ml

Sizes

Stock

Price

473ml

1

£10.32

Details & Buy

Item Properties
UnitPrice:10.1, DisplayPrice:10.1, ExchPrice:10.1, RoundPrice:10.10
Disc: 0, DiscType: BP
STOCK DISCOUNT: 0 PRODID:10789, CATID:, ExCat:521.31
strPhotoName: products/PC-50-473.jpg
Image: PC-50-473
StrPhoto: /dbimages/products/PC-50-473.jpg
Fragile : False
TaxCode : S
LineItemTax : 20
UnitWeight : 0.77
Discount Tracker :

1 - START NEW
1 - 021 Call sub setStockDiscounts:(4030/25,XWEB)
2 - 009 fn categoryDiscount:(4030/25,XWEB)
3 -
3 - 016 fn getStockDiscount: (4030/25,XWEB)
3 - 016b fn getStockDiscount: BandA|0|BP
3 - 010 result:(BandA|0|BP)
3 - 012 result1:Category=4030/25
3 - 013 result1:blnTopCat=False
4 - 008a fn getcat:4030/25
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:(576.02,XWEB)
8 - 009 fn categoryDiscount:(576.02,XWEB)
9 -
9 - 016 fn getStockDiscount: (576.02,XWEB)
9 - 016b fn getStockDiscount: BandA|0|BP
9 - 010 result:(BandA|0|BP)
9 - 012 result1:Category=576.02
9 - 013 result1:blnTopCat=False
10 - 008a fn getcat:576.02
11 - 008c fn getcat=576
11 - 014a blnTopCat1:(False)
11 - 014a varParentCat1:(576)
12 -
12 - 016 fn getStockDiscount: (576,XWEB)
12 - 016b fn getStockDiscount: BandA|0|BP
12 - 014 blnTopCat1:(False)
12 - 014 getCat1:(576)
12 - 014 result1:(BandA|0|BP)
12 - 012 result2:Category=576
12 - 013 result2:blnTopCat=False
13 - 008a fn getcat:576
14 - 008b fn getcat=576
14 - 014a blnTopCat2:(True)
14 - 014a varParentCat2:(576)
15 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

16 - START NEW
16 - 021 Call sub setStockDiscounts:(PC-35/473,XWEB)
17 - 009 fn categoryDiscount:(PC-35/473,XWEB)
18 -
18 - 016 fn getStockDiscount: (PC-35/473,XWEB)
18 - 016b fn getStockDiscount: BandA|0|BP
18 - 010 result:(BandA|0|BP)
18 - 012 result1:Category=PC-35/473
18 - 013 result1:blnTopCat=False
19 - 008a fn getcat:PC-35/473
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:(521.31,XWEB)
23 - 009 fn categoryDiscount:(521.31,XWEB)
24 -
24 - 016 fn getStockDiscount: (521.31,XWEB)
24 - 016b fn getStockDiscount: BandA|0|BP
24 - 010 result:(BandA|0|BP)
24 - 012 result1:Category=521.31
24 - 013 result1:blnTopCat=False
25 - 008a fn getcat:521.31
26 - 008c fn getcat=521
26 - 014a blnTopCat1:(False)
26 - 014a varParentCat1:(521)
27 -
27 - 016 fn getStockDiscount: (521,XWEB)
27 - 016b fn getStockDiscount: BandA|0|BP
27 - 014 blnTopCat1:(False)
27 - 014 getCat1:(521)
27 - 014 result1:(BandA|0|BP)
27 - 012 result2:Category=521
27 - 013 result2:blnTopCat=False
28 - 008a fn getcat:521
29 - 008b fn getcat=521
29 - 014a blnTopCat2:(True)
29 - 014a varParentCat2:(521)
30 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

31 - START NEW
31 - 021 Call sub setStockDiscounts:(PC-39/473,XWEB)
32 - 009 fn categoryDiscount:(PC-39/473,XWEB)
33 -
33 - 016 fn getStockDiscount: (PC-39/473,XWEB)
33 - 016b fn getStockDiscount: BandA|0|BP
33 - 010 result:(BandA|0|BP)
33 - 012 result1:Category=PC-39/473
33 - 013 result1:blnTopCat=False
34 - 008a fn getcat:PC-39/473
35 - 008d fn getcat:BLANK
35 - 014a blnTopCat1:(False)
35 - 014a varParentCat1:()
36 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

37 - START NEW
37 - 021 Call sub setStockDiscounts:(521.31,XWEB)
38 - 009 fn categoryDiscount:(521.31,XWEB)
39 -
39 - 016 fn getStockDiscount: (521.31,XWEB)
39 - 016b fn getStockDiscount: BandA|0|BP
39 - 010 result:(BandA|0|BP)
39 - 012 result1:Category=521.31
39 - 013 result1:blnTopCat=False
40 - 008a fn getcat:521.31
41 - 008c fn getcat=521
41 - 014a blnTopCat1:(False)
41 - 014a varParentCat1:(521)
42 -
42 - 016 fn getStockDiscount: (521,XWEB)
42 - 016b fn getStockDiscount: BandA|0|BP
42 - 014 blnTopCat1:(False)
42 - 014 getCat1:(521)
42 - 014 result1:(BandA|0|BP)
42 - 012 result2:Category=521
42 - 013 result2:blnTopCat=False
43 - 008a fn getcat:521
44 - 008b fn getcat=521
44 - 014a blnTopCat2:(True)
44 - 014a varParentCat2:(521)
45 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

46 - START NEW
46 - 021 Call sub setStockDiscounts:(PC-50/473,XWEB)
47 - 009 fn categoryDiscount:(PC-50/473,XWEB)
48 -
48 - 016 fn getStockDiscount: (PC-50/473,XWEB)
48 - 016b fn getStockDiscount: BandA|0|BP
48 - 010 result:(BandA|0|BP)
48 - 012 result1:Category=PC-50/473
48 - 013 result1:blnTopCat=False
49 - 008a fn getcat:PC-50/473
50 - 008d fn getcat:BLANK
50 - 014a blnTopCat1:(False)
50 - 014a varParentCat1:()
51 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

52 - START NEW
52 - 021 Call sub setStockDiscounts:(521.31,XWEB)
53 - 009 fn categoryDiscount:(521.31,XWEB)
54 -
54 - 016 fn getStockDiscount: (521.31,XWEB)
54 - 016b fn getStockDiscount: BandA|0|BP
54 - 010 result:(BandA|0|BP)
54 - 012 result1:Category=521.31
54 - 013 result1:blnTopCat=False
55 - 008a fn getcat:521.31
56 - 008c fn getcat=521
56 - 014a blnTopCat1:(False)
56 - 014a varParentCat1:(521)
57 -
57 - 016 fn getStockDiscount: (521,XWEB)
57 - 016b fn getStockDiscount: BandA|0|BP
57 - 014 blnTopCat1:(False)
57 - 014 getCat1:(521)
57 - 014 result1:(BandA|0|BP)
57 - 012 result2:Category=521
57 - 013 result2:blnTopCat=False
58 - 008a fn getcat:521
59 - 008b fn getcat=521
59 - 014a blnTopCat2:(True)
59 - 014a varParentCat2:(521)
60 - 022 Output sub arrStockDiscount: 0 - Band = BandA

END

TO
CLEAR

Stock Code: PC50

Shino

Firing Range: 1200-1240°C (Cone 5-6)

Sizes

Stock

Price

473ml

0

£10.10

Details & Buy

Found items: 4

By Type

By Temperature

By Texture

By Colour

Paperclays

By Technique

Decorating Slip

Casting Slips

Brands

Brush-on Glazes

Powdered Glazes

Dipping Glazes

Underglazes & Stains

Onglaze Colours

Lustres

Materials

glaze & slip making

Plasters

Making Tools

Modelling Tools

Throwing Tools

Slab Making Tools

plaster moulds

Brushes

tools sets

Wheels

Making Equipment

Workshop Equipment

Workshop Tools

Kilns

Temperature Control

Kiln Furniture

Firing Aids

placing aids

protective wear

sundries

Kiln Elements

Books

Bisque Ware

Whats New & Offers

About Clayman

Customer Service

Popular Categories

Get In Touch

Secure Payments