Skip to content

Instantly share code, notes, and snippets.

View manutheblacker's full-sized avatar
🎯
Focusing

Emmanuel A. manutheblacker

🎯
Focusing
View GitHub Profile
@manutheblacker
manutheblacker / README.md
Created April 12, 2025 16:41
How to rollback migrations in Drizzle ?

Use the following command :

npx drizzle-kit drop
@manutheblacker
manutheblacker / import-products.csv
Created January 22, 2025 10:25
Template of WooCommerce to Import
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 7 columns, instead of 1 in line 5.
sku,name,images,price,description,categories,tags
game-case-bag-deluxe,Bag for game console - Deluxe,https://demos.homescriptone.com/doko/wp-content/uploads/sites/2/2024/07/1.1_PoductTile_NintendoSwitchCommuterCaseDeluxeEliteEdition_enNOE.jpg,25.00,Case for game console nintendo switch,Game Consoles Case,Nintendo
game-case-bag-deluxe-ac,Bag for game console - AC Deluxe,https://demos.homescriptone.com/doko/wp-content/uploads/sites/2/2024/07/299324b-3701625900450-mockup.jpg,75.00,Case for game console nintendo switch,Game Consoles Case,Nintendo
game-case-bag-deluxe-ged,Bag for game console - Deluxe - Green Edition,https://demos.homescriptone.com/doko/wp-content/uploads/sites/2/2024/07/ssd.jpg,35.00,Case for game console nintendo switch,Game Consoles Case,Nintendo
game-case-bag-deluxe-as,Bag for game console - Deluxe - AnC,https://demos.homescriptone.com/doko/wp-content/uploads/sites/2/2024/07/pdjdusvuaty3sfbaj5wy.jpg,45.00,Case for game console nintendo switch,Game Consoles Case,Nintendo
game-case-bag-deluxe-pl
@manutheblacker
manutheblacker / table.csv
Last active January 22, 2025 10:09
WooCommerce import CSV TABLE Reference
CSV Column Name Maps to product property Example Notes
ID id 100 Defining this will overwrite data for that ID on import.
Type type simple, variation, virtual Product Type. Valid values: simple, variable, grouped, external, variation, virtual, downloadable. Multiple types can be used, CSV separated.
SKU sku my-sku Required. Auto-generated if missing.
Name name My Product Name Required.
Published status 1 1 for published, 0 for private, -1 for draft.
Is featured? featured 1 1 or 0
Visibility in catalog catalog_visibility visible Supported values: visible, catalog, search, hidden
Short description short_description This is a product.
Description description This is more information about a product.
@manutheblacker
manutheblacker / code.py
Created June 13, 2024 20:41
move a column of data to a specific position in openpyxl
import os
import sys
from openpyxl import Workbook
def main():
wb = Workbook()
ws1 = wb.active
ws1.title = "1st Hour"
ws1['A1'] = 'worry'
@manutheblacker
manutheblacker / code.php
Created April 2, 2024 16:25
WIP : Create a PDF using Postscript and PHP
<?php
// Define the file name
$filename = 'example.pdf';
$pdf_content = '%!PS-Adobe
/Helvetica findfont 12 scalefont setfont
0 0 moveto
@manutheblacker
manutheblacker / package.json
Created March 3, 2024 04:36
How to build a modern Svelte apps using Routify and Django
{
"name": "x456",
"private": true,
"version": "1.0.0",
"type": "module",
"scripts": {
"dev": "vite",
"build": "vite build",
"preview": "vite preview"
},
@manutheblacker
manutheblacker / help.md
Created February 7, 2024 09:51
How to prevent spam registration in WooCommerce ?

Make sure to block the REST API endpoints of WooCommerce allowing user creation.

<!-- wp:woocommerce/cart -->
<div class="wp-block-woocommerce-cart alignwide is-loading"><!-- wp:woocommerce/filled-cart-block -->
<div class="wp-block-woocommerce-filled-cart-block"><!-- wp:woocommerce/cart-items-block -->
<div class="wp-block-woocommerce-cart-items-block"><!-- wp:woocommerce/cart-line-items-block -->
<div class="wp-block-woocommerce-cart-line-items-block"> </div>
<!-- /wp:woocommerce/cart-line-items-block -->
<!-- wp:woocommerce/cart-cross-sells-block -->
<div class="wp-block-woocommerce-cart-cross-sells-block"><!-- wp:heading {"fontSize":"large"} -->
<h2 class="wp-block-heading has-large-font-size">You may be interested in…</h2>
@manutheblacker
manutheblacker / code.py
Created January 2, 2024 04:20
How to convert a Excel file into Json using Python Openpyxl ?
import openpyxl # pip install openpyxl
from var_dump import var_dump # pip install var_dump , this method has the same behaviour like the PHP ones.
import json
import datetime
now = datetime.datetime.now()
path = "./atarada.xlsx" # path to your xlsx file
wb_obj = openpyxl.load_workbook( path )
sheet_obj = wb_obj.active
@manutheblacker
manutheblacker / solution.md
Created December 10, 2023 14:34
How to do when Django signals isn't sending in production ?

Hello, I've encountered an issue with a Django project that I was running under CyberPanel 3.

Normally, under certain conditions, when new data is saved to the database, a new identifier is created for the field. While testing locally, it worked as expected, but in production, it failed to send.

After some research, I realized that signals must be loaded, either by adding them to the ready() method in the apps.py file, like this, and ensuring that the app is loaded into settings.py, as in my case: 'users.apps.UsersConfig'

class UsersConfig(AppConfig):
    default_auto_field = 'django.db.models.BigAutoField'
    name = 'users'