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 »

WordPress-Based Shopatron Turnkey Stores

GammaFX is proud to announce a release of a new solution for Shopatron-enabled Manufacturers.   Our WordPress-based Shopatron Turnkey Store solution combines the ease of use of the leading content management system with retail-friendly Shopatron eCommerce. As a part of the solution GammaFX offers: Industry standard online store powered by WordPress and featuring a product catalog (with options), shopping cart and Shopatron checkout Integration of checkout feedback loop populating transactional data in WordPress after customer checks out with Shopatron Import of all current Shopatron product data into WordPress for current Shopatron OnBlocks users Coordination of checkout URL, masking and analytics setup with Shopatron Call  us  today to let one of our Shopatron Integration Specialists walk you through our entire array of Shopatron related services. See it in...

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 »

WordPress and iFrames

iFrames are coming!  As you may have already noticed, your favorite video sharing websites like Vimeo & YouTube had begun introducing iFrame based syndication of their embeddable players.  While this offers a variety of new features, like iPad support for embedded videos, it might be very challenging for WordPress bloggers to insert iFrame-based code into their blog posts.  By default, such code would be filtered out by TinyMCE – WordPress’ WYSIWYG (or Rich Text) editor. Fear not, the solution is simple enough.  Just add the following code to the functions.php file of your template, and voilà – life is beautiful once more. function add_iframe($initArray) { $initArray['extended_valid_elements'] = "iframe[id|class|title|style|align|frameborder|height|longdesc|marginheight|marginwidth|name|scrolling|src|width]"; return $initArray; } add_filter('tiny_mce_before_init',...

Read More »

CakePHP 500 Internal Server Error

Software CakePHP Server Environment (shared) Lynix  Apache PHP MySQL Provider: RackSpaceCloud.com Problem Description Upon installing CakePHP you receive the following error: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log.  Solution This error is caused by ModRewrite issue.  The solution is to modify you .htaccess files to adding a leading slash to urls. Open /.htacess file On line 3 change ^$ app/webroot/ to ^$ /app/webroot/ On line 4 change (.*) app/webroot/$1 to (.*) /app/webroot/$1 Save, close and upload the file to the server Open /app/.htacess file On line 3 change ^$  webroot/ to ^$ /webroot/ On line 4 change (.*)  webroot/$1 to (.*)  /webroot/$1 Save, close and upload the file to the server Open /app/webroot/.htacess file On line 5 change ^(.*)$ index.php?url=$1 to ^(.*)$ /index.php?url=$1 Save, close and upload the file to the server You are...

Read More »

Shopatron Improves Their Bidding System

To help increase efficiency Shopatron, launched the new “Quick Bid” tool today. The Quick Bid was developed entirely based on feedback garnered from Shopatron’s fulfillment partners. This new tool, allows you to place multiple bids at once, and requires less jumping back and forth between screens. The Quick Bid also lets you quickly select, save, and re-use your order viewing filters. Here are some basic features of the new tool: Set and save your Order Display options (or “filters”) so they automatically take effect the next time you view orders and place bids. Place bids from a single screen. Place multiple bids at one time. You stay on the same page after you place a bid. Since you spend less time jumping between bidding screens, you can place your bids faster. Click fewer buttons. Want to bid on all items in an order? Click the Select All button. If partial bids are not allowed, clicking one button will always select all items. View all order types with the same tool. Request standard PhysiBid, Express, In Store Pickup, and CertiBid orders without clicking a different icon. Use new, enhanced filters (such as filtering by specific manufacturer, hide status, or bid status) and find the orders you want to fill more quickly. The Quick Bid is now the default bidding interface within Shopatron and is visible upon entry to the available order...

Read More »