[Skip to main content](#vessel-content) # CSV export error notice / Import problems ## - **[dforrest](/forum/user/2297-dforrest "View dforrest's Profile")** - [![dforrest's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2297-dforrest "View dforrest's Profile") Topic Author - [ Offline](/forum/user/2297-dforrest) Less More - Posts: 56 - Thank you received: 0 - - 14 years 1 day ago - 14 years 1 day ago [\#72387](#72387) by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") *[CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72387 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...")* was created by *[dforrest](/forum/user/2297-dforrest "View dforrest's Profile")* In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect this may have something to do with import problems I'm having. (I will create a separate thread re my import problems just to keep things clear.) The errors come out in the product_id column of the file and are as follows: Code: <br /> <b>Notice</b>: Undefined index: 0 in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Trying to get property of non-object in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Undefined index: 0 in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Trying to get property of non-object in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Undefined index: 0 in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Trying to get property of non-object in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Undefined index: 0 in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> <br /> <b>Notice</b>: Trying to get property of non-object in <b>/home/sites/urdapilleta.eu/public_html/administrator/components/com_hikashop/views/product/tmpl/export.php</b> on line <b>74</b><br /> Since they all have to do with the same line of code in the export.php file I thought I would investigate even though I don't know PHP. Here are lines 71-74, so the one of interest is the last one: Code: if(!empty($this->products)){ foreach($this->products as $k => $product){ if($product->product_type=="variant"){ $this->products[$k]->product_parent_id = str_replace('"','""',$this->products[$product->product_parent_id]->product_code); I suppose I should fix this but don't know how... suggestions? I imagine this may have something to do with import problems I am having now. I took an exported CSV file, modified some values like prices, etc. and am now trying to upload it again and it is not having the desired effect. More details in the other thread I will create shortly. Thanks for any suggestions re this. --- HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site Last edit: 14 years 1 day ago by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile"). Reason: put in code tags Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MjM4Ny1jc3YtZXhwb3J0LWVycm9yLW5vdGljZS1pbXBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) 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: 86292 - Thank you received: 14270 - - 13 years 11 months ago [\#72710](#72710) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72710 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...")* That's because you have variants without main product associated in the database. That should normally not be possible when using the interface to add your products but would be possible if you don't import valid CSVs and screw the products/variants data in the database. To remove the notices, you can add a @ just before that code: $this->products[$product->product_parent_id]->product_code The following user(s) said Thank You: [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MjM4Ny1jc3YtZXhwb3J0LWVycm9yLW5vdGljZS1pbXBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dforrest](/forum/user/2297-dforrest "View dforrest's Profile")** - [![dforrest's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2297-dforrest "View dforrest's Profile") Topic Author - [ Offline](/forum/user/2297-dforrest) Less More - Posts: 56 - Thank you received: 0 - - 13 years 11 months ago [\#72861](#72861) by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") Replied by *[dforrest](/forum/user/2297-dforrest "View dforrest's Profile")* on topic *[Re: CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72861 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...")* Hi Nicolas, Thanks for this advice. Precisely a problem I've had on importing is that some variants become unlinked from their product. Or only partically linked (see my CSV import problems thread). I've turned off the visible error by just setting System Error Reporting to default. Which columns do I need to look at carefully and match up to make sure the products and their variants stay linked? I thought I was doing this correctly but maybe not. :S --- HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MjM4Ny1jc3YtZXhwb3J0LWVycm9yLW5vdGljZS1pbXBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) 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: 86292 - Thank you received: 14270 - - 13 years 11 months ago [\#73210](#73210) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#73210 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...")* Hi, you should look at the columns product_type (which must contain the type either main or variant), the characteristic(s) column(s) (which has to be filled for each variants and the main product for the default values), the product_code (which must be unique) and the product_parent_id (which moust contain the product code of the main product for the variante). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MjM4Ny1jc3YtZXhwb3J0LWVycm9yLW5vdGljZS1pbXBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[espcctv](/forum/user/746-espcctv "View espcctv's Profile")** - [![espcctv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/746-espcctv "View espcctv's Profile") - [ Offline](/forum/user/746-espcctv) Less More - Posts: 1 - Thank you received: 0 - - 13 years 10 months ago - 13 years 10 months ago [\#81467](#81467) by [espcctv](/forum/user/746-espcctv "View espcctv's Profile") Replied by *[espcctv](/forum/user/746-espcctv "View espcctv's Profile")* on topic *[CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#81467 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...")* Thank you Last edit: 13 years 10 months ago by [espcctv](/forum/user/746-espcctv "View espcctv's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MjM4Ny1jc3YtZXhwb3J0LWVycm9yLW5vdGljZS1pbXBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) 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.203 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)