5 Things to Learn in Interior Design Class

2015 August 27
by Furn Warrior

The daunting task of pulling together a space that wasn’t just a bedroom in a fully furnished house, seemed like an impossible chore. As with all things, it took practice, a few moves, and some divine (design) inspiration to finally feel comfortable decorating  home.

1: Personalize your space.

If someone were to walk into your home, they should know that it’s yours. The best way to achieve this is by including accessories that reveal your hobbies and interests.You may be surprised to discover that styling an outfit isn’t too different from decorating a room. So take a look in your closet. What colors are you drawn to? Do you prefer mod or modern? Clean cuts or lacy ruffles? Use your taste in clothing as a style guide for your home–it’s an easy way to ensure your space is 100% you.

2: Keep comfort in mind.

Have you ever purchased a piece of furniture simply because it was pretty, only to discover that it’s painfully uncomfortable (or useless)? comfort is key. When I think of “home sweet home,” the first word that comes to mind is cozy. Making your home comfy and cozy is a must. Nothing is worse than going to a friend’s house and awkwardly balancing on their post-modern chair. Your space should be inviting and comfortable.

3:Work with your surroundings.

It’s important to understand your design limitations. Consider your environment and respond to it. Whether you’re in the city or the countryside, it helps to take a cue from your surroundings. In turn, you can narrow down your choices based on the context of your space.

4: Stick with the classics.

Using classic furniture, prints, and fabrics provides you with a basic foundation to build on with trendy or personalized accessories and finishes.You love the shape and feel of the piece, but the finish or fabric is all wrong. In this situation, I say: invest! There are plenty of ways to transform an older, classic shaped piece of furniture. If it’s a sofa: reupholster, add throw pillows… An aged dresser: paint it! The possibilities are endless when it comes to updating a timeless piece.

5 Less is more.
Keep it simple. You don’t want to overcrowd your space. If you edit the items in each room, the area will appear to be cleaner and even bigger. Just remember, you can always add more!

 

If you have any additional suggestions, please share them.

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

Home Decorating: How to Choose Colors

2015 August 27
by Furn Warrior

When one is home decorating on a budget, one of the easiest and cheapest ways to change the look of any home is to add color. Choosing the right colors for your home decorating can seem like such a daunting task however, that some people are frozen in indecision. Here are some great, easy guidelines to help teach you how to choose colors for your home.

* Keep in mind colors in a room offer a psychological effect as well. Here is a quick run down of the most common colors, and how they affect those in the same environment.

  • Red – The color of love and passion, red tends to cause a lively feeling to any room. It can enhance appetite and feel energetic.
  •  Yellow – The color of optimism. You can’t help but to feel good in a sunny yellow room!
  • Blue- Seen as trustworthy, loyal. Blue is a calming color that feels like sky and water.
  • Green – The color of nature and peace. Soothing color that is easiest on the eye. Some greens are now used as neutrals in a room.
  • Purples – The color of royalty and luxury. It can be both uplifting and calming at the same time, depending on whether there is more blue or red in the undertone.

Remember that paint is relatively cheap, and if you don’t end up liking the final result, you can always repaint, or use a glaze over the paint job to tone it down. Don’t let fear keep you from adding color to your life, and to your home decorating, on a budget!

* Identify a feeling that you want to convey in the home. This will go a long way towards helping you choose the right color scheme. If you are looking for a warm color scheme that wraps you in comfort, try deeper colors in warmer shades such as reds, gold, browns and some greens. Want a light, uplifting feeling? Sunny yellows might be just the ticket. Looking for a calming, serene atmosphere? Pale sky blues, spring greens and lilacs are what you are looking for.

Even if you love your color scheme, be cautious with big purchases. “Don’t commit to large, colorful furniture, because if you get tired of the color, it is much more expensive to replace,” DeWalt says. This bedroom uses the palette with neutral furniture and blue-green accessories.

Traditional Living Room by Mary DeWalt Design Group
Accessories provide the color in rooms with neutral walls. Here the blue and green come in through the cushions, throw pillows, rug and pots. Grouping accessories in threes keeps tabletops interesting yet clutter free.

Note which rooms are visible to one another. Walk through your house and note which spaces you can see from each room. Use a floor plan (a rough sketch is fine) to keep track.

Adjoining rooms are part of this, but you may be able to see quite a bit farther — down a hall and into the kitchen, for instance. These notes will form the basis of your whole-house color plan, so keep them close at hand.

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

Get Dropdown values of all product attribute from Magento Database with sql

2015 May 31
by Furn Warrior

Here is another sql that will help you in getting the list of entity_id, sku and attribute value.

For e.g.

SELECT A.entity_id, B.sku, C.value
FROM `mage_catalog_product_entity_int` AS A
INNER JOIN `mage_catalog_product_entity` AS B
on A.entity_id=B.entity_id
INNER JOIN `mage_eav_attribute_option_value` AS C
on A.value=C.option_id
WHERE A.attribute_id =’218′

 

attribute_id is the id of the attribute that you want to get the value for. You can find this value when you login to magento admin – > manage attributes -> click on that attribute and this value will be visible in the URL.

