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?

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

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

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!

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
"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

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!

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 !!