Practical need for skills to accomplish everyday tasks.
Long story short. As I found myself more and more working with e-commerce solutions for my family business I more often felt absolutely lost and incompetent. And at the same time maintaining (and growing) 600 k€ revenue online business as a hobby. It is hobby because I personally do not earn 🙂
So I decided to learn how things should(!) be done. Hopefully this also simplifies the purchasing process of developing services.
Some examples of tasks
Use (and build?) custom API to get clients’ personal prices to WooCommerce (WC) store.
Automatically generate XML from json to sync stocks.
Generate customized csvs out of XML to speed up data updates.
Send orders from WC to business software.
Build simple php script for price calculations from XML to WC.
Combine multiple XMLs from different sources to lower the number of cron jobs.
Build regular backup system using command lines.
I wrote these down just in case. Maybe I will find these funny simple tasks by the end of curriculum.
Well. I though I should document this path somehow. So I will just take rough notes here.
I am MSc in pharmacy (graduated 2012) and MBA (graduated 2019), left my daily job after 6+ years to study tech at the Tallinn University of Technology (TalTech) on IT Systems Development program.
There are 500+ first-year students (daytime and session study combined) on this program. Though, I believe they are split between different curriculums and not all on the IT Systems Development program.
Pets gave these in Zone slack. I tested and these work differently in Zone and Veebimajutus.
Everything after # (included) is not part of command line but is comment!
4 steps to create backup:
wpfolder is the directory where you have your WP installation.
cd wpfolder # move to folder where your WP installation is.
wp db export # create WP database dump.
cd .. # move one folder upwards.
tar czf veeb_2019-09-05.tar.gz wpfolder/ # pack the folder where you now have database dump and wp installation.
It is very important not to keep your database dump and backup publicly available. Please store these offline if possible.
5 steps to import backup
tar xzf veeb_2019-09-05.tar.gz # unpack your backup
cd wpfolder # move to folder where you have your wp files
nano wp-config.php # change db user, pass and host
wp db import databasefilename.sql # imports copy of database to dp defined in wp-config.
wp search-replace "https://oldname" "https://newname" # replace old URLs everywhere with new.
After import you need to log in to your wp-admin and update permalinks (even if you don’t plan to change anything). I suggest you try it before to understand how everything works.
For Veebimajutus you need to know this secret
It used to be sot that instead of wp you had to type wp-cli in command lines if you use Veebimajutus. But not anymore.
Instead of “localhost” in wp-config you need to have IP 127.0.0.1 because 🙂 You can not find this information anywhere.
Instead of dowloading and uploading (in case you need to move huge amounts of files) you can use wget. I basically means you log in to your new server and move to the folder where you would like to have the file. An you type:
This way you can transfer gigabytes of files within seconds between servers.
I used to code by using Notepad++, FileZilla and WordPress’ built in editor. For years. After blowing up one of my sites twice(!) after the failure of built in editor I understood I is not supposed to be so.
Then I did some research and found free Atom. Since then I had only seen it on pictures on agency websites. Took some time for beginner like myself to understand how it works but I love it. It saves so much time and is very much forgiving if I make mistakes.
To get it work through FTP to develop websites you that are hosted on your server you need to install package named Remote FTP, configure the file correctly (instructions are behind the link) and you are ready to go.
For every FTP connection you need separate “folder” where all the files are kept in your computer. If you need to connect no new ftp go File → Open folder (and open just folder).
If you have any questions then there is plenty of information (also about bugs) in Google.
Also known as front office not working after installation.
First thing after installing PrestaShop was this error. Back-end works fine (or at least looks ok) but front-end does not open. And it may be super annoying if you have worked with trouble free WooCommerce before.
Solution turned out to be very simple:
Turning on SSL (to get all redirections work) if you have SSL. Shop Parameters → General
Clearing cache and turning all cache off during initial build-up and development. Advanced Parameters → Performance
Figuring it out took few hours and bunch of nerves.
Win+R → write “powershell” without quotation marks → and terminal opens.
Very good instructions are here for Zone.ee server users on how to get to your shared hosting through SSH. For beginners this is super useful.
Ubuntu terminal on Windows 10
It is also possible to use Ubuntu terminal on Windows 10. You can download it from Microsoft Store, for example here. But, before you can install it you have to set your Windows settings to developer mode.
If you do not do this then simply does not work. Maybe there was something in addition to that but at this point I do not remember 🙂 But it took few hours to figure out why does the Microsoft Store installation fails.