texts: What's the reason for running a price reindex after placing an order?

texts:
After placing an order Magento triggers a price reindex (which sometimes takes too long) and fails placing the order (because reindex is part of the transaction):

> SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try
> restarting transaction SQL Query: INSERT INTO
> `catalog_product_index_price_tmp` SELECT
> `catalog_product_index_price`.* FROM `catalog_product_index_price`
> WHERE (entity_id IN('39074', '39075', '39076', '39077', '39078',
> '49702', '49703', '49704', '49705', '49706', '49708', '52288',
> '52289', '52291', '52292')) SQL Params: Array ( )

And, because there is an email if the transaction fails, this seems to be expected (otherwise this email wouldn't be implemented).

In order to fix this, I moved the reindex outside the transaction, but I am still puzzled why this is needed.


texts:
I have added custom option in product as selectbox. Its showing fine on frontend but in select box + sign  its showing. Is there a way to remove + Sign Symobl

Select Box options are

-- Please Select --

400x600x300 + Rs1,992.00

450x600x300 + Rs2,121.00

I have change js/varien/configurable.js
changed this line

var str = '';
    price = parseFloat(price);
    if(showSign){
        if(price<0){
            str+= '-';
            price = -price;
        }
        else{
            str+= '+'; **to**
            str+= ' ';
        }
    }

But it's not working.


texts: Magento 2 - Problem with datetime attribute product

texts:
In Magento2 : When I saved date attribute with time is the same picture below. After I saved it only save date and get no time.
 Any know reason and how to fix it?

In database: after saved

When I changed format from \Magento\Framework\Stdlib\DateTime\Filter\Date  to
        \Magento\Framework\Stdlib\DateTime\Filter\DateTime and then I got:

Recoverable Error: Argument 7 passed to Magento\Catalog\Controller\Adminhtml\Product\Initialization\Helper::__construct() must be an instance of Magento\Framework\Stdlib\DateTime\Filter\DateTime, none given, called in
D:\xampp\htdocs\magento\var\generation\Magento\Catalog\Controller\Adminhtml\Product\Initialization\Helper\Interceptor.php on line 15 and defined in <br>
D:\xampp\htdocs\magento\vendor\magento\module-catalog\Con`troller\Adminhtml\Product\Initialization\Helper.php on line 57


texts: Manage Item page in Banner 7 showing blank

texts: On my staging site I witnessed a weird issue, Manage Item page in Banner 7 under Magnetothem menu is showing blank.


texts: When I upload products with images using csv on magento 2.2.6. The error is showing

texts:
Imported resource (image) could not be downloaded from external resource due to timeout or access permissions.

and error_log showing

Stack trace:
#0 /home/mindbsoul/public_html/staging/vendor/magento/module-catalog-import-export/Model/Import/Product.php(2055): Magento\CatalogImportExport\Model\Import\Product\MediaGalleryProcessor->saveMediaGallery(Array)

[21-Feb-2019 14:10:28 UTC] PHP Fatal error:  Uncaught Error: Cannot unpack array with string keys in /home/mindbsoul/public_html/staging/vendor/magento/module-catalog-import-export/Model/Import/Product/MediaGalleryProcessor.php:112


texts: Magento 2 Image upload in table view to store configuration page

texts:
We want to add the "Image Upload" option to table view type multiple fields under store configuration section using system.xml. Check the below screenshot for more clarification.

Any help/suggestion will be highly appreciated. Thank you.


texts:
I use the bellow code to display short review summery.

<?php echo $this->getLayout()->createBlock('review/helper')->getSummaryHtml($product, 'short', false); ?>

What is wired to me is that on one web site it works, but on another one it want show up anything. And I use multiple domains. Any ideas?


texts: Where do I put .php, .js, .html, .css files from a 3rd party lib that interfaces with an extension I develop?

texts:
Let's say I want to develop a Magento extension that interfaces to, say, an Open Source charting package or an image gallery or whatever that is NOT part of the extension itself. When downloaded (separate from the extension) the 3rd party lib comes in its own single .zip with all its .php, .js, .html and .css together.

Do I place on the poor site-owner who wishes to install my extension together with the 3rd party lib, the burden of pulling the original 3rd party .zip apart and make them put .js in /js, .php in /lib, .css in /skin etc?

Or is there a generally accepted "dumping ground" for any 3rd party .zips where one can conveniently unzip the download AS IS and be done with it?


texts: New field created is not being displayed in the backend order

texts:
I created a new field for the client to fill the same in the checkout. I created it from the following code in an sql file:

<?php
    $installer = $this;
    $installer->startSetup();

    $installer->addAttribute("customer", "referencia",  array(
        "type"     => "varchar",
        "backend"  => "",
        "label"    => "Referencia",
        "input"    => "text",
        "source"   => "",
        "visible"  => true,
        "required" => false,
        "default" => "",
        "frontend" => "",
        "unique"     => false,
        "note"       => "")
    );

    $attribute   = Mage::getSingleton("eav/config")->getAttribute("customer", "referencia");

    $used_in_forms=array();

    $used_in_forms[]="adminhtml_customer";
    $used_in_forms[]="adminhtml_checkout";
    $used_in_forms[] = "customer_address_edit";
    $used_in_forms[] = "customer_address";
            $attribute->setData("used_in_forms", $used_in_forms)
            ->setData("is_used_for_customer_segment", true)
            ->setData("is_system", 0)
            ->setData("is_user_defined", 1)
            ->setData("is_visible", 1)
            ->setData("sort_order", 100)
            ;
            $attribute->save();

    $installer->endSetup();
?>

In the billing.phtml file, I added the following input:

       <?php echo $this->__('Referência: ') ?>

            <input style="width: 100% !important;" class="input-text" id="billing:referencia" name="billing[referencia]" title="<?php echo $this->__('Pontos de Referência') ?>" onchange="salvarDadosSession(5,$j(this).val())" value="<?php echo Mage::getSingleton('core/session')->getPontoReferencia(); ?>" />

If I enter a client in the backend and go into account information, the "referencia" field appears there normally, but when a purchase is completed and goes in the same order in the backend, it does not appear there.


texts: Magento 2 how edit price field in configurable product in admin panel

texts:
We enabled the price field in the configurable product edit form. The price is saving in the database but in the form always showing 0 value. please suggest how We show the saved price in the price field.

my di file code
<type name="Magento\ConfigurableProduct\Ui\DataProvider\Product\Form\Modifier\ConfigurablePrice">
       <plugin name="enable_price_configurable_product" type="Awa\ConfigurablePrice\Plugin\DataProvider\Product\Form\Modifier\ConfigurablePrice" sortOrder="20" disabled="false"/>
   </type>

my plugin file code
namespace Awa\ConfigurablePrice\Plugin\DataProvider\Product\Form\Modifier;

use Magento\Catalog\Ui\DataProvider\Product\Form\Modifier\AbstractModifier;
use Magento\Catalog\Api\Data\ProductAttributeInterface;
use Magento\Catalog\Model\Locator\LocatorInterface;
use Magento\ConfigurableProduct\Model\Product\Type\Configurable as ConfigurableType;
use Magento\ConfigurableProduct\Ui\DataProvider\Product\Form\Modifier\ConfigurablePrice as ConfigurablePriceCore;
/**
 * Data provider for price in the Configurable products
 */
class ConfigurablePrice extends ConfigurablePriceCore
{
    /**
     * {@inheritdoc}
     *
     * Added after listener for make price field editable in configurable produc edit page.
     */
    public function afterModifyMeta($subject, $result)
    {
        $groupCode = $this->getGroupCodeByField($result, ProductAttributeInterface::CODE_PRICE)
            ?: $this->getGroupCodeByField($result, ConfigurablePriceCore::CODE_GROUP_PRICE);

        if (!empty($result[$groupCode]['children'][ConfigurablePriceCore::CODE_GROUP_PRICE])) {
            $result[$groupCode]['children'][ConfigurablePriceCore::CODE_GROUP_PRICE]['children']['price']['arguments']['data']['config']['component'] = 'Magento_Ui/js/form/element/abstract';
        }

        return $result;
    }
}


texts: Magento 2 : Face Error while create a custom block

texts:
I got the below error when create the Custom Block for the HTML sitemap.

  Error filtering template: Warning: Declaration of
  Vapor\Sitemap\Block\Sitemap\Category::_getHtml(Magento\Framework\Data\Tree\Node
  $menuTree, $childrenWrapClass, $limit, $colBrakes = Array) should be
  compatible with
  Magento\Theme\Block\Html\Topmenu::_getHtml(Magento\Framework\Data\Tree\Node
  $menuTree, $childrenWrapClass, $limit, array $colBrakes = Array) in
  C:\xampp\htdocs\Magento\app\code\Vapor\Sitemap\Block\Sitemap\Category.php
  on line 62

Block Code

<?php
namespace Vapor\Sitemap\Block\Sitemap;
// use Magento\Framework\View\Element\Template\Context;
use Magento\Framework\View\Element\Template;
// use Vapor\Sitemap\Model\Sitemap\CmsPages;
// use Vapor\Sitemap\Block\Sitemap\Cms;
// use Vapor\Sitemap\Block\Sitemap\Category;
class Index extends Template
{
    const SITEMAP_CUSTOM_TEMPLATE = 'Vapor_Sitemap::sitemap/sitemap.phtml';

    /**
     * [__construct]
     * @param \Magento\Framework\View\Element\Template\Context $context
     * @param \Magento\Framework\Stdlib\DateTime\Timezone      $_stdTimezone [description]
     * @param array $data
     */
    protected $getSitemap;

    public function __construct(\Magento\Framework\View\Element\Template\Context $context,\Magento\Framework\Stdlib\DateTime\Timezone $_stdTimezone,
        array $data = [])
    {
        parent::__construct($context, $data);
        $this->getSitemap();

    }

    /**
     *
     * @return html
     */
    protected function _toHtml()
    {
        return parent::_toHtml();
    }
    /**
     * @return Mixed data
     */
    public function getSitemap()
    {
        //echo "ComeHere";exit;
        $this->setTemplate(self::SITEMAP_CUSTOM_TEMPLATE);
        return $this;
    }
}

Can anyone help to solve this.

Any help would be appreciated.

Thanks in advance..!


texts:
I'm trying to install composer on my Ubuntu 12.04 LTS machine, for Magento2 installation but the following error occurs:

Some settings on your machine make Composer unable to work properly.
Make sure that you fix the issues listed below and run this script again:

The json extension is missing.
Install it or recompile php without --disable-json

I check that JSON is already installed through below command -

aptitude show php5-json

which shows below result -

Package: php5-json
State: installed
Automatically installed: no
Version: 1.3.7-1+deb.sury.org~precise+1
Priority: optional
Section: php
Maintainer: Debian PHP PECL Maintainers <pkg-php-pecl@lists.alioth.debian.org>
Architecture: amd64
Uncompressed Size: 117 k
Depends: libc6 (>= 2.14), libjson-c2 (>= 0.11-3~), phpapi-20121212, ucf
Conflicts: php5-json
Breaks: php5-common (< 5.5.0~rc1+dfsg-1~), php5-common (< 5.5.0~rc1+dfsg-1~), php5-dev (< 5.5.0~rc1+dfsg-1~), php5-dev (< 5.5.0~rc1+dfsg-1~)
Replaces: php5-dev (< 5.5.0~rc1+dfsg-1~), php5-dev (< 5.5.0~rc1+dfsg-1~)
Provided by: php5-common
Description: JSON module for php5
 This package provides a module for JSON functions in PHP scripts.

 PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially
 suited for web development and can be embedded into HTML.

please help to overcome with this.


texts:
In Magento 2, when I went to change my store mode from Developer to Production from cmd(putty), it will return one error message

Command return non-zero exit code :

So how can I fixed it and if possible then please tell me is there anything wrong from our side.

Thanks!


texts: Magento2 Grid : Why is inline editing not default?

texts:
We have been using M1 for say 7 years now. Recently we switched to M2 and were somewhat surprised that there is no inline editing in the data grids. Is there some reason why Magento is not adding this per default - it feels like a no brainer. In 2020 this sounds quite logical to have for an ecom system.
How can Magento2 inline editing in grids be activated?


texts: Magento 2.3.4l: When installing PHP SDK I find "Your requirements could not be resolved to an installable set of packages"

texts:
I'm attempting to install walmart-partner-api-sdk-php from github using composer. Below is what I see on running the command to install. Any advice as to how to fix this is appreciated.
Your requirements could not be resolved to an installable set of packages.
  Problem 1
    - Installation request for fillup/walmart-partner-api-sdk-php ^1.0.9 -> sati                  sfiable by fillup/walmart-partner-api-sdk-php[1.0.9].
    - Conclusion: remove guzzlehttp/guzzle 6.5.5
    - Conclusion: don't install guzzlehttp/guzzle 6.5.5
    - fillup/walmart-partner-api-sdk-php 1.0.9 requires guzzlehttp/guzzle ^5.3.1                   -> satisfiable by guzzlehttp/guzzle[5.3.1, 5.3.2, 5.3.3, 5.3.4].
    - Can only install one of: guzzlehttp/guzzle[5.3.1, 6.5.5].
    - Can only install one of: guzzlehttp/guzzle[5.3.2, 6.5.5].
    - Can only install one of: guzzlehttp/guzzle[5.3.3, 6.5.5].
    - Can only install one of: guzzlehttp/guzzle[5.3.4, 6.5.5].
    - Installation request for guzzlehttp/guzzle (locked at 6.5.5) -> satisfiabl                  e by guzzlehttp/guzzle[6.5.5].

Installation failed, reverting ./composer.json to its original content.


texts: Create fabric product which has meter as unit with default length

texts:
Want to create a fabric type of product which has Meter/Centi meter as selling unit in Magento 2.
I'm following this Question Can you sell product (fabric) by the metre in Magento?, we can use decimal unit in quantity with simple product which will work / please share other approach also.
I want this product to have 2 meters by default and than customer can add more as per his requirement. How can we achieve this.
Like
2 + User Input => This I can think we can achieve by custom option (other suggestion are also appreciated ) , but how can we have the default 2 meter quantity/ length for the product ?


texts: Find out how many times a product was ordered

texts:
I am trying to find out how many times a product was ordered over the last two weeks.
So far I have a loop getting the products.

    foreach($productCollection as $product){

    }

I assume I should be able to get the order details with this placed inside the loop

    $order_items = Mage::getResourceModel('sales/order_item_collection')

I am a little unsure about how to filter this. I know that it needs to be filtered by product id and also the order must have been made within the last 2 weeks.

What should the syntax look like for this query, please?


texts: Autoload error: '/...app/code//Infortis/Infortis' has been already defined in '/...app/code//Infortis/Infortis'.setup-cron:

texts:
This is theme file i installed manually into app folder. noted it is saying it has been already defined in Infortis/Infortis.setup-cron, but i can not find that file or cron schedule. How can I fix this issue? ( I think this might be the reason my configuration cache is always invalidate)

In setup.cron.log

> Autoload error: Module 'Infortis_Infortis' from
> '/home/myusername/public_html/app/design/code/Infortis/Infortis' has
> been already defined in
> '/home/myusername/public_html/app/code/Infortis/Infortis'.setup-cron:
> Please check var/log/update.log for execution summary.


texts: Change Customer Account Sidebar Menu Navigation Title

texts:
I want to change magento 2 customer navigation sidebar menu title.

for example: Account information turns into My Profile

What I've done so far:

customer_account.xml

<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="2columns-left" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd" label="Customer My Account (All Pages)" design_abstraction="custom">
    <body>
        <referenceContainer name="sidebar.main">
            <block class="Magento\Framework\View\Element\Html\Links" name="customer_account_navigation" before="-" cacheable="false" template="Magento_Customer::account/navigation.phtml">
                <referenceBlock name="customer-account-navigation-account-link" remove="true"/>
                <referenceBlock name="customer-account-navigation-account-edit-link">
                    <arguments>
                        <argument name="label" xsi:type="string" translate="true">My Profile</argument>
                        <argument name="path" xsi:type="string">customer/account/edit</argument>
                    </arguments>
                </referenceBlock>
            </block>
        </referenceContainer>
    </body>
</page>


texts: Examples of magento 1 modules that works with 3-rd party API

texts:
Recently I started to work with Magento 1, so want to learn how to do things right. Now I have some task - search through 3-rd party API (I am interesting how Magento works with another API, not own Magento REST API).
It is difficult to understand how can I pass some data (response from API service) from the controller to blocks. There are different ways to do it, but which one is better?
And other good practices.

Will be very thankful for any examples or articles...


texts: Where is Option Id of Newly Added Option For Bundle Product?

texts:
So  I have a module, which I am using to set a custom field in bundle options. I have implimented my module successfully. However I came to a situation to which I can't move on without get an answer for this problem.

In my module, in order to save data to my custom fields, I am observing to <catalog_product_save_after />. In my custom table,along with my custom field id and its content, I want to save option_id and store_id. Things work fine, for product that have already bundle options. For such products, I can get option_id and store_id. But for newly created options for product, option_id field seems to empty. I don't know how to get option_id.

Method I am using to get option details : $product->getBundleOpitonsData()

When echo this, I am getting a result like this.

Array
(
[7] => Array
    (
        [description_id] =>
        [description_new] =>
        [title] => bla bla title
        [description] => bla bla description
        [option_id] =>
        [delete] =>
        [type] => select
        [required] => 1
        [position] =>
    )
 [1] => Array
    (
        [description_id] => 1
        [description_new] => no
        [title] => test
        [description] => new description
        [option_id] => 30
        [delete] =>
        [type] => select
        [required] => 1
        [position] => 0
    )

 ----------
)

As you can see, for newly created option(array[7]), option_id field is empty. But for an already existing option (array[1]), option_id DOES exist.

Note : In Mage_Bundle module, there is an observer for the event <catalog_product_prepare_save />. In the mentioned obsever, we can see that options are SETing.

public function prepareProductSave($observer)
{
    $request = $observer->getEvent()->getRequest();
    $product = $observer->getEvent()->getProduct();

    if (($items = $request->getPost('bundle_options')) && !$product->getCompositeReadonly()) {
        $product->setBundleOptionsData($items);
    }
}

If that is correct, before invoking my observer, option is setting through the bundle observer. Then Why option_id field is empty for new option ?

Please help me friends. I can't move on without your help. Eagerly waiting for your reponses


texts: Dotmailer connector API error while disabled from admin panel

texts:
My Magento 2 module is disabled from my admin panel..

but i still got this exception in exception.log file


texts: Why preference is not working in Magento 2?

texts:
I am trying to implement error report in magento 2 so for that purpose i would like to mail all the errors in email. So I started with prefernece.

di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../lib/internal/Magento/Framework/ObjectManager/etc/config.xsd">
  <preference for="Magento\Framework\App\ErrorHandler" type="Pulsestorm\HelloWorldMVVM\Model\ErrorHandler"/>
</config>

ErrorHandler.php

<?php
namespace Pulsestorm\HelloWorldMVVM\Model;

/**
 * An error handler that converts runtime errors into exceptions
 */
class ErrorHandler extends \Magento\Framework\App\ErrorHandler
{
    protected $errorPhrases = [
        E_ERROR => 'Error',
        E_WARNING => 'Warning',
        E_PARSE => 'Parse Error',
        E_NOTICE => 'Notice',
        E_CORE_ERROR => 'Core Error',
        E_CORE_WARNING => 'Core Warning',
        E_COMPILE_ERROR => 'Compile Error',
        E_COMPILE_WARNING => 'Compile Warning',
        E_USER_ERROR => 'User Error',
        E_USER_WARNING => 'User Warning',
        E_USER_NOTICE => 'User Notice',
        E_STRICT => 'Strict Notice',
        E_RECOVERABLE_ERROR => 'Recoverable Error',
        E_DEPRECATED => 'Deprecated Functionality',
        E_USER_DEPRECATED => 'User Deprecated Functionality',
    ];

    public function handler($errorNo, $errorStr, $errorFile, $errorLine)
    { echo"hii"; exit;
        if (strpos($errorStr, 'DateTimeZone::__construct') !== false) {
            // there's no way to distinguish between caught system exceptions and warnings
            return false;
        }

        $errorNo = $errorNo & error_reporting();
        if ($errorNo == 0) {
            return false;
        }

        $msg = isset($this->errorPhrases[$errorNo]) ? $this->errorPhrases[$errorNo] : "Unknown error ({$errorNo})";
        $msg .= ": {$errorStr} in {$errorFile} on line {$errorLine}";
        throw new \Exception($msg);
    }
}

I try echo exit at top of class (after namespace) but it showing nothing it means class is not calling. Is there any mistake in di.xml.


texts: magento 2 configurable products has not shipping methods in checkout

texts:
In my Magento 2 (2.1.11) configurable products has not shipping methods in checkout.

Configurable and virtual products has weight

How to fix it ?


texts: Conditional Instructions for Bank Transfer Payment Method

texts:
1.7.0.2 CE

I want to provide distinct instructions for the Bank Transfer Payment Method dependent/conditional on the Customers Billing Address Country.

If customer billing address country is AU then use 'Instructions AU'
else use 'Instructions USA'

I believe the file that handles the instructions is
app/design/frontend/base/default/template/payment/info/banktransfer.phtml

<?php
/**
 * @see Mage_Payment_Block_Info
 */
?>

<?php echo $this->escapeHtml($this->getMethod()->getTitle()) ?>

<?php if ($this->getInstructions()): ?>

            <?php echo nl2br($this->getInstructions()) ?>

<?php endif; ?>

Ideally the instructions could be injected from a Static Block


texts: How do I get a website id from a store id?

texts: Given a store id, how do I get the website id that matches that store?


texts: I am trying to install facebook php business sdk but i am getting below Fatal error

texts:
I am trying to install facebook php business sdk but I am getting below Fatal error.
I used the below command
composer require facebook/php-business-sdk
But I am below fatal error
Fatal error: Allowed memory size of 1610612736 bytes exhausted (tried to allocate 134217736 bytes) in phar:///opt/cpanel/composer/bin/composer/src/Composer/DependencyResolver/RuleSet.php on line 83
For reference please find the below image


texts:
In attempting to avoid rewriting the Mage_Checkout_Block_Onepage_Shipping_Method_Additional block, I've been following my current strategy of removing the block with the old class and adding a new one with my new class:

<checkout_onepage_shippingmethod>
  <remove name="root" />
  <block type="my_checkout/onepage_shipping_method_additional" name="my.root" as="root" output="toHtml" template="checkout/onepage/shipping_method/available.phtml" />
</checkout_onepage_shippingmethod>

This works great for non-root blocks, but my alias technique doesn't seem to work in this case. Any ideas?

PS: I'm aware that this can be done with a rewrite.


texts:
I'm trying to understand what particular impact may have a problem I'm facing with when deploying a Magento 2 project.

I run a set of commands in order to update the website and refresh/reindex/update all caches and data.

cd /var/www/sites/php7m2/httpdocs/magento;
n98-magerun2.phar db:query "update core_config_data set value='http://magento.%vm%.php7m2.ci1.interactivated.me/' where path like '%base_url%'";

git pull origin;
git checkout %branch%;

git diff --name-only %branch% master;

rm -rf /var/www/sites/php7m2/httpdocs/magento/var/di;
php -f bin/magento setup:upgrade;
php -dmemory-limit=2G bin/magento setup:di:compile;

for command in \$(git diff --name-only master %branch% | grep Console); do command_code=\$(basename \$command); filename="\${command_code%.*}"; echo \$filename; php bin/magento interactivated:shell \$filename; done;

bin/magento setup:static-content:deploy nl_NL;

n98-magerun2.phar cache:clean;

And it fails on the step where I'd perform compilation:

$ php -dmemory_limit=-1 ./magento setup:di:compile
Compilation was started.
Repositories code generation... 1/7 ====>----------------------- 14% 1 sec 66.0 MiB
PHP Fatal error: Class 'Google_IO' not found in app/code/Magecheckout/SocialLogin/Model/Google/Oauth2/io/Google_CurlIO.php on line 27

So my questions here are:
1. is the command "setup:di:compile" meant to be run mandatory whenever an update of the site is performed?
2. what should be done with this problem? Does it have to be fixed or it's not a problem if the files were not compiled?
3. is the set of commands is generally correct? Just guessing if I'm doing things in wrong order or something like this.


texts: Magento 2 Error click on admin grid edit

texts:
Magento2 error  when clicking edit configurable product

below error shown

  2 exception(s): Exception #0 (Zend_Db_Statement_Exception):
  SQLSTATE[42S22]: Column not found: 1054 Unknown column
  'entity_value.value' in 'field list', query was: SELECT
  entity.sku, product_entity.entity_id AS product_id,
  attribute.attribute_code, entity_value.value AS value_index,
  attribute_label.value AS super_attribute_label,
  IFNULL(option_value.value, default_option_value.value) AS
  option_title, default_option_value.value AS default_title FROM
  catalog_product_super_attribute AS super_attribute  INNER JOIN
  catalog_product_entity AS product_entity ON
  product_entity.entity_id = super_attribute.product_id  INNER JOIN
  catalog_product_super_link AS product_link ON
  product_link.parent_id = super_attribute.product_id  INNER JOIN
  eav_attribute AS attribute ON attribute.attribute_id =
  super_attribute.attribute_id  INNER JOIN catalog_product_entity AS
  entity ON entity.entity_id = product_link.product_id  INNER JOIN
  catalog_product_entity AS entity_value ON
  entity_value.attribute_id = super_attribute.attribute_id AND
  entity_value.store_id = 0 AND entity_value.entity_id =
  entity.entity_id  LEFT JOIN catalog_product_super_attribute_label AS
  attribute_label ON super_attribute.product_super_attribute_id =
  attribute_label.product_super_attribute_id AND
  attribute_label.store_id = 0  LEFT JOIN eav_attribute_option AS
  attribute_option ON attribute_option.option_id = entity_value.value
  LEFT JOIN eav_attribute_option_value AS option_value ON
  option_value.option_id = entity_value.value AND option_value.store_id
  = 1  LEFT JOIN eav_attribute_option_value AS default_option_value ON default_option_value.option_id = entity_value.value AND
  default_option_value.store_id = 0  INNER JOIN
  cataloginventory_stock_status AS stock ON stock.product_id =
  entity.entity_id WHERE (super_attribute.product_id = 24079) AND
  (attribute.attribute_id = '') AND (stock.stock_status = 1) ORDER BY
  attribute_option.sort_order ASC

  Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054
  Unknown column 'entity_value.value' in 'field list'

So help me, someone.
Thank You


texts: Difference Between Sales Quote and Sales Quote Address

texts:
I am looking which collect_totals observer I can use. There are two observers,
sales_quote_collect_totals_before and sales_quote_address_collect_totals_before.

They can be found in /app/code/core/Mage/Sales/Model/Quote.php and /app/code/core/Mage/Sales/Model/Quote/Address.php.

I wonder what is the difference between the two files as both files have the collect total functions?


texts:
I have customized Magento 2 home page using custom theme extends from luma theme.

While Header customization, change color "header.wrapper" it's not reflecting. But some other properties are working.

For Example Change body background color its working fine. Some properties class only not working.

Example:

I added my less file

  vendor/Themename/web/css/mycss.less.

  .panel.wrapper {
   background-color: green;
 }

This is my default.xml file:

  vendor/Themename/Magento_Theme/default.xml

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
    <head>
    <css src="css/mycss.css"/>
    </head>
</page>

I am using grunt compilation, so grunt convert less to css and store to pub/static. and mycss file calling while execute this page, but not reflecting.

But I change via firebug its working fine.

Why? Suggest me how to solve this?.


texts: public_html on a subdomain (in order to make HTTPS work)

texts:
I'm gonna try to make this comprehensible. My web hotel was integrated into another. The consequence was many problems including this specific one: If I write https://example.com it returns the results. If I write https://subdomain.example.com it returns a
"Your connection is not private. Attackers might be trying to steal your information from...." followed by "NET::ERR_CERT_COMMON_NAME_INVALID".
I noticed the following: After the migration to their new servers, they put the contents of https://example.com into a public_html folder. But the subdomains' contents are still inside a folder called subdomain.example.com without a public_html inside. I have a feeling this has to do with the error message I receive when trying to see the page with HTTPS. Any ideas?


texts:
Magento CE 2.2.2
ElasticSearch 6.4
PHP 7.1
Apache 2.4

Magento CE 2.2.2 Elastic Search No Products Front End Category / Listing Pages

We have installed

Amasty Layered Navigation
Amasty ElasticSearch

When we enable in admin Amasty Elasticsearch - changed it from Mysql to Amasty Elasticsearch - our products on the front end - category/listing pages disappear -

Magento admin -> Configuration -> Catalog -> Catalog Search

If I then RESAVE in admin same product they appear in the front end.

I spent a long time researching and notice other people with similar issues when enabling ElasticSearch but no fixes. This is the same problem with other company elastic search extension.


texts:
I wanted to add BOGO (Buy one Get One Free) promotion on my website. I have Successfully added it but it is applied on same product only.

Actually my requirement is like if user purchases 2 products then one of them will be free with condition that product with less than or equal to MRP will be considered as free across categories.


texts: Use boxslider in Magento 2 in custom module

texts:
I am trying to use boxslider in my custom module.

NOTE: I am in developer mode

  UPDATE : In network, i saw that files are loaded as

1) require.js

2) requirejs-config.js ( at top my require codes are mentioned )

3) jquery.js

Is it the normal flow of Magento 2 or I am doing something wrong in my custom module that's why it's loaded first.

At /var/www/html/magento2/app/code/NameSpace/ReviewRating/view/frontend/requirejs-config.js

 var config = {

// main.min is used for custom js where I handle some other things so I need this js file as well.
        deps: [
            "NameSpace_ReviewRating/js/main.min"
        ],

          shim: {
            "boxslider": ["jquery"]

        },

         map: {
            '*': {
                'boxslider': 'NameSpace_ReviewRating/js/boxslider/jquery.bxslider'
            }
        }

    };

At /var/www/html/magento2/app/code/NameSpace/ReviewRating/view/frontend/templates/homeverticalwidget.phtml

<script>
{
require([
        'jquery',
         "boxslider"
        ], function () {
            'use strict';
            jQuery.noConflict();
                jQuery(function () {

                     jQuery('.bxslider').bxSlider({
                        mode: 'vertical',
                        captions: true,
                        slideWidth: 600,
                        minSlides: 3,
                        maxSlides: 3,
                        moveSlides: 2,
                        slideWidth: 200

                     });

        });

    });

}
</script>

Isuues : IN console
1) Uncaught ReferenceError: jQuery is not defined ( in console this points to slider core js file )

I am not able to figure it out where I am wrong.


texts: Magento does not want to find some products on frontend

texts:
I ran into a problem.

I have a product that Magento does not want to find in my search on frontend, when client looking for goods, he finds almost all the goods, but some goods do not, although they are in stock and have qty

search settings are fine tuned. This problem is only in some products.


texts: Does any extensions exit to bulk edit Related, Upsell, Cross Sell products

texts: I need to bulk edit user interface for adding related, up sell and cross sell products, actually i import my all product, i want extension selected products  related, up sell and cross sell products aded.


texts: Magento 1.7 : Import large number of configurable products using CSV

texts:
I am working on project in which I need to create large number of configurable products.
I have two option either

    1. I manually create configurable product and associated simple products to it

    2. Pragmatically import product CSV.

If I create product manually it takes too much time to create a single product. Please help me how do I import configurable product CSV. I have read MAGMI but its working fine with simple product but I don't know how do I use it with configurable products because there no sample CSV for it. Can anyone suggest me something good to import configurable product pragmatically ?

Thank You


texts: Need help patching a 1.5.0.1 Magento website (1533 & 5344)

texts:
I have scoured all the related "how to apply the security patch" questions already posted and have not been successful.
The website in question is on hostgator.com and I have access to the cpanel.

I have uploaded the patches to the root folder and now I'm trying to execute the command to run the patch files.

These are the two files I have uploaded to the root folder.
PATCH_SUPEE-1533_EE_1.10.1.x_v1-2015-02-10-08-20-41.sh
PATCH_SUPEE-5390_CE_1.5.1.0_v1-2015-03-03-09-44-37.sh

This is where I am stuck. I have no idea where to access the command line to run the .sh files. Any help would be greatly appreciated since I am a graphic artist and not a programmer.
Many thanks,
Brian


texts: Create admin user in magento with some limits?

texts: I have an admin user and create one more that have all rights as admin user with one restriction that this new user can not see the admin user created before itself. So the New user can add/edit users create after him but not the one which is created before it.


texts: how to create discounts based on order total?

texts:
we want to give 5 % of discounts if customer added items with total order value is greater than 1000.

we don't want to apply any coupon codes.

Please guide me.


texts: My server manager updated our site to use https site-wide. Now all of our search results redirect to the home page. We don't want to lose our ranking, which is currently very high. How can I fix this?


texts: Error When Install Data Migration Tool to Magento 2.3.1 with composer

texts:
I have run below commands with composer in Magento 2.3.1 and getting error like below.
composer config repositories.magento composer https://repo.magento.com
composer require magento/data-migration-tool:2.3.1

Get error
Fatal error: Uncaught TypeError: Return value of Magento\InventoryComposerInstaller\Plugin_composer_tmp0::initModuleDeployment() must be an instance of Magento\InventoryComposerInstaller\void, none returned in phar:///opt/cpanel/composer/bin/composer/src/Composer/Plugin/PluginManager.php(195) : eval()'d code:69
Stack trace:
#0 [internal function]: Magento\InventoryComposerInstaller\Plugin_composer_tmp0->initModuleDeployment(Object(Composer\Script\Event))
#1 phar:///opt/cpanel/composer/bin/composer/src/Composer/EventDispatcher/EventDispatcher.php(176): call_user_func(Array, Object(Composer\Script\Event))
#2 phar:///opt/cpanel/composer/bin/composer/src/Composer/EventDispatcher/EventDispatcher.php(96): Composer\EventDispatcher\EventDispatcher->doDispatch(Object(Composer\Script\Event))
#3 phar:///opt/cpanel/composer/bin/composer/src/Composer/Installer.php(205): Composer\EventDispatcher\EventDispatcher->dispatchScript('pre-update-cmd', true)
#4 phar:///opt/cpanel/composer/bin/composer/src/Composer/Command/RequireCommand.php(20 in phar:///opt/cpanel/composer/bin/composer/src/Composer/Plugin/PluginManager.php(195) : eval()'d code on line 69

Any solution on this.


texts: Magento 2: Get orders filtering customer email

texts:
Is there any way to get the orders by filtering by the client's email?

I'm trying

 $ordersCollection = $this->_orderCollectionFactory->create();
 $ordersCollection->addAttributeToSelect('*');
 $ordersCollection->addFieldToFilter('customer_email',$customerEmail);
 $ordersCollection->setPageSize($pagesize);
 $ordersCollection->setCurPage($page);

but not work the filter.

Any idea?


texts: How to set value for existing registry variable?

texts:
I want to set value for an already existing registry variable.

E.g. current_category

I need to set some different value for this registry variable. Could someone kindly elaborate how to do it.


texts:
I want to run a script every 23 hours.
following syntax tried but its not working.
is it right syntax for 23 hours:

<cron_expr>0 0,23,46,69,92,115 * * *</cron_expr>


texts: error "File Input" is required value Magento 2

texts:
I have a customer attribute that is "File Input", type is file and require is true but I do not let it show in customer register. When I try to create an account it displays the error like this:

How can I ignore this error without changing the require of the attribute?


texts: Magento 2: Retrieving and updating Attribute Options and Store Lables

texts:
I am currently trying to update an attribute options store label and facing some issues. I can successfully update option store labels by calling

$storeLables = [];
$optionLabel = $this->optionLabelFactory->create();
$optionLabel->setStoreId(1);
$optionLabel->setLabel("Test");
$storeLables[] = $optionLabel;

$optionLabel = $this->optionLabelFactory->create();
$optionLabel->setStoreId(2);
$optionLabel->setLabel("Test 2");
$storeLables[] = $optionLabel;

$option->setStoreLabels($storeLables);

And this works, however lets say in my example above I have 3 store views with the following ids: 1,2,3. Using the code above any label value that was already saved against the option for store 3 would be wiped out. I assume that this is because setStoreLabels() replaces the existing array of values for all stores and does not just update the ones that are passed in.

To be able to fix this issue I would need to retrieve the current store labels array and update the ones that I need to and then pass that array to setStoreLables(). So my query is, how do I retrieve the store labels for options? I have tried the following:

$option->getStoreLabels()
$option->getData('store_labels');

However they both return null.


texts: I have order and invoice. I want to get product from invoice and I tried 2 function getAllItems() and getItemsCollection() but not found product_id.


texts: Security patch 5344 (Shoplift) Error executing check

texts: On Magereport.com in my site patches Security patch 5344 (Shoplift) showing Error executing check. how to resolve it ?


texts: How to Custom Comment History In Admin Dashboard Sales Order?

texts:
How to Custom Comment History In Page Sales Order And programmatically Comment History In Admin Order ?

I've added Config.xml,

<layout version="0.1.0">

<adminhtml_sales_order_view>
    <reference name="head">
        <action method="addItem"><type>skin_css</type><name>ig/css/main.css</name></action>
    </reference>
    <reference name="order_tab_info">
        <action method="setTemplate"><template>ig/sales/order/view/tab/info.phtml</template></action>
        <block type="adminhtml/ig_sales_order_view_history" name="ig_order_history" template="ig/sales/order/view/history.phtml"></block>
    </reference>
</adminhtml_sales_order_view>

How to add Block history.phtml?

And how the flow controller Post in my module?


texts: can't display the product's name after addAttributeToSelect

texts:
I have a table and this table will display the product's name, image, sku, category,and stock.
when I use
$products = $this->_productCollectionFactory->create()->addAttributeToSelect('*')->load();

i can display all those attributes
but when i use
 $products = $this->_productCollectionFactory->create()
                ->addAttributeToSelect(
                    'image',
                    'name',
                    'sku',
                    'stock'
                )
                ->load();

the product's name is not displayed.
did I choose the wrong attributes? if yes which one should I choose in order to display the product name?


texts:
I want to send an email to my magento website admin from my custom module.
How To get the admin's email which has the role Administrator?

Magento Version 1.9


texts: Which observer to use after success order on Magento 2?

texts:
I am working on this Magento 2 extension and part of the features is to push information about the orders to an external application using web services. I need to push this information after an order is placed in the checkout.

At the moment I am using the event checkout_onepage_controller_success_action which triggers the method to create the orders in the external app. I placed this event in /etc/frontend/events.xml.

So far this is working but I found an issue with the orders status. Sometimes the orders are still in pending status and some other times the orders are in processing. The reason for this is because the payment method first initialize the orders as pending and after the payment is approved, the orders changed to processing. I want to push only processing orders. It seems that sometimes the event checkout_onepage_controller_success_action runs before the payment is authorized and this is causing the issues.

Any idea how to solve this? how can I make sure the payment processing runs before I run my code in checkout_onepage_controller_success_action?

Following my code:

events.xml

<?xml version="1.0"?>
<!--
/**
 * Copyright © 2017 companyname.com
 */
-->
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
    <event name="checkout_onepage_controller_success_action">
        <observer name="companyname_order_success" instance="Companyname\Shipping\Observer\CreateCompanynameOrderObserver" />
    </event>
</config>

CreateCompanynameOrderObserver.php

/**
 * Create an order in Companyname when order status match the statuses in the backend
 *
 * @param EventObserver $observer
 * @return void
 */
public function execute(EventObserver $observer){
    $order_ids  = $observer->getEvent()->getOrderIds();
    $order_id   = $order_ids[0];

    //Loading order details
    $orderModel         = $this->_orderFactory->create();
    $order              = $orderModel->load($order_id);
    $shipping_method    = $order->getShippingMethod();
    $order_status       = $order->getStatus();

    if($order_status == 'processing'){
        //Push to external app
    }
}


texts:
I am trying to join two tables like below
    $objectManager =  \Magento\Framework\App\ObjectManager::getInstance();

    $collection = $objectManager->get('Advance\Module\Model\Method')
    ->getCollection()->addFieldToFilter('stores', ['finset' => $store_id]);

    $collection->getSelect()->joinLeft( ['shippingrate'=> 'shippingrate'],
    'shippingrate.method_id = main_table.method_id', ['main_table.method_id']);

This is returning all data from two tables. I could not get specific columns from the end result.


texts: Magento 2 Override Unit.phtml and Row.phtml in Magento_Checkout

texts:
I am trying to override both unit.phtml and row.phtml within my Magento_Checkout module. I am doing everything that I would normally do but it doesn't seem to be overriding like the other phtml files.

The file is being overwritten on my client and then uploaded to Magento_Checkout\templates\item\price but none of the changes i'm making seen to be making a difference.

My goal is to remove the Incl Vat from the cart page and just leave Excl Vat as the standard price.


texts: Backend login page can't display correclty

texts:
After transferring to a new server, the backend login page can't load correctly, but the frontend works well. You can see the links of CSS and JS files are not correct. And the login button can't load either.

I have tried some ways:

set the right permission to the folders: skin, js.
clean the var folder.
set the right timezone in the table core_config_data
load the page with many browsers.

but unluckily they all failed.

How can I fix it?

Thanks.


texts: Magento 2 : How to change UI field(s) dynamically

texts:
On checkout page on country selection i want to change postal zip code from text box to select list with options dynamically ( like region_id ).

For example, if zip code are available for certain country it should show select list with all zip codes, if certain country does not have zip code it should be replaced with text box.

I am trying to achieve this using code below :

requirejs-config.js

var config = {
config: {
    mixins: {
        'Magento_Checkout/js/view/shipping-address/list': {
            'Vendor_Module/js/action/postcode-mixin': true
        }
    }
}
};

postcode-mixin.js

define([
'jquery',
], function ($) {
'use strict';

return function (ListShipping) {
    return ListShipping.extend({
        defaults: {
            template: 'Magento_Checkout/shipping-address/list',
            rendererTemplates: [],
            isExtend: true,
            testVariable: 1
        },

        initialize: function () {
            //this._super()
            //    .initChildren();

                $(document).on('change',"[name='country_id']",function(){
                   var elField = $("[name='postcode']");

                    var countryPostCodes= '{"US":["123456","67890","11221"], "CA":["A01 B0","A11 T1"]}';
                    var codeList= JSON.parse(countryPostCodes);

                    var selectedCountry = $(this).val();
                    var zipcodes= codeList[$(this).val()];

                    if(codeList.hasOwnProperty(selectedCountry)) {
                        elField.replaceWith($('<select>').attr({
                            id: elField.attr('id'),
                            name: elField.attr('name'),
                            class: elField.attr('class')
                            }));
                        $(elField).empty();
                        if(zipcodes!= 'undefined' && zipcodes.length > 0 ) {
                            for(i=0; i < zipcodes.length; i++ ) {
                                $(elField).append("<option value="+zipcodes[i]+">"+zipcodes[i]+"</option>");
                            }
                        }

                });

        }
    });
}
});

Above code replaces the input field with select field but on submit it gives error validation error and form is not being submit.

I don't know if that needs to be done using knockout js and creating html template for drop down. ( if so please guide me how to do that )

Help will be highly appreciated.


texts: Magento 2 set locale in CLI command module

texts:
I'm developing a command line module in magento 2 and I cannot find a way to set locale programmatically.

The module takes care of creating a pdf invoice from an order and sends it via email to customer. All is going fine but the mail and the pdf invoice are in english.

Also if I try to print something like echo __('my phrase'), and I have the corresponding translation in /i18n/it_IT.csv file, it doesn't print the translated sentence.

I'm stuck there since 8h or so, trying a bunch of ways to do that.

If I instantiate a local resolver instance (Magento\Framework\Locale\ResolverInterface) via objectManager or injecting it in the constructor and then try $this->_localResolver->getLocale(), it prints it_IT, but nothing happens.

Here is a piece of my code:

$locale = $objectManager->create('Magento\Framework\Locale\ResolverInterface');
echo $locale->getLocale();  //it prints 'it_IT'
$locale->setLocale('it_IT');
$locale->setDefaultLocale('it_IT');

echo __('Price including VAT') . "\n\r"; //It prints 'Price including VAT' and not the translated sentence.


texts: Filter collection with dropdown attribute

texts:
I want to hide products on frontend that have attribute brand = branda and brandb. Attributes are dropdown and flat tables are enabled.
Reason is i am importing alot of products and some of those should be hidden automatically.

My plan is to hide with event <catalog_product_collection_load_before>.

In observer method i have this:

public function filterProductsbyBrand($observer) {
                $AttributeName = 'brand';
                $brand = 'branda';
                $brand2 = 'brandb';
                if (!Mage::app()->getStore()->isAdmin()) {
                    if (isset($observer['collection'])) {
                        $collection = $observer['collection'];
                        $collection->addFieldToFilter($AttributeName, array('neq' => Mage::getResourceModel('catalog/product')->getAttribute($AttributeName)->getSource()->getOptionId($brand)))
                        $collection->addFieldToFilter($AttributeName, array('neq' => Mage::getResourceModel('catalog/product')->getAttribute($AttributeName)->getSource()->getOptionId($brand2)));
                        return $this;
                    }
                }
            }

But this give error and are not working. Error are like this:

exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.brand' in 'where clause'' in /var/www/mysite.com/public_html/lib/Zend/Db/Statement/Pdo.php:228

If i run external with this i get correct collection.

$AttributeName = 'brand';
$brand = 'branda';
$brand2 = 'brandb';
$collection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter($AttributeName, array('neq' => Mage::getResourceModel('catalog/product')->getAttribute($AttributeName)->getSource()->getOptionId($brand)))
    ->addFieldToFilter($AttributeName, array('neq' => Mage::getResourceModel('catalog/product')->getAttribute($AttributeName)->getSource()->getOptionId($brand2)));

What am i doing wrong here?


texts: Magento 2 - Get abandoned shopping carts through Rest API

texts:
I'm trying to retrieve the abandoned shopping cart through the Magento Rest API. Here is my request

https://<my_domain>/rest/V1/carts/search?searchCriteria[filter_groups][0][filters][0][field]=is_active&searchCriteria[filter_groups][0][filters][0][value]=1&searchCriteria[filter_groups][0][filters][0][condition_type]=eq&searchCriteria[filter_groups][1][filters][0][field]=store_id&searchCriteria[filter_groups][1][filters][0][value]=1&searchCriteria[filter_groups][1][filters][0][condition_type]=eq&searchCriteria[filter_groups][2][filters][0][field]=items_count&searchCriteria[filter_groups][2][filters][0][value]=0&searchCriteria[filter_groups][2][filters][0][condition_type]=gt

I retrieve 514 items.

When I check the report which is available in Magento back-office, it gives me 189 items. I cannot explain the difference.

What should be the request in order to actually retrieve the abandoned shopping carts ?

Thanks


texts: M2: Unable to Remove configurable product from Cart Page

texts:
I have an odd issue using Magento 2.1.6

I cant seem to remove a configurable product form the cart on the cart page.
The X to remove just does not show up in the action bar for any configurable.

Any idea why this is or how I can add one?


texts: Magento 2.1.7 how to get different domain name for different stores

texts:
How can i get different domains name for different stores created.
Created store name as French its domain name should be fr.domainname.com.Thanks in advance..


texts: enable swatches not displayed as crossed out when out of stock?

texts: I just want to remove crossed out lines and enable Swatches when the sample product is out of stock. This is already working on Magento 2.3.2 but after update to 2.3.4, its shows crossed outline. can anyone help me with this problem?


texts: Remove price filter from category view Magento 2

texts: How can I disable the price filter to show on category view?


texts: Empty email custom module Magento 2 transportBuilder

texts:
I have set up an controller to send email:

<?php namespace Qxs\Verkoopje\Controller\Index;

use Magento\Framework\App\Action\Context;
use Magento\Framework\Mail\Template\TransportBuilder;
use Magento\Framework\App\Action\Action;

class Index extends Action
{
    private $transportBuilder;

    public function __construct(
        Context $context,
        TransportBuilder $transportBuilder
    ) {
        parent::__construct($context);
        $this->transportBuilder = $transportBuilder;
    }

    public function execute()
    {
        $post = $this->getRequest()->getPostValue();

        $postObject = new \Magento\Framework\DataObject();
        $postObject->setData($post);

        $transport = $this->transportBuilder
          ->setTemplateIdentifier('qxs_verkoopje_template')
          ->setTemplateOptions([
            'area' => \Magento\Backend\App\Area\FrontNameResolver::AREA_CODE,
            'store' => \Magento\Store\Model\Store::DEFAULT_STORE_ID,
          ])
          ->setFrom([
            'name' => 'xx xxxxx',
            'email' => 'info@xxx.net',
          ])
          ->setTemplateVars(['data' => $postObject])
          ->addTo('xxx@gmail.com')
          ->setReplyTo('info@xxx.net')
          ->getTransport();

        $transport->sendMessage();
    }
}

email_templates.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Email:etc/email_templates.xsd">
    <template id="qxs_verkoopje_template"
              label="Verkoop je"
              file="verkoopje_mail.html" type="html"
              module="Qxs_Verkoopje" area="frontend"/>
</config>

verkoopje_mail.html

<!--@subject {{trans "Verkoop je"}}  @-->
Test
Test1
Test2

The email is sent but the email content / subject are empty. Anybody any ideas?

Thanks,


texts: Store Filter on Category Collection Not Working

texts:
Have just noticed that a function is pulling categories from any store. I used the below setStore() method thinking this would limit the scope of categories returned to just the current store however does not seem to be the case.
$categoryCollection = $this->categoryCollectionFactory->create();
$categories = $categoryCollection->setStore($this->_storeManager->getStore())->addAttributeToFilter('name', $this->brand);

This is how it was done and the storeID pulled seems fine when i run $this->_storeManager->getStore()->getId() so unsure what could be wrong. Wondering if anyone can shed some light have tried a few variations of above with no luck so far.
For now I can achieve like below however would like to figure out why the above does not work:
->addAttributeToFilter('path', array('like' => "1/" . $store->getRootCategoryId() . "/%"));


texts: Magento2: How to get product categories on product view page

texts:
I've created a custom module and in that created a block to get current categories on product view page. I've added that block via layout xml of module.
I've used $this->_registry->registry('current_category') to get current categories of product on product view page.
But in my phtml file it's not rendering the categories.


texts: Add checkbox field with catalog category

texts:
I am trying to add a checkbox field with catalog category with following code but its not adding with category, when i change to text it works properly but not with checkbox .

$installer->addAttribute('catalog_category', 'disable_banner',  array(
    'type'     => 'int',
    'label'    => 'Disable Banner',
    'input'    => 'checkbox',
    'global'   => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
    'visible'           => true,
    'required'          => false,
    'user_defined'      => false,
    'default'           => 0
));

I found lots of tutorials for text fields but not for checkbox or radio button.
Is it possible to add checkbox through custom module and if yes then what i am missing here.

Here is the tutorial I use for reference https://www.atwix.com/magento/add-category-attribute/


texts: How to show a date selected in Calendar?

texts:
When we open date calendar, it shows current date selected by default. But I need to show a date selected which is 15 days ahead of current date.

My code

HTML:

<input type="text" class="input-text" id="delivery_date" name="delivery_date">

Script:

   Calendar.setup({
                inputField: "delivery_date",
                ifFormat: "%d/%m/%Y",
                showsTime: false,
                button: "delivery_date_trig",
                align: "Bl",
                singleClick : true
            })

Thanks.


texts: Indexer Update by Schedule not Updating Indexer Related Cron Job

texts:
A few days back everything works well.
But suddenly other cron get run except indexer-related cron.
Nighter new code or feature get added not changes done on server.
Only changes happen some new products get added.
then found indexer_update_all_views showing running & not get executed.
Executed stated ad 14:11:03, when I take the screenshot it read 20:00:55.

On indexer, third-party indexer Cron job (Like Algolia)run well, but Magento code indexer not get run.
Any Idea??
Platfrom : Magento 2
Version : 2.2.7
Php Version: 7.1
Thanks in advance.


texts: Magento2: Add Custom table next to Product attribute in Product Detail Page

texts: How to add Custom table next to product attribute in a product detail page


texts: Magento 2 category listing page not show product

texts: In our magento store category listing page not display anyone product getting this error"We can't find products matching the selection." in all pages but  in admin side product  assign to category and visibility is catalog,search.If any one facing this type of issue in fronted side please reply me


texts:
Is it possible to disable Magento 2 image cache (it's consuming 41G), I want to use S3 for images since I expect our images to go over 2TB in few months, I am afraid generating cache on S3 may take too much time and result in inconsistencies. So is there a way to disable magento image cache?

I do not see image cache under Cache Management.

Thanks


texts: how to add extra fee for international order in magento

texts: I am not developer, I am  Web/Graphics designer.  only I am handle whole multi designer website. when some one place order from out of india, add extra charge per product price or destination.


texts: Magento 2 - How to create a shipping carrier?

texts:
I am trying to create a new shipping carrier in just like DHL, FEDX, UPS.
I am taking a reference of Magento_DHL module.
Can any one tell the required code needed to create a shipping carrier.

Thank you,


texts: Check if model column exists before saving in database

texts:
I want to insert a column into my db table, but only if it does not exist, yet.
So I thought I'd check if the model with the specified email exists, and if not I perform save() method.

Here is what I do:

$customerModel = Mage::getModel('custom/customerobject');
$loadedModel = $customerModel->load($RequestParams['email'],'email');
$customerIsUnique = empty($loadedModel->getData('email'));

if($customerIsUnique)
{
    // Do stuff
 }

Is this the common way how it's done in magento or is there a better way, like
$customerModel->saveOnlyIfItDoesNotExistOrAnyOtherAwesomeMethod() ?

Thanks in advance


texts: How to add Loc_layered navigation in catalog search page in magento 2

texts:
I am using magento 2.3.5 version
I have used Lof_LayeredNavigation module for multiselect filter
but this is not working on catalog search page, as we have search any product,
Attribute is show in catalog search yes (in attribute configuration)
I have added catalogsearch_result_index.xml file theme and add some code
/app/design/frontend/My/theme/Magento_CatalogSearch/layout/catalogsearch_result_index.xml
<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
    <body>
        <move element="div.sidebar.main" destination="columns" before="main"/>
        <move element="div.sidebar.additional" destination="columns" after="-"/>
        <referenceBlock name="catalog.leftnav">
            <action method="setTemplate" ifconfig="layered_navigation/general/enable">
                <argument name="template" xsi:type="string">Lof_LayeredNavigation::layer/view.phtml</argument>
            </action>
        </referenceBlock>
        <referenceBlock name="catalog.navigation.renderer">
            <action method="setTemplate" ifconfig="layered_navigation/general/enable">
                <argument name="template" xsi:type="string">Lof_LayeredNavigation::layer/filter.phtml</argument>
            </action>
        </referenceBlock>
        <referenceBlock name="category.products">
            <action method="setTemplate" ifconfig="layered_navigation/general/enable">
                <argument name="template" xsi:type="string">Lof_LayeredNavigation::products.phtml</argument>
            </action>
        </referenceBlock>
    </body>
</page>

But its not working on catalog search , anyone help here,
thanks in advance


texts:
How to Cancel Shipment Creation for an Order in Magento2?

I have a condition where If the condition is false I need to stop Shipment Creation and Cancel the order. How can I manage this? Any help will be appreciated.


texts:
I have tried this but this haven't worked for me
{
    if (isset($this->_areaCode)) {
        throw new MagentoFrameworkExceptionLocalizedException(
            new MagentoFrameworkPhrase('Area code is already set')
        );
    }
    $this->_configScope->setCurrentScope($code);
    $this->_areaCode = $code;
}```


texts: Magento 1.9.0.1 with sample data 1.9.0.0 install did not work

texts:
This looks to just be a simple problem, but I cannot find an answer to it. Here is the site:

http://www.cindyconner.com

Magento 1.9.0.1
Sample Data 1.9.0.0

My server tested OK for the install.


texts: I want to override the labels of form System -> My Account like User Name change to Customer Name. As well as i want to remove one field Last Name from that form.


texts: Change labels on checkout page in Magento 2

texts:
On the checkout page I want to change the labels of Zip/Postal code and State/Province. I have updated the en_US.csv file, but nothing happens, despited clearing cache.

Any ideas on how to solve this?


texts: magento 1 : how to send automatic reminder for incomplete orders in admin

texts:
I need to get a list of customers that did not pay yet every 2 days in my mail or anything to keep track on them.

How can I create a notification for orders that are not completed in system?


texts: Why are some checkboxes missing from related products when they are downloadable?

texts:
We made a bunch of downloadable products. First made one, then duplicated it a bunch of times and changed what it links to.

Then for each downloadable product we added all the other downloadable products as "related products" so they show up in the left side-bar.

However only some of them have a checkbox next to them! We've gone through each product and clearly each of them has the exact same values for everything except the SKU and what the downloadable item is that they link to.

Can someone please explain why? Or how to fix this? It seems very random. Thanks.

We're on CE 1.8.1.0, BTW.


texts:
I have a flat shipping rate set up i.e. if cart total less than Rs.800 then shipping is Rs.100, if more than Rs.800 then shipping is free.

I want to apply a flat 10% discount on the final total including shipping if any.

how would I go about doing this?

Thanks


texts: New website/store view, all pages 404 (including homepage)

texts:
As per the title, I've set up a new store on a different domain and all pages including the home page are returning 404.

I've tried pretty much everything, and I'm wondering if any of you can think of a good way to debug this.

I've tried:

Clearing Mage cache, reindexing
Clearing APC cache
Reloading nginx
Creating a new CMS page at a certain URL to see if that will load
Disabling web server rewrites
Checking store config against other stores that do work (default cms page etc)
Trying default URLs (e.g. /customer/account)
Changing the Nginx configuration a few times based on various examples (and also based on the other working Nginx configuration files that are in use)

The site is loading the correct theme, but not finding any content for some reason - it just gives me a 404 page no matter what URL is given.

At this stage, I'm not sure if it is a server config issue or a Magento config issue.

A version is EE 1.12.

Current Nginx conf file is as follows (removed any sensitive variables):

server {
    listen 000.00.000.000:80;
    listen 000.00.000.000:443 ssl;
    server_name subdomain.site.com;
    root /var/www/vhosts/companyname/staging;

#   SSL Configuration redacted

    location / {
        index index.html index.php;
        try_files $uri $uri/ @handler;
#        try_files $uri $uri/ /index.php?q=$uri&$args;
#        expires 30d;
    }
    location @handler {
#        rewrite / /index.php?req=$uri;
        rewrite / /index.php;
    }

    location ~ \.php/ {
        rewrite ^(.*\.php)/ $1 last;
    }

    location ~ \.php$ {
        if (!-e $request_filename) { rewrite / /index.php last; }

#        expires        off;
#        fastcgi_pass   stagebackend;
#        fastcgi_param  HTTPS $fastcgi_https;
#        fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
#        include        fastcgi_params;

#copied config below

        expires        off;
        fastcgi_pass   stagebackend;
        fastcgi_param  HTTPS $fastcgi_https;
        fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
        fastcgi_param  MAGE_RUN_CODE site_en;
        fastcgi_param  MAGE_RUN_TYPE website;
        include        fastcgi_params;

#end copied config

    }

}

Relevant settings for the view are (the cms page defined here does exist and is enabled for the storefront):

SEO:

Web server rewrites: No

Default Pages:

URL: cms
CMS Home Page: Home Page
Default No-Route URL: cms/index/noRoute

Any ideas would be much appreciated!


texts: Working with a very 'niche' merchant account provider that I've managed to add to Authorize.net. We need to accept subscription payments through our website, and require a module that supports recurring subscription payments using the Authorize.net AIM module. Does anyone have experience with this?


texts: How to recover magento, when database is alive but ALL the files are removed?

texts:
So I have a Magento website where ALL the files are removed by accident and there is no back up for it.

But, the database is still alive and working.

Is there anyway for me to recover at least some parts of my website? Or at least my products and data? I am aware that my front-end and all its changes are removed, but is there an approach to at least get my products and data up and running again? Even if it's to use another template for it?


texts: Admin is returning a 404 on styles.css and theme.js on Magento 2.3.3

texts:
The backend of my Magento installation is not loading CSS/JS. I have reached a point where I just cannot work out why this is happening and hoping that someone might have an idea.

This is what I am seeing:

I can also see that in pub/static/adminhtml/backend/en_US there is no css folder.

This is what I have tried to resolve this:

Confirmed .htaccess is present in the pub/static folder
In developer mode, I have ran the following commands:

bin/magento cache:clean
bin/magento cache:flush
bin/magento setup:upgrade
bin/magento setup:di:compile
bin/magento setup:static-content:deploy -f

Set dev/static/sign to 0 directly in DB.
Built in production mode with:

bin/magento setup:upgrade
bin/magento deploy:mode:set production

Checked and reset all permissions
Checked var/log/ for any indications of errors - there is just this:

main.ERROR: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/css/styles.css' [] []
main.CRITICAL: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/css/styles.css' [] []
main.ERROR: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/js/theme.js' [] []
main.CRITICAL: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/js/theme.js' [] []

I have spent way too long searching for an answer on here, Google, etc. and it just seems to send me in circles with all suggestions being one of the above.

I am guessing it might be something simple, something I have overlooked but I am just not seeing it today. Any help will be appreciated.


texts: How to manually calculate the weight of configurable product

texts:
i have the following problem:
when I try to edit an order in Magento, on the initial loading of the edit page,
Mage_Shipping_Model_Rate_Request::getPackageWeight() returns zero.This behaviour occurs only with configurable products.

My question is how can i calculate manually the total weight of the package.
I am using Magento 1.7.0.2 CE.
Thanks in advance!


texts: Get store name and store url, email address magento 2

texts:
I want to get store name and store URL in magento 2.
https://www.mageplaza.com/devdocs/how-get-store-information-magento-2.html
I tried to use Magento\Store\Model\StoreManagerInterface and get the store with this code
$this->storeManager->getStore()->getName()

However, this always returns the string Default Store View instead of my store name
I tried  $this->storeManager->getStore()->getCurrentUrl(true) to get the store URL but there is no getCurrentUrl in the StoreInterface;


texts: Call to undefined method addFieldToFilter() in magento 2

texts:
I have a model,resource model,collection file shown below.

app/code/Magge/Custom/Model/Categrory.php

namespace Magge\Custom\Model;

use Magento\Framework\Model\AbstractModel;

class Categrory extends AbstractModel
{
protected function _construct()
{
    $this->_init('Magge\Custom\Model\ResourceModel\Categrory');
    }
}

app/code/Magge/Custom/Model/ResourceModel/Categrory.php

namespace Magge\Custom\Model\ResourceModel;

use Magento\Framework\Model\ResourceModel\Db\AbstractDb;

class Categrory extends AbstractDb
{
protected function _construct()
{
    $this->_init('customer_products', 'customproduct_id');
}
}

app/code/Magge/Custom/Model/ResourceModel/Categrory/Collection.php

namespace Magge\Custom\Model\ResourceModel\Categrory;

use Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection;

class Collection extends AbstractCollection
{

protected function _construct()
{
    $this->_init('Magge\Custom\Model\Categrory', 'Morello\Customproducts\Model\ResourceModel\Categrory');
}

}

I have a another module named CustomPriceApi within which I have a price.php file in Model .From this file I am try use the factory class but got the error.

namespace Insigma\CustomPriceApi\Model;

class Price implements PriceInterface {

public function __construct(
\Magge\Custom\Model\CategoryFactory $factoryCategory,
.....
)
{
$this->factoryCategory   = $factoryCategory;
}

Within its public method I use

$category = $this->factoryCategory->create()->addFieldToFilter('price_id',array('eq' => $priceId))->getData();

And I get  error.I tried using addAttributetoFilter() but still get undefined method.Please help me in this regard.


texts: How to add plugin for MSI in module with version condition for M2.2 without error?

texts: Does any one knows how to add plugin for Multi Source Inventory in module so it should work for M2.2 and M2.3.x?


texts: show a custom link list in section header

texts: I am a beginner Magento developer (I am currently using the 1.9.0.1 version). I am working on a project of web shop which has the need to display a series of custom link in the header section. I studied how to develop a custom module but I did not manage to display this list of links in my own template. Anyone can point me to some resource and/or give me some suggestions on how to achieve this task?


texts:
I want to connect Magento 2.3.5 to MSSQL database to export records about new orders like (product ID - Quantity sold - price - customer information)
So what are my options?
Before I post this question I found many solutions, but I don't know if it's will work or no?
Microsoft Flow
Blend.co
PDO connector


texts: How to check if on multiple address checkout page?

texts: I need a way to check if the customer is using multiple checkout.


texts: Gzip Comporession and leverage Browser Cache Not working

texts:
i am trying to optimize my store.

to optimize it i have added Gzip Code and Leverage Browser Cache Code in .htaccess File.

There are 2 .htaccess file on my server.  one is .htaccess and second is .htaccess.bak

both file have same code and Some 301 Redirect COdes.

inspite having Gzip and leverage Browser Cache Code in .htaccess  it is not working.

Following Gzip and Htaccess code i  have put in my .htaccess and .htaccess.bak file

    <ifModule mod_gzip.c>
   mod_gzip_on Yes
  mod_gzip_dechunk Yes
  mod_gzip_item_include file .(html?|txt|css|js|php|pl)$
  mod_gzip_item_include handler ^cgi-script$
  mod_gzip_item_include mime ^text/.*
 mod_gzip_item_include mime ^application/x-javascript.*
 mod_gzip_item_exclude mime ^image/.*
 mod_gzip_item_exclude rspheader ^Content-Encoding:.*gzip.*
</ifModule>
  # compress text, HTML, JavaScript, CSS, and XML
 AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/xml
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE application/rss+xml
AddOutputFilterByType DEFLATE application/javascript
AddOutputFilterByType DEFLATE application/x-javascript

 # remove browser bugs
BrowserMatch ^Mozilla/4 gzip-only-text/html
BrowserMatch ^Mozilla/4\.0[678] no-gzip
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
Header append Vary User-Agent

 ## EXPIRES CACHING ##
  <IfModule mod_expires.c>
  ExpiresActive On
  ExpiresByType image/jpg "access 1 year"
  ExpiresByType image/jpeg "access 1 year"
  ExpiresByType image/gif "access 1 year"
  ExpiresByType image/png "access 1 year"
  ExpiresByType text/css "access 1 month"
  ExpiresByType text/html "access 1 month"
  ExpiresByType application/pdf "access 1 month"
  ExpiresByType text/x-javascript "access 1 month"
  ExpiresByType application/x-shockwave-flash "access 1 month"
  ExpiresByType image/x-icon "access 1 year"
  ExpiresDefault "access 1 month"
  </IfModule>
  ## EXPIRES CACHING ##

after adding this code i did check Gzip COmpression working or not.  Gtmetrixt, googlepagespeed  showing it is not working. also did check in gzipcomression Checker: http://checkgzipcompression.com/  it says compression in not enabled.

is there any setting in server or php that i should enable for Gzip COmpression to work.?

How to Fix it? Need HElp!


texts: Custom category attribute not showing back end

texts:
I have a small module that creates an attribute for categories. Works fine on my dev site but not on my live.

I can see the module in system>config>advanced>advanced and it is enabled.

I can't see the attribute in the catalog_eav_attribute table and it's not showing in category details on the back end.

I can see the set up entry in the core_resource table.

I have flushed all caches and reindexed but no joy. Any ideas on what might be wrong?


texts: Unable to create order from admin in magento 2

texts:
Here is server error log:

  [proxy_fcgi:error] [pid 14406] [client xxx.2x1.4x.xxx:21633] AH01071:
  Got error 'PHP message: PHP Fatal error:  Uncaught TypeError: Argument
  1 passed to
  Magento\Payment\Gateway\Data\Quote\QuoteAdapter::__construct() must
  implement interface Magento\Quote\Api\Data\CartInterface, null given,
  called in
  /var/www/magento/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php
  on line 111 and defined in
  /var/www/magento/vendor/magento/module-payment/Gateway/Data/Quote/QuoteAdapter.php:32\nStack
  trace:\n#0
  /var/www/magento/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php(111):
  Magento\Payment\Gateway\Data\Quote\QuoteAdapter->__construct(NULL,
  Object(Magento\Payment\Gateway\Data\Quote\AddressAdapterFactory))\n#1
  /var/www/magento/vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php(66):
  Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\Payment...',
  Array)\n#2
  /var/www/magento/vendor/magento/framework/ObjectManager/ObjectManager.php(56):
  Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Payment...',...\n',
  referer:
  https://magentosite.com/admin/sales/order/index/key/9bafd2f5e462f32d65756b10f575c2e6e76a64ddd16f255487d2a90a081fbb7e/


texts: Set up a shopping cart rule that only applies if 2 specific products are in the cart

texts: I am trying to set up a code where it is only valid, IF two products are in the cart.


texts:
Just realized that in order confirmation email it displays wrong hours to contact the store. Checked in admin panel > system > configuration > sales > sales emails and all templates files say default from locale. After finding *.phtml files in

/httpdocs/app/design/frontend/base/default/template/email/order

I still did not find a file to edit to change the correct working hours to contact the store.

Another problem is that in shipment confirmation email the logo at the top of the email does not display.


texts: How to add wrapper div on product page so that it includes related products sidebar?

texts:
I'm trying to implement schema.org microdata for rich snippets.

I can do that for the main product, easily. But I would like to tag the related products with the isRelatedTo property for the main product. The problem is that they must be contained in a child div of the main product div, and they are not.

I cannot do it in view.phtml.

Any ideas?

Also please help with tags for this quesiton. The only one I could think of was seo.


texts: magento 2 error factory class does not exist

texts:
This is my block class for form

Smartshore/Subscription/Block/SubscriptionForm

namespace Smartshore\Subscription\Block;

class SubscriptionForm extends \Magento\Framework\View\Element\Template
{

  protected $_subscriptionLoader;

  public function __construct(
        \Magento\Framework\View\Element\Template\Context $context,
        \Magento\Catalog\Model\SubscriptionFactory $_subscriptionLoader

    ) {
        $this->_subscriptionLoader = $_subscriptionLoader;
        parent::__construct($context);
    }

    public function getSubscriptionBy($id)
    {
        return $this->_subscriptionLoader->create()->load($id);
    }

}

Smartshore/Subscription/view/frontend/layout/subscription_index_add.xml

This is my xml file

<?xml version="1.0"?>
<page layout="1column" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
    <head>
        <title>New Subscription</title>
    </head>
    <body>
        <referenceContainer name="content">
            <block class="Smartshore\Subscription\Block\SubscriptionForm" name="subscriptionform.add" template="Smartshore_Subscription::form.phtml"/>
        </referenceContainer>
    </body>
</page>

In my template(Smartshore/Subscription/view/frontend/templates/form.phtml) I'm using $this->getSubscriptionBy($id);

But I'm getting two errors:

Invalid block type: Smartshore\Subscription\Block\SubscriptionForm
Class Magento\Catalog\Model\SubscriptionFactory does not exist

What is causing the errors here?


texts: Magento2.3.3: Unknown column 'e.min_price' in 'field list'

texts:
Working on custom layered navigation on custom collection. follow this solution link

Getting an Error:

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.min_price' in 'field list', query was: SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(e.min_price ) * 1, 2) AS `max`, ROUND(MIN(e.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((e.min_price ) * 1, 2)) AS `std` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_entity_int` AS `at_brands` ON (`at_brands`.`entity_id` = `e`.`entity_id`) AND (`at_brands`.`attribute_id` = '509') AND (`at_brands`.`store_id` = 0) WHERE (FIND_IN_SET('16304', at_brands.value)) AND (e.min_price IS NOT NULL)


texts:
I want to install Magento 1 on my WAMP localhost server. The only file available for download from magento.com is the downloader.php file. I have absolutely no idea what settings to use in order to get this downloader to connect and download the magento files....

Is there a direct download anywhere - or instructions as to how to use the infernal downloader? (the installation guide seems to have been removed from magento.com  too... the link goes to 404 page)

Why make things simple? - I'm seriously considering a move away from Magento...


texts:
I want to dig deeper into Magentos SQL adapter. There are a lot of answer that often suggests to use Magentos own implementation of the SQL-Adapter.

I currently want to do this SQL in a resource Model:

SELECT pd.sku
FROM wishlist_item AS wl
LEFT JOIN catalog_product_entity AS pd
ON pd.entity_id = wl.product_id
WHERE wl.wishlist_id = 2;

How would I transform that into Magento Code if I shall not use ->query($query)?


texts:
I have a Magento website upgraded from 1.9.2.4 to CE 1.9.3.0 and there is an issue with the file uploads after the upgrade. In CMS page or CMS block if I try to upload an image or file that does not work.

When I click the browse files button nothing happens. I checked for the .swf files in media, removing or adding those files seems to have no effect.

Other websites I have works fine. So I don't think this will be an issue regarding the flash player in the browser.

Does anyone know the solution for this issue?

Thanks.


texts: Product page (Related.php) error in Magento 2.1.16

texts:
I override the page Related.php and add my extra custom function in this class it works perfectly on 2.2.X but in 2.1.16 it shows me this error

  Warning: Invalid argument supplied for foreach() in /home2/hide/public_html/vendor/magento/module-catalog/Block/Product/ProductList/Related.php on line 129

now I don't why is it giving this error n how can I solve this error on 2.1.16 on 2.2.X its works perfectly.


texts: Is it possible to leave an entry in bundle product required and yet allow it to be zero

texts:
I need a product which has other subproducts with variable quantity (like a box of multiple X of different sorts of desired quantity, which you fill in a input field). So I created a bundle product to accomplish this. For all the sorts I added corresponding bundle subproducts, and chose "dropdown" as input type, and made every entry required. Since in every option there is only one product, it appears not as dropdown, but as plain text, which is what I need. So I get pretty much what I need except for one thing: when one puts a zero in quantity field and adds products to the cart, quantity is automatically set to one. I suppose it is due to every option being labeled as "required". So when I unset "required", first of all I get a dropdown with the options (whether to add product or not), which is undesired (I would prefer for a customer to set zero if they don't want to have a particular sort of the product). On top of that quantity input field gets disabled.

So what I wanted to ask is whether it is possible to keep options for every sort to be required and at the same time avert automatic quantity increment in case zero? Should I override cart model / some controller? Or alternatively, can I get same functionality with options not being "required"?

Thank you in advance!


texts: How to sync between multiple magento sites keeping one as master?

texts:
I have two child magento websites and one master website, Now I would like to synchronize child sites when something happens to master,
For example: When a product is added or a price change - sync to other two child websites. (i.e.) All/Custom admin activities are synchronized between Master and child magento websites.

Note: These Magento stores are not configured like Multi-stores and these are installed separately on different domains.


texts: Magento 2: Adding Sample Data to an Already Installed System

texts:
Is it possible to add the sample data to an already running Magento 2 system?  Or is this only possible at install time?

If I run

php bin/magento sampledata:deploy

This will add the sample data modules to my composer.json file.  This installs the modules into my system.  However, it does not (seem to?) automatically deploy any of the products, users, etc.


texts: Magento 1.9 Small Business in Germany / remove tax information / inkl 0 % MWST

texts:
I search a solution to modify my new Shop Magento 1.9 for a Small Business in Germany.

The correct name in Germany is : Kleinunternehmer Regelung (Small Business Rule)

In this solution I must remove the tax and tax information and change this with a special sentence: "UST.- frei gem Kleinunternehmer Regelung §19 USTG".


texts: enabling newly installed magento extension (facebook connect) what now?

texts:
I have followed the instructions to a T here on how to properly install a Magento extension. http://www.magikcommerce.com/blog/how-to-install-magento-extensions-magento-extension-installation-guide/

The extension in question is the Magento Facebook Connect for Facebook login capabilities. The extension key seemed to work successfully upon pasting it into extension key field. Afterwards I got a small success message and scrolled down seeing the terminal frame act like it was a success. Then following the instructions in the above link, I simply hit refresh. Now, under 'Manage Existing Extensions' I see the facebook extension in there. But what now? How do I enable it?

The small drop-down next to the extension, just has two options. Re-install or uninstall? How do I configure it and what do I do now to allow the facebook login functionality. For Wordpress, Drupal and other CMS's it typically just appears near the default login options. How do I enter my Facebook app ID and get this going?

Note: // There is no documentation to be found on this Facebook extension so any suggestions would be rad.


texts: Improve performance - Catalog Search Fulltext

texts:
Do you have some suggestion how can I improve the performance of the catalogsearch_fulltext indexer for Magento 2.1.X

I already set this indexer to 'Update By Schedule' so only the updated products are refreshed thanks to Mview pattern.

I have ElasticSearch as search engine, but it is not really related to it.

I have around

20k products
7k products visible in search by store
31 stores
less than 10 new custom searchable attributes

For a full re-index, Magento took around 10 minutes by stores, so around 5 hours for all stores.

I plan to re-index each store in parallel and increase the server CPU and memory because each catalog search index seems independent by stores.

I try to import products with a differential approach, but sometime my customer needs a full product import.

Edit: I did a POC thanks to https://github.com/amphp/parallel reducing from 5 hours to 14 min using the c5.9xlarge EC2 instance with 36vCPU. But I want to know if there is alternative solution. (>1000$ per month)


texts:
On hover, Magento 2 gives a dropdown functionality, like megamenu, cart, and My account drop-down.
The issue on the hovering the dropdown or pop up menu appears fine but when I remove my mouse and again point it to the area of dropdown submenu it shows the dropdown again although I didn't hover on the anchor or li tag this time.

ex- When I hover my mouse on the anchor of what's new then this submenu opens,

  Black marked line is my house position

When I remove my mouse away from the anchor tag and submenu area and then point my mouse to click other things in the homepage, but since due to previous what's new hover submenu still takes some kind of z-index so it again opens the submenu

This is awkward behavior. It works fine when I click somewhere else after the first hover and then try to hover.

Mega menu should fade/disappear quickly when user leaves the menu area. If within short time user moves around Add to cart option, menu becomes visible distracting the user

How to fix this issue


texts: Add to cart button is redirecting to check out page

texts:
If we click on "add to cart" button , it's redirecting to "checkout page", but it should stay on same page.

This is our addtocart.phtml   http://pastebin.com/37P4wUdb

Please help me to find solution


texts: How can I remove the white borders from images? Magento 2.1

texts:
All my images appear like this.

<image id="category_page_grid" type="small_image">
    <width>240</width>
    <height>300</height>
    </image>
    <image id="category_page_grid-1" type="small_image">
    <width>240</width>
    <height>300</height>
</image>

Thats the setting in my view.xml file. I changed the width/height, but the outcome was the same. I've checked the images and there is no border on them in PS. So my only guess is that Magento applies this? The image size is 1080 x 720 jpg. Do I need to increase its dimensions?

EDIT:

Seems that increasing the image size to over 1600 x 1200 will remove this border.


texts: Magento 2 : Set free shipping method programatically from an observer

texts:
I need to add free shipping method fro particular quote in an observer.
I am calling an event sales_quote_collect_totals_before.

And my observer code is -

namespace Vendor\Module\Observer;

use Magento\Framework\Event\Observer as EventObserver;
use Magento\Framework\Event\ObserverInterface;

class SalesQuoteCollectTotalsBefore implements ObserverInterface
{
    public function execute(EventObserver $observer)
    {
        $quote = $observer->getEvent()->getQuote();
        $address = $quote->getShippingAddress();
        $address->setFreeShipping(true);
    }
}


texts: How to display my stores google Business Reviews on my custom phtml page

texts: I want to display 32 stores of google business reviews on my custom phtml page, how to get that. What is the best approach to do this.


texts: Magento 2 Remove cart content when user log-out | Empty cart when logged back in

texts:
Correct me if I'm wrong, but completely removing the cart content on customer log-out is not native to Magento 2 is it?

I read about the "Persistent cart" but it seems to work only for removing the cart content on logout but when the user logs back in, they get their cart content back.

I try to achieve the following scenario:

Customer logs in to the website.
Adds a product to cart.
Logs out of the website.

Cart is empty (Persistent cart feature can do that)

Customer logs back in to the website.

Cart is still empty (Not sure if this can be achieved using native functionality)

If this can be done using Native features of Magento 2 that would be great. If not, has anybody done that before? Any guidance will be appreciated.


texts: It seem's that after upgrading to the latest mage 2 build, the category admin layout has changed slightly (unless i'm missing something) and I'm unable to see my custom category attributes....


texts: Get Tier Price of Configurable Products that contain simple products : Magento 2.3

texts:
Currently, I am using the following code in addtocart.phtml to retrieve tier price data:

$allTiers     = $_product->getTierPrice();
$checktiers   = array_values($allTiers);
$tierPrices   = json_encode($checktiers);

This only works for simple products and not configurable products that contain simple products. The output on the configurable products always return empty array.

How can I retrieve tier price data from a configurable product that contains multiple simple products?

Any help?

Thanks in advance...!!!


texts: How to show price using echo $block->getDisplayValue() in list.phtml file?

texts:
I found product price which is showing on the single product page. And it's coming form default.phtml file inside Catalog/product/price/amount/default.phtml.

This code is using

<?php echo $block->getDisplayValue(); ?>

to display the price in that file.

Now i want to show this price in my product list page and when i am trying this code, show the product price. I am getting $0.00 ?

Can anyone tell me why this happening ?


texts: How to Change Order and Rename Links in customer navigation?

texts:
How to Change placing order for customer navigation, I need order as showing in below Image:

and also how to Rename the text (eg: Instead of my product list I need My Grocery List)


texts: How to add Custom Currency option in Magento 2.1.3 Admin

texts:
I have two different stores on my website. For one of the store I need to show product price in "Points" like instead of "$45.00" I need to show it as "45 points". Like in the image attached.

Note: This change is only for one store. Other store should use USD as the price.

How I can achieve this ??


texts: My product page layout configuration not responding to any changes?

texts:
** I got changes in my product page layout and I want to restore it back to the default of my theme layout .. and the product configuration does not take any effect in changes of the col in the bootstrap system .. and there is pictures of my old and new layout that I want to change**

THERE IS the OLD LAYOUT DEFAULTS THAT I WANT TO GET BACK TO IT

THATS THE DIFFERENTS BETWEEN THE OLD CONFIGURATIONS AND NEW ONE


texts: Magento 2 product custom options name and storeview scope

texts:
I have a M2 store (2.1.0) with 2 storeviews. When I change the name of a product custom option (not a product attribute) in storeview A, the name in storeview B is also changed.

Very similiar to https://community.magento.com/t5/Magento-2-Feature-Requests-and/Product-custom-option-price-scope-issue/idi-p/44973, but not with the price but the option name.

How can I fix that?

Thanks!


texts: How to get orders shipping method full name via REST API?

texts:
The order object from V1/orders/{$id} only contains the shipping methods short name, not the full (e.g. localized) name. When using an extension like matrixrate, the shipping method only contains something like matrixrate_matrixrate_123 which is completely useless.

Is there any way the get the full name via REST?