ProudCommerce proudcommerce
proudcommerce
/ OXID eShop - MySQL Snippets
Last active
August 2, 2023 12:19
collection of useful and important mysql snippets for the oxid eshop
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*** ARTIKEL / ARTICLES ***/ | |
| /******************************************************/ | |
| /* artikelnamen aller artikel anzeigen, welcher einer bestimmten kategorie zugeordnet sind [proudcommerce.com] */ | |
| select oxarticles.oxtitle, oxarticles.OXVARSELECT as Variant, oxcategories.OXTITLE as Kategorie from oxarticles left join oxobject2category on oxarticles.OXID = oxobject2category.OXOBJECTID left join oxcategories on oxcategories.OXID = oxobject2category.OXCATNID where oxcategories.OXROOTID = '<YOUR-CATEGORY-OXID>'; | |
| /* variantenpreise (oxvarmin, oxvarmax) anhand der aktuellen artikel aktualisieren [foxido.de] */ | |
| UPDATE oxarticles B, (SELECT oxparentid,MIN( oxprice ) AS min ,MAX( oxprice ) AS max FROM oxarticles GROUP BY oxparentid) AS A SET oxvarminprice = A.min, oxvarmaxprice = A.max WHERE B.oxid = A.oxparentid | |
proudcommerce
/ OXID eShop - Redirect old seo urls
Created
December 25, 2013 15:50
Script for saving old seo urls. Redirects old seo urls (e. g. from an other shop software after relaunch) to the new oxid shop seo urls.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * This program is free software: you can redistribute it and/or modify | |
| * it under the terms of the GNU General Public License as published by | |
| * the Free Software Foundation, either version 3 of the License, or | |
| * (at your option) any later version. | |
| * | |
| * @copyright (c) Proud Sourcing GmbH | 2013 | |
| * @link https://gist.github.com/proudcommerce | |
| * @version 1.0.0 |