string(463) "SELECT MAX(p.price) as price_max_limit, MIN(p.price) as price_min_limit, tax_class_id FROM product p 
					LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) 
					LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
					LEFT JOIN product_option_value pov  ON (p.product_id = pov.product_id)
					LEFT JOIN product_attribute pa  ON (p.product_id = pa.product_id)
					WHERE 
					p2s.store_id = 0  AND p2c.category_id  = 44 LIMIT 1"
string(535) "SELECT MAX(ps.price) as price_max_limit, MIN(ps.price) as price_min_limit, tax_class_id FROM product p 
					INNER JOIN product_special ps ON (p.product_id = ps.product_id) 
					LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) 
					LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
					LEFT JOIN product_option_value pov  ON (p.product_id = pov.product_id)
					LEFT JOIN product_attribute pa  ON (p.product_id = pa.product_id)
					WHERE 
					p2s.store_id = 0  AND p2c.category_id  = 44 LIMIT 1"
string(583) "SELECT *,m.image as image FROM manufacturer m 
					LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) 
					INNER JOIN  product p  ON (m.manufacturer_id = p.manufacturer_id)
					LEFT JOIN product_special ps ON (p.product_id = ps.product_id)  
					LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
					LEFT JOIN product_option_value pov  ON (p.product_id = pov.product_id)
					LEFT JOIN product_attribute pa  ON (p.product_id = pa.product_id)
					WHERE 
					m2s.store_id = 0 AND p2c.category_id  = 44 GROUP BY(m.manufacturer_id)"
string(470) "SELECT *,c.category_id as category_id,count(p2c.product_id) as prod_count FROM category c 
			LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) 
			LEFT JOIN category_description cd ON (c.category_id = cd.category_id) 
			LEFT JOIN product_to_category p2c ON (c.category_id = p2c.category_id) 
			WHERE c.parent_id = '44' AND cd.language_id = '1' AND c2s.store_id = '0 '  AND c.status = '1' GROUP BY c.category_id ORDER BY c.sort_order, LCASE(cd.name)"
string(832) "SELECT *,od.name as option_name, ovd.name as value_name, ov.image as value_image, count(p.product_id) as prod_count 
				FROM product_option_value pov 
			LEFT JOIN option_value ov ON (pov.option_value_id = ov.option_value_id) 
			LEFT JOIN option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) 
			LEFT JOIN `option` po  ON (pov.option_id = po.option_id) 
			LEFT JOIN option_description od ON (po.option_id = od.option_id) 
			INNER JOIN product_to_category p2c ON (pov.product_id = p2c.product_id AND p2c.category_id = 44)
			LEFT JOIN product_attribute pa  ON (pov.product_id = pa.product_id)
			INNER JOIN  product p  ON (p.product_id = p2c.product_id) 
			LEFT JOIN product_special ps ON (p.product_id = ps.product_id) 
			WHERE ovd.language_id = '1'  AND p2c.category_id  = 44 GROUP BY ov.option_value_id"
string(471) "SELECT pa1.attribute_id, ad.name, pa1.text,count(pa1.product_id) as prod_count FROM product_attribute pa1 
			 
			 LEFT JOIN attribute_description ad ON (pa1.attribute_id = ad.attribute_id)
			 WHERE ad.language_id = '1' AND pa1.language_id = '1' 
			 AND product_id IN (
			 SELECT p.product_id FROM 
			 product p
			 INNER JOIN product_to_category p2c ON (p.product_id = p2c.product_id) 
			  AND p2c.category_id  = 44) GROUP BY pa1.attribute_id,text ORDER BY ad.name"
array(0) {
}
 AND p2c.category_id  = 44
mob!le
Availability
  • HP Banner

test 12

There are no products to list in this category.

About

You can change this text from Control Panel Social band > About text

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Twitter

Facebook

 Customize theme   Save settings

Catalog mode

Default style
Remove cart and price
Remove cart

Color

Default style
Blue
Blue two
Green two
Green
Red

Product names text

Default style
Fixed three lines
Fixed two lines
Wrap newline
Cut

Header

Homepage background
Subpages background
Top links background
Top links text color
Top links color
Top links icon color
Top header link
Top header background
Top header background home

