Skip to main content

move HikaShop from website to another one

More
8 years 6 months ago #290865 by francota
move HikaShop from website to another one was created by francota
-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5

Hello
My question is if it is possible move from a website to an other one everything reguarding hikashop, product, order,configuration.
The sorce website is with joomla 3.6.6 and HikaShop Essential 2.6.4, the destintation is joomla 3.8.6 and HikaShop Business 3.4.0.

Thanks Frank

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

More
8 years 6 months ago #290892 by francota
Replied by francota on topic move HikaShop from website to another one
Hello
I found this old topic on this forum:
www.hikashop.com/forum/import-export-csv...uct-to-new-site.html
So I exported these tables and imported:
hikashop_product,
hikashop_product_related,
hikashop_product_category,
hikashop_category,
hikashop_price,
hikashop_file,
hikashop_variant,
hikashop_characteristic,
hikashop_field.

But I didn't have any effect :dry:

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

More
8 years 6 months ago #290872 by nicolas
Replied by nicolas on topic move HikaShop from website to another one
Hi,

Yes. You need to export/import all the tables with hikashop_* in your phpmyadmin (you might have to change the prefix of the tables if you don't use the same ones on both websites) after deleting them from your new website database.
Then, you want to click on the "check database" button of the Hikashop configuration so that it can add all the missing columns and tables from HikaShop 2.6.4 to HikaShop 3.4.0.
You also want to copy the files in media/com_hikashop/upload/ and images/com_hikashop/upload/ from your old websit to your new website via FTP.
You shoudl then be all good.

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

More
8 years 6 months ago #290926 by francota
Replied by francota on topic move HikaShop from website to another one
I did what you sayd but when I check the database the result list was:
Code:
Info Could not load columns from the table "hikashop_orderstatus" : Table 'Sql1024141_4.#__hikashop_orderstatus' doesn't exist OK Problem solved - table "hikashop_orderstatus" created Info Could not load columns from the table "hikashop_email_log" : Table 'Sql1024141_4.#__hikashop_email_log' doesn't exist OK Problem solved - table "hikashop_email_log" created Info Field "address_type" missing in hikashop_address OK Field "address_type" added in the table "hikashop_address" OK Table "hikashop_badge" checked OK Table "hikashop_banner" checked Info Field "cart_currency_id" missing in hikashop_cart OK Field "cart_currency_id" added in the table "hikashop_cart" Info Field "cart_payment_id" missing in hikashop_cart OK Field "cart_payment_id" added in the table "hikashop_cart" Info Field "cart_shipping_ids" missing in hikashop_cart OK Field "cart_shipping_ids" added in the table "hikashop_cart" Info Field "cart_billing_address_id" missing in hikashop_cart OK Field "cart_billing_address_id" added in the table "hikashop_cart" Info Field "cart_shipping_address_ids" missing in hikashop_cart OK Field "cart_shipping_address_ids" added in the table "hikashop_cart" Info Field "cart_fields" missing in hikashop_cart OK Field "cart_fields" added in the table "hikashop_cart" Info Field "cart_ip" missing in hikashop_cart OK Field "cart_ip" added in the table "hikashop_cart" Info Field "cart_product_wishlist_product_id" missing in hikashop_cart_product OK Field "cart_product_wishlist_product_id" added in the table "hikashop_cart_product" OK Table "hikashop_category" checked OK Table "hikashop_characteristic" checked OK Table "hikashop_click" checked OK Table "hikashop_config" checked OK Table "hikashop_currency" checked Info Field "discount_user_id" missing in hikashop_discount OK Field "discount_user_id" added in the table "hikashop_discount" Info Field "discount_tax" missing in hikashop_discount OK Field "discount_tax" added in the table "hikashop_discount" Info Field "discount_shipping_percent" missing in hikashop_discount OK Field "discount_shipping_percent" added in the table "hikashop_discount" OK Table "hikashop_download" checked OK Table "hikashop_entry" checked OK Table "hikashop_field" checked OK Table "hikashop_file" checked OK Table "hikashop_filter" checked OK Table "hikashop_geolocation" checked OK Table "hikashop_history" checked OK Table "hikashop_limit" checked OK Table "hikashop_massaction" checked Info Field "order_lang" missing in hikashop_order OK Field "order_lang" added in the table "hikashop_order" Info Field "order_token" missing in hikashop_order OK Field "order_token" added in the table "hikashop_order" OK Table "hikashop_orderstatus" checked Info Field "order_product_status" missing in hikashop_order_product OK Field "order_product_status" added in the table "hikashop_order_product" Info Field "order_product_wishlist_product_id" missing in hikashop_order_product OK Field "order_product_wishlist_product_id" added in the table "hikashop_order_product" OK Table "hikashop_payment" checked Info Field "price_users" missing in hikashop_price OK Field "price_users" added in the table "hikashop_price" Info Field "price_start_date" missing in hikashop_price OK Field "price_start_date" added in the table "hikashop_price" Info Field "price_end_date" missing in hikashop_price OK Field "price_end_date" added in the table "hikashop_price" Info Field "product_sort_price" missing in hikashop_product OK Field "product_sort_price" added in the table "hikashop_product" Info Field "product_description_raw" missing in hikashop_product OK Field "product_description_raw" added in the table "hikashop_product" Info Field "product_description_type" missing in hikashop_product OK Field "product_description_type" added in the table "hikashop_product" Info Field "product_option_method" missing in hikashop_product OK Field "product_option_method" added in the table "hikashop_product" Info Field "product_condition" missing in hikashop_product OK Field "product_condition" added in the table "hikashop_product" OK Table "hikashop_product_category" checked Info Field "product_related_quantity" missing in hikashop_product_related OK Field "product_related_quantity" added in the table "hikashop_product_related" OK Table "hikashop_plugin" checked OK Table "hikashop_shipping" checked OK Table "hikashop_shipping_price" checked OK Table "hikashop_tax" checked OK Table "hikashop_taxation" checked OK Table "hikashop_user" checked OK Table "hikashop_variant" checked OK Table "hikashop_vote" checked OK Table "hikashop_vote_user" checked Info Field "language" missing in hikashop_waitlist OK Field "language" added in the table "hikashop_waitlist" OK Table "hikashop_widget" checked OK Table "hikashop_zone" checked OK Table "hikashop_zone_link" checked OK Table "hikashop_warehouse" checked OK Table "hikashop_email_log" checked Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.65.171' at line 1 Error hikashop_vote_user: Duplicate entry '11-151.26.65.171' for key 'PRIMARY' Error ALTER TABLE #__hikashop_vote_user ADD PRIMARY KEY(vote_user_id,vote_user_user_id) OK Product categories checked OK Variants orphan links cleaned OK Order statuses imported OK Joomla users synchronized OK User email addresses synchronized

DO you see any problem in that??
Thanks
FRank

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

More
8 years 6 months ago #290932 by nicolas
Replied by nicolas on topic move HikaShop from website to another one
Hi,

No, that's all ok. The error with the vote_user table can be ignored.

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

More
8 years 5 months ago #291007 by francota
Replied by francota on topic move HikaShop from website to another one
Hello

why in the new web site,after have done all what you suggested, I still have in documentation tab this "You have the latest stable version of HikaShop Essential: 3.4.0".
I mean the number version is correct but why essential and not business??

Thanks
Frank

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

More
8 years 5 months ago #291009 by francota
Replied by francota on topic move HikaShop from website to another one
And I just saw that something in configuration of Hika is disabled couse "it is only for HikaShop Business"
Maybe I should update hikashop with business packet as new installation??

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

More
8 years 5 months ago #291094 by Jerome
Replied by Jerome on topic move HikaShop from website to another one
Hello,

As Nicolas explained ; you should use the exact same package in the two websites.
Same packages means the same version number but also the same edition of HikaShop.
Because, if you migrate an HikaShop Essential on an HikaShop Business ; the Business feature will be deactivated when copying the database.

Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

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

Time to create page: 0.183 seconds
Powered by Kunena Forum