Questions about export and import of products

-- url of the page with the problem -- : www.mateplas.com.br
-- HikaShop version -- : 3.0.3
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.3.10

For example:
if I export my products and want them matter to another site that uses hikashop, I have to recreate the categories and backup the images?
Can you provide me a manual that shows step by step?

Hi,

You have to go in the menu Products > Products, then click on "export" button in the toolbar.
Then on the new website go in Products > Import and import the CSV file.

For the images, you have to copy them from the folder "media\com_hikashop\upload" and paste them in the same folder on the new website.

and categories?
recreate it automatically or will I have to recreate?

Hi,

The export will handle the name and image of the categories and their structure, but not all their fields (meta description, description, alias, canonical URL, etc).
If you don't use them, then you'll be good. Otherwise, with the CSV export/import, you'll get your category structure with the names and images, but you'll have to enter the other information manually.

Alternatively, you can go in the hikashop_category table of your database, export its content and import it in your new website's phpmyadmin database after installing hikashop and you'll get you're category structure.

Of course, you still need to copy the image files from the media/com_hikashop/upload folder of the old website to the new.

OK!
I did back up!
But how do I backup the wishlist?

Hi,

You want to export/import the tables hikashop_user, hikashop_cart and hikashop_cart_product from your old phpmyadmin to the new one.
Note that for that to work, you want to make sure that the ids of your joomla users between your old and new website are still the same when you migrate them.

I did exactly as told me in the last post.
I back up the tables: hikashop_user, hikashop_cart and hikashop_cart_product.

But it did not work! When we click wishlist does not show the old site lists.

Can you help me?

mateplas.com.br/novo/index.php/lista

Did you make sure that the ids of the Joomla users are still the same between the old website and the new website ?
Otherwise, the users in HikaShop won't be linked to the corresponding users in Joomla and it won't work.

But are the wishlist that are not working!
Há outra coisa, eu não posso importar para o novo site da mesa responsável pela Users.sql dos usuários ", but the other tables I copied successfully!
I'll get you the username and password of the administration!

Hi,

We know that it's the wishlists that are not working, but the wishlists are linked on the Joomla user ID, so you need to have correct correspondance between the HikaShop user ids and the Joomla ones.

Could you detail your second issue ? I don't understand the google translation of your sentence.

Probably is not working because I can not import the "Users.sql" table.
This table contains all Joomla users and Hikashop registered.
I believe that if i can import the "User.sql" table to the new site, the wishlist will normally appear!
I need help!

Hello,

I believe that if i can import the "User.sql" table to the new site, the wishlist will normally appear!

Note that Hikashop use Joomla users so if your issue is with the importation of users, you'll just have to import your Joomla users and you'll be able to use them with Hikashop.

So!
It is just that!
But I can not do the import, is giving error!
Would if I give you the access to my MySQL database, you could help me solve the problem?

Hi,

Unfortunately, the import/export of Joomla users is not something which we can handle here.
Either hire someone to help you, or ask the Joomla community on forum.joomla.org, or use a user export/import extension for Joomla, which can handle that automatically for you.

Hi
"The export will handle the name and image of the categories and their structure, but not all their fields (meta description, description, alias, canonical URL, etc)"...
So how transfert all data using Joomla ?
Does mass action is the way to go to transfert the others fields not manage by hikashop export import ?

regard's

@lionel75 if you need to import all the products data, even the one not handled by the export tools in HikaShop, then you would have to export the tables in your database.

But precisely this is what I did!
I copied the hikashop Tables shown.
Also, I'm trying to copy "user.sql" table, but it is giving error when importing to the new site!
I need help to import this table, without it the wishlist does not work!

The export/import of the user table of Joomla via phpmyadmin might not work if you're doing it for two different versions of joomla.
That's why I recommended in my previous answer to you to use an extension specialized in that instead of doing it manually.

Perhaps some clue ?
Rather than be technical or low level ; there is wonderfull extension in joomla jed call J2XML.

--Easy way (recommended) ---
J2XML support 2 ways to "transfert data" ( user is supported) .
You need to have you current website available (call it A running) and the new one already install and available (call it B runniing). The Component and Plugin must be install and enable on both joomla website .
1 way
in A go to user manager panel a new icon call export appear , select user , export data
in B Go to component whaever item , you ll see an icon call " import" ....
2 way
in A configure server B ( ip protocol admin name/ password ) J2XML -> website manager
in A goto user manager then ccik on the icon call Send , select the server B you configure .
All the review in jed are excellent , it ll avoid waste your time and money .
extensions.joomla.org/extensions/migrati...mport-a-export/12816

--Technical way : some clue ----
Do you use same php version same mysql version ?
Does the issues is in changelog or forum of mysql / phpmyadmin joomla ?
Does the format table change in mysql using phpadmin ( type , lenght name ) ?
Does some extra information in the sql file ( filename.sql) block the import ?
Does the file content ( in casse of filename.csv) separator encoding is right ?
Does the file you import export contain definiton of structure OR Data or Both ?
Did you succeed re import the data in the same table after delete the original data ?
Do you have right to import data in the server ?
Export one item user from origin and target server and compare the content .
Study them to see if there is difference ?
Is there a limitation about the size of data during import export ?
Try export one item and then import this file with one item in the new table !
Use a mysql GUI Tool like Heidi SQL or what you want ( pay one can be use for limited time)
Does the ENCODING UTF-8 UTF-16 is the same in mysql during export ?
...write what ever you want ...no rocket science here ... try test any cases you think
.. use google instead All the inefficient search input form locate in website many website !!!

Hope this help you , very simple usefull try and Do it !!