Yearly Archives - 2015

Magento Dataflow Error

Magento 1.9.2 Dataflow Export Error – Undefined index: website

Shortly after updating Magento 1.9.1.1 to 1.9.2 I needed to do a Dataflow export of product data. When the 'Run Profile In Popup' button was pressed I was almost instantly greeted with an error messages. Notice: Undefined index: website in /var/www/vhosts/domain.com/htdocs/app/code/core/Mage/Catalog/Model/Convert/Parser/Product.php on line 510 To fix this issue I had to make 3 changes to the Product.php file. Line 423 change 'websites'      => '', to 'website'      => '', Line 436 change $row['websites'] = join(',', $websiteCodes); to $row['website'] = join(',', $websiteCodes); Line 438 change $row['websites'] = $this->getStore()->getWebsite()->getCode();...

Read more...

Moving Magento To Another Server

Overview Here is an overview of the steps we’ll take to do this: Make a MySQL dump file of the database Archive the media and theme directories Copy the files to the other server Install a clean version of Magento Import the dump file to a blank database Move our copied data to the correct places Old Server The first thing you’ll want to do is login to the server where Magento currently resides. You will need to go to the directory where Magento is installed. For the...

Read more...

M2ePro slow to add products to listings groups on large catalog

If your running a Magento store with a large catalog of products you may notice that when adding products using the 'Add from product list' option that it can become very slow to load. The problem is related to the fact that MySql query used for adding the products to the Listing works differently on the different versions of MySql servers. There is an alternative query already written in the code that should be much faster. Please look at the specified files: app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/Product/Grid.php app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Amazon/Listing/Product/Grid.php app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Buy/Listing/Product/Grid.php app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Play/Listing/Product/Grid.php 1. Find...

Read more...

Magento M2ePro ‘1690 BIGINT UNSIGNED’ Database Error

Recently we have come across a few clients that have an SQL database error appear in the search tab of the M2ePro eBay Listings page. The error looks like this; Fatal error occurred: “SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(SELECT COUNT(*) FROM (SELECT DISTINCT `l`.`account_id`, `l`.`marketplace_id`, `main_table`.`product_id`, `cpev`.`value` AS `product_name`, `cpe`.`sku` AS `product_sku`, `em`.`currency`, `ebit`.`item_id` AS `ebay_item_id`, `main_table`.`status`, `second_table`.`online_sku`, `second_table`.`online_title`, (second_table.online_qty - second_table.online_qty_sold) AS `online_qty`, `second_table`.`online_qty_sold`, `second_table`.`online_buyitnow_price`, `l`.`id` AS `listing_id`, `l`.`title` AS...

Read more...