Moving hikashop from an old website to a new one

  • Posts: 8
  • Thank you received: 0
8 years 2 months ago #249111

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.45
-- Browser(s) name and version -- : Chrome 52.0.27

I want to migrate my whole HIKASHOP from old website to the new one (Joomla). Here is what I did step by step:

In the old website:
1- I updated Joomla to the latest version.
2- I updated Hikashop to the latest version
3- I exported all the Hikashop tables, as well as Joomla tables: Users, Modules, Menus to an sql file.

In the new website (a new template)
1- I Imported all the tables (without problem)
2- I installed the new hikashop.

I also copied all the files in Media/com-hikashop to the new website via FTP

But when I go to the hikashop I have nothing there. No products, No orders, No users.
I checked the database through hikashop and It says all ok.

I even brows database through phpmyadmin and the data is there. I can see products etc, but Hikashop does not grab them.

Last edit: 8 years 2 months ago by Gholizadeh.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
8 years 2 months ago #249116

Hi,

It's probably because you're using a different table prefix on both websites. So you need to change the prefix of the tables from the old website to use the new website table prefix. Otherwise, the tables from the old website will be ignored.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
8 years 2 months ago #249181

That is correct. The table prefixes are different. What do you suggest I can do? Is it possible to make them identical?

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
8 years 2 months ago #249182

Hi,

Yes. Rename the tables and use the prefixes of your new website. You can do that via phpmyadmin:
my.bluehost.com/cgi/help/2158

The following user(s) said Thank You: Gholizadeh

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
8 years 2 months ago #249273

Thank you very much. I could manage to do that and imported all the tables which look fine now. I installed HIKASHOP in the new website and I can see all the data is available now. However now I have a new problem. Dashboard will not load. Whenever I click to see dashboard or I select Hikashop from the component it starts to load the page but never finishes. Any idea?

UPDATE: Dashboard is now loading with all the data.

1- However I observed that the pictures for products are not being shown.
2- whenever I add a product to the cart it says: Message / The cart is empty

Last edit: 8 years 2 months ago by Gholizadeh. Reason: Update

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
8 years 2 months ago #249277

1. You need to copy the files from the folder images/com_hikashop/upload and media/com_hikashop/upload from your old website to your new website.
2. It looks like a user session issue.
If you try while being logged in, do you have the same problem ?
Or maybe it's a database issue. Try clicking on the "check database" button in the HikaShop configuration and see if that helps.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
8 years 2 months ago #249361

1- I copied all the files from media/com_hikashop/upload from the old website to the new one. I DO NOT HAVE images/com_hikashop/upload folder. It did not work. still no photos.

2- The process in the old website was that first users fill out their baskets then the system ask them to log in. So I do not follow how can I first log in and then fill basket.

Check the database status, ALL OK.

3- Also I realised that things like ordering process stages, or language file has not been imported. Should I setup them again? is it possible and I did miss something.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
8 years 2 months ago #249368

Hi,

1. Check that you're using media/com_hikashop/upload as upload folder in the Files section of the HikaShop configuration. If it's looking for the images in the images/com_hikashop/upload folder, and you put them in media/com_hikashop/upload, it's normal that it can't find them.

3. The language files of HikaShop can be added again easily via the Languages tab of the Hikashop configuration.
I don't see what you mean by "order process stages". If you're talking about the checkout workflow, you can configure it under the "checkout" tab of the HikaShop configuration.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
8 years 2 months ago #249406

Hi

1- SOLVED (thank you).

2- I still have the problem of when selecting products, it won't add them to the cart

3- Some thing new I am noticing is that when I go to dashboard in new website it takes a lot of time to load that page, almost 1 minute and half. That's why originally I though it won't open it at all. However it opens but takes a lot of time. What do you think the reason is?

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
8 years 2 months ago #249412

Hi,

2. You can first login through this page:
Part of the message is hidden for the guests. Please log in or register to see it.

Then,go on your products listing.
It's just to test that it is working. But from your previous message, I had understodd that the "check database" had fixed the problem.

3. Hard to say. Turn on the "debug" mode of the Joomla configuration and try again. Then, look at the MySQL queries debug at the bottom of the page. One of them should be noted as really slow. If you can provide the debug data about that query, we should be able to tell you what's going on.
You can also try to go in the menu Orders>Reports and deactivate the widgets of the dashboard one by one until you find the one causing the slow down.

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum