[Skip to main content](#vessel-content) # Sample Data ## - **[ag0g0girl](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile")** - [![ag0g0girl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile") Topic Author - [ Offline](/forum/user/5739-ag0g0girl) Less More - Posts: 7 - Thank you received: 0 - - 14 years 9 months ago [\#36554](#36554) by [ag0g0girl](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile") *[Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#36554 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* was created by *[ag0g0girl](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile")* I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! #### *This attachment is hidden for guests. Please log in or register to see it.* [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_Shot_2012_01_24_at_5.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_Shot_2012_01_24_at_5.png "[img") - [ ![Screen_Shot_2012_01_24_at_5.png](/forum/attachment/2491) ](/forum/attachment/2491 "...01_24_at_5.png") [ ](/forum/attachment/2491?download=1 "...01_24_at_5.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 9 months ago [\#36593](#36593) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#36593 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Your data sample is probably too old. Here is a new export of the demo website hikashop tables. You should use this one. #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ag0g0girl](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile")** - [![ag0g0girl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile") Topic Author - [ Offline](/forum/user/5739-ag0g0girl) Less More - Posts: 7 - Thank you received: 0 - - 14 years 9 months ago [\#36599](#36599) by [ag0g0girl](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile") Replied by *[ag0g0girl](/forum/user/5739-ag0g0girl "View ag0g0girl's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#36599 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Works good! For database newbies: The newer Joomla have random prefixes for the tables in the databse. Not all table names begin with jos_ anymore. Occasionally importing the file in PHPadmin gives a primary key error. Today I got some wierd message about needing to be SuperAdmin. Whatever. So I edit the file with Text Wrangler to find and replace in the file for the table name prefixes to match my 1.7 joomla tables that hika installed for the component itself. I changed the name of the file to match the prefix of my database, and all was good. I have cpanel on Linus server, so I could just did a restore from backup in the backup part of my cpanel, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#50985](#50985) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50985 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Just got this error when trying to import into database. Can you advise on how to fix. SQL query: -- -- テーブルのデータをダンプしています `aq1_hikashop_category` -- INSERT INTO `aq1_hikashop_category` (`category_id`, `category_parent_id`, `category_type`, `category_name`, `category_description`, `category_published`, `category_ordering`, `category_left`, `category_right`, `category_depth`, `category_namekey`, `category_created`, `category_modified`, `category_access`, `category_menu`, `category_keywords`, `category_meta_description`) VALUES (1, 0, 'root', 'ROOT', '', 0, 0, 1, 56, 0, 'root', 0, 0, 'all', 0, '', ''), (2, 1, 'product', 'product category', '', 1, 1, 2, 31, 1, 'product', 0, 1307798875, 'all', 0, '', ''), (3, 1, 'tax', 'taxation category', '', 1, 2, 32, 37, 1, 'tax', 0, 0, 'all', 0, '', ''), (4, 1, 'status', 'order status', '', 1, 3, 38, 49, 1, 'status', 0, 0, 'all', 0, '', ''), (5, 4, 'status', 'created', 'When a customer finishes a checkout, an order is created with the status created', 1, 1, 39, 40, 2, 'created', 0, 0, 'all', 0, '', ''), (6, 4, 's[...] MySQL said: \#1062 - Duplicate entry '1' for key 1 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 5 months ago [\#50991](#50991) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50991 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* That's an old package. Please try again. I've updated it with the latest version of the data. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#50992](#50992) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50992 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Thank you - but where is the latest data stored? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 5 months ago [\#50994](#50994) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50994 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* It's the same link. I've just replaced the file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#50995](#50995) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50995 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* so how do I get rid of the old data Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#50996](#50996) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50996 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* JUST GOT ANOTHER ERROR WITH THE NEW FILE Error SQL query: -- -- テーブルのデータをダンプしています `aq1_hikashop_cart_product` -- INSERT IGNORE INTO `aq1_hikashop_cart_product` ( `cart_product_id` , `cart_id` , `product_id` , `cart_product_quantity` , `cart_product_parent_id` , `cart_product_modified` , `cart_product_option_parent_id` , `test` , `amount` ) VALUES ( 265, 93, 192, 1, 0, 1336100480, 0, NULL , NULL ) , ( 264, 92, 10, 1, 0, 1336015093, 0, NULL , NULL ) , ( 266, 93, 214, 1, 0, 1337377208, 0, NULL , '50' ) , ( 267, 94, 192, 1, 0, 1337623428, 0, NULL , NULL ) , ( 268, 95, 58, 1, 0, 1337623559, 0, NULL , NULL ) ; MySQL said: Documentation \#1054 - Unknown column 'test' in 'field list' Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 5 months ago [\#50998](#50998) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#50998 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* You will have to delete the hikashop tables in the database before importing the file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#51002](#51002) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51002 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* I uninstalled Hikashop - deleted all tables - reinstalled Hikashop - went to imported .... Got the following error. Error SQL query: -- -- テーブルのデータをダンプしています `aq1_hikashop_cart_product` -- INSERT IGNORE INTO `aq1_hikashop_cart_product` ( `cart_product_id` , `cart_id` , `product_id` , `cart_product_quantity` , `cart_product_parent_id` , `cart_product_modified` , `cart_product_option_parent_id` , `test` , `amount` ) VALUES ( 265, 93, 192, 1, 0, 1336100480, 0, NULL , NULL ) , ( 264, 92, 10, 1, 0, 1336015093, 0, NULL , NULL ) , ( 266, 93, 214, 1, 0, 1337377208, 0, NULL , '50' ) , ( 267, 94, 192, 1, 0, 1337623428, 0, NULL , NULL ) , ( 268, 95, 58, 1, 0, 1337623559, 0, NULL , NULL ) ; MySQL said: Documentation \#1054 - Unknown column 'test' in 'field list' Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 5 months ago [\#51004](#51004) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51004 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Of course. Do like that: deleted all hikashop tables -> import Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#51006](#51006) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51006 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Nicholas - you don't understand - I DID IT ALREADY - and got the error shown above Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 5 months ago [\#51008](#51008) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51008 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* That's not possible. The table definition is included in the SQL file. If you get that error, it means that you still have that table in the database before the import and thus, the table from the demo website cannot be created. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#51016](#51016) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51016 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Well not really - Step 1 - uninstall hikashop Step 2 - delete tables Step 3 - reinstall hikashop .... at this point the table will have been recreated. Or do I just delete tables without touching the Hikashop component install. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")** - [![sydneyartschool's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") - [ Offline](/forum/user/5329-sydneyartschool) Less More - Posts: 14 - Thank you received: 0 - - 14 years 5 months ago [\#51017](#51017) by [sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile") Replied by *[sydneyartschool](/forum/user/5329-sydneyartschool "View sydneyartschool's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51017 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Ok just deleted the db without uninstalling hika. data imported except Products have no images. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 5 months ago [\#51108](#51108) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#51108 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* Yes, the images are saved in the media/com_hikashop/upload folder, not in the database. You would have to download them directly on our demo website and upload them on your website. For example: [ demo.hikashop.com/media/com\_hikashop/upl...tolia\_20227750\_s.jpg](http://demo.hikashop.com/media/com_hikashop/upload/fotolia_20227750_s.jpg) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dineva](/forum/user/8235-dineva "View dineva's Profile")** - [![dineva's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8235-dineva "View dineva's Profile") - [ Offline](/forum/user/8235-dineva) Less More - Posts: 3 - Thank you received: 0 - - 14 years 3 months ago [\#57772](#57772) by [dineva](/forum/user/8235-dineva "View dineva's Profile") Replied by *[dineva](/forum/user/8235-dineva "View dineva's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#57772 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* I tried to add products ... But it shows ERROR Warning: include_once(/home/dubota/public_html/new/administrator/components/com_hikashop/types/acl.php) [function.include-once]: failed to open stream: No such file or directory in /home/dubota/public_html/new/administrator/components/com_hikashop/helpers/helper.php on line 783 Warning: include_once() [function.include]: Failed opening '/home/dubota/public_html/new/administrator/components/com_hikashop/types/acl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dubota/public_html/new/administrator/components/com_hikashop/helpers/helper.php on line 783 Fatal error: Call to a member function display() on a non-object in /home/dubota/public_html/new/administrator/components/com_hikashop/views/product/tmpl/common.php on line 119 Also check the IMage - [ ![hikasss.JPG](/forum/attachment/4816) ](/forum/attachment/4816 "hikasss.JPG") [ ](/forum/attachment/4816?download=1 "hikasss.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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: 86292 - Thank you received: 14271 - - 14 years 3 months ago [\#57774](#57774) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sample Data](/forum/2-general-talk-about-hikashop/36554-sample-data#57774 "I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up? I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like. Thank You Guys! [file]")* You are missing some of the files of HikaShop. You must have had a problem during the installation. Please try to install again and report any error you might have. If all goes well, please try again to add products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM2NTU0LXNhbXBsZS1kYXRhP3RtcGw9bWFya2Rvd24=) 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.485 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)