[Skip to main content](#vessel-content) # problem exporting 0 as first number from product ## - **[mici](/forum/user/33257-mici "View mici's Profile")** - [![mici's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33257-mici "View mici's Profile") Topic Author - [ Offline](/forum/user/33257-mici) Less More - Posts: 16 - Thank you received: 0 - - 11 years 8 months ago [\#191645](#191645) by [mici](/forum/user/33257-mici "View mici's Profile") *[problem exporting 0 as first number from product](/forum/37-import-export-csv-xls/875148-problem-exporting-0-as-first-number-from-product#191645 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 Dear all, I have a custom filed = catalog number. Field type = Text. When exporting the .csv file the catalog numbers of the products won't show the zero number when it is in the first number (for example catalog number 0100 = 100). This happens as-well when we use the code filed it won't show the zero number when it is in the first number (for example code 0100 = 100). Please advice, M")* was created by *[mici](/forum/user/33257-mici "View mici's Profile")* -- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 Dear all, I have a custom filed = catalog number. Field type = Text. When exporting the .csv file the catalog numbers of the products won't show the zero number when it is in the first number (for example catalog number 0100 = 100). This happens as-well when we use the code filed it won't show the zero number when it is in the first number (for example code 0100 = 100). Please advice, M Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzUxNDgtcHJvYmxlbS1leHBvcnRpbmctMC1hcy1maXJzdC1udW1iZXItZnJvbS1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) 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 - - 11 years 8 months ago [\#191655](#191655) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[problem exporting 0 as first number from product](/forum/37-import-export-csv-xls/875148-problem-exporting-0-as-first-number-from-product#191655 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 Dear all, I have a custom filed = catalog number. Field type = Text. When exporting the .csv file the catalog numbers of the products won't show the zero number when it is in the first number (for example catalog number 0100 = 100). This happens as-well when we use the code filed it won't show the zero number when it is in the first number (for example code 0100 = 100). Please advice, M")* Hi, I did a test on my end but I'm not able to reproduce the problem. Are you sure that it doesn't come from your CSV editor software which converts the numbers automatically when it opens the CSV file ? If you open the CSV with Notepad++, do you see the numbers like you would expect ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzUxNDgtcHJvYmxlbS1leHBvcnRpbmctMC1hcy1maXJzdC1udW1iZXItZnJvbS1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mici](/forum/user/33257-mici "View mici's Profile")** - [![mici's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33257-mici "View mici's Profile") Topic Author - [ Offline](/forum/user/33257-mici) Less More - Posts: 16 - Thank you received: 0 - - 11 years 8 months ago [\#191952](#191952) by [mici](/forum/user/33257-mici "View mici's Profile") Replied by *[mici](/forum/user/33257-mici "View mici's Profile")* on topic *[problem exporting 0 as first number from product](/forum/37-import-export-csv-xls/875148-problem-exporting-0-as-first-number-from-product#191952 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 Dear all, I have a custom filed = catalog number. Field type = Text. When exporting the .csv file the catalog numbers of the products won't show the zero number when it is in the first number (for example catalog number 0100 = 100). This happens as-well when we use the code filed it won't show the zero number when it is in the first number (for example code 0100 = 100). Please advice, M")* Hi True, Notepad++ does open the csv with 0 in the begining but it does not save csv format and therfore have no use for me. I need to update my HIKASHOP oroducts from a diferent program that produces eather excel or ASCII formats and i have many products that starts with -0-. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzUxNDgtcHJvYmxlbS1leHBvcnRpbmctMC1hcy1maXJzdC1udW1iZXItZnJvbS1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) 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) - 11 years 8 months ago [\#191962](#191962) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[problem exporting 0 as first number from product](/forum/37-import-export-csv-xls/875148-problem-exporting-0-as-first-number-from-product#191962 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 Dear all, I have a custom filed = catalog number. Field type = Text. When exporting the .csv file the catalog numbers of the products won't show the zero number when it is in the first number (for example catalog number 0100 = 100). This happens as-well when we use the code filed it won't show the zero number when it is in the first number (for example code 0100 = 100). Please advice, M")* Hi, I think that the csv editor can be set up to handle the entries starting by "0". Or you can potentially try to use libreoffice or openoffice and see if they manage that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzUxNDgtcHJvYmxlbS1leHBvcnRpbmctMC1hcy1maXJzdC1udW1iZXItZnJvbS1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) 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.241 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)