How to run Elasticsearch on localhost?
-
admin
-
September 8, 2024
-
DevOps, Magento 2
-
0 Comments
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 Custom Shipping Method based on Weight & Size
-
admin
-
September 8, 2021
-
Magento 2
-
0 Comments
# Magento 2 Custom Shipping Method based on weight & size This module provide a custom shipping method on the site. ## Condition Shipping charge will be calculated according to product size and weight. a. If weight is more than 10 KG and size is less than 100 CM, Shipping Charge will be 100 TK b. If weight is less …
Continue Reading
Magento 2 Hello World Module Development
-
admin
-
September 7, 2021
-
Magento 2
-
0 Comments
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
-
admin
-
February 26, 2019
-
Magento 2
-
0 Comments
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
Database user does not have enough privileges. Please make sure SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, View, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, S HOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER privileges
-
admin
-
February 25, 2019
-
Magento 2
-
0 Comments
Very simple Check into my.ini file in MySql config section and check whether skip-grant-tables is there below #skip-grant-tables
Continue Reading
How to get all cli command in Magento 2
-
admin
-
February 11, 2019
-
Magento 2
-
0 Comments
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
-
admin
-
February 3, 2019
-
Magento 2
-
0 Comments
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
-
admin
-
February 3, 2019
-
Magento 2
-
0 Comments
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
-
admin
-
January 31, 2019
-
Magento 2
-
0 Comments
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
-
admin
-
January 30, 2019
-
Magento 2
-
0 Comments
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