texts: Error while sudo php bin/magento setup:upgrade command in cmd

texts:
Replace App And Pub Folder of Theme In Magento2.
  After that Run Following Command : **sudo php bin/magento setup:upgrade**

  PHP Warning:
  require(/var/www/html/magento2/bin/../app/bootstrap.php):
  failed to open stream: No such file or directory in /var/www/html/magento2/bin/magento on line 14
  PHP Fatal error:  require(): Failed opening required '/var/www                                             /html/magento2/bin/../app/bootstrap.php' (include_path='.:/usr/share/php') in /var/www/html/magento2/bin/magento on line 14


texts: shell script magento cant load product model

texts:
in shell directory is file myscript.php with code

<?php
require_once 'abstract.php';

class MyModule_Shell_Myscript extends Mage_Shell_Abstract
{
    protected $_argname = array();

    public function __construct()
    {
        parent::__construct();

        set_time_limit(0);
        if ($this->getArg('argname')) {
            $this->_argname = array_merge(
                $this->_argname,
                array_map(
                    'trim',
                    explode(',', $this->getArg('argname'))
                )
            );
        }
    }

    public function run()
    {
        $product = Mage::getModel('catalog/product')->load('2');
        var_dump($product->getData());
    }
}

$shell = new MyModule_Shell_Myscript();
$shell->run();

Product with this id is in database
When i try to run command php shell/myscript.php
I got error


texts: Unable to update cart total after shipping option selected

texts:
I just updated Magento to 1.9.2 and while testing, I noticed that on the cart page, the Update Total button is always disabled even after selecting a shipping option. I'm not sure if I had this same problem before updating.

I don't see any console/JS errors or any errors in the logs. Anyone else experience this/Have any advice on how to debug? I've disabled all extensions, cleared all the cache and still have same problem.


texts: How to get Customer Id while exporting customer details in magento backend

texts:
I wish to download Customer Id while exporting customer details in Magento back-end?

Systems -> Export->Customer Main file

Can anybody guide me , how to include customer id while export customer data


texts: magento Shopping Cart is Empty on safari & explorer browsers when i add products on these browsers

texts:
My store Shopping Cart is Empty is always empty when I use safari browser and internet explorer to view my store and add to cart from this browser.
Please, can anyone help me regarding this? What can be the cause and how to solve the issue?


texts: how to redirect on product detail page after search product by sku

texts: Like I have a product with sku: xra-ss1cr-600g15k when I enter this id in search it redirect to this product detail instead of catalogsearch result filter page


texts: Magento2 Add to cart button in row with grouped products

texts:
In magento2 i want to add "Add to cart" button with qty for every single product of Grouped Product.
Is it possible? How?
I see that the form is only one.
I also need to remove the standard "Add to cart" button after the form.
See below attachment.


texts: Magento 2 $wishlist->addNewItem($productId); not working

texts:
I am trying to add wishlist item but its not working
in post man it works with
http://localhost/m233/rest/V1/wishlistapi/1/1
but not working with
http://localhost/m233/rest/all/V1/wishlistapi/1/1
Error which is appearing
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id = main_table.product_id AND cat_index.category_id = '0' AND cat_index.visibility IN (3, 2, 4) WHERE (`wishlist_id` = '1') AND (`main_table`.`store_id` IN('0')) at /opt/lampp/htdocs/m233/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'm233.catalog_category_product_index_store0' doesn't exist at /opt/lampp/htdocs/m233/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php:91)"} []

any idea , why its behaving like this ?


texts: Static block only call in few category not on all category

texts:
i made one static block, i want to display that block in all category but its only display on subcategory of furniture and another category which is created by me. but it is not call on electronic and apparel category.
   I copied catalog.xml into example_theme/layout and it is as below

<catalog_category_default translate="label">
    Catalog Category (Non-Anchor)
    <reference name="left">
        <block type="catalog/navigation" name="catalog.leftnav" after="currency" template="catalog/navigation/left.phtml"/>
    </reference>
    <reference name="content">

            <block type="cms/block" name="example_block" >
                <action method="setBlockId"><block_id>example-block</block_id></action>//this is block which i call
            </block>
         <block type="catalog/category_view" name="category.products" template="catalog/category/view.phtml">
            <block type="catalog/product_list" name="product_list" template="catalog/product/list.phtml">
                <block type="catalog/product_list_toolbar" name="product_list_toolbar" template="catalog/product/list/toolbar.phtml">
                    <block type="page/html_pager" name="product_list_toolbar_pager"/>

                </block>
                <action method="addColumnCountLayoutDepend"><layout>empty</layout><count>6</count></action>
                <action method="addColumnCountLayoutDepend"><layout>one_column</layout><count>5</count></action>
                <action method="addColumnCountLayoutDepend"><layout>two_columns_left</layout><count>4</count></action>
                <action method="addColumnCountLayoutDepend"><layout>two_columns_right</layout><count>4</count></action>
                <action method="addColumnCountLayoutDepend"><layout>three_columns</layout><count>3</count></action>
                <action method="setToolbarBlockName"><name>product_list_toolbar</name></action>
            </block>
        </block>

    </reference>
</catalog_category_default>

so, how can i get solution?


texts: Magento2 products errors: Item (Magento\Catalog\Model\Product\Interceptor) with the same ID "21" already exists

texts:
Since a while I get the following when i go to catalog->products

  Item (Magento\Catalog\Model\Product\Interceptor) with the same ID "21"
  already exists

That is a product existing but its not duplicated.
Also there are no duplicated rewrite urls or anything.

When i hard deleted the product entity from the DB i could get the table to load but still i get all kinds of popup with errors.

There is no logging in exception.log debug.log or anything to pull in more info


texts: How to reindex one product from observer?

texts: I have an observer function that calls before product save. I want to reindex one single product (the one that it is edited in observer).


texts:
Recently I transfer my hosting to Godaddy. They did a site migration for me. However, after the migration, there is a weird situation that

when a new order comes in, I can see it when I first logged in. But after a while, the order just disappear. I couldn't find it even in my database.
I have configured the email setting. I can receive and sent email properly. But I cannot receive the copy of new order email

my site is www.vehicode.com

Can Someone please help me with this. Thank you.


texts: Magento2 - Add custom attribute after SKU in e-mail

texts:
we are using magento 2.1.9ce

In the transactional sales e-mails is the sku shown.
I have found that the vendor/magento/module-sales/Block/Order/Email/Items/Order/DefaultOrder.php controls this sku.

Now I would like to add in the same line a custom attribute.
So we get: SKU: defaultSKU / customSKU

Now I have tried for testing to replace the default SKU with the custom attribute like this:

  return $item->getAttribute('artikelnummer');

But in my sales e-mail the SKU line stays empty.
The attribute name of the custom SKU is artikelnummer

How can I do this?


texts: SUPEE-11086 Missing patches for magento versions

texts: I don't see a patch for 1.9.0.1 is this an error by the magento team or is it not supported?


texts:
For SEO, I need to change few URLs like below:

My magento site has the same content on these URL's:

URL 1: www.example.com/some-product-page/

URL 2: www.example.com/category/subcategory/some-product-page/

I need that URL 1 moves to URL 2.

URL: www.example.com/category/

URL: www.example.com/category/?p=1
has the same content, how to fix it?


texts:
I'm creating a SOAP v2 api in Magento, and one of the methods is to upload an image to the Magento media folder.
So my question is: how can I send an image to magento without using a form? and how can I upload it to the media folder.


texts: How to get data from url and pass it to block method

texts:
I need to get data from url and pass it block method for some operation.
Basically i need to list some content on specific id in magento.

my controller function is
----------------------------

        public function showArchiveAction() {

            $id = $this->getRequest()->getParams('o');
            $this->loadLayout();
            $this->renderLayout();
          }

my block method
----------------
public function getMagazine($id)
     {

      $defaultMagazine = Mage::getModel('magazine/display')->getCollection()->load($id);
      $data = $defaultMagazine->getData();
      $defaultMagazineId = $data[0]['magazine_id'];
      $collection = Mage::getModel('magazine/page')->getCollection()->addFieldToFilter('magazine_id',$defaultMagazineId);

      return $collection;
      }


texts:
I have something like that:

<?php echo "<form><input style="."text"." id="."email"."name="."email"." placeholder="."email".">"

How can i send this email to ProductController?
I am trying like that:

 $data = $this->getRequest()->getPost();
         var_dump($var = $data['email']);

But it didin't work, any ideas?


texts: How to add after plugin /vendor/magento/module-customer-graph-ql/Model/Resolver/CreateCustomer.php resolve() method?

texts:
How to add after plugin
/vendor/magento/module-customer-graph-ql/Model/Resolver/CreateCustomer.php

resolve() method ?
etc/di.xml
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/ObjectManager/etc/config.xsd">
    <type name="Magento\CustomerGraphQl\Model\Resolver\CreateCustomer">
        <plugin name="segment_create_account_plugin" type="Vendor\Module\Plugin\CreateAccount" />
    </type>
</config>

CreateAccount.php
<?php

namespace Vendor\Module\Plugin;

class CreateAccount
{

    protected $logger;
    public function __construct(\Psr\Log\LoggerInterface $logger)
    {
        $this->logger = $logger;
    }
    public function afterResolve(\Magento\CustomerGraphQl\Model\Resolver\CreateCustomer $subject, $result,$context, $info) {

        $writer = new \Zend\Log\Writer\Stream(BP . '/var/log/CustomerRRegisterplugin1.log');
        $logger = new \Zend\Log\Logger();
        $logger->addWriter($writer);
        $this->logger($subject);
        $writer = new \Zend\Log\Writer\Stream(BP . '/var/log/CustomerRRegisterplugin2.log');
        $logger = new \Zend\Log\Logger();
        $logger->addWriter($writer);
        $this->logger($context);

    }

}


texts: How to show ts_dimensions attributes in product edit panel?

texts:
I have a three attributes:
How can I show them in Product Editor?


texts: Invoice view in admin missing totals and footer

texts:
I have a problem when viewing single invoice in Magento admin. When I open an invoice it is missing the totals section and the footer completely. I attached a screenshot. The grey area in the screenshot is the missing magento admin footer.

Any ideas what could cause this? I have recently upgraded from 1.5.0.1 to 1.8.1.0. There was also a problem with printing invoices, but it was solved by editing the FileParserDataSource.php and to my understanding it was because of some php version clash or something like that.


texts: Magento2 module not getting detected after installing via composer

texts: Magento2 I am confused about why the module is not getting deducted after installing via the composer. When I run the cmd of setup upgrade the module is not getting configured.


texts: Magento 2.4 installed with composer fail when setup:install for error with composer.json in var/composer_home/

