In addition to clear the SEARCH TERMS
ALTER TABLE catalogsearch_query AUTO_INCREMENT=1;
ALTER TABLE catalogsearch_fulltext AUTO_INCREMENT=1;
ALTER TABLE catalogsearch_result AUTO_INCREMENT=1;
TRUNCATE TABLE sales_bestsellers_aggregated_daily;
TRUNCATE TABLE sales_bestsellers_aggregated_monthly;
TRUNCATE TABLE sales_bestsellers_aggregated_yearly;
ALTER TABLE sales_bestsellers_aggregated_daily AUTO_INCREMENT=1;
ALTER TABLE sales_bestsellers_aggregated_monthly AUTO_INCREMENT=1;
ALTER TABLE sales_bestsellers_aggregated_yearly AUTO_INCREMENT=1;
In addition to clear the NEWSLETTER SUBSCRIBERS
ALTER TABLE newsletter_problem AUTO_INCREMENT=1;
ALTER TABLE newsletter_queue AUTO_INCREMENT=1;
ALTER TABLE newsletter_queue_link AUTO_INCREMENT=1;
ALTER TABLE newsletter_queue_store_link AUTO_INCREMENT=1;
ALTER TABLE newsletter_subscriber AUTO_INCREMENT=1;
ALTER TABLE newsletter_template AUTO_INCREMENT=1;
I think it will help others …
For my case, I did not enable any of the FlateRate or TableRate but another extension “Cash on delivery ” and I used shipping code “tablerate_bestway”
then after entering that value the module worked perfectly on Magento CE 126.96.36.199.
Sometime there need to be a situation to change the default attributes name for the front-end. In that case the all of the custom theme don’t have the pre-work for this. We have to make it with replace the following code ….
/view/type/options/configurable.phtml in line 35 for my case
if the file not there then please check in
and you may copy it to the theme and Change the following code inside the line
Then you should get the Label you set in Default Store View section of the attribute in admin
Currently I have faced a problm to change the email template’s background color for the tranctactional emails in magento.To change the background color of Magento’s Email templates for Magento CE 188.8.131.52, please do the following steps…
We have to copy the following css from skin/frontend/base/default/css/email-inline.css
Then you will see the default background color for emails used is #ebebeb.
It is around line 33.
It’s around line 55.
It is around line 83
Now change the value of the background and background-color properties to (e.g.) #ffffff.
Make sure to flush all caches. And now it should work.
It’s very common that the order confirmation email is not sent to the email. And it’s specially problem for the Magento 1.9.x. There is a very simple trick to make it work …
We need to change in order.php in below
We have to create one directory structure on the path below, then copy and paste the file to the path below.
Now, change from
$mailer->setQueue($emailQueue)->send(); ( for me it was line 1356)
This is one of the common error when you will going to install any magento extension or some of them.And For my case it happened many time but finally I got the solution that I mention below although there are many alternative options that I tried.
I just replace the below code in downloader/lib/Mage/HTTP/Client/Curl.php (My Magento version was 1.9.2)Read More »