Skip to content

Instantly share code, notes, and snippets.

View shinesoftware's full-sized avatar

Shine Software shinesoftware

View GitHub Profile
@shinesoftware
shinesoftware / _Magento2_DeleteTestData.md
Created September 8, 2021 14:13 — forked from leek/_Magento2_DeleteTestData.md
Magento 2 - Delete All Test Data

These set of scripts are for Magento 2. For Magento 1, see this Gist.

@shinesoftware
shinesoftware / fix-duplicates-product-entity-varchar.php
Last active August 20, 2021 14:10
Magento 2: Reindex Error - 1062 Duplicate entry `catalog_product_index_eav_temp` (?, ?, ?, ?, ?)...
<?php
$conn = mysqli_connect("HOST", "USER", "PASS", "DATABASE");
if (!$conn) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
@shinesoftware
shinesoftware / fix-serializer.php
Created November 12, 2019 09:50
Magento Migration: Fixing the Magento 2.1 and Magento 2.2 serialization fields.
<?php
$conn = mysqli_connect("HOST", "USER", "PASS", "DBNAME");
var_dump($conn->get_charset());
if (!$conn) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
<?php
namespace Shinesoftware\Bnl\Cron;
use Shinesoftware\Bnl\Model\Utils;
class CheckPayments
{
/**
@shinesoftware
shinesoftware / varnish.vcl
Created December 22, 2017 14:19
Varnish configuration file for Magento 2
vcl 4.0;
import std;
# The minimal Varnish version is 4.0
# For SSL offloading, pass the following header in your proxy server or load balancer: 'X-Forwarded-Proto: https'
backend default {
.host = "127.0.0.1";
.port = "8080";
}
@shinesoftware
shinesoftware / it_IT.csv
Last active September 8, 2017 08:09
Emipro - TicketSystem - Italian Translation
My Support Tickets Le Mie Segnalazioni
Create New Ticket Nuova Segnalazione
You have not created any support ticket. Non hai ancora creato alcuna segnalazione.
Department Categoria
Please Select Department Seleziona la Categoria
Please Select Priority Seleziona la Priorità
Please Select Order Id Seleziona il tuo Codice Ordine
Order Id Codice Ordine
Add Attachment Aggiungi Allegato
Submit Ticket Crea Segnalazione
.
├── app
│   ├── code
│   │   └── local
│   │   └── ShineSoftware
│   │   └── Bancasella
│   │   ├── Block
│   │   │   ├── Adminhtml
│   │   │   │   ├── Bancasella
│   │   │   │   │   ├── Edit
.
├── app
│   ├── code
│   │   └── community
│   │   └── ShineSoftware
│   │   └── Constriv
│   │   ├── Block
│   │   │   ├── Adminhtml
│   │   │   │   └── System
│   │   │   │   └── Config
@shinesoftware
shinesoftware / magento2-setup.sh
Last active November 9, 2020 08:41
Magento 2 - Bash Script - Install by cloning from Github repository and bash
#!/bin/bash
#title :magento2-setup.sh
#description :This script will install Magento from github
#author :Shine Software Italy
#date :20170202
#version :0.1
#usage :Set the execution permission for this file and then call it ./magento2-setup.sh
#notes :Install Composer and cURL to use this script.
@shinesoftware
shinesoftware / tax_rules.csv
Created November 8, 2016 09:50
Easyfatt Tax Rates
Code Country State Zip/Post Code Rate Zip/Post is Range Range From Range To default
10 IT * * 10.0000
10sp IT * * 10.0000
20 IT * * 20.0000
20d IT * * 20.0000
20i IT * * 20.0000
20inUe IT * * 20.0000
21 IT * * 21.0000
21d IT * * 21.0000
21exUe IT * * 21.0000