texts:
I try to install Magento 2.4 installed with composer without any errors.
bin/magento setup:install \
--backend-frontname=admin999 \
--base-url=https://magento24.test \
--base-url-secure=https://magento24.test \
--db-host=localhost \
--db-name=aesa_mgt2 \
--db-user=aesa_mt2usr \
--db-password=7syQ74Si8yHqnags239 \
--admin-firstname=Abdelkarim \
--admin-lastname=Mateos \
--admin-email=abdelkarim.mateos@castris.com \
--admin-user=abkrim \
--admin-password=2wwYDR7zWwXo4zDs \
--language=es_ES \
--currency=EUR \
--timezone=Europe/Madrid \
--use-rewrites=1 \
--search-engine=elasticsearch7 \
--elasticsearch-enable-auth=false \
--elasticsearch-host=127.0.0.1 \
--elasticsearch-port=8080 \
--cleanup-database \
--enable-modules=all \
--session-save="files"
...
Module 'Magento_ComposerRootUpdatePlugin':
Installing data... Reading /home/abkrim/Sites/magento24/composer.json
Loading config file /home/abkrim/Sites/magento24/var/composer_home/auth.json
Loading config file /home/abkrim/Sites/magento24/composer.json
Loading config file /home/abkrim/Sites/magento24/auth.json
Reading /home/abkrim/Sites/magento24/auth.json
Failed to initialize global composer: Composer could not find the config file: /home/abkrim/Sites/magento24/var/composer_home/composer.json
To initialize a project, please create a composer.json file as described in the https://getcomposer.org/ "Getting Started" section
Reading /home/abkrim/Sites/magento24/vendor/composer/installed.json
Reading /home/abkrim/Sites/magento24/composer.lock

Well after this error, I've created a empty var/composer_home/composer.json with
{}

Also put a  var/composer_home/auth.json with same auth.json that root auth.json (my credentials on magento)
Work fine for this error or warnings. But get same error in other questions, with Magento_CatalogSampledata
[Progress: 740 / 1283]
Module 'Magento_CatalogSampleData':

In PatchApplier.php line 170:

  Unable to apply data patch Magento\CatalogSampleData\Setup\Patch\Data\InstallCatalogSampleData for module Magento_CatalogSampleData. Original exception message: Rolled back transaction
   has not been completed correctly.


texts: Show popup with item info on clicking add to cart

texts:
I need to display a popup with item name and its other attributes like color, manufacturer, etc when we add this product in cart.
I need to display the popup on clicking add to cart button on product page.
Please guide me, I have tried few things like getting product info after "product_add_to_cart_complete" event but didn't get appropriate result.
I want to show all the product info as it is coming in cart page, like if we have a configurable product, then product is appearing with its option on cart page, same is wanted on popup also.


texts: backend_clean_cache cron never completes

texts:
If I run
SELECT job_code,scheduled_at,executed_at,finished_at FROM cron_schedule where executed_at is not null and finished_at is null;
I can see backend_clean_cache never completes
Has anyone had this issue or does anyone know how to call backend_clean_cache manually so that I can try to debug to see what it never completes


texts: Magento 2 - Programatically updating the inventory store wise not working

texts:
I have a function to update the product inventory progrmmatically.below is my function in the helper file.

protected $stockRegistry;
...
public function __construct(
.... //Some code--
    \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry) {
     $this->stockRegistry = $stockRegistry;
}
public function updateStockAndPricesByStore($productId,$store_data,$sku)
{
    $productFactory = $this->_productFactory->create();

        foreach($store_data as $store){
            $store_datas = explode("-",$store);

            $store_id = $store_datas[0];
            $qty = $store_datas[1];
            $price = $store_datas[2];

            $this->productResourceModel->load($productFactory, $productId);
            $productFactory->setStoreId($store_id);
            $productFactory->setPrice($price);
            $this->productResourceModel->saveAttribute($productFactory, 'price');

            $stockItem = $this->stockRegistry->getStockItemBySku($sku, $store_id);
            //$stockItem->setStoreId($store_id);
            $stockItem->setQty($qty);
            echo "Stock Also Updated";
            $stockItem->setIsInStock((bool)$qty); // this line
            $this->stockRegistry->updateStockItemBySku($sku, $stockItem);
        }
}

This is my array i am passing as $store_data.

  Array ( [0] => 1-11-11 [1] => 2-22-22 ) - (store_id - qty - price)

Whenever updating for both stores, last qty updated to both store but price is correctly updating .

How can i update the inventory store wise programatically in Magento 2.


texts: Best way to redirect from observer in magento 2

texts:
I am trying to redirect from observer but it does passing in Magento marketplace validations.

Tried.

$this->redirect->setRedirect($customRedirectionUrl);
$this->_response->create()->setRedirect($url)->sendResponse();
 $this->_messageManager->addError($message);
$this->_responseFactory->create()->setRedirect($url)->sendResponse();

I need a redirect method which does not depend on exit and die because magento does not allow that.


texts:
I am creating a bespoke extension and I want to allow the admin to choose to restrict by product types eg Simple, Configurable, Bundle etc

The issue is I am not sure what source model to use.

I have the following code in my system.xml

<field id="product_types" translate="label" type="multiselect" sortOrder="1" showInDefault="1" showInWebsite="0" showInStore="0">
   <label>Product Type</label>
   <source_model></source_model>
   <comment>Restrict defined product types</comment>
</field>

Could anyone advise which source model I need to use so that the options in the multi-select are the product types eg Simple, Configurable, Bundle etc


texts:
I am creating a custom API in magento 1.9, but i don't know how to give url for the request and response
here is the api route
<routes>
   <route_entity>
      <route>/servicebms/inboundoncall/:call_date/:call_time/:caller_number/:called_number/:call_status/:agent_number/conversation_duration/:call_duration/:call_type/:recording_url</route>
      <action_type>entity</action_type>
   </route_entity>
   <route_collection>
       <route>/servicebms/calls</route>
       <action_type>collection</action_type>
   </route_collection>
   </routes>

I tried with the URL http://127.0.0.1/rest/api/servicebms/calls/(parameters)
In post man response i am getting home page code and status as 404 NOT FOUND Error.
Whar url shoild i give to get proper response


texts: Magento 2: I need to initialize the object manager out of foreach loop

texts:
I need to initialize the object manager out of for each loop.

Here is my code:

<?php
namespace Abc\Mkt\Controller\Adminhtml\Order;
    use Magento\Framework\Stdlib\DateTime;
    use Magento\Framework\App\Config\ScopeConfigInterface;
    class Masssync extends \Magento\Backend\App\Action{
        /**
         * Masssync Action for Mass Sync of customer with Marketo
         * @return Void
         * */
        protected $_objectManager;
        protected $_api;
        protected $scopeConfig;
        public function __construct(Orderapi $Api, ScopeConfigInterface $scopeConfig, \Magento\Framework\Json\Helper\Data $jsonHelper, \Magento\Customer\Model\Customer $customerData,\Magento\Framework\ObjectManagerInterface $objectmanager, \Magento\Backend\App\Action\Context $context)
        {

            $this->scopeConfig = $scopeConfig;
            $this->jsonHelper = $jsonHelper;
            $this->dataHelper = $dataHelper;
            $this->customerData = $customerData;
            $this->modelData = $modelData;
            $this->_objectManager = $objectmanager;
            $storeScope = \Magento\Store\Model\ScopeInterface::SCOPE_STORE;
            parent::__construct($context);
        }
        public function execute(){

                    $customerIds = $this->getRequest()->getParam("selected");
                     foreach ($customerIds as $customerId) {
                                $item = $this->_objectManager->create('\Abc\Mkt\Model\Data');
                                $customer = $this->customerData->load($customerId);
                                $item->setCustomerId($customerId);
                                $item->setSyncWithMarketo(1);
                                $item->save();
                                $data['FirstName'] = $customer->getFirstname();
                                $data['LastName'] = $customer->getLastname();
                                $data['Email'] = $customer->getEmail();
                                $allfield = array("email");
                                array_push($mergeData,$data);
                        }

                }
        }

Please suggest

Thanks


texts: How to set a page to display sub-categories and not products?


texts: How do I use a custom attribute as the final price of a product?

texts:
I created 2 attributes: sale (yes/no) and sale_price

I would like to be able to determine whether sale is set to yes, then use the sale_price as the final price of the product, "overriding" the regular price, special price, tier prices, and if possible Catalog Price rules too.

Is this possible?


texts: Character encoding issue when importing articles description into magento

texts:
I put all articles in a csv file with swedish characters åäö and thai characters กขค and some other characters like é.

Saved it in excel Apple OSX csv. Opened Textwrangler and replaced all ; with ,
Sets character encoding to Unicode (UTF-8) and Windows CRLF.

Magento displays wildcard character � for the swedish characters.
Not sure what character encoding or how I should save it so that magento will be able to display properly.


texts: How Can I get breadcrumbs in block to add on any new page?

texts: Can I get breadcrumb in block ? so I can add this block on any page ?


texts: Magento 2 Custom Payment Method Status Change New order instead of Processing

texts:
I'm using Magento 2.1 for when I'm using Custom Payment Method than Status Change New order instead of Processing.

kindly help me, anyone


texts: problem with installing the quick payment module

texts:
I try to install extension payments online 'Dotpay' on my store.

https://github.com/dotpay/Magento2

b) copying plugin files to:
- app/code/Dotpay/Dotpay

In next step I go to System > Web Setup Wizard > Component Manager and select enable module and install.

When I try install I get error.

Can anyone know how to solve this?


texts: Magento2 : Manage and understand images of deleted products behavior?

texts:
I'm trying to understand how M2 handle images of deleted products. If I delete a product (by admin or import/delete), all associated images in the media/catalog/product folder are still here.

In M1 and Magento Image Clean installed, I was able to remove all images of a deleted product. The same extension Magento 2 Image Clean for M2 fetch only 1 unused image.

After many reading, I found this Magento 2, How to delete unused images using PHP script. The solution seems to use the php bin/magento eav:media:remove-unused command of magento-hackathon/EAVCleaner but still only 1 image found (same that the previous extension).

I try a script on my own who scan the catalog_product_entity_media_gallery table, then scan the media/catalog/product folder to look for the difference but there is not. After digging into the database, I just realize that M2 keep records of old deleted product images in the DB.

Question is: how do you manage disk usage with all these useless images ?? My store has almost 4 collections/year and around 11.000 products to change... in only 6 months media/catalog/product folder size is around 6GB (without the cache) and still growing.

PS: I'm on a 2.1.9 version


texts: Order information is replaced by an unknown U.S. address

texts:
Recently I discovered a very strange thing going on in Magento store.
Some kind of virus or something is changing order information.

As you can see order is from United States. I tried ordering myself, typed in random order info like sdfsdfsdfs. But when I looked up in orders found this. Any suggestions what can I do about it? I'm very lost on this one, never happened before.


texts: Where are the meta-titles for categories set/created by default?

texts:
I want to change my page titles for categories but cannot find where it's originally set.

Right now, they look usually like this: Laptops - Computers - Electronics - Magento

