AirHead.com & SportStuff.com

Introducing the new AirHead.com & SportStuff.com Running on a single Magento platform, this multi-site implementation features clean, mobile-friendly, responsive template designed and implemented by GammaFX from ground up. In addition to standard Magento functionality both sites include sophisticated Banner Management system, Mega Menu navigation and integration with Shopatron XML...

Read More »

Magento 1.5.0.1 – Problem Importing Images with Advanced DataFlow Profiles

Software Magento 1.5.0.1 Server Environment (dedicated) Lynix/Windows Apache PHP MySQL Problem Description After upgrading to 1.5.0.1 version of Magento, CSV-based import does not import images.  All other product information gets imported correctly, but images are being ignored. Workaround (solution pending) Upgrade to the latest version of Magento (at the moment it is ver. 1.5.1.0-beta1).  Create a new import profile just for images and bring them in separately. To do so follow the steps below: go to System > Import/Export > Dataflow – Profiles. Click Add New Profile. Setup a profile and select NO for “Original Magento attribute names in first row” (see attached screenshot) Map the fields to the ones in your CSV Save and Run the profile with your CSV As long as the product is already imported the image CSV can just have a sku, image, thumbnail, small_image fields. If the product does not exist, you’ll get an error on that line. Hope this helps...

Read More »

Magento 1.5.0.1 – SQLSTATE[42S02]: Base table or view not found…

Software Magento 1.5.0.1 Server Environment (dedicated) Lynix Apache PHP MySQL Problem Description When using  Insert Image function in Magento’s WYSIWYG,  Create Folder function results in the following error: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘colorado_soybu.magento_core_directory_storage’ doesn’t exist Solution The issue is caused by a missing “core_directory_storage” table.  To remedy you’ll need to run the following command on your MySQL database (please make sure that you replace “mag_” table prefix with your own): CREATE TABLE IF NOT EXISTS mag_core_directory_storage ( `directory_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT ”, `path` varchar(255) NOT NULL DEFAULT ”, `upload_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`directory_id`), UNIQUE KEY `IDX_DIRECTORY_PATH` (`name`, `path`), KEY `parent_id` (`parent_id`), CONSTRAINT `FK_DIRECTORY_PARENT_ID` FOREIGN KEY (`parent_id`) REFERENCES mag_core_directory_storage (`directory_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT...

Read More »