[Skip to main content](#vessel-content) # Import and Export XML data ## - **[shifty\_](/forum/user/3676-shifty "View shifty_'s Profile")** - [![shifty_'s Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3676-shifty "View shifty_'s Profile") Topic Author - [ Offline](/forum/user/3676-shifty) Less More - Posts: 35 - Thank you received: 1 - - 14 years 3 months ago [\#56842](#56842) by [shifty\_](/forum/user/3676-shifty "View shifty_'s Profile") *[Import and Export XML data](/forum/4-how-to/56842-import-and-export-xml-data#56842 "Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: XML for products - need to IMPORT this in to Hikashop XML for sales - need to EXPORT this from Hikashop XML for users - need to IMPORT this to Joomla/Hikashop Thanks!!!")* was created by *[shifty\_](/forum/user/3676-shifty "View shifty_'s Profile")* Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: **XML for products - need to IMPORT this in to Hikashop**Code: <Product> <MasterGroupID>3</MasterGroupID> <MasterGroupName>Wine</MasterGroupName> <GroupID>676</GroupID> <GroupName>Wine - Red - Shiraz Blends</GroupName> <CategoryID>34</CategoryID> <CategoryName>2 for Deal</CategoryName> <Name>Pillar Box Red</Name> <Code>19218</Code> <ExtraDescription>This will be the description of the product with lots of detail.</ExtraDescription> <NormalPrice>12.9500</NormalPrice> <PriceRetail>12.9500</PriceRetail> <StockLevel>60</StockLevel> <SubCode>5766</SubCode> <Quantity>55</Quantity> <Vintage></Vintage> <CustomVarChar1>750ml</CustomVarChar1> <CustomVarChar2>South Australia</CustomVarChar2> <CustomVarChar3>Australia</CustomVarChar3> <TypeName>Padthaway</TypeName> <IsSpecial>0</IsSpecial> <IsVisible>1</IsVisible> <InternetSpecial>0</InternetSpecial> <Rating>0</Rating> <Weight>1.3400</Weight> <CreatedDate>2008-05-04T23:21:46.687</CreatedDate> <NewRelease>N</NewRelease> <InternetAuction>N</InternetAuction> </Product> **XML for sales - need to EXPORT this from Hikashop**Code: <Sales> <Sale> <ID>2120157</ID> <SaleDate>2012-05-17 21:20</SaleDate> <TillID>1000</TillID> <MemberID>1</MemberID> <Transactions> <Transaction> <PLU>3313</PLU> <Quantity>1</Quantity> <UnitPrice>699</UnitPrice> <TotalDiscount>0</TotalDiscount> </Transaction> <Transaction> <PLU>20071</PLU> <Quantity>4</Quantity> <UnitPrice>4990</UnitPrice> <TotalDiscount>0</TotalDiscount> </Transaction> </Transactions> <Payments> <Payment> <MediaID>2</MediaID> <Amount>20659</Amount> </Payment> </Payments> </Sale> </Sales> **XML for users - need to IMPORT this to Joomla/Hikashop**Code: <Members> <Member> <ID>4</ID> <Name>John Smith</Name> <Email>jsmith@nowhere.com</Email> <Password>p@$$word</Password> </Member> </Members> Thanks!!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2ODQyLWltcG9ydC1hbmQtZXhwb3J0LXhtbC1kYXRhP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 14 years 3 months ago [\#56859](#56859) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import and Export XML data](/forum/4-how-to/56842-import-and-export-xml-data#56859 "Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: XML for products - need to IMPORT this in to Hikashop XML for sales - need to EXPORT this from Hikashop XML for users - need to IMPORT this to Joomla/Hikashop Thanks!!!")* Hi, 1. In order to import the XML for the products, the easiest would be to convert it into a CSV. Either via a script you would write or a tool online like this one: [ www.luxonsoftware.com/opensource/xmltocsv](http://www.luxonsoftware.com/opensource/xmltocsv) 2. In order to export orders in XML, you will have to change the code of the file "export" of the view "order" for your back end template via the menu Display->Views. 3. Importing users into joomla is not related to HikaShop. Once users will be in joomla, HikaShop will be able to "see" them. You will find several solutions for importing users into joomla: [ extensions.joomla.org/extensions/migrati...sers-import-a-export](http://extensions.joomla.org/extensions/migration-a-conversion/users-import-a-export) I don't know if any supports XML, but if that's not the case, you should ask them. The following user(s) said Thank You: [shifty\_](/forum/user/3676-shifty "View shifty_'s Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2ODQyLWltcG9ydC1hbmQtZXhwb3J0LXhtbC1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[enzo24](/forum/user/8014-enzo24 "View enzo24's Profile")** - [![enzo24's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8014-enzo24 "View enzo24's Profile") - [ Offline](/forum/user/8014-enzo24) Less More - Posts: 15 - Thank you received: 1 - - 14 years 1 month ago [\#63970](#63970) by [enzo24](/forum/user/8014-enzo24 "View enzo24's Profile") Replied by *[enzo24](/forum/user/8014-enzo24 "View enzo24's Profile")* on topic *[Re: Import and Export XML data](/forum/4-how-to/56842-import-and-export-xml-data#63970 "Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: XML for products - need to IMPORT this in to Hikashop XML for sales - need to EXPORT this from Hikashop XML for users - need to IMPORT this to Joomla/Hikashop Thanks!!!")* > nicolas wrote: Hi, > ..../ > > 2\. In order to export orders in XML, you will have to change the code of the file "export" of the view "order" for your back end template via the menu Display->Views. > > /.... Hi, I'm using Hikashop Business edition and I'm needing to export order info to XML when order gets "shipped' status. This XML file is for UPS (see more here : [ devwiki.volusion.com/index.php/UPS\_WorldShip](http://devwiki.volusion.com/index.php/UPS_WorldShip)) I'm no PHP crack, but I'd like to know where I can get more info on how to transform that CSV export to XML export & better yet, have it sent via e-mail to UPS (any examples or tutos welcome). I hope I'm not the only one needing this and maybe someone has already come accross a solution to this. Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2ODQyLWltcG9ydC1hbmQtZXhwb3J0LXhtbC1kYXRhP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 14 years 1 month ago [\#64124](#64124) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import and Export XML data](/forum/4-how-to/56842-import-and-export-xml-data#64124 "Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: XML for products - need to IMPORT this in to Hikashop XML for sales - need to EXPORT this from Hikashop XML for users - need to IMPORT this to Joomla/Hikashop Thanks!!!")* Hi, In the file "export" of the view "order", HikaShop echo the data of the orders with the CSV format. You will have to change it to echo the data with the XML format of UPS. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2ODQyLWltcG9ydC1hbmQtZXhwb3J0LXhtbC1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Georg](/forum/user/5871-georg "View Georg's Profile")** - [![Georg's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5871-georg "View Georg's Profile") - [ Offline](/forum/user/5871-georg) Less More - Posts: 79 - Thank you received: 1 - - 13 years 6 months ago [\#101107](#101107) by [Georg](/forum/user/5871-georg "View Georg's Profile") Replied by *[Georg](/forum/user/5871-georg "View Georg's Profile")* on topic *[Re: Import and Export XML data](/forum/4-how-to/56842-import-and-export-xml-data#101107 "Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: XML for products - need to IMPORT this in to Hikashop XML for sales - need to EXPORT this from Hikashop XML for users - need to IMPORT this to Joomla/Hikashop Thanks!!!")* Hi, is there any sample file for this instruction *In the file "export" of the view "order", HikaShop echo the data of the orders with the CSV format. You will have to change it to echo the data with the XML format of UP*S. I realy would love to export the csv into xml data but haven´t got a clue how to manage this. Probably there is a smiple manual for dummies? Which erp system do the most hikashop customers use normaly? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2ODQyLWltcG9ydC1hbmQtZXhwb3J0LXhtbC1kYXRhP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 13 years 5 months ago [\#101321](#101321) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import and Export XML data](/forum/4-how-to/56842-import-and-export-xml-data#101321 "Hi There I was wondering if it is possible (even with some modifcations or development) to use specific XML files for importing and exporting data in and out of Hikashop. My client has a sophisticated POS system that takes care of inventory, sales and memberships throughout their organisation. So I am looking in to the possibility of importing their current product catalogue and users using their XML data and exporting the Hikashop sales to import back in to their POS system to track sales and update quantities etc. Below are 3 samples of the xml files: XML for products - need to IMPORT this in to Hikashop XML for sales - need to EXPORT this from Hikashop XML for users - need to IMPORT this to Joomla/Hikashop Thanks!!!")* Each ERP will have a different XML format. So we cannot provide a simple manual as it would have to be different for each erp. Thus it requires a developer in order to make it compatible with your ERP format. I guess that openERP must be used a lot. They have an import tool which handles CSV imports: [ doc.openerp.com/v6.1/book/8/8\_20\_Config/...g\_import\_export.html](http://doc.openerp.com/v6.1/book/8/8_20_Config/8_20_Config_import_export.html) The following user(s) said Thank You: [Georg](/forum/user/5871-georg "View Georg's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2ODQyLWltcG9ydC1hbmQtZXhwb3J0LXhtbC1kYXRhP3RtcGw9bWFya2Rvd24=) 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.245 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)