The above SQL statement will give you list of all the active product entity_id, sku and values of the attribute needed.

Hope it helps. Will be back soon with another Magento Musing.

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

Magento admin missing product images

2015 May 31
by Furn Warrior

Hi Guys,

Another short note on Magento musings. After working a lot on missing product images in magento admin, we found out that magento admin missing images can be fixed using this sql -

 

insert into catalog_product_entity_media_gallery (attribute_id, entity_id, `value`)
select ga.attribute_id, v.entity_id, v.value 
from catalog_product_entity_varchar v
inner join eav_entity_type et on et.entity_type_code='catalog_product'
inner join eav_attribute va on va.entity_type_id=et.entity_type_id and va.frontend_input='media_image' and va.attribute_id=v.attribute_id
inner join eav_attribute ga on va.entity_type_id=et.entity_type_id and ga.attribute_code='media_gallery'
left join catalog_product_entity_media_gallery g on g.entity_id=v.entity_id and g.value=v.value
where v.value<>'no_selection' and v.value<>'' and g.value is null;

The reason it happens is because while importing products, magento does not automatically create values in media_library. After importing products regularly,
you should run this script so that both media_gallery table and product_entity_varchar image values can remain in sync.
Hopefully that will solve the problem of magento delete images after product edit in admin.
We will be back with another update soon.
HT : http://www.unirgy.com/blog/2009/03/importing-product-images-with-csv/

VN:D [1.9.18_1163]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.18_1163]
Rating: 0 (from 0 votes)

21 Must Have Free Magento Extensions for your Ecommerce store

2015 May 22
by Furn Warrior
  1. Junaid Super marketplace – for sending orders directly to your vendors. : FREE ( you might have to tweak it a little )
  2. For sending SMS/Text updates to your customer - www.mage-sms.com   : Not Free but Pay as you Go
  3. Creare SEO for SEOing your Magento Store – FREE
  4. Freshdesk Support ToolFreshdesk is available for free to handle your support needs. Magento plugin for Freshdesk takes care of integration with your store. – FREE
  5. ANARAKY GDRT – plugin for Google Remarketing.
  6. Fooman Analytics – for implementing universal Google Analytics implementation, much better than default google api functionality in magento – FREE
  7. Fooman Speedster for minifying the js & CSS files and improving Site Speed  - FREE
  8. Activo – SEO friendly categories : FREE
  9. 1 skip checkout – Allows users to skip registration while placing orders – FREE
  10. Login Redirect-  to take customers back to page they came from after login. Its helpful : FREE
  11. Magemonkey – for Mandrill which allow you to send email from Mandrill server so that your emails don’t end up in spam folder., Gives you abandoned cart functionality, gives your mailchimp’s email marketing facility: FREE
  12. Region Management – to disallow users in certain states from placing the orders.
  13. Cloudflare – Makes your Magento site speed SUPERFAST – FREE
  14. Yireo Disablelog – cleans up magento Log automatically : FREE
  15. Magmi importer – allows you to import to Magento site in much faster way – FREE
  16. Auto Related Products – helps you to automate the related product process automated
  17. Responsive Custom Menu for your site – FREE

More to come ….I’ll update it as I remember or use more.

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

Jesson Dark Brown Modern Media Cabinet DC-5

2015 January 22


The Jesson Contemporary Media Cabinet was designed especially for your ever-growing DVD collection. With specially-sized fixed-position shelves and wide-swinging doors, this DVD storage cabinet can fit dozens of media cases with ease. Made in Malaysia with an engineered wood frame, the Jesson DVD cabinet features dark brown faux wood grain paper veneer with matte silver metal door handles. Assembly is required….read more

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

How to Organize a China Cabinet

2014 October 13
by Furn Warrior

The far east pantry shelves as well as china buffets are widely-used through many people to be able to elegantly show any china collection. For many, on the other hand, buffets be a catch-all regarding all kinds of bits and pieces, through in which homemade pot your own relative colored that you any dried-up rose bouquet you have for a wedding party and that is currently slowly and gradually looking towards particles. Coordinate your own china cupboard and recover it is rightful area to be a great piece of furniture that may in addition flaunt your own china and very pieces.
Starting any The far east Display case:

Apparent the particular cupboard. Eliminate everything from the particular china cupboard and collection this besides using a kitchen table as well as on to the ground. Airborne dirt and dust the particular china buffet totally and make use of goblet solution to clean almost any glass-front cupboard entrance doors. Fresh the within regarding almost any storage also.

Coordinate your own products. Go through the products anyone removed from the particular china cupboard. Make piles regarding circumstances to give away, items to package in place, circumstances to dispose of and physical objects you wish to return to the particular hutchto possibly be viewable as well as stored.

Start off at the pinnacle. On the top space of your buffet, setup groups regarding very wines glasses, floral vases as well as additional beautiful glassware. Quite a few china buffets use a mild collection above the particular best space. Inserting very products on top space enables the particular mild to be able to luster to them, creating a wonderful show.

