Magento is an open-source e-commerce platform written in PHP for e-commerce web sites. Magento employs the MySQL/MariaDB relational database management system, the PHP programming language, and elements of the Zend Framework. It applies the conventions of object-oriented programming and model–view–controller architecture. Magento also uses the entity–attribute–value model to store data.

Share tech news, updates, or what's on your mind.

Sign up to Post

Unusual High CPU CLoud watch alarm from my AWS Ec2 Instance. The Ec2 Instance consists of Magento 2 website and Wordpress websites. The Magento 2 site is loading very slow accessing when the server is UP. But the server goes down for every 30 mins approx.  In the Apache Error log, it shows :

[Mon Mar 19 01:29:55.216115 2018] [lbmethod_heartbeat:notice] [pid 2571] AH02282: No slotmem from mod_heartmonitor
[Mon Mar 19 01:30:01.432626 2018] [mpm_prefork:notice] [pid 2571] AH00163: Apache/2.4.27 (Amazon) OpenSSL/1.0.2k-fips PHP/5.6.32 configured -- resuming normal operations
[Mon Mar 19 01:30:01.432665 2018] [core:notice] [pid 2571] AH00094: Command line: '/usr/sbin/httpd'
[Mon Mar 19 01:35:45.104754 2018] [mpm_prefork:notice] [pid 2571] AH00169: caught SIGTERM, shutting down
[Mon Mar 19 01:37:03.874296 2018] [suexec:notice] [pid 2570] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)

This unusual activity started on March 12th before that the server went down only once in a month. Any Idea on what causing this issue? Is it apache MPM prefork version or Magento codes? I don't know how to troubleshoot this.
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

We are creating a product page and this product has 2 configurable types, I will call them LONG and SHORT. We have implemented a double swatch extension that does a very good job of allowing using to configure a product with various options.

We are trying to figure out if we can have the image swatch sizes for LONG set to 100 x 20 and the swatch image sizes for SHORT be set to 20 x 20.

Is this possible in Magento 2 to have 2 swatches, but different sizes. I only see a single place to change swatch image size in the file: vendor/magento/module-swatches/etc/view.xml

I have inherited a Magento shopping cart that is hosted on an old shared server, which does not offer SSLs. The site works well though.

I have copied the files and database over to a new hosting package that supports SSL and been able to replicate the website.

Although the new site works, it is painfully slow. There does not seem to be any notable errors in the log files.

Is anyone able to advise where I can track down the problem?

I have checked that the database connection is working fine and that the server seems to process test PHP files ok.

The site is at

Thank you
Hello Experts!

I am trying to get a bundled product in the shopping cart to add the " Additional Accessories " to total what the additional shipping cost is.

For example - One Product: Light Booth: <-- shipping price: 250.00
Additional bundled item:
Accessory: Table Stand. <----shipping price: 100.00

The shopping cart only will show 250.00 with this product in the cart.

So the extension is called the Product Matrix from

Thank you all !
I want to capture 80% amount in For example I have placed order with 1000 amount and I can see this amount in sand box in unsettled transaction, I have searched api, by this api we can to capture 800 amount only. How to implement this in magento? Anyone have idea? Please let me know. Please find link here.
Hi folks

We support a Magento shop for which we recently enabled Nginx as a front end. All is good, however the Wordpress blog located at ./blog is being ignored, instead Magento tries to serve the location, and ends up in a 404.

I know this is due to the Nginx config not correctly redirecting for the /blog folder, but I don't know enough about Nginx to fix it.

There is a .htaccess file in the /blog folder, which looks like this:
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /blog/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /blog/index.php [L]

# END WordPress

Open in new window

However this is now being ignored.  I have tried to add various bits of code to the Nginx config to no avail.  Please can someone fix my Nginx config to allow the Wordpress blog to work.  Either by redirecting to the correct index.php, or just excluding the /blog path from Nginx and allowing Apache to do it's thing.