But I cannot find the piece of code that lines up all the categories and seperates them with " - "

I expected it to be in

Mage_Page_Block_Html_Head

Or in

Mage_Catalog_Block_Category_View

Or maybe

Mage_Catalog_Model_Category

but it was nowhere to be found.

In Category_View the title gets only set when there is a title set in the backend:

if ($title = $category->getMetaTitle()) {
      $headBlock->setTitle($title);
}

but there's no else after that.

In     Mage_Page_Block_Html_Head there is the method getDefaultTitle() which I'd expect to be called when no title has been set.

I am aware that I don't necessarily need to find that piece of code to change my title but it would certainly help to understand magento better.

For clarification:
I am talking about meta-titles.
I know how to set them.
I want to know where they are set that they look like this:
Laptops - Computers - Electronics - Magento

Thanks


texts: Easiest method to install Facebook Pixel

texts:
Complete coding illiterate here so forgive my incompetence.

Trying to install Facebook Pixel in my store, would simply copy & pasting my pixel code into here work?

Any help and advice are greatly appreciated.


texts: Magento 2: import product with many other data fields

texts:
I want to import many products with many custom fields. How can I do that, I hope anyone helps me, Thank in advance.
Here is notice when I import product with many custom field


texts: Hostname validation; new gTLD & store email addresses

texts:
UPDATE: While I got the answer I needed down below, this question was later asked again in this post and received a more elaborate answer.
My magento store is hosted on a 'new' gTLD (.boutique), but Magento does not allow me to set the store email addresses with this tld.
I understand that Magento's validation runs through the Zend framework and the responsible file for validating the TLDs is 'Hostname.php' in /lib/Zend/Validate/.
However, adding all the TLDs from http://data.iana.org/TLD/tlds-alpha-by-domain.txt as suggested in this thread on the Magento forums did not solve my problem.
I thought perhaps it was an issue with Magento storing the previous Zend file in a cache, so I already tried clearing all cache files from the cache management page; this did not resolve the problem.
Am I overlooking any other arrays or such that should include all the TLDs? Should I clear the cache in another way? Anything else altogether?
Any help is much appreciated.
EDIT: I was naughty and actually edited the Zend file in /lib/Zend/Validate/Hostname.php after making a Hostname.php.bak file in the same dir. Moving the edited Hostname.php file to /app/code/local/Zend/Validate/ and restoring the original Hostname.php.bak in the Zend library as suggested by the marked answer solved the problem.


texts: How to set up a/b testing in Magento 1.9?

texts:
Is there anyone in this forum that can explain how a/b (split) testing can be set up in Magento 1.9+?

I have searched on the internet but couldn't find real help.


texts:
Customer Grid indexer process unknown error:

SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'group_id' used in key specification without a key length, query was:

 CREATE TABLE IF NOT EXISTS `customer_grid_flat` (
  `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
  `name` text NULL COMMENT 'Name' ,
  `email` varchar(255) NULL COMMENT 'Email' ,
  `group_id` text NULL COMMENT 'Group_id' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created_at' ,
  `website_id` int NULL COMMENT 'Website_id' ,
  `confirmation` varchar(255) NULL COMMENT 'Confirmation' ,
  `created_in` text NULL COMMENT 'Created_in' ,
  `dob` date NULL COMMENT 'Dob' ,
  `gender` int NULL COMMENT 'Gender' ,
  `taxvat` varchar(255) NULL COMMENT 'Taxvat' ,
  `lock_expires` timestamp NULL default NULL COMMENT 'Lock_expires' ,
  `shipping_full` text NULL COMMENT 'Shipping_full' ,
  `billing_full` text NULL COMMENT 'Billing_full' ,
  `billing_firstname` varchar(255) NULL COMMENT 'Billing_firstname' ,
  `billing_lastname` varchar(255) NULL COMMENT 'Billing_lastname' ,
  `billing_telephone` varchar(255) NULL COMMENT 'Billing_telephone' ,
  `billing_postcode` varchar(255) NULL COMMENT 'Billing_postcode' ,
  `billing_country_id` varchar(255) NULL COMMENT 'Billing_country_id' ,
  `billing_region` varchar(255) NULL COMMENT 'Billing_region' ,
  `billing_street` varchar(255) NULL COMMENT 'Billing_street' ,
  `billing_city` varchar(255) NULL COMMENT 'Billing_city' ,
  `billing_fax` varchar(255) NULL COMMENT 'Billing_fax' ,
  `billing_vat_id` varchar(255) NULL COMMENT 'Billing_vat_id' ,
  `billing_company` varchar(255) NULL COMMENT 'Billing_company' ,
  PRIMARY KEY (`entity_id`),
  INDEX `CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
  INDEX `CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
  INDEX `CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
  INDEX `CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
  INDEX `CUSTOMER_GRID_FLAT_DOB` (`dob`),
  INDEX `CUSTOMER_GRID_FLAT_GENDER` (`gender`),
  INDEX `CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
  FULLTEXT `FTI_8746F705702DD5F6D45B8C7CE7FE9F2F` (`name`, `email`, `created_in`, `taxvat`, `shipping_full`, `billing_full`, `billing_firstname`, `billing_lastname`, `billing_telephone`, `billing_postcode`, `billing_region`, `billing_city`, `billing_fax`, `billing_company`)
) COMMENT='customer_grid_flat' ENGINE=innodb charset=utf8 COLLATE=utf8_general_ci

Category Products index has been rebuilt successfully in 00:00:02
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:01
Product EAV index has been rebuilt successfully in 00:00:01
Stock index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00

we tried:

on phpmyadmin setting customer_eav_attribute

we changed id 10 (group_id) is_sercheable_in_grid to value 1


texts: Magento 1.9 Google Analytics acquisition not working

texts:
I'm running a Magento 1.9 store and have added the GA tracking code to the back end of Magento and this is tracking conversions just fine. To a degree.

While the code appears on the site when I place test orders correctly when I look in Analytics Conversions it's approximately 1/2 of what we would expect to see.

When trying to narrow down where the missing conversions were I was looking through acquisition and spotted a weird trend. The only channel we can see revenue for is the Referal channel.

Direct, Organic search, Social, Paid search and Email all have a number of sessions against them so standard tracking is recording them entering the site, but the only channel to display revenue is Referal.

To me this looks like something wrong with Magentos tracking code forgetting the user after they enter the site and thinking they're a referral user from them on. Does anyone have any insight on this issue?

EDIT

Looking at the aquisiiton breakdown on referrals also shows that checkout.sagepay.com and paypal.com are the only referrals with conversions with 0% new sessions


texts:
I am looking at creating a store along the lines of Etsy, where we sell items on behalf of other people who will have their store hosted on the site. I have found a few extensions that may provide this functionality but all I have found have either had no demo, a demo that breaks in places, not many reviews or downloads, or are just not seemingly that reliable. I don't want to part with any money for extensions that may not fit the bill, so does anyone have any recommendations?

The extension needs:

To provide different store fronts for each seller
The ability for the user to login and add/remove/change products in their own store
The ability for the site admin to add/remove/change products in ANY store
The ability to have a profile page for each user
To stop the seller from changing the design of their store, or provide an option to disable this functionality
To produce invoices from the seller to the buyer.
Be able to remove commission for a payment before sending to the seller, and send an invoice to the seller for that commission

There will probably be other issues as well but if I can find something that produces most of this I can make the other required changes. So has anyone had experience with this type of store? Where would be the best place to look for info? What are the best extensions of this type that you know of?


texts: couldn't import Magento Table Rate Price vs. Destination CSV file

texts:
I am having difficulties to configure Magento table rate shipping method.
I want to charge $15 shipping fee for orders to California and charge $25 for orders to the rest of the country.

I choosed main website in "Current Configuration Scope", then navigated to Shipping Methods, Under "Table Rates" I first export the csv file and edited it using Open Office software. Below is what is in the file:

Country Region/State Zip/Postal Code Order Subtotal (and above) Shipping Price

US, *,  *,  0,  25

US, CA, *,  0,  15

Then I went back to "Table Rates" clicked on browse button next to "import" chose the file I just finished edit, Then clicked on "Save Config". I notice there is a message next to the browse button says "no file selected".

Anyone know why this file is not uploading?
Thanks for your help in advance!


texts:
I try to change Order Grid, but I don't know where I have a problem ...
There is my files:

app/code/local/My/Module/etc/config.xml

<?xml version="1.0"?>
<config>
    <global>
        <blocks>
            <adminhtml>
                <rewrite>
                    <sales_order_grid>My_Module_Block_Adminhtml_Order_Grid</sales_order_grid>
                </rewrite>
            </adminhtml>
        </blocks>
    </global>
</config>

Inside app/code/local/My/Module/Block/Adminhtml/Order/Grid.php I've just copy the methods from Mage_Adminhtml_Block_Sales_Order_Grid change class name to My_Module_Block_Adminhtml_Order_Grid and comment out this:

    $this->addColumn('grand_total', array(
        'header' => Mage::helper('sales')->__('G.T. (Purchased)'),
        'index' => 'grand_total',
        'type'  => 'currency',
        'currency' => 'order_currency_code',
    ));

I expected that G.T. (Purchased) disappear but is not.
So i tried another easier way. I've just copy app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.php to app\code\local\Mage\Adminhtml\Block\Sales\Order\Grid.php and repeat action but still nothing. I'm totally Magento Newbie so please to some help.


texts: Magento 2.3 : Serving site from pub, now images get 404

texts:
My original installation of v2.3.0 was working fine. All images showed up for categories. I decided (after setting up a lot of categories and images for those categories) to serve the site from pub.

The only code customization my site has is a modification for a bug that is apparently fixed in v2.3.1. Other than that, i have no third party modules installed or other code customizations.

I followed docs to make site more secure using Ubuntu and Apache2 (not nginx). When i visit a page with images (front-end or admin area), i get a 404 not found for the image. Page loads text and css but console outputs:

GET http://192.168.5.10/pub/media/Shoes/nike.jpg 404 (Not Found)

What i've tried that did not work:

Looking for errors in /var/log/apache2/error.log and  /var/log/apache2/error.log (found nothing other than a record of 404 but no permission errors.)
Checked magento/var/log/system.log, magento/var/log/exception.log and magento/var/log/debug.log, no permission errors.
Switching modes:

bin/magento deploy:mode:set production
bin/magento cache:flush
bin/magento deploy:mode:set developer
bin/magento cache:flush

Made sure had default .htaccess in magento directory.
Made sure pub/ had default .htaccess.
Doc: bin/magento setup:static-content:deploy -f
"Flush Cache Storage", "Flush Magento Cache", "Flush Catalog Images Cache", and "Flush Static Files Cache" from admin area > System > Cache Management.
Refresh all cache types from admin area > System > Cache Management.
Re-ran permissions as root cd /var/www/html/magento2 && find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} + && find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} + && chown -R :www-data . && chmod u+x bin/magento
Ran alternative permissions commands (does same thing as above):

