Pinakin Patel
PHP Web Developer
Add a Checkout Flow to Any Website: Platform-Independent Tools for E-commerce
Introduction If you already have a website — whether it’s built on WordPress, Webflow, a static HTML template, or even a custom CMS — adding a modern, secure checkout flow can be tricky.Maybe you’ve outgrown your current e-commerce system, or you just want a faster,...
Creating a Tone of Voice Document with ChatGPT
If you want to keep a standard tone through out your website and communications then a tone of voice document will help with this. Firstly use this this GPT https://chatgpt.com/g/g-FmzvmSPkI-tone-of-voice-gpt and paste in a copy of an article you would like to analyse...
How to add an email account using IMAP/SMTP on iPhone 14
1. Open Settings Tap the grey Settings app (⚙️). 2. Go to Mail settings Scroll down and tap Mail, then tap Accounts 3. Add a new account Tap Add Account, then tap Other, and select Add Mail Account 4. Enter your basic account info Fill in these fields: Name: the name...
Xcart 4 Error codes
X-Cart 4.1.x Error ID Codes List – Based on X-Cart 4.1.12 Error ID 2 (admin/editor_mode.php):Attempted to access Editor mode without being logged in or in Editor Mode Error ID 3 (admin/editor_mode.php):Attempted to access editor_mode.php without being in Editor Mode...
Updating Custom Field Values in MailWizz using SQL
using sql to update mailwizz custom fields
Recursively deleting files by extension value on linux
Replace . with path to folder ie /home/rwewr/ewr/ewr/ find . -type f \( -iname "*.jpg" -o -iname "*.jpeg" -o -iname "*.webp" -o -iname "*.gif" -o -iname "*.png" \) -delete
Installing Docker and Docker Desktop on Linux Mint
These instructions are merged from https://forums.linuxmint.com/viewtopic.php?t=414617 and https://docs.docker.com/desktop/setup/install/linux/ubuntu/ # Install required packages sudo apt-get update sudo apt-get install ca-certificates curl gnupg # Add Docker's...
How To Open Website On Startup with a Raspberry Pi
The following instructions have been used to startup chrome from https://smarthomepursuits.com/open-website-on-startup-with-raspberry-pi-os/ On your pi you can edit the file ~/.config/lxsession/LXDE-pi/autostart using the following command in terminal sudo leafpad...
Creating a SQL based on the products export CSV in Shopify
I used chatgpt to create this SQL based on the prompt "can you create a SQL create table based on this data" I additionally copied and pasted the header and the first 4 rows of data in the prompt. CREATE TABLE products ( handle VARCHAR(255) NOT NULL PRIMARY KEY, title...
using imapsync on terminal
how to start a sync from terminal using the excellent imapsync
how to increase increase by a percentage and round to the nearest 5p
select pr.*, round((pr.price * 1.2), 2 ) as 'round_price_2', round( (pr.price * 1.2) / 0.05, 0) * 0.05 as 'new_price_2_05' from xcart_pricing as pr where pr.membershipid = 0 use round( (pr.price * 1.2) / 0.05, 0) * 0.05 to round to the nearest 5p update xcart_pricing...
Command to show the top ten file requests from an apache log file
You can use a combination of terminal commands like awk, sort, uniq, and cut to analyze an Apache log file and find out which files are called the most and the bandwidth they are using.
Function to create a slug in MySQL
Use this to create a slug from a string field.
using curl to fetch a file using sftp with password in command
If you need to download a file using SFTP from the command line, you should use the sftp or scp commands.
updating custom field values in mailwizz using direct SQL
In mailwizz you can create custom fields which get assigned a field_id in the database table. So in my case the customer field is called rank and the field_id = 24.
Format Telephone numbers into US format in MySQL
if you have a telephone field in a table where numbers have been entered in the format 1234567890 then use this to format it as 123-456-7890
Adding a product level field which is language dependent
Use this guide to add a new field to the xcart_products_lng_en table.
Driving School Price Comparison using wpDataTables
How to create a searchable and sortable data table in wordpress using wpDataTables Lite Plugin. I have chosen this plugin as the lite version can fetch data from a publicly hosted CSV file. As part of this setup I have created a database table with columns company,...
Reading a CSV and calling ChatGPT and outputting to a New CSV file
In this example I am going to use python to read a CSV with 1 column headed 'country' and then for each country in the file it will write a new CSV file with the information returned from ChatGPT3 to create a country and description CSV file. file1.csv should be kept...
jQuery to check the first charater of a link started with hash #
I came across an issue with an old wordpress site where the mobile menu did not close when a menu item link to internal page content because the url started with # hash.
Guide to Changing Directory Permissions to 755 and File Permissions to 644
Tutorial on how to change the permissions of all files and directories within a directory tree on Linux
Adding a HTML Sitemap to a Shopify Store
I have found that themes generally use links to prodct pages that are not the canonicalised url to the product on the store page. So this is to allow the breadcrumb to be dynamic and show based on the route they took to the product page.
How to get the sending IP addresses from the references in your SPF record
If you use SMTP services like Mailjet or Amazon then your email could be sent from multiple possible IP addresses. An easy way to identifiy these ip addresses is by looking at the SPF record. This is easily done using googles dig tool...
Using aspect Ratio in CSS
Aspect Ratio in CSS refers to the proportional relationship between the width and height of an element. It represents the ratio of the element's width to its height. For example, an element with an aspect ratio of 16:9 would have a width that is 16 times larger than...