General

Homepage body background
Subpages body background
Logo text
Search text color
Search text background
Welcome text
Welcome text a
Language & currency text

Menu

Menu text
Menu text homepage
Submenu background
Megamenu background
Submenu text
Megamenu text color
Megamenu parent categories
Megamenu links

Sequencejs slider

Slide subtitle color
Slide subtitle background
Slide title color
Slide title background
Slide button color
Slide button background
Slide paragraph color
Slide paragraph background

Products

Products title
Products price
Products new price
Products old price
Products add to cart background
Products add to cart color
Products add to cart background hover
Products add to cart color hover

Products badge

Sale badge background
Sale badge color
Sale badge border color
Popular badge background
Popular badge color
Popular badge border color
New badge background
New badge color
New badge border color

Product page

Product title
Product description
Product price
Product tax price
Product button-cart background
Product button-cart background hover
Product button-cart color
Product button-cart color hover
Product tab color
Product tab color hover
Product tab-active color

Footer

Newsletter background
Footer background
Footer column text
Footer links
Powered text

Header

Welcome text
Search text
Logo text
Top header link

Menu

Menu text
Submenu text
Megamenu links

Sequencejs slider

Slide subtitle
Slide title
Slide button
Slide paragraph

Products

Products title
Products price
Products new price
Products old price

Product page

Product title
Product description
Product price
Product price-tax

Footer

Footer title
Footer text
Power text

Header

Show logo text
Show logo image
Show text under logo
Show welcome visitor
Show language
Show currency
Show search
Show phone number
Show opencart default login
Show top bar

Product page

Show share widget
Show review
Show buy now button
Show excluding tax price
Show product tags
Show wishlist, compare
Show default related products
Description height

Category page

Show category info
Show category thumb in megamenu
Add to cart

Products

Hover buttons
Hover add to cart
Hover quickview
Add to cart button
Sale badge
Rating
Product description
Product name
Product price

Footer