cd /var/www/html/<magento install directory>
find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} +
find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} +
chown -R :www-data . # Ubuntu
chmod u+x bin/magento

Checking permissions of example image from magento directory:

magentouser$ ls -al pub/media/Shoes/nike.jpg
-rw-rw-r-- 1 magentouser www-data 77645 Jan 15 17:14 pub/media/Shoes/nike.jpg

rm -rf var/cache
bin/magento indexer:reindex
Checked my /etc/apache2/sites-available/000-default.conf

Listen 8080
<VirtualHost *:80>

    ServerAdmin webmaster@localhost
    DocumentRoot /var/www/html/magento2/pub

    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined

</VirtualHost>
<Directory "/var/www/html">
AllowOverride all
</Directory>

Re-started systemctl restart apache2
Change DocumentRoot back to /var/www/html/magento2, and restarted apache2.

Note: i was in the wrong demo server the first time i tried step 16 again. I had spun up so many test servers trying to re-duplicate the issue in different ways (too many terminals open trying to test different variations without attention to IP). I noticed while deleting all the demo servers from the network that the command was in the wrong one. After switching server 56 back to documentRoot to /var/www/html/magento2, and restarting apache on server 56, all images show up again normally. but the URL is still like (example): http://192.168.5.10/pub/media/Shoes/nike.jpg. I'm still not sure how "pub" got in there or even how i would add "pub" if it was't there and I wanted it, or how to remove it from the url and make the system look in the right place without having to re-upload all my images. This test confirmed again that when not serving from pub, the site works fine...but images appear to be already served in a strange way (unable to confirm this without a snapshot of the system before following docs to serve from "pub")

How do you resolve this?


texts: Unable to override Magento Adminhtml Block

texts:
I've been going around in circles here trying to find reason why my block is not loading when i extend it. Can you help me to extend it
Original file is

app/code/core/Mage/Adminhtml/Block/Catalog/Product/Attribute/Edit/Tab/Options.php

my file

app/code/local/Comp/Module/Block/Adminhtml/Catalog/Product/Attribute/Edit/Tab/Options.php

comp_module/app/code/local/Comp/Module/etc/config.xml

<?xml version="1.0" encoding="UTF-8"?>

<config>
    <modules>
        <Comp_Module>
            <version>0.1.0</version>
        </Comp_Module>
    </modules>
    <global>
        <blocks>
            <module>
                <class>Comp_Module_Block</class>
            </module>
            <adminhtml>
                <rewrite>
                    <catalog_product_attribute_edit_tab_options>Comp_Module_Block_Adminhtml_Catalog_Product_Attribute_Edit_Tab_Options</catalog_product_attribute_edit_tab_options>
                </rewrite>
            </adminhtml>
        </blocks>
    </global>
</config>

app/etc/modules/Comp_Module.xml

<?xml version="1.0" encoding="UTF-8"?>
<config>
    <modules>
        <Comp_Module>
            <active>true</active>
            <codePool>local</codePool>
        </Comp_Module>
    </modules>
</config>


texts: How can I make similar pages in magento 2

texts:
I would like to create a similar pages in my main categories in my website. How are these possible to make?
For example now if i click on any main category lets say "School supplier" in my website it opens the product category page that has many different products available, which is;
I would like similar page to show when clicked on a main category from the menu bar "School supplies"
it will show similar page with different images related to different categories within the main category school supplies


texts: How to make the second address field required during checkout?

texts:
I have config set to display 2 lines for address during checkout (Configuration → Customer → Customer Configuration → Name and Address Options):

Number of lines in a street address: 2

How can I make the second line a required field? Only the first field seems to be required. I've looked in the eav_attribute table & can't seem to find it listed there.


texts: Stock reduction on Invoice instead of Order

texts:
Currently, stock gets reduced when the Order has been placed, is there any way to change on invoice?

As there, lot of junk orders, is there any way to make stock reducing when invoice for the corresponding stock has been made.


texts:
In Magento2.1, I'm able to load a product in CMS page using:

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$product = $objectManager->get('Magento\Catalog\Model\Product')->load(1);

Then I'm trying (without any luck) to display the add-to-cart link using:

<?php echo Mage::helper('checkout/cart')->getAddUrl($product) ?>

What am I doing wrong?

p.s. I saw many Q&A about this topic but none of them seems to work in my project.

EDIT

I've just found the following that actually displays the link, but it completely breaks the layout.

$listBlock = $objectManager->get('\Magento\Catalog\Block\Product\ListProduct');
$addToCartUrl =  $listBlock->getAddToCartUrl($product);

echo $addToCartUrl;

EDIT 2

so I did some tests and got inconsistent results.

I was able to display an add-to-cart button with the following:

<?php
    $objectManager = \Magento\Framework\App\ObjectManager::getInstance();
    $listBlock = $objectManager->get('\Magento\Catalog\Block\Product\ListProduct');
    $addToCartUrl =  $listBlock->getAddToCartUrl($product);
?>

<form data-role="tocart-form" action="<?php echo $addToCartUrl; ?>" method="post">
    <?php echo $block->getBlockHtml('formkey')?>
        <button type="submit"
            title="Add to Cart"
            class="action tocart primary dark">

Add to Cart

        </button>
 </form>

This button does not add anything to the cart untill I click on the link built with:

<a href="<?php echo $objectManager->get('Magento\Checkout\Helper\Cart')->getAddUrl($product) ?>">ADD TO CART

After that, the JS button start working correctly.. I'm currently at a dead end


texts: My store currency euro but on checkout page currency showing in dollar in magento2

texts:
All prices are in euro but charged currency showing in dollar in Magento2
How to change Dollor to Euro for checkout page?


texts: Can't log into Secure (SSL) Magento site on front end in Chrome

texts:
I've been having a constant struggle with being able to log into the site www.dragondirectsales.com. It's a magento 1.9.1 site. The site has a subdomain, cas.dragondirectsales.com. Everything seemed fine until we moved the site to the live hosting that they are currently using.

Ever since, we've been fighting issues with logging in, both on the front end (customer logins) and the back end (admin). If you attempt to log in, it just loops you back to the appropriate login screen with no error messages. Again this happens only for customer logins.

Every time it happens I spend hours trying to fix it, and manage to get it working across every test case I can think of. Then about a month later the client emails me saying it's broken again, and swearing that he hasn't touched anything in the admin section. We're on the 4th time I've had to fix this, and all the previous changes appear to still be in there, so I'm at a loss for what is causing this issue.

Right now I have the site using Secure URLs in the front end. Cookie Path is blank. Cookie Domain is .dragondirectsales.com. I'm using HTTP Only (iPad was having a separate login issue that this fixed). Cookie Restriction Mode is set to no.

The only thing that has happened between the last time this worked and now is that we had an extension developer work on the Partial Payment extension, and I'm not entirely convinced that their work had anything to do with this issue. I can turn the extension completely off from the module xmls and the issue still happens.

Any help is completely appreciated!


texts:
i want to apply coupon automatically after adding to cart.
Apply Coupon Code While Programmatically Adding Product to Cart In Magento 2
How can i acheive this one ?
Thanks


texts: keep cart contents on login in Magento 1.8

texts:
When the guest-User logs-in at checkout, the current shopping cart becomes discarded in favor of the persisted one.
This is highly annoying.

I would rather have the carts to be merged.

I assume I need an observer to monitor the login action and store the current cart to merge it in the end with the persisted cart.

Does there exist some plugin that can do that for me?
Which events should i observe to gain access to both the to be discarded cart and the old persisted one
Do you have negative experience with this kind of "black magic"?


texts: import products in each category in magento

texts: As per my client client request, we need to import all the products in magento each category. Is this possible to do that in magento 1.9 version?


texts:
We have a heavy store with a 400k+ products. So we decide to completely remove bestsellers aggregation feature. This suppose to reduce sql load, and to free space, occupied this huge unneeded tables.
How to do this properly?

Bestsellers aggregation defined in sales/observer::aggregateSalesReportBestsellersData method, which schedules by cron job.
There are some possible ways, that I see to solve this issue:

Override cron schedule. I've tried to override cron job schedule in
local/MyModule/Sales/etc/config.xml, but it didn't work.
Override sales/observer model, and replace
    aggregateSalesReportBestsellersData with empty method

I prefer solution #1, but can't make it work. Here's config of my custom module:

<config>
    <crontab>
        <jobs>
            <aggregate_sales_report_bestsellers_data>
                <schedule><cron_expr>0 5 31 2 *</cron_expr></schedule>
                <run><model>sales/observer::aggregateSalesReportBestsellersData</model></run>
            </aggregate_sales_report_bestsellers_data>
        </jobs>
    </crontab>
</config>


texts: Shipping Methods not showing up in multiple Websites

texts:
I have 2 Store Views and 2 Websites in my Magento 1.9.2.4. One of them is for the US and the other one is set to Canada. They are in the same installation and I am using a folder structure to display both websites www.mysite.com and www.mysite.com/ca/

Everything is working fine, but the Shipping Methods are not showing up in my Canada site.

It is very weird because some methods (Table Rates, Free Shipping) are working fine and I can see them on the Canada site, but Fedex and DHL show just on the US site.

I tried to use the inherited scope (Default) in System > Configuration > Shipping Methods and also tried to uncheck the "default" checkbox and have individual settings. Nothing seems to work

Any ideas of what could be the problem?

UPDATE:

I checked in the DHL log and I can see that a request is made to their API and return success, but Magento is not showing it.


texts: Layered navigation filter by product name

texts:
In Magento 1.9 I would like to filter the products returned by the layered navigation.
The collection should be filtered if the name contains a string passed through a parameter in the querystring, if present.

How can I achieve this results? Should I extend some layered navigation classes?


texts: How to clean Magento enterprise large size *_cl tables

texts:
I have magento multidomain website hosted, Automatic cleanup of such tables setting: System > Configuration > index Management > Index Clean Schedule
is on but still the size is not reduced.

Total Domains 15, Total Products 1619, Total Orders 252320

Tables:

catalogsearch_fulltext_cl         15.75G
catalog_product_index_price_cl    15.69G
cataloginventory_stock_status_cl  15.41G
catalog_product_flat_cl           13.65G
catalog_category_product_index_cl 13.43G

Please suggest.


texts: moving magento1.9 from one to another server

texts:
i moved magento 1.9 from one server to another server, but it is not working giving error "SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'"

for admin panel it is showing url not found.


texts: upload image to skin path from admin system config

texts:
In system.xml file you can upload images to /media/... by using:

<upload_dir config="system/filesystem/media" scope_info="1">modulename/folder</upload_dir>
<base_url type="media" scope_info="1">modulename/folder</base_url>

However i need to upload the image in skin/frontend/modulename/themename/css/images directory. I've tried with config="system/filesystem/skin" and type="skin" but it doesn't work.


