Exporting Magento Product Prices with Configurable Product Super Options

A client today needed to export their pricing for products. This is normally not hard, the admin provides a simple system to do it. But, my client was using related products with pricing modifications involving super attributes and options. Think "Shirt X costs $4.99. Large is another $2 and XL is $3 more". That doesn't export well, and the table storage for the values is a huge mystery at first. Here's the finished solution to get those prices.


Change Magento Base Url

In a some infuriating day, I have discovered there is one more step to changing a Magneto base url than most people list. It's a rare problem, and not one I expect most people will find.

The standard steps for changing magento's base url are:


Drupal Migration from Location to Address Field Mapping

With Location module quickly becoming obsolete, replaced by the dedicated separate modules: addressfield, geofield, and geocoder, it's handy to have a copy paste mapping to translate the data. Here's a field map from location to addressfield format for you.

Bulk Updating Magento Product Prices

Had a client that needed to increase their prices by 1.58%, across the entire store. They used base product prices on configurable products with super options that had their own price modifications. Think: Product A - $10. Option A (`12 oz ) +$2. The sql queries below will update the product tables as required. Note that these work only on static price adjustments, not percentage. Though, that should be easy enough to figure out given the below tables



Subscribe to Fragmented Thought RSS