[Skip to main content](#vessel-content) # Exported database has 124 rows of errors ## - **[LordSatori](/forum/user/2933-lordsatori "View LordSatori's Profile")** - [![LordSatori's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2933-lordsatori "View LordSatori's Profile") Topic Author - [ Offline](/forum/user/2933-lordsatori) Less More - Posts: 25 - Thank you received: 0 - - 15 years 3 months ago [\#22531](#22531) by [LordSatori](/forum/user/2933-lordsatori "View LordSatori's Profile") *[Exported database has 124 rows of errors](/forum/3-bug-report/22531-exported-database-has-124-rows-of-errors#22531 "Joomla 1.7.0 Hikashop 1.5.3 Added a tax category and figured be quicker to export my Hika product db and put the data in there then import it then go though item by item. Exported the database and inserted in the first 124 rows is the following: Notice: Undefined property: stdClass::$category_ordering in /home/content/86/7988486/html/ts16/administrator/components/com_hikashop/classes/product.php on line 254 the normal database starts at row 125 and only about half of my products are in the table.")* was created by *[LordSatori](/forum/user/2933-lordsatori "View LordSatori's Profile")* Joomla 1.7.0 Hikashop 1.5.3 Added a tax category and figured be quicker to export my Hika product db and put the data in there then import it then go though item by item. Exported the database and inserted in the first 124 rows is the following: <b>Notice</b>: Undefined property: stdClass::$category_ordering in <b>/home/content/86/7988486/html/ts16/administrator/components/com_hikashop/classes/product.php</b> on line <b>254</b><br /> the normal database starts at row 125 and only about half of my products are in the table. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMjUzMS1leHBvcnRlZC1kYXRhYmFzZS1oYXMtMTI0LXJvd3Mtb2YtZXJyb3JzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 3 months ago [\#22540](#22540) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exported database has 124 rows of errors](/forum/3-bug-report/22531-exported-database-has-124-rows-of-errors#22540 "Joomla 1.7.0 Hikashop 1.5.3 Added a tax category and figured be quicker to export my Hika product db and put the data in there then import it then go though item by item. Exported the database and inserted in the first 124 rows is the following: Notice: Undefined property: stdClass::$category_ordering in /home/content/86/7988486/html/ts16/administrator/components/com_hikashop/classes/product.php on line 254 the normal database starts at row 125 and only about half of my products are in the table.")* Exporting/importing is not as easy as that yet as there are things that are not exported by the system. For example, the images of categories are not exported. You should export and just import a CSV with two columns: product_tax_id and product_code That way, the system will just update the tax_id and not touch everything else which is already working. That line 254 of that file should be: $all_products[$category->product_id]->categories_ordering[]=$category->ordering; instead of: $all_products[$category->product_id]->categories_ordering[]=$category->category_ordering; We'll change that on our end. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMjUzMS1leHBvcnRlZC1kYXRhYmFzZS1oYXMtMTI0LXJvd3Mtb2YtZXJyb3JzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[LordSatori](/forum/user/2933-lordsatori "View LordSatori's Profile")** - [![LordSatori's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2933-lordsatori "View LordSatori's Profile") Topic Author - [ Offline](/forum/user/2933-lordsatori) Less More - Posts: 25 - Thank you received: 0 - - 15 years 3 months ago [\#22685](#22685) by [LordSatori](/forum/user/2933-lordsatori "View LordSatori's Profile") Replied by *[LordSatori](/forum/user/2933-lordsatori "View LordSatori's Profile")* on topic *[Re: Exported database has 124 rows of errors](/forum/3-bug-report/22531-exported-database-has-124-rows-of-errors#22685 "Joomla 1.7.0 Hikashop 1.5.3 Added a tax category and figured be quicker to export my Hika product db and put the data in there then import it then go though item by item. Exported the database and inserted in the first 124 rows is the following: Notice: Undefined property: stdClass::$category_ordering in /home/content/86/7988486/html/ts16/administrator/components/com_hikashop/classes/product.php on line 254 the normal database starts at row 125 and only about half of my products are in the table.")* Up till installing the 08-02-2011 HS build I've never had a problem exporting the table using the export button/icon on the product back end page. Is there a way to change the parameters of that button to only export certain columns? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMjUzMS1leHBvcnRlZC1kYXRhYmFzZS1oYXMtMTI0LXJvd3Mtb2YtZXJyb3JzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 3 months ago [\#22686](#22686) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exported database has 124 rows of errors](/forum/3-bug-report/22531-exported-database-has-124-rows-of-errors#22686 "Joomla 1.7.0 Hikashop 1.5.3 Added a tax category and figured be quicker to export my Hika product db and put the data in there then import it then go though item by item. Exported the database and inserted in the first 124 rows is the following: Notice: Undefined property: stdClass::$category_ordering in /home/content/86/7988486/html/ts16/administrator/components/com_hikashop/classes/product.php on line 254 the normal database starts at row 125 and only about half of my products are in the table.")* You can edit the file export of the view product via the menu Display->Views but the modification is not so easy to do as a lot of things are dynamic like the characteristics, the custom fields, etc. The easiest is to just remove the columns you don't need after opening the CSV in excel. That can be done really easily compared to changing the code in the view file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMjUzMS1leHBvcnRlZC1kYXRhYmFzZS1oYXMtMTI0LXJvd3Mtb2YtZXJyb3JzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.086 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)