texts: Magento 2 - Hide SHIPPER_ACCOUNT_NUMBER on FedEx shipping label

texts:
I would need to hide SHIPPER_ACCOUNT_NUMBER on FedEx shipping label.
FedEx support told me I had to set this in the module, that their API is able to hide some elements.

They gave me :

<CustomerSpecifiedDetail>
<MaskedData>CUSTOMS_VALUE</MaskedData>
<MaskedData>DUTIES_AND_TAXES_PAYOR_ACCOUNT_NUMBER</MaskedData>
<MaskedData>SHIPPER_ACCOUNT_NUMBER</MaskedData>
<MaskedData>TRANSPORTATION_CHARGES_PAYOR_ACCOUNT_NUMBER</MaskedData>
</CustomerSpecifiedDetail>
</LabelSpecification>

But I can't find which file I have to edit.

I found

  SHIPPER_ACCOUNT_NUMBER

in

  vendor/magento/module-fedex/etc/wsdl/ShipService_v9.wsdl

and

  vendor/magento/module-fedex/etc/wsdl/ShipService_v10.wsdl

:

<xs:simpleType name="LabelMaskableDataType">
    <xs:annotation>
        <xs:documentation>Names for data elements / areas which may be suppressed from printing on labels.</xs:documentation>
    </xs:annotation>
    <xs:restriction base="xs:string">
        <xs:enumeration value="CUSTOMS_VALUE"/>
        <xs:enumeration value="DUTIES_AND_TAXES_PAYOR_ACCOUNT_NUMBER"/>
        <xs:enumeration value="SHIPPER_ACCOUNT_NUMBER"/>
        <xs:enumeration value="TERMS_AND_CONDITIONS"/>
        <xs:enumeration value="TRANSPORTATION_CHARGES_PAYOR_ACCOUNT_NUMBER"/>
    </xs:restriction>
</xs:simpleType>

So module should be able to hide this also, but I did not find any options in administration.

I would also like to have this as an override if possible, so that I could update Magento without having to write a hack every time.

Any help would be appreciated


texts: Add configure product in Cart using Magento 2 API facing an issue

texts:
Here's the url

http://<magento host>/rest/default/V1/carts/mine/items

  Method POST

Headers

Authentication :: Bearer <customer token>
Content-Type :: application/json

  Body json data

{
  "cartItem": {
    "sku": "HKrh15hc",
    "qty": 1,
    "quote_id": "23",
    "product_option": {
      "extension_attributes": {
        "configurable_item_options": [
          {
            "option_id": "93",
            "option_value": 50
          },
          {
            "option_id": "141",
            "option_value": 169
          }
        ]
      }
    },
    "extension_attributes": {}
  }
}

  I have cross checked the attributes and options value id and also a Quote id

Response

  {
      "message": "Could not save quote",
      "trace": "#0 /var/www/html/rb-dev/vendor/magento/module-quote/Model/QuoteRepository/SaveHandler.php(82):
  Magento\Quote\Model\Quote\Item\CartItemPersister->save(Object(Magento\Quote\Model\Quote\Interceptor),
  Object(Magento\Quote\Model\Quote\Item))\n#1
  /var/www/html/rb-dev/generated/code/Magento/Quote/Model/QuoteRepository/SaveHandler/Interceptor.php(24):
  Magento\Quote\Model\QuoteRepository\SaveHandler->save(Object(Magento\Quote\Model\Quote\Interceptor))\n#2
  /var/www/html/rb-dev/vendor/magento/module-quote/Model/QuoteRepository.php(181):
  Magento\Quote\Model\QuoteRepository\SaveHandler\Interceptor->save(Object(Magento\Quote\Model\Quote\Interceptor))\n#3
  /var/www/html/rb-dev/vendor/magento/framework/Interception/Interceptor.php(58):
  Magento\Quote\Model\QuoteRepository->save(Object(Magento\Quote\Model\Quote\Interceptor))\n#4
  /var/www/html/rb-dev/vendor/magento/framework/Interception/Interceptor.php(138):
  Magento\Quote\Model\QuoteRepository\Interceptor->___callParent('save',
  Array)\n#5
  /var/www/html/rb-dev/vendor/magento/framework/Interception/Interceptor.php(153):
  Magento\Quote\Model\QuoteRepository\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Quote\Model\Quote\Interceptor))\n#6
  /var/www/html/rb-dev/generated/code/Magento/Quote/Model/QuoteRepository/Interceptor.php(78):
  Magento\Quote\Model\QuoteRepository\Interceptor->___callPlugins('save',
  Array, Array)\n#7
  /var/www/html/rb-dev/vendor/magento/module-quote/Model/Quote/Item/Repository.php(92):
  Magento\Quote\Model\QuoteRepository\Interceptor->save(Object(Magento\Quote\Model\Quote\Interceptor))\n#8
  [internal function]:
  Magento\Quote\Model\Quote\Item\Repository->save(Object(Magento\Quote\Model\Quote\Item))\n#9
  /var/www/html/rb-dev/vendor/magento/module-webapi/Controller/Rest.php(330):
  call_user_func_array(Array, Array)\n#10
  /var/www/html/rb-dev/vendor/magento/module-webapi/Controller/Rest.php(239):
  Magento\Webapi\Controller\Rest->processApiRequest()\n#11
  /var/www/html/rb-dev/vendor/magento/framework/Interception/Interceptor.php(58):
  Magento\Webapi\Controller\Rest->dispatch(Object(Magento\Framework\App\Request\Http))\n#12
  /var/www/html/rb-dev/vendor/magento/framework/Interception/Interceptor.php(138):
  Magento\Webapi\Controller\Rest\Interceptor->___callParent('dispatch',
  Array)\n#13
  /var/www/html/rb-dev/vendor/magento/framework/Interception/Interceptor.php(153):
  Magento\Webapi\Controller\Rest\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))\n#14
  /var/www/html/rb-dev/generated/code/Magento/Webapi/Controller/Rest/Interceptor.php(39):
  Magento\Webapi\Controller\Rest\Interceptor->___callPlugins('dispatch',
  Array, Array)\n#15
  /var/www/html/rb-dev/vendor/magento/framework/App/Http.php(135):
  Magento\Webapi\Controller\Rest\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))\n#16
  /var/www/html/rb-dev/generated/code/Magento/Framework/App/Http/Interceptor.php(24):
  Magento\Framework\App\Http->launch()\n#17
  /var/www/html/rb-dev/vendor/magento/framework/App/Bootstrap.php(256):
  Magento\Framework\App\Http\Interceptor->launch()\n#18
  /var/www/html/rb-dev/index.php(39):
  Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor))\n#19
  {main}" }


texts: Magento customer import not defined issue

texts:
I want to import customers to magento via import/export profile

my csv look like this:

ID,Name,Company,Email,Group,Telephone,ZIP,Country,State/Province,Customer Since,Website,Controle:,Status:
1163,dhr Name,berkel management &amp; consultancy,example@hotmail.com,45%,015-2023091,2907 PE,Netherlands,,"Jun 7, 2017 9:27:00 AM",Main Website,,

When i run the import i receive this message:
Skipping import row, required field "website" is not defined.

I already changed the encoding to UTF-8.

Does anyone know where is my problem here?


texts: How to get an image in the bottom corner of my screen on every page

texts:
I want a little image to appear for certain customer groups when they are logged in. this image has to appear at the bottom right hand corner of every page. For example the google certied logo on http://ao.com/ does anybody know how to do this is magento? I know how to make a check to see if the customer is logged in. However i do not know how to display the image or even what file it should be put in or to make a new one.

If someone could help me that would be great.

Thank you


texts: Does Varnish cache not compatible with Redis?

texts:
I choosed a VPS account to host my Magento 2 site and i asked support to help me install Varnish,Memcached,XCache and Redis and i got this answer:

"
Please note that not all of the services can be installed at the same time, because the services are not compatible with each other. In order to avoid any issues with your server I would like to suggest you the installation of Varnish and Memcached.
"

Im wondering wheter this information is correct or not because i read everywhere that top Magento optimization including Varnish and Redis at the same time.

Thank you


texts:
A client wanted to move products to a different category when sold out so I quickly created an observer but it failed to save the product since frontend wasn't allowed to modifiy the products.

By temporary switching to the admin store and back it would save properly but are there any security conserns by doing this?

$store = Mage::app()->getStore()->getStoreId();
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
try {
  $product->save();
} catch ( Exception $e ){
  Mage::logException($e);
}
Mage::app()->setCurrentStore($store);

Client is using magento 1.8


texts: Can't get Magento2's .media-width() LESS mixin to work

texts:
I'm trying to use Magento2's .media-width() mixin.  I followed the instructions from the devdocs and added the mixin in my theme like this:

.logo img {
  width: 125px;
  height: 29px;
  .media-width(@extremum, @break) when (@extremum = 'min') and (@break = @screen__m) {
    width: 250px;
    height: 58px;
  }
}

Only the CSS outside of the .media-width() is being generated.  Nothing within it is being generated.  Am I missing something.

UPDATE

Following the advice of @circlesix I did not nest the media query, but still I'm having some trouble.

.logo img {
  width: 125px;
  height: 29px;
}
.media-width(@extremum, @break) when (@extremum = 'min') and (@break = @screen__m) {
  .logo img {
    width: 177px;
    height: 41px;
  }
}

My desktop rule in the media query is being overruled by the first rule for .logo img as it is defined later in styles-l.css.

Interestingly I don't see the rule I defined within the media-width() mixin defined anywhere within styles-m.css.  So perhaps I need to use the media-width() for both desktop & mobile views and only define common properties outside of it?


texts: Magento 2.2 - 502 Bad Gateway nginx/1.12.2

texts:
i have used AWS shared hosting. i'm getting bellow error on multi-vendor products edit.
502 Bad Gateway
nginx/1.12.2
please help me solve this, its urgent. i'm only getting this error on production server, on other servers it works fine.
thanks in advance.


texts: Magento 2.2.4 - checkout/cart get shipping rates via AJAX

texts:
Version 2.2.4 seems to have a buggy form post on checkout/cart to update shipping rates.
I have other stores using 2.3.* that work fine.
I am trying to run defaultProcessor.getRates() on a JavaScript but when I change, I get an error message saying that it needs an address object and I cannot find one because I am still on checkout/cart and did not provide a full address.
Help !!
Thank you !!


texts:
I have a pretty weird error in a Magento setup:

The page loads normally and shows in the browser. However, when I inspect it using firebug, the server returns the page as a server error 500!

This leads to problems for Google which states that it cannot access the pages.

Again, the pages do show, you can browse the shop normally.

Some pages load without this 500 error (e.g. homepage), but many pages have this effect.

I already checked the file permissions, the memory limit (set this high to 1024M to be sure) and the .htaccess file and both seem to be fine. Any ideas of what could produce this?

The server error log does not shield any insights.


texts: Get Canceled Orders with specified range using magento soap api

