Author Archives: admin

Filezilla Server Connection Issue

How to fix “Can’t open data connection for transfer of “/”” error when connecting to a FTP server with Filezilla server.

  1. Change Filezilla server setting
    Settings -> Passive mode settings -> Use custom port range
    6000-6010
  2. Create a new inbound rule in Windows Firewall for above port range

Reference:

Define BASE_URL globally

/app/Providers/AppServiceProvider.php

 

Group Example

 

Laravel in IIS (url rewrite example)

Notes:

  1. Destination in IIS should point to public folder
  2. Avoid creating folders in public with the same name as prefix in routes.
    e.g. public/admin and URI “/admin” will cause error.

 

Laravel helpers (composer)

Add “files” in composer.json:

Update autoload.php

Reference:

  1. https://kejyuntw.gitbooks.io/laravel-5-learning-notes/services/helpers/services-custom-helpers-README.html

Google Analytics Ecommerce tracking via Tag Manager

 

Enhanced ecommerce tracking with tag manager

Image 20

Reference:

  1. Tag Manager for enhanced-ecommerce
  2. https://developers.google.com/tag-manager/enhanced-ecommerce#overview
  3. e-commerce tips for tag manager
    https://www.simoahava.com/analytics/ecommerce-tips-google-tag-manager/
  4. Google Analytics for ecommerce:
    https://developers.google.com/analytics/devguides/collection/analyticsjs/ecommerce
  5. Unlock the Data Layer: A Non-Developer’s Guide to Google Tag Manager
    https://www.lunametrics.com/blog/2013/10/15/unlock-data-layer-google-tag-manager/
  6. Implementing E-commerce tracking via tag manager:
    https://www.optimizesmart.com/implementing-e-commerce-tracking-google-tag-manager/

SQL to retrieve woocommerce orders

Reference:

  1. http://codecharismatic.com/sql-script-to-get-all-woocommerce-orders-including-metadata/