Skip to content

Instantly share code, notes, and snippets.

View antoinekociuba's full-sized avatar

Antoine Kociuba antoinekociuba

26 followers · 47 following
View GitHub Profile
@antoinekociuba
antoinekociuba / full_reindex.php
Last active March 23, 2016 07:37
Magento full reindex script (EE compatible)
<?php
/** Full reindex script */
/**
* @var array
*/
$processes = array();
/**
* @var Mage_Core_Model_Factory $factory
@antoinekociuba
antoinekociuba / disable_enable_ee_index.php
Last active March 23, 2016 07:38
Disable/Enable EE index updates (might be useful during a script execution to speed it up...)
<?php
/**********************
****** DISABLE *******
**********************/
/** var Mage_Core_Model_Config $config */
$config = Mage::app()->getConfig();
/**
@antoinekociuba
antoinekociuba / update_emails.sql
Created October 2, 2015 13:01
Update customer/order email addresses in test environment database (prevent to accidentally send test emails to real customers)
## Update order email addresses ##
UPDATE `sales_flat_order`
SET `customer_email` = CONCAT('test__', `customer_email`)
WHERE `customer_email` NOT IN ('[email protected]', '[email protected]')
AND `customer_email` NOT LIKE 'test__%';
## Update customer email addresses ##
UPDATE `customer_entity`
SET `email` = CONCAT('test__', `email`)
WHERE `email` NOT IN ('[email protected]', '[email protected]')
@antoinekociuba
antoinekociuba / gist:f136d817c22cd750dc252a4434cc72f4
Created July 7, 2016 15:54
Flush Magento EE url rewrites (>= 1.13) + Rebuild
# SQL Query
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `enterprise_url_rewrite_redirect_rewrite`;
TRUNCATE TABLE `enterprise_url_rewrite_redirect_cl`;
TRUNCATE TABLE `enterprise_url_rewrite_redirect`;
TRUNCATE TABLE `enterprise_url_rewrite_product_cl`;
TRUNCATE TABLE `enterprise_url_rewrite_category_cl`;
TRUNCATE TABLE `enterprise_url_rewrite`;
TRUNCATE TABLE `enterprise_catalog_product_rewrite`;
TRUNCATE TABLE `enterprise_catalog_category_rewrite`;
@antoinekociuba
antoinekociuba / disable_products_without_image.sql
Last active October 11, 2016 17:20
Magento - Disable configurable products without image, through SQL direct query
UPDATE catalog_product_entity_int SET value = 2
WHERE attribute_id = (
SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'status' AND entity_type_id = (
SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product'
)
)
AND entity_id IN (
SELECT catalog_product_entity.entity_id
FROM catalog_product_entity_media_gallery
RIGHT OUTER JOIN catalog_product_entity ON catalog_product_entity.entity_id = catalog_product_entity_media_gallery.entity_id
@antoinekociuba
antoinekociuba / git-clone-non-empty-directory.sh
Created October 11, 2016 17:19
GIT - Clone into a non-empty directory
git init
git remote add origin PATH/TO/REPO
git fetch
git checkout -t origin/master
@antoinekociuba
antoinekociuba / rsync_media
Last active July 23, 2019 23:30
rsync Magento media folder from a remote server to a local media directory
rsync -avz --dry-run SOURCE DESTINATION
rsync -avz --dry-run SSH_USER@IP:/REMOTE_ASBOLUTE_PATH/media/ media/
--dry-run is to test if everything is fine, always do it first ;p
Remove it then to launch the real action
@antoinekociuba
antoinekociuba / define_root_folder_after_ssh.sh
Last active April 11, 2017 12:10
Vagrant quickies - Go to project root folder or specific folder after SSH connexion
#!/bin/bash
echo "cd /var/www/magento" >> /home/vagrant/.bashrc
@antoinekociuba
antoinekociuba / .gitignore_magento
Created April 25, 2017 14:25 — forked from herveguetin/.gitignore_magento
Magento .gitignore example
######################
# Magento .gitignore #
######################
# Magento Core unnecessary files #
##################################
/errors/local.xml
/index.php
/install.php
/mage
@antoinekociuba
antoinekociuba / add-checkout-form-key.sh
Last active June 19, 2017 20:17 — forked from grafikchaos/add-checkout-form-key.sh
Magento SUPEE-9767 Checkout Form Key Theme Patch
find -L app/design/frontend -name 'shipping.phtml' -or -name 'billing.phtml' -or -name 'shipping_method.phtml' -or -name 'payment.phtml' -or -name 'addresses.phtml' \
| xargs grep -L formkey \
| xargs perl -i -pe 's/<\/form>/<?php echo \$this->getBlockHtml("formkey") ?>\n<\/form>/g'
find -L skin/frontend -name 'opcheckout.js' \
| xargs grep -L form_key \
| xargs perl -i -pe 's/if \(elements\[i\]\.name=='\''payment\[method\]'\''\) \{/if (elements[i].name=='\''payment[method]'\'' || elements[i].name == '\''form_key'\'') {/g'
find -L js -name 'payment.js' \