texts:
Can anyone help me how to get the Canceled orders of specified range in magento1.9 soap api.

Iam getting the orders but time exausting so i wants to get the orders between range.

Find the below code to get orders of status canceled:

$filter = array('filter' => array(array('key' => 'status', 'value' => 'canceled')));
$result = $client->salesOrderList($session, $filter);

Thanks

Thanks


texts: Magento2.4 - Implementing ckeditor 4 Editor wont save data

texts:
I have tried implementing ckeditor 4 to Magento 2.4. Everything works, but the editor wont save data in editor mode, only in source mode. I have followed this tutorial
https://devdocs.magento.com/guides/v2.3/ui_comp_guide/components/wysiwyg/add-custom-editor/
I get 0 erros, which makes it hard to identify the problem.
Does anyone else have this problem?


texts:
//App/Code/Local/Acme/Datecontrol/etc/config.xml:

<config>
    <modules>
        <Acme_Datecontrol>
            <version>0.1.0</version>
        </Acme_Datecontrol>
    </modules>
    <frontend>
        <routers>
            <datecontrol>
                <use>standard</use>
                <args>
                    <module>Acme_Datecontrol</module>
                    <frontName>datecontrol</frontName>
                </args>
            </datecontrol>
        </routers>
    </frontend>
    <global>
        <events>
            <controller_front_init_before>
                <observers>
                    <Acme_Datecontrol_Model_Observer>
                        <type>singleton</type>
                        <class>Acme_Datecontrol_Model_Observer</class>
                        <method>checkDate</method>
                    </Acme_Datecontrol_Model_Observer>
                </observers>
            </controller_front_init_before>
        </events>
    </global>
</config>

And the observer,

//App/Code/Local/Acme/Datecontrol/Model/Observer.php:

class Acme_Datecontrol_Model_Observer {

    public function checkDate($observer) {
        Mage::log('Frontend Page loaded', null, 'FirstObserver.log');
    }
}


texts: Are we need to join the Magento community?

texts:
Anyone can tell me.

I am a beginner Magento developer So are we need to join the Magento community?

If yes, What are the benefits of Magento community?


texts:
I am currently part of a team trying to build an e-commerce platform with Magento, and we also happen to need a way for the site to interact with a mobile app we are developing in parallel. We ran into problems with REST (highly convoluted token setup for a mobile app) and SOAP (too slow), but I was able to get something to work by creating my own PHP files on the web server that call Mage.php for relevant queries.

I keep my PHP files in a self-made folder that can be accessed through a URL that looks this:

http://mymagentostore.com/myownfolder/myownfile.php

The app sends data to these PHP files through HTTP Post, and the PHP script processes the data received before finally sending response data back to the app. This has so far been really useful since it has turned out to be much faster, and allows us to work with custom functionality we have added to the website since. But I would like to know if this is considered secure.

For what it's worth I always make sure that sensitive data queries are accompanied with a username and password for authentication without which the PHP script will not do anything, and as far as I know the inner workings of a PHP file should remain hidden from the user. Is there any inherent problem with setting up the client-server functionality this way? Is there a better/easier way of allowing the app to properly talk to the server?


texts: Magento Configurable Product Save Not Working

texts:
On configurable product creation, when I hit the save button, I'm getting the error

Fatal error: Call to a member function getStoreLabel() on a non-object in /app/code/core/Mage/Catalog/Model/Product/Type/Configurable/Attribute.php on line 79

I've disabled all the local modules and still the error is coming. Simple products are saving correctly. Could anyone shed some light on this issue?


texts: How to add Custom alerts to modal.js file in magento2

texts:
I wants to add custom alert for modal.js file in magento 2.

When click on product item delete button.

Thanks.


texts: I cant Reindex the ID catalogsearch_fulltext MAGENTO 2.4

texts: do you know if this is a server error Catalog Search index exception: Could not ping search engine: No alive nodes found in your cluster, if I send the index command everything does it except for this ID php bin / magento indexer : reindex catalogsearch_fulltext my data is hosted on a server and I do it through SSH, the Magento version is the newest 2.4, it seems that it is a node error so I was checking, someone knows something about it, I would appreciate it


texts:
I've been using Alphanumeric order increment id's since ~CE 1.1 - they're all set up using an alpha character in the prefix field of core_entity_store.

At the time there was no real documentation surrounding setup and multi-store setup, so we adopted the practice that all order id's were prefixed with an Alpha that represented the store. Order numbers typically looked like M000000003, PA000000004, etc.

Fast-forward 5 years to EE 1.11 and since approximately PE/EE 1.10 we have noticed that orders periodically return a SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'PA00505156' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID' error or something similar. It's infrequent - but my research leads me to the fact that a race-condition while reserving the order ID might be due to the prefix being alpha and not numeric.

I know that Ashley Schroder was working on this a while back, with a Pro edition of a module he developed - http://www.aschroder.com/2010/07/easily-set-a-custom-order-number-in-magento-with-my-free-setstartordernumber-extension/ - But it doesn't look like there has been much movement there, as the pro version isn't on Magento Connect.

Is anyone else using alpha prefixes? How has it performed for you so far? Do you see the same errors?


texts: Data upgrade data doesn't work in Magento 1

texts:
This is my upgrade script:

//mynamespace/mymodule/data/upgrade-1.0.0-1.0.1.php

$eavAttributes = [
    [
        'entity_type_id' => '12',
        'attribute_code' => 'reason_contact',
        'backend_model' => 'eav/entity_attribute_backend_array',
        'backend_type' => 'text',
        'frontend_type' => 'multiselect',
        'frontend_label' => 'Reason contact',
        'source_model' => 'eav/entity_attribute_source_table',
        'is_required' => '0',
        'is_unique' => '0',
        'is_user_defined' => '1',
        'note' => 'Reason contact for contact profile',
    ],
    [
        'entity_type_id' => '12',
        'attribute_code' => 'result_contact',
        'backend_model' => 'eav/entity_attribute_backend_array',
        'backend_type' => 'text',
        'frontend_type' => 'multiselect',
        'frontend_label' => 'Result contact',
        'source_model' => 'eav/entity_attribute_source_table',
        'is_required' => '0',
        'is_unique' => '0',
        'is_user_defined' => '1',
        'note' => 'Result contact for contact profile',
    ],
];
// @todo insert more data in other custom tables.
foreach ($eavAttributes as $eavAttribute) {
    Mage::getModel('eav/attribute')
        ->setData($eavAttribute)
        ->save();
}

The resources part:

    <resources>
        <mynamespace_mymodule_setup>
            <setup>
                <module>Mynamespace_Mymodule</module>
                <class>Mynamespace_Mymodule_Model_Resource_Setup</class>
            </setup>
        </mynamespace_mymodule_setup>
    </resources>

I updated my config xml to the 1.0.1 version and it is updated in the core_resources table . But there are no values inserted into eav_attribute. Actually I put some exit in my files and it doen't know about this file . What am I missing ? Thnx


texts: Browse File button doesn't work (Only in AM Revolution Slider) after patch 8788

texts:
I have installed the SUPEE-8788 patch in Magento 1.9.2.3 CE. At the first time I have installed the v1 of the patch, now I have reverted it and I have installed the v2, but the issue persisting. When I try to change the image background in a slide of AM Revolution Slider, the "Browse File.." doesn't work, I can't change the image.
I'd try to clear Magento cache, browser cache, restart Apache2 but nothing.
I'd check the source of page and this file are not present:

/js/lib/uploader/flow.min.js
/js/lib/uploader/fusty-flow.js
/js/lib/uploader/fusty-flow-factory.js

Someone has an idea how I can solve?


texts:
We are trying to migrate our code from magento 1.7 to 1.9 and I have an issue when i build a request with magento 1.9.
I wrote this for a column on the order grid :

 $this->addColumn('id_po', array(
              'header'      => $helper->__('Commande / OP'),
              'index'       => 'id_po',
              'filter_index' => "CONCAT(main_table.increment_id , CONCAT('|AP', LPAD(main_table.entity_id , 7, '0')), '0|', coalesce(main_table.order_id_lengow , ''))",
              'renderer' => new Amixys_Pilot_Block_Adminhtml_Renderer_IdPo(),
          ));

But it returns an error

  :"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.order_id_lengow , '')) LIKE '%OFR00093036%')' at line 2, query was: SELECT COUNT(*) FROM sales_flat_order AS main_table
   INNER JOIN sales_flat_order_address AS a ON main_table.entity_id = a.parent_id AND a.address_type != 'shipping' WHERE (CONCAT(main_table.increment_id , CONCAT('|AP', LPAD(main_table.entity_id , 7, '0')), '0|', coalesce(main_table.order_id_lengow , '')) LIKE '%OFR00093036%')"

You can't see it on this page , but it added some unicode caracters U+0060 in wrong places as you can see on my screenshot

Do you have an idea to fix it?

Thanks a lot
Thomas


texts:
I migrate settings from Magento 1.9.3.10 to Magento 2.3, after the migration was successful when I try to reindex or flush de cache from command line I have this error:

  The website with id 0 that was requested wasn't found. Verify the website a
  nd try again.

Also in the exception.log file I see this error:

main.CRITICAL: The website with id 0 that was requested wasn't found. Verify the website and try again. {"exception":"[object] (Magento\\Framework\\Exception\\NoSuchEntityException(code: 0): The website with id 0 that was requested wasn't found. Verify the website and try again. at /var/www/clients/client0/web15/web/vendor/magento/module-store/Model/WebsiteRepository.php:110)"} []

What I can do to fix this? or what can be the problem?

Thank you

Core_config_data with the scope=websites


texts: Create a product using Magento REST API 1.x gives 401 and product gets created

texts:
I have admin role access to Magento REST API with full access to all the attributes.

Upon creating a product the response code returned is 401 and there is no response body. How do I get the recently created product id or a valid response code like 201 or 200 ?

Is there any configuration required for that ? What is the expected behaviour?


texts:
I have a RWD catelog template css problem.
see here

Thanks!

I found this to be chrome problem, the problem has not been solved yet.


texts: Gift option in cart instead of shipping block on checkout?

texts:
I'm trying to accomplish this without an additional extension. I am including the checkout process on my cart page and would like to move the gift option in the cart section with the ability for each product to have it's own checkbox that asks if this is a gift.

The way it's set up currently it doesn't look like I can easily integrate it the way I would like.

Has anyone else done this that can give me some pointers?


texts:
I am trying to recover the termes and conditions in my class but without success.

Here is my class :

class Bvr extends \Magento\Framework\Model\AbstractModel{

    public function __construct(
    \Magento\Framework\Filesystem $filesystem,
    \Magento\CheckoutAgreements\Model\Agreement $agreement,
    array $data = []

     ) {

    $this->_rootDirectory = $filesystem->getDirectoryRead(DirectoryList::ROOT);
    $this->agreement = $agreement;
    // parent::__construct($data);
    }

protected function printSlip($invoice, $order) {

    $referenceNumber = $invoice->getOrder()->getIsrReferenceNumber();
    $aCmsPage = $this->agreement->getContent();

 }

}

