Export Product data out of Magento with SQL & phpmyadmin

2014 May 23
by Furn Warrior

If you have ever tried to export product data from Magento for a bigger catalog, you would know that Magento can be very notorious in that. You can try these SQL statements to export Magento product data in parts -

 

To export SKU &  price (active product with price)

select sku, value attribute_id from mage_catalog_product_entity JOIN mage_catalog_product_entity_decimal on mage_catalog_product_entity.entity_id=mage_catalog_product_entity_decimal.entity_id where mage_catalog_product_entity_decimal.attribute_id=’68′

To export SKU & Description ( active product with description )

select sku, value from mage_catalog_product_entity JOIN mage_catalog_product_entity_text on mage_catalog_product_entity.entity_id=mage_catalog_product_entity_text.entity_id where mage_catalog_product_entity_text.attribute_id=’64′

To export SKU & Name ( active product with name )

select sku, value from mage_catalog_product_entity JOIN mage_catalog_product_entity_varchar on mage_catalog_product_entity.entity_id=mage_catalog_product_entity_varchar.entity_id where mage_catalog_product_entity_varchar.attribute_id=’63′

To export SKU & Image ( active product with image )

select sku, value from mage_catalog_product_entity JOIN mage_catalog_product_entity_varchar on mage_catalog_product_entity.entity_id=mage_catalog_product_entity_varchar.entity_id where mage_catalog_product_entity_varchar.attribute_id=’77′

To export SKU & URL ( active product with url )

select sku, value from mage_catalog_product_entity JOIN mage_catalog_product_entity_varchar on mage_catalog_product_entity.entity_id=mage_catalog_product_entity_varchar.entity_id where mage_catalog_product_entity_varchar.attribute_id=’89′

 

Hope it helps. Feel free to write comments if you have a better way of doing it.

 

——————————

Update – 05252014

You can create the above as views.Using these views, you can create another view which will give you all the essential products details in one table. This can be exported out of phpmyadmin in zipped format easily.

SELECT A.sku, E.name, A.url, C.image, D.price, B.description

FROM `active product with url` AS A

INNER JOIN `active product with description` AS B

ON A.sku=B.sku

INNER JOIN `active product with image`  AS C

ON A.sku=C.sku

INNER JOIN `active product with price` AS D

ON A.sku=D.sku

INNER JOIN `active product with name` AS E

ON A.sku=E.sku

———————————————-

VN:F [1.9.18_1163]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.18_1163]
Rating: 0 (from 0 votes)

Same Old Living Room? How To Spruce It Up With A Few Accessories

2014 May 15
by Furn Warrior

Everyone needs a little change every now and then. Maybe you’ve noticed that you haven’t been making much use out of your living room or you’re just bored with how it looks. Either way, a few changes here and and there or a new piece of furniture can leave your living room looking modern and brand new. Turn your living room into a space you actually want to come home to and spend your evenings in with a few simple additions.

 

 

Have a Plan:

 

Before you start any kind of home improvement project, it’s really helpful to have a clear image of what you want to accomplish and how you’re going to get there. Maybe all you want to do is put up some new art on your walls and bring in a new table or something, or maybe you want to completely revamp your living room with remodeling, new paint, new floors, or completely new furniture. Either way, you’ll save yourself time and money if you have a good plan when you start.

It also helps to see what other people are doing, the latest trends, and get ideas for money saving DIY projects. Pinterest, Dwellinggawker, and Tumblr are great places to start, where you’ll find tons of visual inspiration, how-tos, and can easily save the posts you like and go back to them later. Of course, even a simple Google search will help steer you towards home decorating ideas to fit your budget and style.

Rearrange:

 

 

Before you go out and buy a bunch of new furniture, take a weekend to get organized and try rearranging the furniture you have. You might find that changing up the layout of your living room is all the change you need, and there are plenty of ways to arrange your furniture to create more space in your living room. Buying a new shelf or some other accessories for better organization can free up even more space and completely change the look and feel of a room and at the same time make your life a little easier.

Upcycle:

 

Buying furniture used is a great way to save money, recycle and be eco-friendly, and end up with something totally unique for your home. You might be surprised by what you can find at thrift stores, flea markets, antique stores, and online through websites like Craigslist. There are also plenty of DIY projects that you can find online which explain how to fix up old furniture and turn it into something that looks brand new.

 

What to Buy New: