order export template - remapping fields

-- url of the page with the problem -- : beeskneesfashion.co.uk
-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.x
-- PHP version -- : 5.4

Hi i would like some advice on how to achive the following by modifying the backend orders export view,

1. only export columns of interest ie order number quantity address etc
2. Remap the column headings in line with amazons flat file fulfilment request ie. shipping_address_street becomes ship_street_1
3. mail the csv (cant see the option in export orders only in MA's)


Big picture is to dump on order confirmed, i have a desktop app that will receive the file and push to amazon for shipping, i would use mass actions BUT i'm having the issue of rogue underscores in the exported data ie country_united_kingdom_222 and state field is also throwing teh same error.

Thanks in advance for any assistance!

I have the time and i'm willing to learn, can you at least point me towards the correct files to edit to reduce the number of fields exported in orders?

Ok, here is the answer in abbreviated form..

1. create new fields hikashop_address > Zone, real_post_code
2. create trigger - on new user or address update - lookup 2 digit country code in zones table - populate, do the same for post code
3. create table - Amazon_orders
4.create trigger - on order insert populate amazon orders.
5. create trigger - after amazon order run sql to export amazon_orders as csv

tomorrow will work on the php to pull all this together and try to skip the csv and use the amazon API to push the order to amazon

almost there....

order status change triggers filling of new table hikashop_amazon_orders exports to tab delimited csv, checks filesize is not zero and updates status to confirmed and shipped.

only issue im having is converting your epoch order_created into realworld yyyy-mm-dd.

fixed the states and country with 2 new columns in hikashop_address çountry code (looked up from zone) and state coming from zone_name_english, these values get looked up and filled by a trigger on hikashop_user update (account is verified)

after all the dev work here im seriously considering publishing as a amazon fulfillment plugin, would you guys have an issue with this?