Show newsletter
Show footer
Show social band
Show powered by
Show social-network
Show scroll to top btn
Background style
Disable background pattern
Satinweave
Diamond upholstery
Black Linen
White wall2
Diagonal noise
Always grey
White sand
Fancy deboss
Fabric 1
Wavecut
Wild oliva
Subtle white feathers
Polaroid
Square bg
Circles
Ice age
Pw maze white
Subtle surface
Micro carbon
White plaster
Gradient squares
Burried
Darkdenim3
Pineapplecut
Rockywall
Wavegrid
Argyle
Az subtle
Real cf
Paper
P6
Skelatal weave
Lyonnette
Grid
Green gobbler
Binding dark
White texture
Witewall 3
Little pluses
Polonez car
Paper fibers
Tactile noise
Triangles
Mirrored squares
Cardboard 1
Rubber grip
Wood 1
Diagonal waves
Black scales
Solid
Xv
Low contrast linen
Felt
Weave
Hexabump
Arches
Husk
Lil fiber
Subtle dots
Slash it
White leather
Striped lens
Bedge grunge
Light grey floral motif
Concrete wall 2
Gray jean
Dimension
Strange bullseyes
Little triangles
Vaio hard edge
Lghtmesh
Noisy grid
Ticks
White bed sheet
Dark mosaic
Light checkered tiles
Moulin
Twinkle twinkle
Cutcube
Reticular tissue
Ricepaper2
Cracks 1
Farmer
Scribble light
Nami
Dirty old shirt
Denim
Fabric of squares gray
Extra clean paper
Linen
Type
Simple dashed
Straws
Norwegian rose
Greyzz
White paperboard
Textured paper
Fake brick
Rip jobs
Dark leather
Mooning
Frenchstucco
Navy blue
Light wool
Broken noise
Noisy
Noise pattern with crosslines
Billie holiday
Wall4
Triangles pattern
Soft wallpaper
Retina wood
Subtle stripes
45degreee fabric
Noisy net
Texturetastic gray
Woven
Concrete wall 3
Escheresque
Nasty fabric
Candyhole
Stucco
Dark dotted
Clean textile
Arab tile
Binding light
Tweed
Handmadepaper
Linedpaper
Worn dots
Squares
Hexellence
Tapestry pattern
Cream dust
Double lined
Black thread
Silver scales
Green fibers
Small tiles
Tex2res1
Dark geometric
Flowers
Rough diagonal
Green dust scratch
Blizzard
Blu stripes
White carbonfiber
Chruch
Random grey variations
Gridme
Kuji
Stitched wool
Subtle orange emboss
Whitey
Purty wood
Black paper
Gplaypattern
Vertical cloth
Rebel
Diamonds
Gold scale
Soft circle scales
Absurdidad
CrissXcross
Egg shell
Asfalt
Furley bg
Dust
Pool table
Grid noise
Ps neutral
P5
Batthern
Stacked circles
Merely cubed
Carbon fibre
Ecailles
Embossed paper
Psychedelic pattern
Cubes
Washi
Pinstriped suit
Dark fish skin
Squairy light
Skewed print
Creampaper
Fake luxury
Vintage speckles
Foggy birds
Wood pattern
Leather 1
Subtle zebra 3d
Climpek
Black twill
Wood 1.jpg
Kindajean
Paper 1
Crossed stripes
Crosses
Tex2res2
Concrete wall
Crisp paper ruffles
Carbon fibre big
Lightpaperfibers
Daimond eyes
Hoffman
First aid kit
Whitediamond
Flowertrail
Grey wash wall
Light honeycomb
Plaid
Pyramid
Inflicted
Blackmamba
Dark wood
Light toast
Elegant grid
Dark dotted2
Zigzag
Classy fabric
Irongrip
Dark circles
Greyfloral
Polyester lite
Project papper
Debut light
Elastoplast
Diagonal striped brick
Small crackle bright
Use your illusion
Pw maze black
Smooth wall
Blackorchid
Txture
Perforated white leather
Brushed alu dark
Redox 02
Ravenna
Brickwall
Bo play pattern
Beige paper
Black linen v2
Debut dark
Groovepaper
Tiny grid
Dark Tire
Black lozenge
Shinedotted
MochaGrunge
Old wall
White brick wall
Outlets
Grey sandbag
White wall
Littleknobs
Bright squares
Cross scratches
Checkered pattern
Geometry
Px by Gre3g
Gray sand
Tileable wood texture
60degree gray
White wave
Textured stripes
Assault
Carbon fibre v2
Subtlenet2
Hixs pattern evolution
Black denim
Dark exa
Redox 01
Natural paper
Ricepaper
Bgnoise lg
Tex2res5
Corrugation
Tasky pattern
Soft kill
White tiles
Shattered
Exclusive paper
Tex2res3
Sneaker mesh fabric
Light alu
White carbon
Brillant
Paper 2
Robots
Connect
Escheresque ste
Old mathematics
Padded
Retro intro
Grey
Dvsup
Tex2res4
Grilled
Honey im subtle
Pw pattern
P1
Darth stripe
Cream pixels
Black mamba
Knitting250px
Struckaxiom
Cardboard flat
Subtle carbon
Stressed linen
Quilt
Snow
Graphy
Skin side up
Starring
Pixel weave
P4
Office
White wall hash
Lined paper
Dark stripes
Cork 1
Fabric plaid
Diagonales decalees
Foil
Triangular
Dark matter
Paper 3
Cartographer
Subtle grunge
Cardboard
Grunge wall
Wood 2
Brushed alu
Diagmonds
Roughcloth
Nistri
Paven
Cloth alike
Pinstripe
Subtle freckles
Wide rectangles
Swirl
Gun metal
Shinecaro
P2
Noise lines
Dark brick wall
Soft pad
Shl
Vichy
Light noise diagonal
Agsquare
Dark wall
Knitted netting
Otis redding
Large leather
Back pattern
  Note: To add custom background image just upload the png images to the nico_theme_editor/patterns folder and they will be available here.
Patterns from subtlepatterns.com

The import tool overwrites your store settings such as product images and module configuration, please make backups before using and preferably use on a new opencart installation

Choose store to import
css folder writable - OK
js folder writable - OK
Notice: index.php write permission failed, speed cache can't be automatically installed, you need to set write permission for /home/www/nico/mobile2/catalog//../index.php
Speed cache already installed
Saving is disabled in the DEMO version!