Category Archives: woocommerce

SQL to retrieve woocommerce orders

Reference:

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

Woocommerce thank you page

Variable $order in thankyou.php will be created by order key from URL. e.g. key=wc_order_593a3d1583f2e

So, it’s important to make sure return URLs of payment gateways include this param or thank you page won’t display order info and purchase event of Facebook pixel will not work neither.

Reference:

  1. How to get order key:
    https://stackoverflow.com/questions/37669956/woocommerce-get-order-key

Woocommerce Checkout page customization

Reference:

  1. Official Tutorials
    https://docs.woocommerce.com/document/tutorial-customising-checkout-fields-using-actions-and-filters/
  2. Sorting for checkout fields
    https://wordpress.stackexchange.com/questions/78339/how-to-reorder-billing-fields-in-woocommerce-checkout-template
  3. Woocommerce Hooks
    https://docs.woocommerce.com/wc-apidocs/hook-docs.html
  4. Other tutorial:
    http://uploadwp.com/customizing-the-woocommerce-checkout-page/

WordPress + Woocommerce must plugins

一般

  1. PixelYourSite
  2. 可設定Pixel Purchase, checkout, Add to cart相關Event
  3. Post Views Counter
  4. Slider Revolution
  5. WooCommerce – Social Login
  6. WP-Mail-SMTP
  7. WooCommerce Email Test
  8. WPBakery Visual Composer
  9. Yoast SEO
    抓meta image會有問題,NextGen Facebook可能比較好
  10. NextGEN Facebook (NGFB)
    管理meta tags
  11. Order your Posts Manually
  12. Password Strength for WooCommerce
  13. Redirection
  14. Slider Revolution
  15. Flamingo
    表單製作相關
  16. Contact Form 7
    搭配Flamingo
  17. WooCommerce Google Analytics Integration
    Google Analytics電子商務
    https://www.youtube.com/watch?v=e4TZVnOtdKQ
  18. Disable Comments

結帳相關:

  1. ECPay
    綠界金流
  2. WooCommerce Checkout Field Editor (Manager) Pro
    可新增/修改結帳頁的欄位屬性,免費,好用
  3. Product Sales Report for WooCommerce
  4. Advanced Order Export For WooCommerce
  5. WooCommerce Print Invoice & Delivery Note
  6. Checkout Manager For Woocommerce
    https://www.webmart.tw/blog/woocommerce-checkout-field-editor/
  7. WooCommerce COD Advanced 貨到付款

客戶管理:

  1. User Switch: Login as user
    https://tw.wordpress.org/plugins/user-switching/

其它付費外掛:

  1. https://cloudwp.pro/market/plugins/premium-plugins/ezship/

FB login – replace login name with email

Plugin: yith-woocommerce-social-login

Update this file: yith-woocommerce-social-login/includes/class-yith-social-login.php (Line 180)

 

Replace register login name with email

Create a plugin to do this: