Amazon Orders Import for AbleCommerce 7

by Joe Payne 22. November 2013 15:34

Wrapped up a nifty Amazon Order Import system for AbleCommerce 7 this week.     The client wanted to bring in all of their Amazon orders into Able so consolidated sales reporting would be possible.

The import routine supports importing orders by date range, is totally aware of orders already imported and even maintains separate import logs for easy management.

Currently it’s designed assuming Amazon fulfilled the order.  So there is no posting back to Amazon to indicate the Able shipment status etc.   I’d love to work with a client that wants full two-way processing of Amazon orders via AbleCommerce 7. 

This programming would require modification to work in AbleCommerce Gold.   However the effort would not be significant.

Tags: ,

New Products | AC7 Articles

SQL 2008 R2 in an Amazon EC2 virtual instance reports UTC with GetDate()

by Joe Payne 1. August 2012 09:48

Ran into the most curious issue after migrating live sites running SQL 2008R R2 into Amazon AWS virtual instances.  There was a job scheduler module that populated a queue table based on triggers from other tables.

The triggers used the T-SQL GETDATE() function to log the current datetime of the transaction being triggered.  However, after migrating SQL to a virtual instance, the “current” datetime was off.     The trigger code was seeing the wrong datetime value every time GETDATE() was called.

I even went so far as to light up a local SQL install and compare it to the instance SQL install.  Executing SELECT GETDATE() on separate copies of SQL doesn’t report the same values.  Even though both server OS environments have the same date and time zone settings.

Finally I found another blog post about Azure but discussed the same problem.  Apparently when SQL is run in a virtual instance, it ALWAYS reports GETDATE() in UTC format regardless of the server OS time zone settings.

The IIS instance didn’t seem to have any trouble with it.  The issue was specific to the SQL OS.

One more reason (and lesson) why it’s better to store your SQL datetime values in UTC format so things like this don’t happen in the first place……

Tags: , , , , ,

Personal | AC7 Articles

Month List