move HikaShop from website to another one

  • Posts: 281
  • Thank you received: 3
6 years 7 months ago #290865

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

  • Posts: 281
  • Thank you received: 3
6 years 7 months ago #290892

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.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
6 years 7 months ago #290872

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.

  • Posts: 281
  • Thank you received: 3
6 years 7 months ago #290926

I did what you sayd but when I check the database the result list was:

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.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
6 years 7 months ago #290932

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.

  • Posts: 281
  • Thank you received: 3
6 years 7 months ago #291007

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

Attachments:

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

  • Posts: 281
  • Thank you received: 3
6 years 7 months ago #291009

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.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
6 years 7 months ago #291094

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.075 seconds
Powered by Kunena Forum