This is on a Plesk-controlled CentOS server, so shared hosting is involved.  Here is the current NGINX config:
## These locations would be hidden by .htaccess normally
location ^~ /app/                { deny all; }
location ^~ /includes/           { deny all; }
location ^~ /lib/                { deny all; }
location ^~ /media/downloadable/ { deny all; }
location ^~ /pkginfo/            { deny all; }
location ^~ /report/config.xml   { deny all; }
location ^~ /var/

Open in new window


I hope that someone is able to help. The web development team have changed the current website that we are using. We have an order download application that integrated into mageno.

The issue is that I try to change the endpoint address to the following and I receive an error:

Error message is attached(error1)

I have also tried to generate a proxy class using the same error message.

My issue is that I can browse to this URL ok.

I would appreciate any help. I have contacted the hosting company and they don't have any iea.

Best Regards,

We have a new site under development, running on Magento and are looking for an extension that allows customers to "Make an offer" for a product.  There are many of these extensions out there, however we have not been able to locate one that works with CONFIGURABLE PRODUCTS. All of the products in our store are configurable and NOT simple products.

Can anyone recommend a well-performing extension of this nature that meets the following criteria:

1.  Works with configurable products
2. Allows a NON logged-in site visitor to make an offer ie. does not require registration and login first.

Hello everyone,

I am needing to remove UPS, Ground, Free Shipping etc whenever a certain product is in the cart or checkout.  I was able to remove the free shipping class when products with a Freight class are set in the back end.

The other challenge is the logic then to make sure if the same product going to CA lands in the $300 class but if it is going to GA then it should ship in the Freight_250 class. Im thinking that maybe that can be removed thru magento? But still would need the UPS and Ground etc whenever a Freight_class isnt showing.

The product is the Product Martrix Extension.

Thank you all!
I have a magento website in which I need to change the footer. I see the address change on the actual design area of the settings and I change it but it does not change the footer address. Do I need to get into the actual files to change it or am I missing the area in which I change that information?
Get expert help—faster!
LVL 12
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