I get this error :

Fatal error: Call to a member function getContent() on null in /var/www/magento21-test2/app/code/acme/BVR/Model/PDF/Bvr.php

Is that you know the solution to recover the terms and conditions?
Thank you


texts:
I have this code to caputre magento's mail method:

Mage::dispatchEvent('email_template_send_before', [
            'email' => $email,
            'email_to' => $name,
            'variables' => $variables,
            'template' => $this->getId()
        ]);

        $returnVal = parent::send($email, $name, $variables);

        Mage::dispatchEvent('email_template_send_after', [
            'email' => $email,
            'email_to' => $name,
            'variables' => $variables,
            'return_value' => $returnVal
        ]);

I have an observer, which is working and doing what it's needs to do.
I'd like to set a value in the observer and then use that value in this method.
How can I do this?


texts: M2: Exception #0 (Exception): Notice: Undefined index: id in

texts:
I upgraded Magento from 2.3.4 to 2.4
After upgrade,it's impossible to open stores ---> configuration I got Exception:
1 exception(s):
Exception #0 (Exception): Notice: Undefined index: id in /home/shop/domains/domain.pl/public_html/vendor/magento/module-config/Model/Config/Structure/Element/Iterator.php on line 63

Exception #0 (Exception): Notice: Undefined index: id in /home/shop/domains/domain.pl/public_html/vendor/magento/module-config/Model/Config/Structure/Element/Iterator.php on line 63
<pre>#1 Magento\Config\Model\Config\Structure\Element\Iterator->setElements(array('magentech' => array('id' => 'magentech', 'translate' => 'label', 'sortOrder' => 1, 'label' => 'Magentech.com', '_elementType' => 'tab', 'children' => array('market' => array('id' => 'market', 'translate' => 'label', 'type' => 'text', 'sortOrder' => 1, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'class' => 'separator-top', 'label' => 'SM Market', 'tab' => 'magentech', 'resource' => 'Sm_Market::confi...', 'children' => array('general' => array('id' => 'general', 'translate' => 'label', 'type' => 'text', 'sortOrder' => 1, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'label' => 'General Options', 'children' => array('theme_color' => array('id' => 'theme_color', 'translate' => 'label', 'type' => 'text', 'sortOrder' => 5, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'label' => 'Theme Color', 'frontend_model' => 'Sm\Market\Block\...', '_elementType' => 'field', 'path' => 'market/general'), 'heading_bodyfont' => array('id' => 'heading_bodyfont', 'translate' => 'label', 'type' => 'text', 'sortOrder' => 10, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'label' => 'Body Font', 'frontend_model' => 'Magento\Config\B...', '_elementType' => 'field', 'path' => 'market/general'), 'body_font' => array('id' => 'body_font', 'translate' => 'label', 'type' => 'select', 'sortOrder' => 15, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'label' => 'Main Font', 'source_model' => 'Sm\Market\Model\...', '_elementType' => 'field', 'path' => 'market/general'), 'body_google_font' => array('id' => 'body_google_font', 'translate' => 'label', 'type' => 'select', 'sortOrder' => 20, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'label' => 'Google Font Name', 'source_model' => 'Sm\Market\Model\...', 'depends' => array('fields' => array('body_font' => array('id' => 'market/general/b...', 'value' => 'google_font', '_elementType' => 'field', 'dependPath' => array('market', 'general', 'body_font')))), '_elementType' => 'field', 'path' => 'market/general'), 'font_size' => array('id' => 'font_size', 'translate' => 'label', 'type' => 'select', 'sortOrder' => 25, 'showInDefault' => 1, 'showInWebsite' => 1, 'showInStore' => 1, 'label' => 'Font Size', 'source_model' => 'Sm\Market\Model\...', '_elementType' => 'field', 'path' => 'market/general'), 'body_link_color' => array('id' =>

Iterator.php on line 63
/**
 * Set element data
 *
 * @param array $elements
 * @param string $scope
 * @return void
 */
public function setElements(array $elements, $scope)
{
    $this->_elements = $elements;
    $this->_scope = $scope;
    if (count($elements)) {
        $lastElement = end($elements);
        $this->_lastId = $lastElement['id'];
    }
}


texts: Find out to which categories a product belongs to

texts:
I opened a product in the backend, but when I switch to the categories tab, the category tree is fully collapsed. I would have to expand all categories to see in which ones the product is in.

How can I quickly see (in the backend) to which categories the product belongs?


texts: Refresh a .phtml file when product added to cart

texts:
When you add an item to cart the mini cart cart.phtml data is refreshed with the new data.

What I want is for another .phtml data to be refreshed when an item is added to the cart (catalog/product/view/type/default) to be exact.

Can this be done?


texts:
Getting really weird issue. Some of my products are not getting to cart.

https://www.saree.com/beige-and-navy-blue-art-silk-blouse-with-stone-work-saaabl003

while this one works

https://www.saree.com/off-white-art-silk-blouse-with-resham-embroidery-work-saaabl011

The configs of both the products are same from backend. Both the products were used to work few days ago. No changes have been made to website. No customization done in last 3 months. No server configs were changed.

When I turn on developer console, i get some json error. Can anyone please help me with this ?

The first product will start working if I change the url key value.
The following product was having same problem, but after changing url key, it started working as normal.

sareedotcom/saaabl004 (cant put more than 2 links due to restriction )


texts: If quantity(qty) is greater then 1 so this green update button show otherwise disable. How can I do this in Magento 2?

texts: If qty greater then 1 so this green update button show otherwise disable. How can I do this in magento2


texts: How to add breadcrumbs in product details page with category name in 2.3.4?

texts:
I want to add a category name in bread crumb in product detail page?. Can you help me how to do that?
Here is the example I want it.

Home > Main Category Name > Sub category name > Product name

Currently, I can see like this:

Home > Product name

But,  need to add a category into that.
Thanks you in advance!


texts: How I can get secure url (https) of CMS page using url_key?

texts:
I have enable SSL and one of CMS is restricted for register users.

And this page is in footer.

If logged in user try to access without https it fails and redirect to my account.

I want that particular CMS page url alway secure ie https://

<?php echo $this->getUrl('page_url_key',array('_secure'=>true));?> is not working.

How I will get CMS page url alway secure?


texts:
i am working as a inventory controller and IT professional the problem i am facing is before our store website was not responsive and build by someone on freelance but now they want responsive website.
i am messed up where to start.
need help for making that site responsive.


texts: How to Copy Magento live site to localserver?

texts:
I got error when type 'http://localhost/allgoodrange/index.php' then the path will automatic change like 'https://allgoodrange.com

how i do in my site.


texts: page scrolling by clicking on add to cart button

texts:
In the Magento 2.3.1 on the configurable product detail page.

If size/color is not selected and clicking on add to cart the page is scrolling down.

is this a good behavior?

How can we stop scrolling in this case?


texts: How to change column layout for contact us page in magento?

texts: I want to change contact us page layout from current 2columns-rightlayout to 1column layout, i have no idea how to do that.


texts: Send to friend sends picture not product

texts:
Our send to a friend works fine..., but it sends a link of the products picture. Not a link to the products page. How can I change that? Obviously I would like people to click on the link they receive and direct them to the product page.

Edit:

version 1.9.3.10

  https://www.boekmetnaam.nl/


texts: Call JS function with controller function on click

texts:
I want to do to tasks simultaneously on the click of button.

Insert the details into database.
redirect to checkout.

I have redirected to checkout using java script but I am not being able to enter details in database.


texts: Magento 1 Restore coupon for a especific customer

texts:
I'm trying to restore a coupon for a specific customer, I know their id and the coupon code.

My code is:

$customerId = 98080;

$coupon = Mage::getModel('salesrule/coupon')->load('test-it', 'code');
$coupon->setTimesUsed($coupon->getTimesUsed()-1);

$coupon->save();

$timesUsed = $coupon->getTimesUsed();

$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$query = "UPDATE salesrule_coupon_usage SET times_used = times_used-1 WHERE customer_id='".$customerId."' AND coupon_id='".$coupon->getId()."'";

$result = $write->query($query);

if ($customerCoupon = Mage::getModel('salesrule/rule_customer')->loadByCustomerRule($customerId, $coupon->getRuleId())) {
    $customerCoupon->setTimesUsed($customerCoupon->getTimesUsed()-1);

    $customerCoupon->save();
}

And apparently all is working fine, I check the customer in the database and he doesn't have the discount assigned:

SELECT group_concat(distinct sfo.coupon_code) FROM sales_flat_order sfo
WHERE coupon_code IS NOT NULL
AND customer_email='email@example.com'
GROUP BY customer_email;
// group_concat(distinct sfo.coupon_code) == 0,one-discount,another

And in the code table:

SELECT coupon_code, count(coupon_code) FROM sales_flat_order
WHERE coupon_code ='test-it4'
GROUP BY coupon_code;
//Empty set

At first, all goes well, I can use the code again, but in the last step of the checkout I have the next message:

  There was an error processing your order. Please contact us or try
  again later.

I don't know why the logs don't show anything

UPDATE

I have this error in apache2 log:

  Integrity constraint violation: 1062 Duplicate entry '331536-98080'
  for key 'PRIMARY''

Where 331536 is the coupon_id and 98080 is the customer_id, but I don't find in which table is this data stored


texts: Password reset throws "An Exception was raised while creating "Laminas\Mail\Protocol\Smtp\Auth\Login" no instance returned

texts:
I am resetting the password of magento 2.3 admin account (backend) and I get the exception saying "An Exception was raised while creating "Laminas\Mail\Protocol\Smtp\Auth\Login" no instance returned"
But password gets updated to new password
Can anyone help me to resolve this exception


texts: Update tiny_mce to latest version 4.0.3 (2013-08-08)

texts:
On EE 1.12, I would like to update to the latest version of tiny MCE.

This is to make use of some updated plugins (non-editable areas etc)

Seems like it is not just a drop-in replacement.

