[Skip to main content](#vessel-content) # order export template - remapping fields ## - **[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")** - [![psymedia's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38357-psymedia "View psymedia's Profile") Topic Author - [ Offline](/forum/user/38357-psymedia) Less More - Posts: 11 - Thank you received: 1 - - 11 years 2 months ago [\#211392](#211392) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211392 "-- 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!")* was created by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* -- 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! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 2 months ago [\#211396](#211396) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211396 "-- 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!")* Hi, All this will require several hours of development of a professional developer. I would recommend you contact our partners for a quote on such work: [ www.hikashop.com/home/our-partners.html](http://www.hikashop.com/home/our-partners.html) The mass actions system can already handle exporting only some columns and not others, and mailing the exported CSV but not remaping the column headings. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")** - [![psymedia's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38357-psymedia "View psymedia's Profile") Topic Author - [ Offline](/forum/user/38357-psymedia) Less More - Posts: 11 - Thank you received: 1 - - 11 years 2 months ago [\#211413](#211413) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") Replied by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* on topic *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211413 "-- 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")** - [![psymedia's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38357-psymedia "View psymedia's Profile") Topic Author - [ Offline](/forum/user/38357-psymedia) Less More - Posts: 11 - Thank you received: 1 - - 11 years 2 months ago [\#211462](#211462) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") Replied by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* on topic *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211462 "-- 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!")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 2 months ago [\#211483](#211483) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211483 "-- 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!")* Hi, 1. Can be done with HikaShop custom address fields via the menu Display>Custom fields. 2. Can be done with the user/address API of HikaShop in an HikaShop plugin: [ www.hikashop.com/support/support/documen...r-documentation.html](http://www.hikashop.com/support/support/documentation/62-hikashop-developer-documentation.html) 4. Can be done with the order API of HikaShop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")** - [![psymedia's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38357-psymedia "View psymedia's Profile") Topic Author - [ Offline](/forum/user/38357-psymedia) Less More - Posts: 11 - Thank you received: 1 - - 11 years 2 months ago [\#211544](#211544) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") Replied by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* on topic *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211544 "-- 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!")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 2 months ago [\#211546](#211546) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[order export template - remapping fields](/forum/25-install-update/878735-order-export-template-remapping-fields#211546 "-- 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!")* Hi, "order_created" and the other fields storing a time ; are timestamp. A timestamp can be easily converted into a date using the PHP date function or using "hikashop_getDate" (which will also handle the Joomla timezone). And we do not have any issue having third party developers who create plugins for HikaShop ![:)](/media/kunena/emoticons/8.png ":)") Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODczNS1vcmRlci1leHBvcnQtdGVtcGxhdGUtcmVtYXBwaW5nLWZpZWxkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.240 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)