Create the particular discs. Set up a number of cosmetic discs over the returning with the minute space. This discs really should seem to be “leaning” against the returning wall membrane. The china hutch needs any ridge over the space for only in which purpose. In any other case, you will need to buy a number of plate holders.

Coordinate a number of teacups and saucers while watching discs. And keep the particular teacups through rattling while an individual walks through using a weighty follow, area any caffeine separate out involving the pot along with the saucer. Minimize this to install so that it does not indicate beneath the tea pot.

Finish this off. Exhibit inspired bowls, floral vases as well as additional large and exciting products around the bottom part space. Last but not least, setup the particular china hutch being well-designed. Complete the particular storage, if almost any, together with placemats, tablecloths and sheets and pillowcases napkins. When you have the space, you might like to retailer your own tableware inside hutch.

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

The Best way to set up a Dining Room

2014 October 13
by Furn Warrior

Collecting all your family throughout the kitchen home furniture is the best way to spending some time together. The particular kitchen is said to be the bedroom where all your family complies with together to get a secure evening associated with supper and also chat. In a few residences, this kind of merely happens immediately after the many debris along with your table may be swept away from and also transferred on top of various other piece of kitchen home furniture. Prevent dinner-time cleaning by means of arranging the kitchen to produce the attractive living space regarding foods that will is always fresh and also interesting, certainly not chaotic and also sloppy. Keep reading regarding points and also tips on what to prepare some sort of kitchen.
Techniques for Organizing some sort of Lounge:

Take away the debris. Eating platforms, making use of their wide, smooth types of surface, tend to be magnets regarding debris, and you tend not to desire to contest with that will whilst consuming supper. Form the items from a kitchen home furniture in to heaps. The moment sorted, arrange the items with selected canisters. You will understand precisely finding the items you’re looking for once you’ve a functioning process available. By way of example, you should position a few holders along the wall regarding build items when you frequently operate the kitchen dining room table regarding build initiatives.

Take stock of your respective products. Provide almost any outdated dinners, tablecloths, placemats or other products in the kitchen that you do not frequently utilize. Manage the items you keep by means of coloration or design and also keep all of them neatly in the compartments associated with other kitchen home furniture, just like buffets or cina cupboards, regarding simple entry.

Choose the best home furniture. The table can be a have to yet 12 chairs aren’t. Go many of the dining chairs out of the bedroom whenever its not necessary all of them, and the bedroom can experience much less chaotic and much more organized. Squeeze in a cina cupboard or buffet on the bedroom regarding design and also regarding storing dining room table bed sheets, cina and also dinnerware.

Generate guidelines regarding the usage of your kitchen. In the event you let your kids to use your dining room table regarding groundwork, by way of example, designate some sort of hard drive regarding bags and also school items lowered in dining chairs which can be whisked aside or hidden. This is some sort of hole table along the wall, gift basket or other furniture piece that you could go from the bedroom after groundwork is completed.

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

The Best Way to Freshen a Futon Mattress

2014 October 13
by Furn Warrior

Futons are definitely more when compared with disaster bedsheets with regard to friends. A number of entrepreneurs choose futons above standard mattresses because they are typically cheaper when compared with standard mattresses and they are convertible, a feature that is perfect for modest rooms. Such as standard a mattress, futon a mattress need freshening regularly so they really don’t develop smells. The ones associated with nurturing futons range between airing them outside to help cleanup them that has a rainy cloth; what we choose will depend on the state of hawaii of your mattress. Search underneath to help be able to freshen some sort of futon mattress.
Freshening some sort of Futon Mattress:

Atmosphere out there the actual futon on the sunny day. Spot the actual futon mattress level in addition to change it above following a couple of hours. Also you can hold it coming from a series. Should the futon incorporates a stratum associated with airborne debris, overcome it out there that has a 2-by-2 amount while futon is usually dangling on the line.

Make use of cooking soda to take out smells. Dust cooking soda liberally above one particular part in the mattress. Encourage the dust to help take a seat on the actual futon for around 30 minutes and remove it that has a vacuum cleaner. Do it again conversely.

Take away staining. Drop some sort of cloth with drinking water blended with some sort of slight detergent in addition to shake it out there. Polish the actual spots for the futon inside a spherical motion. Drop yet another cloth with drinking water, shake it out there and wash the actual soaked spots. Allow futon dried up absolutely.

Thoroughly clean the actual futon. Lay the actual futon mattress level about the figure or on to the floor. Apply one particular part together with upholstery better in addition to polish it thoroughly clean that has a brush or possibly a dried up cloth. Clean over grubby suds that has a spoon or make use of a vacuum, and wash the actual futon thoroughly clean that has a wet cloth. Encourage the part to help dried up absolutely before transforming it above. Do it again the method with the different part. Work towards modest portions at any given time.

Stage the actual futon. When there are lumps within your futon mattress, place it level in addition to walk into it. Pay attention to the actual high spots in addition to attempt to shift the actual filling up to the skinny spots.

Rotate the actual futon. Rotate in addition to change the actual futon mattress at least one time every thirty days in order that you are choosing each part of the usb ports. If not, the actual futon will certainly sag within the position you generally lie about.

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

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)