Skip to content

Instantly share code, notes, and snippets.

@Quetzacoalt91
Quetzacoalt91 / categories.csv
Last active April 8, 2022 15:22
PrestaShop Pokemon Products
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
ID;Active (0/1);Name *;Parent category;Root category (0/1);Description;Meta title;Meta keywords;Meta description;URL rewritten;Image URL
100;1;Normal;Home;0;;Meta title-normal;Meta keywords-normal;Meta description-normal;normal;http://cdn.bulbagarden.net/upload/e/e4/NormalIC.gif
101;1;Fighting;Home;0;;Meta title-fighting;Meta keywords-fighting;Meta description-fighting;fighting;http://cdn.bulbagarden.net/upload/8/8e/FightingIC.gif
102;1;Flying;Home;0;;Meta title-flying;Meta keywords-flying;Meta description-flying;flying;http://cdn.bulbagarden.net/upload/7/73/FlyingIC.gif
103;1;Poison;Home;0;;Meta title-poison;Meta keywords-poison;Meta description-poison;poison;http://cdn.bulbagarden.net/upload/7/71/PoisonIC.gif
104;1;Ground;Home;0;;Meta title-ground;Meta keywords-ground;Meta description-ground;ground;http://cdn.bulbagarden.net/upload/d/d9/GroundIC.gif
105;1;Rock;Home;0;;Meta title-rock;Meta keywords-rock;Meta description-rock;rock;http://cdn.bulbagarden.net/upload/1/15/RockIC.gif
106;1;Bug;Home;0;;Meta title-
@Quetzacoalt91
Quetzacoalt91 / generate_json_from_translations_csv.php
Created November 29, 2021 17:20
Using the English json file + the CSV with all the translations, generate one json file per lang we want to use on the module
<?php
// load strings
$allTranslations = [];
if (($handle = fopen("psxmarketingwithgoogle_19112021_bis.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 0, ";")) !== FALSE) {
$key = $data['0'];
$allTranslations[$key] = $data;
}
fclose($handle);
@Quetzacoalt91
Quetzacoalt91 / CLDR_cases.tsv
Created May 9, 2019 15:47
Shell script deploying PrestaShop & Starting tests
France EUR fr fr 3 446,40 €
Spain EUR es es 3.446,40 €
Italy EUR it it 3.446,40 €
United_Kingdom GBP en gb £3,446.40
India_(Hindi) INR hi in ₹3,446.40
India_(English) INR en in ₹ 3,446.40
India_(Bengali) INR bn in ১২,৩৪,৫৬৮.১২₹
Japan JPY ja jp ¥3,446
Mexico MXN es mx $3,446.40
Poland PLN pl pl 3 446,40 zł
@Quetzacoalt91
Quetzacoalt91 / gist:9cef61ebbf12c139f44d27035d3cb1fd
Last active October 25, 2018 09:05
MySQL diff PrestaShop 1.6 >> 1.7
# server1 on 127.0.0.1: ... connected.
# WARNING: Objects in server1.prestashop16 but not in server1.prestashop:
# TABLE: ps_scene_lang
# TABLE: ps_compare
# TABLE: ps_scene_products
# TABLE: ps_scene_category
# TABLE: ps_scene_shop
# TABLE: ps_cms_block_shop
# TABLE: ps_themeconfigurator
# TABLE: ps_theme_specific
@Quetzacoalt91
Quetzacoalt91 / Dockerfile
Created September 12, 2018 17:25
Docker for generating a zip from the latest commit on develop branch
## Nightly build generation of PrestaShop releases.
## Build with `docker build -t nightly-gen .`
## Then, run it with `docker run -ti --rm -v $PWD/builds:/var/www/html/tools/build/releases -e PS_VERSION=1.7.5.0 nightly-gen`
FROM prestashop/prestashop-git:7.2
ENV PS_BRANCH develop
ENV PS_VERSION 1.7.X.X
RUN git fetch origin && git checkout origin/$PS_BRANCH