Skip to content

Instantly share code, notes, and snippets.

View IP-CAM's full-sized avatar

Ernie IP-CAM

View GitHub Profile
@IP-CAM
IP-CAM / index.php
Created April 7, 2020 17:04
Product Import from csv to Opencart's database. Using native Opencart API
<?php
ini_set ("display_errors", 1);
$start_time = microtime(true);
// Configuration
if (file_exists('config.php')) {
require_once('config.php');
} else {
die("Config file is not exists");
@IP-CAM
IP-CAM / remove all opencart products
Created May 23, 2021 18:56 — forked from eapdob/remove all opencart products
remove all opencart products - sql
DELETE t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15
FROM `oc_product` t1
LEFT JOIN `oc_product_attribute` t2 ON(t1.product_id=t2.product_id)
LEFT JOIN `oc_product_description` t3 ON(t1.product_id=t3.product_id)
LEFT JOIN `oc_product_discount` t4 ON(t1.product_id=t4.product_id)
@IP-CAM
IP-CAM / discount_interactive.xml
Last active May 23, 2021 18:57 — forked from eapdob/discount_interactive.xml
Product discount options
<?xml version="1.0" encoding="utf-8"?>
<modification>
<name>Product discount options</name>
<version>1.0.0</version>
<link>https://e-m.com.ua</link>
<author>em</author>
<code>product_discount_options</code>
<file path="catalog/model/catalog/product.php">
<operation error="skip">
<search><![CDATA[$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_discount WHERE product_id = '" . (int)$product_id . "' AND customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC");]]></search>