Need Ecwid Shopping Cart REST API imported into database where running product and order totals are calculated. Then filter views by cities to calculate individual purchase totals, totals by product, overall order totals, and total product weight. API info here http://kb.ecwid.com/w/page/43697230/Order%20API#Authentication