New answers tagged

1

Make sure to clear all the caches you have . If that doesnt work than do : rm -rf var/cache/* generated/* var/view_preprocessed/* var/page_cache/* pub/static/* bin/magento setup:upgrade bin/magento setup:static-content:deploy bin/magento cache:flush Additional commands sudo service php-fpm restart sudo service varnish restart Clear your redis cache.


2

Step 1 : Go to setup_module table and delete the entry of Vgroup65_Testimonial extension. Step 2 : Remove var/* and generated/* folders. Step 3 : Make sure Vgroup65_Testimonial is there in app/code/ directory. Step 4 : Do setup:upgarde command once.


0

Taken from Magento2: How can I modify custom order number? Go to your database in phpmyadmin, Here _1 is used for store id after tablename. Default Frontend store id is 1. if you have multi store then you have to set query for each store with table name like sequence_order_2 upto sequence_order_.* Enter below query for table sequence_order_1 is used for ...


0

First, make a backup of your DB. Then you can try running the following SQL statement to change where your orders / invoices begin: ALTER TABLE sequence_order_1 AUTO_INCREMENT=0000000910; This will increment orders starting at 0000000910 for example. Change this to whatever you need. You can also do this for other tables as well, such as invoices: ...


1

Are separate store views, one for each restaurant, not what you want? See All Stores Documentation. In this instance, I would suggest you use a single instance of Magento with either separate store views or separate stores. This way all your stores can share a single product catalog but present each item differently (different price, content, imagery, etc.). ...


0

It's not possible with out of the box Magento, to implement something like this would require heavy core logic customization, which could lead into unforseen and hard to predict consequences. Also it highly depends on the number of products and webstores(restaurants) you would have to sustain, and would all the products be unique per webstore. Maybe ...


0

You can also do it programmatically. But if you need solution for SQL then you can use commands like these: UPDATE sales_order o INNER JOIN sales_order_address oa ON o.entity_id=oa.parent_id INNER JOIN customer_entity c ON oa.email=c.email SET o.customer_id = c.email, o.customer_is_guest = 0 WHERE oa.address_type='shipping' AND c.email = {YOUR CUSTOMER ...


0

We have the same issue with our shop. Since a while the import with firebear takes about 10-12 minutes where it was finished in 3 minutes before. It is a simple stock update for about 10.000 items with sku and quantity, so nothing complex. On every chunk of 100 items the time between the import lasts longer and longer. Any ideas?


0

You can find specific instruction on how to do this within the official Magento Commerce Cloud documentation: https://devdocs.magento.com/cloud/live/stage-prod-migrate.html#cloud-live-migrate-db A summary of the steps is: SSH into the server Get the database credentials Create a dump file of the database. The file must be created within the /tmp directory ...


0

ece-tools is available in magneto 2 . You can just refer link https://devdocs.magento.com/cloud/reference/ece-tools-reference.html


0

You don't need elevate permissions.Try this: wget https://files.magerun.net/n98-magerun2.phar Then: php n98-magerun2.phar db:dump Done. Now you can import db without problems.


0

quote table is not cart. If you delete quote from DB raw by entity_id it will be restored with new entity_id. It will have all items.


0

Just remove an empty WHERE (()) because it is wrong syntax for MySQL. In case you don't know from where it comes, add more details: when and where that error appears.


-1

<?php namespace Meetanshi\Contact\Controller\Index; use Magento\Framework\App\Action\Action; use Magento\Framework\App\Action\Context; use Meetanshi\Contact\Model\ContactFactory; class Submit extends Action { protected $_pageFactory; protected $hello; protected $contactFactory; public function __construct( Context $context, ...


0

Rohit's answer has been the percieved wisdom for the longest time but as of Magento 2.3 this is changing. It is no longer best practice to use flat catalog due to apparent "performance degradation and other indexing issues". While this seems counter intuitive, intial research seems to show this is due to reworking of how data is retrieved using Elatic Search....


0

I think you have used wrong connection for indexer. 'indexer' => [ 'host' => 'localhost', 'dbname' => 'm2', 'username' => 'user', 'password' => 'xxx', 'model' => 'mysql4', 'engine' => 'innodb', 'active' => '1', 'persistent' => NULL ...


0

You can find the entire customers in the below tables. SELECT * FROM `customer_address_entity`; SELECT * FROM `customer_address_entity_datetime`; SELECT * FROM `customer_address_entity_decimal`; SELECT * FROM `customer_address_entity_int`; SELECT * FROM `customer_address_entity_text`; SELECT * FROM `customer_address_entity_varchar`; SELECT * FROM `...


0

OK after following the advice at the question posted here: Cannot process definition to array for type tinytext in Magento 2.3.0 I managed to ascertain that the type field causing the issue was in a backup table for an old extension that I no longer use. Removing the table with the field in PHPMyadmin fixed the issue but it is also possible to just change ...


0

Try This Query :- SELECT * FROM table_name WHERE filter_ids IN (13,7,575) AND filter_options = 804 GROUP BY product_sku HAVING COUNT(*) > 1


2

Make sure Gtin attribute set as use in product sorting to Yes in Store > Attribute add edit Gtin attribute and check this change Store > Configuration > Catalog > Storefront > Product Listing Sort By to Gtin also got to Catalog > Manage Category and edit the category in which you want to change sorting and make sure here Default ...


0

Please comment the code which create the db table mage_permission_variable in file upgrade-1.6.1.1-1.6.1.2.php


1

I've tested it, please add this code: public function addIndexCategoriesFilter(array $categoriesFilter) { foreach ($categoriesFilter as $values) { if(count($values) > 1) $categoriesInCondString = implode(',',$values); else $categoriesInCondString = $values[0]; } $...


1

I fixed the issue I edited customer_eav_attribute table and removed records, there were some records with wrong Attribute ID table should list in sequence but I found some records where showing like 1,2,3,4,5, 10,12,14,20 I just removed 10,12,14,20 and it worked fine ! if anyone have the same issue I strongly recommend you to take back of table first!


1

Try to use the below query and you can generate CSV from a database. SELECT O.entity_id AS "Order ID", P.entity_id AS "Payment ID", S.entity_id AS "Shipment ID" FROM sales_order O LEFT JOIN sales_order_payment P ON (O.entity_id = P.parent_id) LEFT JOIN sales_shipment S ON (O.entity_id = S.entity_id) WHERE O.created_at between '...


0

Given your exact scenario, @Phillip Sander's answer is correct, but it's important to understand why it's correct. You stated: From my understanding the volumes are present so it should work. That's technically incorrect. Please consider what Metin Y. said here: services, networks and named volumes declared in a compose.yml are bound to the ...


0

following steps will help you. Export catalog_product_index_price_replica table. find database user name which is not related to current database. replace old dbuser to current dbuser. Take database backup. drop catalog_product_index_price_replica and Import last modified .sql file reference chage privillages Thank you.


0

simply you can create a script and in you dbscripts folder and run this file from terminal or web browser. e.g save file in /dbscripts/filename.php paste this code and change according to your requirement <?php require_once '../app/Mage.php'; //ini_set('display_errors', 1); //umask(0); Mage::app(); /** @var Mage_Core_Model_Resource_Setup $...


0

you can create a script and in you dbscripts folder and run this file from terminal or web browser. e.g save file in pub/dbscripts/filename.php paste this code and change according to your requirement <?php use Magento\Framework\App\Bootstrap; require '../../app/bootstrap.php'; $bootstrap = Bootstrap::create(BP, $_SERVER); $obj = $bootstrap->...


0

Go to Admin panel->Marketing->Cart price rules click on Add new button. Fill the required field with coupon code value as No Coupon. And go to Actions tab create a rule that match with your requirement under Apply the rule only to cart items matching the following conditions (leave blank for all items). Select Free Shipping drop down value as For ...


2

Use below code $total = $array['amount'] - $arr['base_grand_total']; $sortedData = $prepaidModel->getCollection()->addFieldToFilter('customer_id',1); foreach($sortedData as $sData) { $sData->setData('amount',$total); $sData->save(); }


0

I faced a similar issue. I solved it by removing the entries which have target_path LIKE %/category/0% from url_rewrites table. Check out this forum


1

Below is an example of save multiple model instances at once. Try with below example class yourClassName extends \Magento\Framework\Model\AbstractModel { public function __construct( ............ \Magento\Framework\DB\TransactionFactory ............ ) { ............ $this->transactionFactory = $transactionFactory; ..........


0

If you have enabled Flat Product Tables, you can query those tables directly, using the visibility column for your condition. The names of the table(s) will depend on how many stores you have, but it will look similar to this: catalog_product_flat_1 for your default store, catalog_product_flat_2 for the second store that you created, catalog_product_flat_3 ...


1

To verify the visibility of product (either it is visible in catalog or search) you can use the $product->getData('visibility') method. It will give a numeric value which is set as a constant in \Magento\Catalog\Model\Product\Visibility In product EAV it is represented by the attribute with code 'visibility' so you can make a inner join using product and ...


0

you can call one .phtml file on CSM page or Block and in .phtml file, you can load product and put add to cart button as you want.


1

you dont need to go very deep in to just add a new block and use button inside anchor tag and then add the product url and insert that block on homepage through widget for reference refer the code below:- <a href="http://localhost:96/magento/laptops.html"><button type="button"> Shop Now</button> </a> just do some here in url it is ...


1

Here is how to get the options table for a specific product id: SELECT _cpo.product_id, _cpo.option_id, _cpo.type, _cpo.is_require, _cpop.price, _cpop.price_type, _cpot.title, _cpotv.sku, _cpotp.price, _cpott.title AS Description FROM catalog_product_option _cpo LEFT JOIN catalog_product_option_price _cpop ON (_cpop....


Top 50 recent answers are included