zamaliphe / clean-cache-mcloud.sh

Created March 19, 2021 17:00 — forked from cagartner/clean-cache-mcloud.sh

Clean redis cache on mcloud

redis-cli -p 6372 #To find the port look inside of app/etc/env.php file

zamaliphe / magento2-clear.sql

Created March 19, 2021 17:00 — forked from cagartner/magento2-clear.sql

Magento 2 Clear Database

	##########################################################
	# PRODUCTS
	##########################################################
	DELETE FROM `catalog_product_bundle_option`;
	DELETE FROM `catalog_product_bundle_option_value`;
	DELETE FROM `catalog_product_bundle_selection`;
	DELETE FROM `catalog_product_entity_datetime`;
	DELETE FROM `catalog_product_entity_decimal`;
	DELETE FROM `catalog_product_entity_gallery`;
	DELETE FROM `catalog_product_entity_int`;

zamaliphe / CreateProductController.php

Created March 19, 2021 17:00 — forked from cagartner/CreateProductController.php

Creating product programatically on Bagisto Laravel

	<?php
	// File: app/Http/Controllers/CreateProductController.php

	namespace App\Http\Controllers;

	use Illuminate\Http\Request;
	use Webkul\Attribute\Models\Attribute;
	use Webkul\Attribute\Models\AttributeOption;
	use Webkul\Attribute\Repositories\AttributeFamilyRepository;
	use Webkul\Product\Repositories\ProductRepository;

zamaliphe / WebsiteAndStoreCreator.php

Created March 19, 2021 17:00 — forked from cagartner/WebsiteAndStoreCreator.php

Magento 2 : Create Programmatically Website/Store/StoreGroup

	<?php
	/**
	* This file is part of Namespace for Magento.
	*
	* @license All rights reserved
	* @author Phuong LE <[email protected]> <@>
	* @category Namespace
	* @package Namespace_Core
	* @copyright Copyright (c) 2016 Agence Soon (http://www.agence-soon.fr)
	*/

zamaliphe / customer_account.xml

Created March 19, 2021 17:00 — forked from cagartner/customer_account.xml

Add a link to logout user in my account menu in magento 2

	<?xml version="1.0"?>
	<!--
	/**
	* Copyright © Magento, Inc. All rights reserved.
	* See COPYING.txt for license details.
	*/
	-->
	<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="2columns-left" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd" label="Customer My Account (All Pages)" design_abstraction="custom">
	<body>
	<referenceBlock name="customer_account_navigation">

zamaliphe / updateData.php

Created March 19, 2021 16:59 — forked from cagartner/updateData.php

Create block with upgrade

	<?php
	use Magento\Cms\Model\Block;
	use Magento\Cms\Model\BlockRepository;
	use Magento\Cms\Model\BlockFactory;
	// contruct
	public function __construct(
	BlockRepository $blockRepository,
	BlockFactory $blockFactory
	)
	{

zamaliphe / rsync-server.md

Created March 19, 2021 16:59 — forked from cagartner/rsync-server.md

Sync files from server to local, rsync command

Sync files from server

rsync -chavzP --stats <ssh_user>@<domain>:/<path> .

Non-default ssh port example:

rsync -chavzP -e "ssh -p 22124" --stats <ssh_user>@<domain>/<path> .

zamaliphe / Add_breadcrumbs_xml.xml

Created March 19, 2021 16:59 — forked from cagartner/Add_breadcrumbs_xml.xml

Add breadcrumbs XML

zamaliphe / magento2-get-all-products-with-sku-and-url.sql

Created March 19, 2021 16:52 — forked from cagartner/magento2-get-all-products-with-sku-and-url.sql

Magento 2 SQL Queries Bible

	SELECT e.entity_id,
	e.sku,
	v.value as url_key
	FROM catalog_product_entity e
	INNER JOIN catalog_product_entity_varchar v
	ON e.entity_id = v.entity_id
	AND attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'url_key' AND entity_type_id = 4);

zamaliphe / create-inventory-stock-view-m2.sql

Created March 18, 2021 12:25 — forked from cagartner/create-inventory-stock-view-m2.sql

Create inventory_stock_1 view for Magento 2

	CREATE
	OR REPLACE
	VIEW `inventory_stock_1` AS select
	distinct `legacy_stock_status`.`product_id` AS `product_id`,
	`legacy_stock_status`.`website_id` AS `website_id`,
	`legacy_stock_status`.`stock_id` AS `stock_id`,
	`legacy_stock_status`.`qty` AS `quantity`,
	`legacy_stock_status`.`stock_status` AS `is_salable`,
	`product`.`sku` AS `sku`
	from