[Skip to main content](#vessel-content) # How to prepare an Excel file for import ## - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 5 months ago [\#157618](#157618) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#157618 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* was created by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* -- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 5 months ago [\#157656](#157656) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#157656 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi, Have you read that documentation ? [ hikashop.com/support/support/documentati...hikashop-import.html](https://hikashop.com/support/support/documentation/73-hikashop-import.html) It explains how the csv import work in HikaShop, and how to format the csv file. You can to create example products in your shop, then export them to have a real example of a valid csv file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 5 months ago - 12 years 5 months ago [\#157714](#157714) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#157714 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi Xavier, I see by creating an export file AFTER I make some valid Category and Product entries into HikaShop, i can make a 'template' of how to set up my source .csv for import - clever solution, thanks I'll try your suggestion now. Although I expect the way the Categories and Sub-Categories have been formatted in the source spreadsheet may be problematic, I'll see. Last edit: 12 years 5 months ago by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile"). Reason: expand explanation Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 5 months ago [\#157730](#157730) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#157730 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi, Indeed, you will have to manage the csv file before importing it in order to have the correct format. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#157797](#157797) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#157797 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Since the Category, sub-Category and 2nd level Sub-Category are currently spread over columns A-F throughout the spreadsheet, perhaps it would be best to firstly add 3 columns at the LH side and move them to say Category = column A, Sub-Category = column B and Sub-Category 2 = column C - so that before converting to .CSV every item to be parsed would have its own column? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 4 months ago [\#158016](#158016) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#158016 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Sorry, but I don't really understand what you mean. Could you write a more detailed example ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#158056](#158056) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#158056 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi, I have attached the Polycom Price list. A main Category, REALPRESENCE ROOM Can be seen on Row 1 2 Sub-categories; HDX Executive Collection Stand Systems Service - HDX Executive Collection Can be seen on Row 3 and Row 9; A further nested Sub-Category of Service - HDX Executive Collection; Installation Services is on Row 14 As these are the Categories and Sub-Categories for all the Polycom products, we will need them to be created and ready for monthly updates from Polycom Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 4 months ago [\#158439](#158439) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#158439 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi, You can add one category per row in the csv. They must be filled in the column "category" and "parent_category" depending on the three. Example: parent_category;category ;realpresence room realpresence room;HDX Executive Collection Stand Systems realpresence room;Service - HDX Executive Collection HDX Executive Collection Stand Systems;Installation Services You just have to keep this format, but the categories can be in row1, 3, 9 and 14. You just need to have the parent category before the child one. Hope this will help you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161343](#161343) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161343 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi Xavier, I have manually edited the original Polycom price list to prepare it for (monthly) export to .csv. I am no expert at Excel, and i have assumed what has taken much manual cut and pasting, can be achieved either by VB or scripting (not sure what approach is preferable). The original May Polycom price list and the manually modified spreadsheet are both attached here. If i have it correct, i will employ an Excel expert to created the necessary conversion code. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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: 86293 - Thank you received: 14271 - - 12 years 4 months ago [\#161345](#161345) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161345 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* There are no attachments on your message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161397](#161397) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161397 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* This is the original Polycom price list (unmodified) This is the same price list with a page of the same list I have modified (prior to changing to .csv format) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161400](#161400) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161400 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* having trouble attaching files..Cant see why, Trying just the modified version Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161468](#161468) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161468 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hmm, Trying again to attach Source (unmodified) and Target (manually modified ) versions of the Polycom price list. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161469](#161469) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161469 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* My apologies, I forgot to zip these spreadsheets in .xls; *This attachment is hidden for guests. Please log in or register to see it.* *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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: 86293 - Thank you received: 14271 - - 12 years 4 months ago [\#161476](#161476) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161476 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* You're almost there with your manually edited CSV. For the column names, you need to use the ones from HikaShop. So Category should actually be parent_category, child category should be categories, long description should be product_description RRP should be price_value and product id should be product_code Also, for the price, you need to remove the $. And finally for the last product, the grandchild category should actually be in the child category column and the child category should be in the category column. To simplify the categories, the best is to pre created your categories via the interface of HikaShop and then just specify the direct category of the product in the "categories" column. That should be simplify your script for generating the CSV file in the correct format. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161644](#161644) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161644 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi, I have made the recommended changes, but feel there is still an issue with what I labelled as "grandchild" category. To explain, throughout the entire Polycom price list there are 3 levels of category. In that price list (see attached) all categories are placed in column A The highest level can be identified by the fact it is all in upper case. (e.g. REALPRESENCE ROOM) The second level is identified by have a grey background (e.g. HDX Executive Collection Stand Systems) The third level can be identified by the fact it has no formatting (e.g. Polycom Branded Services) *This attachment is hidden for guests. Please log in or register to see it.* Therefore in the Manually Modified v02 (see attached) I have labelled them; parent_category (example REALPRESENCE ROOM) categories (example HDX Executive Collection Stand Systems) child_category (example Polycom Branded Services) *This attachment is hidden for guests. Please log in or register to see it.* Is this correct and ready for conversion to .csv for HikaShop? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161646](#161646) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161646 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* here again is the 2nd Manually Modified V02 *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161647](#161647) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161647 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hmm something wrong here after attaching the properties show a 0 file size for Manually Modified v02 zipped - since the zipped file is only 22 bytes - might be too small? I have placed it here in my Dropbox account in both .xls and zip formats. [ db.tt/pTJNmyB2](https://db.tt/pTJNmyB2) [ db.tt/mGYrAejj](https://db.tt/mGYrAejj) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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: 86293 - Thank you received: 14271 - - 12 years 4 months ago [\#161687](#161687) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161687 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi, Here is the file I would recommend: *This attachment is hidden for guests. Please log in or register to see it.* As you can see, I left only the categories column for the categories. This assumes that you already have the categories created via the menu Products>Categories. I've also fixed the product_description column name. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")** - [![CNXTim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30341.jpg)](/forum/user/30341-cnxtim "View CNXTim's Profile") Topic Author - [ Offline](/forum/user/30341-cnxtim) Less More - Posts: 27 - Thank you received: 0 - - - [](http://esolsea.com) - 12 years 4 months ago [\#161693](#161693) by [CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile") Replied by *[CNXTim](/forum/user/30341-cnxtim "View CNXTim's Profile")* on topic *[How to prepare an Excel file for import](/forum/37-import-export-csv-xls/868536-how-to-prepare-an-excel-file-for-import#161693 "-- url of the page with the problem -- :http://tbcp.siamwide.com/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.0 -- PHP version -- : 5.4.28 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error_message I am not sure the best way to proceed with this (see attached Excel Price List from Polycom) But it would seem it would be prudent to firstly parse the existing sheet into something more palatable for HikaShop. Any guidance here would be gratefully received. I am no programmer but reasonably competent in Excel...")* Hi Nicolas, Thnaks for that, it is very much appreciated. However i am still not sure all is OK. In the case of the category; Polycom Branded Services This is a subset or child category of; Service - HDX Executive Collection Which in turn is a subset or child category of HDX Executive Collection Stand Systems This pattern is repeated throughout the entire Polycom Price List As the price list is over 2,000 line items it is important that we can by programming, automate the monthly updates as they arrive from Polycom. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Njg1MzYtaG93LXRvLXByZXBhcmUtYW4tZXhjZWwtZmlsZS1mb3ItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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.161 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)