How Do I do Select Statement in _preparecollection in Magento if the table I joined in the Main table has 2 rows with 1 parent ID. Tables I have now. Table 1(Main Table) Table 2(sales_flat_invoice_comment) My Current Prepare Collection $collection…
i have a store that i have a lot of products, more than 50,000 products, and trying to figure out one of the issues with the pageload of my home page, one of them i already found it (frontend) but…
In Sales->Invoice->Invoice Grid, I added a column Payment method. In the $collection, I joined the sales_flat_order_payment table so I can pull the method of each entity_id and did it successfully. When I echo the query and use it in Mysql,…
When I use the below code for updating store credit balance to customer, I am getting this error: Fatal Error: Call to a member function setCustomer() on boolean in $balance = Mage::getModel('enterprise_customerbalance/balance') ->setCustomer($customer) ->setWebsiteId($websiteId) ->setAmountDelta($anyNumber) ->setComment($data['comment']); $balance->save();
I'm using fancybox (2.15) and elevatezoom (3.0.8) that come with Magento 1.9.2.4, to zoom the main image and create a fancybox gallery with the other images of the gallery. Fancybox is opened when clicking on the main image. What i…
I recently discovered the site I am developing in Magento 2 is missing the Postcode field in the Shipping Address form on the checkout page. I have been digging around and cannot find any reason why it is missing. I…
How to call Multiple Website Store in sub folder of main magento installation? HowMultiple Website Store call in sub folder of main magento installation directoy with same bakend. Index.php $mageFilename = '../app/Mage.php'; require_once $mageFilename; /* Store or website code */…
We need to distribute software which should contain a PHP script which will run for some minutes. Therefore I am searching a best practise way to do this in 2017. It has to be invoked by an HTTP request. There…
im trying to query a smarter search result, i checked online about Leveshtein and similiar_text but i believe Leveshtein algorithm is the best optionm how could i implement in my query the algorithm of LEvenshtein? I cant find any good…
In Magento, there's a column in Product Grid/Table which is Name. It only accepts or filter the table if you put the exact word/s. Sample is "What Happened Last Night" (just an example) If you put "What" it will filter…