Nothing to Post

Posted on November 12, 2011 by julbx

Just another Tool Night for me while chatting with friends in Facebook..

Excited for 2012…

Posted in web development | Leave a comment

Books I want to Read

Posted on September 8, 2011 by julbx

Before taking a cute nap, I would like to share this book that I want to buy.

I think this books are cool…

I am not sure if buying a kindle is cool also but I have to save money for my Lamborghini dream…

Posted in life lessons | Leave a comment

Smoking Crocs

Posted on September 6, 2011 by julbx

Got my crocs and my viceroy in a glommy wtf friday evening.

Posted in web development | Leave a comment

Bakuteh

Posted on September 6, 2011 by julbx

hungry night

Posted in life lessons | Leave a comment

X.commerce Singapore

Posted on July 22, 2011 by julbx

Well… I am very interested on X.commerce. I am so sleepy right now but, you know… chaoo!!!!

Posted in web development | Leave a comment

The Future of X.Commerce

Posted on July 21, 2011 by julbx

I am into the power of x.commerce.. hope I can post more here…
I still have to study more about it and what it is man.

Posted in CMS,ERP,CRM, magento, web development | Tagged | Leave a comment

Magento 1.5 Reset Test Orders

Posted on July 19, 2011 by julbx

Yeah Baby…

Magento 1.5.x reset test orders is here.

  1. SET FOREIGN_KEY_CHECKS=0;
  2.  
  3. TRUNCATE `sales_flat_order`;
  4. TRUNCATE `sales_flat_order_address`;
  5. TRUNCATE `sales_flat_order_grid`;
  6. TRUNCATE `sales_flat_order_item`;
  7. TRUNCATE `sales_flat_order_status_history`;
  8. TRUNCATE `sales_flat_quote`;
  9. TRUNCATE `sales_flat_quote_address`;
  10. TRUNCATE `sales_flat_quote_address_item`;
  11. TRUNCATE `sales_flat_quote_item`;
  12. TRUNCATE `sales_flat_quote_item_option`;
  13. TRUNCATE `sales_flat_order_payment`;
  14. TRUNCATE `sales_flat_quote_payment`;
  15. TRUNCATE `sales_flat_shipment`;
  16. TRUNCATE `sales_flat_shipment_item`;
  17. TRUNCATE `sales_flat_shipment_grid`;
  18. TRUNCATE `sales_flat_invoice`;
  19. TRUNCATE `sales_flat_invoice_grid`;
  20. TRUNCATE `sales_flat_invoice_item`;
  21. TRUNCATE `sendfriend_log`;
  22. TRUNCATE `tag`;
  23. TRUNCATE `tag_relation`;
  24. TRUNCATE `tag_summary`;
  25. TRUNCATE `wishlist`;
  26. TRUNCATE `log_quote`;
  27. TRUNCATE `report_event`;
  28.  
  29. ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;
  30. ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;
  31. ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;
  32. ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
  33. ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;
  34. ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
  35. ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
  36. ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
  37. ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
  38. ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
  39. ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
  40. ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;
  41. ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;
  42. ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;
  43. ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
  44. ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;
  45. ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;
  46. ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;
  47. ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
  48. ALTER TABLE `tag` AUTO_INCREMENT=1;
  49. ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
  50. ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
  51. ALTER TABLE `wishlist` AUTO_INCREMENT=1;
  52. ALTER TABLE `log_quote` AUTO_INCREMENT=1;
  53. ALTER TABLE `report_event` AUTO_INCREMENT=1;
  54.  
  55. – lets reset customers
  56. TRUNCATE `customer_address_entity`;
  57. TRUNCATE `customer_address_entity_datetime`;
  58. TRUNCATE `customer_address_entity_decimal`;
  59. TRUNCATE `customer_address_entity_int`;
  60. TRUNCATE `customer_address_entity_text`;
  61. TRUNCATE `customer_address_entity_varchar`;
  62. TRUNCATE `customer_entity`;
  63. TRUNCATE `customer_entity_datetime`;
  64. TRUNCATE `customer_entity_decimal`;
  65. TRUNCATE `customer_entity_int`;
  66. TRUNCATE `customer_entity_text`;
  67. TRUNCATE `customer_entity_varchar`;
  68. TRUNCATE `log_customer`;
  69. TRUNCATE `log_visitor`;
  70. TRUNCATE `log_visitor_info`;
  71.  
  72. ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;
  73. ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;
  74. ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;
  75. ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;
  76. ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;
  77. ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;
  78. ALTER TABLE `customer_entity` AUTO_INCREMENT=1;
  79. ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;
  80. ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;
  81. ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;
  82. ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;
  83. ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;
  84. ALTER TABLE `log_customer` AUTO_INCREMENT=1;
  85. ALTER TABLE `log_visitor` AUTO_INCREMENT=1;
  86. ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;
  87.  
  88. – Now, lets Reset all ID counters
  89. TRUNCATE `eav_entity_store`;
  90. ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;
  91.  
  92. SET FOREIGN_KEY_CHECKS=1;
Posted in database, magento, web development | Leave a comment

ZMOT ( Zero Moment of Truth ) Experts and Consultants in Singapore

Posted on July 19, 2011 by julbx

Internet marketing with knowledge on Zero Moment of Truth in Singapore.
This is cool, so I will read about this and spend maybe an hour or two for this ok?

Zero Moment of Truth here we come!

Posted in Zero Moment of Truth | Tagged | Leave a comment

Installed Apache on my Linux Image in Amazon

Posted on April 10, 2011 by julbx

Yeshh, Good morning! I successfully installed a linux image on my amazon ec2 playground yeshh!!!..

whats next? install mysql and zend framework?

I thought running amazon cloud is just as easy as deploying in Google App Engine or Hosting in ordinary web hosting with cpanel, turns out its like giving you an empty machine and you have to install what you need. Right now, I installed apache by using the command

sudo yum install httpd

Posted in web development | 3 Comments

Amazon EC2 connection

Posted on April 9, 2011 by julbx

Although I’m so sleepy, I still continue to prepare my web app, so now there are good news, I successfully created an Instance in the Amazon EC2 web service, I downloaded certificates and private keys, I also downloaded the Amazon Terminal so I do SSH from there…

I have navigated inside my Linux image on AWS and I felt so cool about it. I am so sleep now!!!!

Posted in Linux | Leave a comment