Once droped in the js folder and I adjusted head.phtml to load the new version, I get js error, and no tiny mce editor :(

<?php if($this->getCanLoadTinyMce()): // TinyMCE is broken when loaded through index.php ?>
<script type="text/javascript" src="<?php echo $this->getJsUrl() ?>tiny_mce_new/tinymce.min.js"></script>
<?php endif; ?>

I am hoping someone has a resource available, or done this before and know how to fix this - no time to dig, on a strict deadline on this project :(

Help appreciated.


texts: Migration from 1.9.3.x to Magento 2.3.5 issue multi-website data not migrate

texts:
I have migrated from Magento1.9.3.x to Magento2.3.5  after check multi-website data not convert. anyone, please guide how to check the issue.
Thank You


texts: How to distribute Magento application across several nodes in cluster setup?

texts:
I've been Googling around, but still don't have a clear picture of the subject.
I've set up following

1x LB node (nginx)
1x Webserver node (Nginx + PHP-FPM)
1x Cache-Session node (2 Redis instances)
1x MySQL node

So far this set is working well.

Now I need to add one (or two) Webserver nodes (scale horizontally).

I've set up one more node Webserver2 (nginx + PHP-FPM) and mounted Media from Webserver1 as NFS.

The question is how to distribute Magento's application files and folders (e.g. app, downloader, includes, js etc)?

I've been reading about rsync, NFS, csync2, lsyncd but still not sure which one is more appropriate.

As well as how to handle /app/etc/local.xml file and log files.

I'd appreciate any help and advice since I got stuck at this stage.

Thanks


texts: Magento 1.9 can't link a product to a specific store view

texts:
I have magento 1.9.3.2 and i have multiple store views

i can't link a specific product to a specific store (for example jordan store) because it force me to select main website only which includes the 2 stores together


texts: How to delete unused dropdown values, those unused by any product, on Magento 2.3.4, using the recommended API

texts:
I'm trying to delete unused dropdown options, the values that are not used by any product.

So what is the proper way to delete all unused dropdown options? What APIs should I use for this?

Here is a picture of where these options are managed in the backed, to help clarify which ones I'm talking about specifically.


texts:
When a payment fail I redirect the customer to a URL looks like below

http://exsample.com/checkout/cart?status=0&responcecode=91

in the page how can I read this $_GET['responcecode'] value?

please help me out.


texts:
We have dropdown, which have an option to sort the products by position, name, etc., but its not working.

Could anyone please help me?


texts: GIT and deployment strategy Magento2 projects

texts:
With Magento 1 I used a deploy tool that pulled in the GIT repo, ran commands like modman deploy-all and made sure the var directory was writable. For the .gitignore I used this one which worked pretty well.

But what about Magento 2?

What gitignore works best, how do you deploy your project and what command should one run pre- and post deploy. Looking forward to hearing some insights from the community.

Question will stay open for quite some time


texts: Accessing comments from a credit memo after the event: sales_order_creditmemo_refund

texts:
I am generating XML which is sent to an external system whenever a Credit Memo is generated. I am using the event sales_order_creditmemo_refund which gives me the credit memo and order models (which I am using to generate the appropriate XML)

$creditMemo = $observer->getEvent()->getCreditmemo();
$order      = $creditMemo->getOrder();

However I am having trouble accessing comments. I can see in Mage_Sales_Model_Order_Creditmemo there is getCommentsCollection() but this is not returning anything.

I am guessing the comments are added to the model at a later stage, should I be using a different event for my observer?

I can see that Mage::dispatchEvent('sales_order_creditmemo_refund', array($this->_eventObject=>$this)); is located inside the refund() method of the same model, but the only other event I can see in the model is sales_order_creditmemo_cancel


texts: Magento 1.9: Can't translate order status labels on the order grid?

texts:
We can't translate the order status labels on the order grid.
When viewing a specific order, the translation is working as it should be.

Were having a problem with translating the order status labels "Processing", "Canceled" and "Complete" into Swedish. For example, we want to change "Complete" to "Skickad" (Sent in English). Please see the picture below. We have done the necessary changes in "System" => "Order Statuses", but that doesn't change these statuses labels on the grid?!


texts: Show Simple Product attribute on homepage

texts:
I want to show a custom_attribute of a simple product only.

I need this on the home page.

I want to foreach loop the 10 highest priced configurable products and show the lowest priced simple product custom_attribute

I can do it on the product page itself with its own simple products just fine with the following:

    if($_product->getTypeId() == "configurable"): ?>
    <?php
        $childIds=Mage::getResourceSingleton('catalog/product_type_configurable')
            ->getChildrenIds($_product->getId());
        $simple_collection=Mage::getResourceModel('catalog/product_collection')->
        addAttributeToFilter('entity_id', array('in' =>  array_values($childIds[0])))
        ->addAttributeToSelect('*')->addAttributeToSort('price', 'asc');
                // add  in stock to collection
        $cond = array(
            '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=1 AND {{table}}.is_in_stock=1',
            '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=0',
        );

            $cond[] = '{{table}}.use_config_manage_stock = 1 AND {{table}}.is_in_stock=1';

        $simple_collection->joinField(
            'inventory_in_stock',
            'cataloginventory/stock_item',
            'is_in_stock',
            'product_id=entity_id',
            '(' . join(') OR (', $cond) . ')'
        );

foreach($simple_collection as $simple_product){

        echo $sample_attribute
        echo $sample_attribute_2

}


texts: Magento1: Form Validation suddenly broken?

texts:
I'm trying to find a solution to a problem I've recently run into, whenever I attempt to create an account or checkout as a guest it keeps coming up with "The first name cannot be empty, The last name cannot be empty, Invalid email address".

As we run quite a busy store I make changes on a daily basis and can't for the life of me figure out what caused it, one change in particular matches up to the time perfectly.

I have the Clarion Customer Attributes extension installed and I set the first/last name's Input Validation to "Letters" and the email attribute to "Email". The moment I noticed the error I quickly reverted my changes (setting input validation to none) and it continued happening. Now for the life of me I can't figure out what I've triggered!

As a temporary measure I commented out the warnings themself but I'm constantly receiving notifications from paypal and our other payment provider that parts of the customers information is missing (usually email or name)

Any help would be massively appreciated


texts: Filter product collection for Criteo Tags in category page: module setup (config.xml)

texts:
I'm implementing Criteo Tags in my store,
Criteo Tags must be put inside the header, for the category page I must get the Sku of the first 3 product listed in the page.

I'm using a module that get the list of sku using this code

public function getTopProducts() {
    $layer = Mage::getSingleton('catalog/layer')->getCurrentCategory();

    $i = 0;
    $list = array();
    foreach ($layer->getProductCollection() as $product) {
      $list [] = $product->getSku();
      if ($i++ >= 2) {
        //stop after 3rd element
        break;
      }
    }

    return json_encode($list);
  }

But in this way i just get 3 sku of the last products created of that category, i must get the real first product that user see in the list that depends on "sort by" select (priv, bame or position), on the direction arrow (hight to low or low to hight)and the page.

UPDATE-----
Trying to implement Cristi's solution:

I've created a new module called CriteoTags with this files and directory:

CriteoTags
  - etc
     - config.xml

  - Model
     - observer.php

My config is

<?xml version="1.0" encoding="UTF-8"?>
<config>
    <modules>
        <Lamasas_CriteoTags>
            <version>0.0.1</version>
        </Lamasas_CriteoTags>
    </modules>
    <global>
        <models>
            <lamasas_criteotags>
                <class>Lamasas_CriteoTags_Model</class>
            </lamasas_criteotags>

        </models>

        <events>
            <catalog_block_product_list_collection>
                <observers>
                    <lamasas_criteotags>
                        <class>lamasas_criteotags/observer</class>
                        <method>criteoList</method>
                    </lamasas_criteotags >
                </observers>
            </catalog_block_product_list_collection>
        </events>

    </global>

</config>

My observer is

<?php

class Lamasas_CriteoTags_Model_Observer
{
    /**
 * Observe catalog_block_product_list_collection
 * @param Varien_Event_Observer $observer
 */
    public function criteoList(Varien_Event_Observer $observer)
    {
        $category = Mage::registry('current_category');
        if (!$category) {
            return;
        }

        //get head block
        if ($head = Mage::app()->getLayout()->getBlock('head')) {
            $block = Mage::app()->getLayout()->createBlock('core/template', 'criteo.category');
            $block->setTemplate('criteo/category.phtml');
            $head->append($block);
        }
    }

}

Obviously I've created the xml file for etc/modules

At last I've created the required template file in
app/design/frontend/base/default/template/criteo/category.phtml

But Doesn't work, what is wrong with the code?

Thanks!


texts: Magento 1.9 Top Links. Issue with removal of addLink from another layout handle

texts:
I have a project where I needed to add a custom link to top.links via XML (This is a product URL). Maybe this is not the correct way to add a product to top.links?  The handle customer_logged_out works as expected to add the new desired link, however when I try to remove this link within the handle catalog_product_view it does not remove. Below is my content from my local.xml file Does anyone have any ideas?

<customer_logged_out>
    <reference name="top.links">

        <action method="addLink" translate="label title" module="catalog">
            Sign Up
            <url>/individual-membership.html</url>
            <title>Sign Up</title>
            <prepare/>
            <urlParams/>
            <position>20</position>
            <liParams/>
            <aParams>class="btn btn-primary sign-up"</aParams>
            <beforeText><![CDATA[]]></beforeText>
            <afterText><![CDATA[]]></afterText>
        </action>
    </reference>
</customer_logged_out>

<catalog_product_view>
    <reference name="top.links">

        <action method="removeLinkByUrl">
            <url>/individual-membership.html</url>
        </action>
    </reference>
</catalog_product_view>

Please note the below removeLinkByUrl method below works as expected for a different link.

<reference name="top.links">

    <action method="removeLinkByUrl"><url helper="customer/getRegisterUrl" /></action>
</reference>

As requested by the comments below, I've also tried the following without success:

<catalog_product_view>
    <reference name="top.links">

        <action method="removeLinkByUrl">
            <url>/individual-membership</url>
        </action>
    </reference>
</catalog_product_view>

<catalog_product_view>
    <reference name="top.links">

        <action method="removeLinkByUrl">
            <url>individual-membership</url>
        </action>
    </reference>
</catalog_product_view>

<catalog_product_view>
    <reference name="top.links">

        <action method="removeLinkByUrl">
            <url>/individual-membership</url>
        </action>
    </reference>
</catalog_product_view>


texts: How can I make Parcel shipping cost take priority over Large Letter?

texts: Our shop sells over 150 products ranging in weight from 2g to 50kg. Some of the lightweight items are Large letter and cost £1 to post to UK address whilst others, although still lightweight, are bulky and therefore categorised as small parcel: these cost £3 or so to post. All products are categorised correctly (Large Letter Post enabled? either Yes or No). When customer purchases product in Large Letter category, correct postage is shown, but when they continue shopping and buy other small packet items (costing £3 to post), the postage remains at £1. If the Large Letter item is removed from the basket, the postage then reverts to the correct £3. Meanbee cannot assist and our web developer says that there are no extensions available to fix this problem. Could the Shipping rules or other features be adjusted so that parcel postage takes priority over Large Letter when customers buy both items?


texts: Magento2.2 CLI command not working for PHP version 7.1.18

texts:
I have installed php version 7.1.18, apache2.4 and mysql5.7.
but magento2.2 cli commands are not working for me.
anyone can help me regarding this.


texts: Magento 2 adding version in css and js path when creating a custom theme

texts: Magento 2.1.2 adding version in css and js path, like version1483790821 when creating custom theme. Please have a look on the attached screenshot.