Andrew Maury

personal blog

Change attributes on existing configurable product in Magento

I recently need to add a product attribute to an existing configurable product in Magento. The product allowed for the 'size' attribute to be selected, but I needed to add 'color'. I couldn't find a way in the Magento Admin and tried a couple different imports, but ended up changing this directly in the database.

To do this, go to the table 'catalog_product_super_attribute'. You'll need to insert the new option for the configurable product here. You can find the product_id in the admin (in the ID column - not the SKU column). You can also find the attribute_id in the admin by going to Catalog -> Attribute -> Manage Attributes. Then select the attribute you'd like to add. You'll see the attribute ID at the end of the URL (e.g. example.com/admin/catalog_product_attribute/edit/attribute_id/12).

Insert a new product_super_attribute_id with the attribute_id and the product_id. Then just check it in your admin to confirm. Make sure to make backups first.

Google Shopping = Next Google Wave?

Watch out, Amazon, there's a new kid on the retail block and it comes with a familiar name tied to it: Google is said to be discussing a new service with various retailers that would offer web shoppers super speedy delivery.
via consumerist.com

Sounds like another good concept, but not something that's going to catch on. People don't even use Google Checkout much compared to Amazon or PayPal. Will they now change their shopping habits to pay and buy through Google?

Old article, but a good reminder of how awful Donald Sterling is

Sterling "wanted tenants that fit his image," according to testimony Davenport gave in a discrimination lawsuit brought against Sterling in 2003 by 19 tenants and the nonprofit Housing Rights Center. (That case ended in a confidential settlement in 2005; attorneys for the Center declined to comment for this story. In a separate suit, also concluded in 2005, Davenport claimed Sterling sexually harassed her, and lost. She declined comment. The Magazine has obtained depositions in both cases.) Cultivating his image, Davenport said, meant no blacks, no Mexican-Americans, no children (whom Sterling called "brats") and no government-housing-subsidy recipients as tenants. So according to the testimony of tenants, Sterling employees made life difficult for residents in some of his new buildings. They refused rent checks, then accused renters of nonpayment. They refused to do repairs for black tenants and harassed them with surprise inspections, threatening residents with eviction for alleged violations of building rules.
via sports.espn.go.com

Also "The Clippers have reached the second round of the playoffs just once in that time, going 701-1,317 overall, for a .347 winning percentage that is easily the worst among the four major sports. Horrible trades, disastrous drafts, endless injuries -- with Sterling at the helm"

Happy he doesn't own a team I root for. Sorry Clippers fans.

New Moment Comi 192 Skis

Just got my Moment Comi 192 skis today. They are huge and and I can't wait to use them. Thanks to ALPENTOLIC from the Teton Gravity Forums for hooking me up with a great price on these pow skis. Definitely in good shape and by far the biggest skis I've owned. Rockered in the front. Can't wait for some powder. Here's a few photos.

 

(download)

 
Posterous theme by Cory Watilo