How to run Elasticsearch on localhost?

Please follow the following step: Download and install Elasticsearch Go to the bin directory (elasticsearch-7.16.2\bin) in the Elasticsearch installation folder Run the elasticsearch command Verify that Elasticsearch is running by going to the address in your web browser or by sending a GET request to localhost:9200

Continue Reading

Magento 2 Hello World Module Development

Magento 2-Hello World Module Learn how to create a hello world module in Magento 2 After create the module if you run the command as: php bin/magento module:status To enable a module in Magento 2 php bin/magento module:enable Zendanwar_Magetigers Please upgrade your database: Run bin/magento setup:upgrade from the Magento root directory. Let run the following command: php bin/magento setup:upgrade Please …

Continue Reading

Magento 2 after install showing blank page

Very simple. Please go to below file location  C:\xampp\htdocs\magento23\vendor\magento\framework\View\Element\Template\File\Validator.php Replace below code :  protected function isPathInDirectories($path, $directories) { if (!is_array($directories)) { $directories = (array)$directories; } $realPath = $this->fileDriver->getRealPath($path); foreach ($directories as $directory) { if (0 === strpos($realPath, $directory)) { return true; } } return false; } With: protected function isPathInDirectories($path, $directories) { if (!is_array($directories)) { $directories = (array)$directories; } $realPath …

Continue Reading

How to get all cli command in Magento 2

It’s very simple. Just go to your root directory. And run following command C:\xampp\htdocs\magento2> php bin/magento Output : Magento CLI 2.3.0   Usage: command options arguments   Options: -h, –help            Display this help message -q, –quiet           Do not output any message -V, –version         Display this application version –ansi            Force ANSI output –no-ansi         Disable ANSI output -n, –no-interaction  Do not ask …

Continue Reading

Magento 2 delete all sample product data from database

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_category_product`; TRUNCATE TABLE `catalog_category_product_index`; TRUNCATE TABLE `catalog_category_product_index_tmp`; TRUNCATE TABLE `catalog_compare_item`; TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_product_bundle_price_index`; TRUNCATE TABLE `catalog_product_bundle_selection`; TRUNCATE TABLE `catalog_product_bundle_selection_price`; TRUNCATE TABLE `catalog_product_bundle_stock_index`; TRUNCATE TABLE `catalog_product_entity`; TRUNCATE TABLE `catalog_product_entity_datetime`; TRUNCATE TABLE `catalog_product_entity_decimal`; TRUNCATE TABLE `catalog_product_entity_gallery`; TRUNCATE TABLE `catalog_product_entity_int`; TRUNCATE TABLE `catalog_product_entity_media_gallery`; TRUNCATE TABLE `catalog_product_entity_media_gallery_value`; TRUNCATE TABLE `catalog_product_entity_media_gallery_value_to_entity`; TRUNCATE TABLE …

Continue Reading

Magento 2 delete all Orders/Invoices data from database

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `gift_message`; TRUNCATE TABLE `quote`; TRUNCATE TABLE `quote_address`; TRUNCATE TABLE `quote_address_item`; TRUNCATE TABLE `quote_id_mask`; TRUNCATE TABLE `quote_item`; TRUNCATE TABLE `quote_item_option`; TRUNCATE TABLE `quote_payment`; TRUNCATE TABLE `quote_shipping_rate`; TRUNCATE TABLE `reporting_orders`; TRUNCATE TABLE `sales_bestsellers_aggregated_daily`; TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`; TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`; TRUNCATE TABLE `sales_creditmemo`; TRUNCATE TABLE `sales_creditmemo_comment`; TRUNCATE TABLE `sales_creditmemo_grid`; TRUNCATE TABLE `sales_creditmemo_item`; TRUNCATE TABLE `sales_invoice`; TRUNCATE TABLE …

Continue Reading

Magento 2.x auto mini cart open extension

I have been develop an extension for mini cart alert after adding product in Magento 2.x. It will focus to customer for attention. Customer can check what he added product into cart. Specially it will help to B2B customer. Download here After install the extension run following command with cli mode. php bin/magento setup:upgrade php bin/magento setup:static-content:deploy -f php bin/magento …

Continue Reading

Magento 2 add simple product programmatically

just create a file like upload.php and run from root directory. <?php use \Magento\Framework\App\Bootstrap; include(‘app/bootstrap.php’); $bootstraps = Bootstrap::create(BP, $_SERVER); $object_Manager = $bootstraps->getObjectManager(); $app_state = $object_Manager->get(‘\Magento\Framework\App\State’); $app_state->setAreaCode(‘frontend’); $set_product = $object_Manager->create(‘\Magento\Catalog\Model\Product’); try{ $set_product->setWebsiteIds(array(1)); $set_product->setAttributeSetId(4); $set_product->setTypeId(‘simple’); $set_product->setCreatedAt(strtotime(‘now’)); $set_product->setName(‘BD product simple product’); $set_product->setSku(‘bd-pro-simple’); $set_product->setWeight(1.0000); $set_product->setStatus(1); $category_id= array(4,5,6,7); $set_product->setCategoryIds($category_id); $set_product->setTaxClassId(0); $set_product->setVisibility(4); $set_product->setManufacturer(29); $set_product->setColor(20); $set_product->setPrice(1999); $set_product->setCost(1800); $set_product->setMsrpDisplayActualPriceType(1); $set_product->setMetaTitle(‘BD product simple product’); $set_product->setMetaKeyword(‘BD product simple product’); $set_product->setMetaDescription(‘BD …

Continue Reading