willboudle

UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('xxxxxxxxPASSWORD', 256), ':xxxxxxxx:1')
WHERE `email` = "guysemail@hotmail.com";

willboudle

#select children of sku
 SELECT
  *
FROM
  catalog_product_entity cpe
  LEFT JOIN catalog_product_super_link cpsl
    ON cpe.row_id = cpsl.`parent_id`
  LEFT JOIN catalog_product_entity child
    ON cpsl.`product_id` = child.`entity_id`
WHERE cpe.sku = "sku";

willboudle

#Select parent of a sku
 SELECT
  parent.sku
FROM
  catalog_product_entity parent
WHERE parent.row_id =
  (SELECT
    relationship.parent_id
  FROM
    catalog_product_super_link relationship

willboudle

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

use Magento\Framework\App\Bootstrap;

try{

    require __DIR__ . '/app/bootstrap.php'; 

willboudle

// allcolors.js
// https://github.com/bgrins/devtools-snippets
// Print out CSS colors used in elements on the page.

(function () {
  // Should include colors from elements that have a border color but have a zero width?
  var includeBorderColorsWithZeroWidth = false;

  var allColors = {};
  var props = ["background-color", "color", "border-top-color", "border-right-color", "border-bottom-color", "border-left-color"];

willboudle

select gal.value from catalog_product_entity as ent
left join catalog_product_entity_media_gallery_value as val on (ent.row_id = val.row_id)
left join catalog_product_entity_media_gallery as gal on (val.value_id = gal.value_id);
# where ent.type_id='configurable';

willboudle

SELECT    ce.sku,           
        ea.attribute_code,
        ea.attribute_id,
        CASE ea.backend_type
           WHEN 'varchar' THEN ce_varchar.store_id
           WHEN 'int' THEN ce_int.store_id
           WHEN 'text' THEN ce_text.store_id
           WHEN 'decimal' THEN ce_decimal.store_id
           WHEN 'datetime' THEN ce_datetime.store_id

willboudle

SELECT e.sku ,t.title AS 'name',cv.value AS 'Custom option name'
      ,GROUP_CONCAT(ot.title) AS 'Custom option values'
FROM catalog_product_option o 
JOIN catalog_product_entity e ON e.entity_id=o.product_id 
JOIN catalog_product_option_title t ON t.option_id=o.option_id 
JOIN catalog_product_entity_varchar cv ON 
                   cv.entity_id=e.entity_id AND 
                   cv.attribute_id=(SELECT attribute_id 
                                    FROM eav_attribute ea 
                                    JOIN eav_entity_type et 

willboudle

# Groove Commerce Magento Robots.txt 05/2011
#
# robots.txt
#
# This file is to prevent the crawling and indexing of certain parts
# of your site by web crawlers and spiders run by sites like Yahoo!
# and Google. By telling these “robots” where not to go on your site,
# you save bandwidth and server resources.
#
# This file will be ignored unless it is at the root of your host:

willboudle

User-agent: *
Disallow: /index.php/
Disallow: /*?
Disallow: /*.js$
Disallow: /*.css$
Disallow: /customer/
Disallow: /checkout/
Disallow: /js/
Disallow: /lib/
Disallow: /media/