Zend Anwar

Full stack web developer

Category: Magento 2

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)) { […]

Read More

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 […]

Read More

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`; […]

Read More

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`; […]

Read More

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 […]

Read More

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’); […]

Read More

Magento 2 install with cli mode

Go to your root directory C:\xampp\htdocs\magento2> and run following command php bin/magento setup:install –base-url=”http://127.0.0.1/magento2/” –db-host=”localhost” –db-name=”databasename” –db-user=”databaseuser” –db-password=”databasepass” –admin-firstname=”Yourname” –admin-lastname=”Yourname” –admin-email=”borntowinanwar@gmail.com” –admin-user=”admin” –admin-password=”strongpassword” –backend-frontname=”admin”

Read More

Magento 2 after install shows blank page

Please below instruction hope it will resolve. Just got to vendor/magento/framework/View/Element/Template/File/validation.php And go to line 138 lines Replace  $realPath = $this->fileDriver->getRealPath($path); foreach ($directories as $directory) { if (0 === strpos($realPath, $directory)) { return true; } } With  $realPath = $this->fileDriver->getRealPath($path); foreach ($directories as $directory) { $directory = $this->fileDriver->getRealPath($path); if (0 === strpos($realPath, $directory)) { return […]

Read More

Notice: unserialize(): Unexpected end of serialized data in Magento 2 data migration

Just follow the following step. Go to /yii/caching/CCache.php file and replace with following code. $value=unserialize($value); Change to : $value=unserialize(base64_decode($value)); It will work fine. hope so  

Read More