I'm using Magento and when I log the queries I get , e.g
SQL: INSERT INTO `catalog_product_entity_varchar` (`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?) 
BIND: array (
  0 => 4,
  1 => 85,
  2 => 0,
  3 => 243,
  4 => '/b/b/bb1052wrb_6.gif',
  5 => 4,
  6 => 86, etc, etc

Open in new window

Is there a handy-dandy way of getting the sql with the placeholders replaced by the values so i can tug it apart easily?
Hello there,

I have a question. I'm using magento 1.9 and I have a problem to figure out how to menage and solve this problem.

Basically, I have one product. Inside this product, I want to put another product with the quantity selection too. Right now, I made my page and I load a product with the basic custom options -> chechbox. This works fine, but I would like to give the options to the costumer to select two different quantity.

Think about a ticket, you can buy 4 ticket but just for 2 you want the special options.

I also tried the grouped products. But I don't want to make 3 product every time (one grouped product, one specific ticket, and the one special option). If I do this, I should make one grouped product and maybe I will load dynamically by id the two products in the page. So that, I will have one grouped products for all the products that I want to use with this options.

So, because I'm making my own phtml page, I'm looking if there is any specific code to put the checkbox options manually inside with the quantity too. The ticket will change, but this options would be static.

Ex: show_product.phtml


$sku = $_GET["event"];

 $vPath = $sku.".html";
 $oRewrite = Mage::getModel('core/url_rewrite')

  $iProductId = $oRewrite->getProductId();
  $oProduct = Mage::getModel('catalog/product')->load($iProductId);

  $id = $iProductId;

  //get id 

Open in new window

I am unable to import large magento database (more then 11 mb) using phpmyadmin under ubuntu operating system.

I have already increase "post_max_size=100M" and "upload_max_size=100M" using php.ini file

The Error is showing after importing file:
"Script timeout passed,if you want to finish import please resubmit the same file and import will continue."

i have also resubmitted the same file but same error is showing.
Please help how to solve the issue.

I am trying to figure out how to sort SKUs in the sales order and in the shopping cart in Magento (ver. Ideally we would like ascending SKU order. Any ideas on how to accomplish this?

Thanks in advance!
Is a good practice to instantiate a Magento help in the constructor?

public function __construct()

Open in new window

hi, I managed to create a magento module with a custom collection.
I have now to import a CSV file into the database as a part of module initialisation, so I'm using

Open in new window

$content = $helper->getFileContents($path); //Varien_File_Csv() 

Open in new window

I'm looping into content in this way, as I want discard duplicates rows from the csv. So I thought about pushing data into an array before saving.

foreach ($content as $row){
if (!in_array(getManagerName($row), $managers)){  

        try {
        } catch (Exception $e){
        $managers[$managersModel->getId()]= getManagerName($row);

Open in new window

Question is, is there any other faster or better approach I could use to limit db transaction eg: saving the entire collection after removing duplicates?
I need to get a basic install of Magento  up - so I decided to use the Azure 'Magento CE v1.9.1.0 on Ubuntu 14.04LTS'.

When I browse to the IP of the VM Magento returns error

"There has been an error processing your request
Exception printing is disabled by default for security reasons.

Error log record number: 1489044056301"

When I look at error  1489044056301 in /var/www/magento/var/report$

It shows:

[b]a:4:{i:0;s:107:"SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)";i:1;s:2280:"#0 [/b]

Open in new window

Stumbled at the first hurdle. Why is it not connected to MYSQL?

The readme file says to start mysql but it alreay appears to be started.

I thought I would simply need to start the VM.

Anyone with experience with this Azure Template/VM got a quick answer?
I would like to change my layered navigation so users can only selected 1 item per drop down.
as a bonus, I would like it to behave like old style ajax menus
I have 4 different drop down menus in my layered navigation and they are all attributes. Ideally, the first drop down would cause the second drop down to populate, the second -> populate third drop down, the third -> populate fourth drop down. Is it possible to modify my layered navigation to behave this way? What files and functions could i modify to accomplish this?
I need to modify how products are displayed in the layered navigation and search results. I have many products that have the same attribute value so I want to add a GROUP BY so only one of each products displays if they have the same attribute value. What page and functions do I modify to add this?
Free Tool: Port Scanner
LVL 12
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

how to add search bar after the top links in magento 2?
i am facing this issue but really dont know how to solve it. please tell me the solution even if its really simple for you as i am having a hard time solving it. whenever a customer sign ups to my website magento confirmation email have some code file in attachment .is there anyone to stop that code file in attachments
After ordering an item and going to checkout page..

By default, the form is showing in this order:

Street Address
Zip/Postal Code
I want to it to be in this order:

Zip/Postal Code
Street Address
I already re-order the first three(country, zip and state) by adding this:

<item name="sortOrder" xsi:type="string"> *** </item>

Open in new window

But there is no city and street address on \vendor\magento\module-checkout\view\frontend\layout\checkout_index_index.xml

How will I put the street after city?
My hosting provider upraded the server where one of my client's site was hosting using magento.  Since the upgrade, I am getting this message whenever anybody tries to checkout.
Fatal error: Class 'Mage_Checkout_Model_Type_Onepage' not found in /home/nicolas/public_html/app/code/local/Amasty/Customerattr/Model/Rewrite/Checkout/Type/Onepage.php on line 3

Not sure what to do.
sir i am tryint to import file byt the file is not properly uploaded it gives me error .

1-Skipping import row, required field "sku" is not defined.
2-Imported 0 records
I already save into utf-8 but still it is showing the error.

While trying to register a customer via a magento 2 extension, I always get We Can't save customer. I have tracked the filed responsible for it but couldn't resolve it.

I have attached the file for further inspection






Magento is an open-source e-commerce platform written in PHP for e-commerce web sites. Magento employs the MySQL/MariaDB relational database management system, the PHP programming language, and elements of the Zend Framework. It applies the conventions of object-oriented programming and model–view–controller architecture. Magento also uses the entity–attribute–value model to store data.

Top Experts In