Import issue from virtuemart 2.0.12b

  • Posts: 73
  • Thank you received: 7
10 years 10 months ago #138412

Hi again,

You did well removing the tables. Next time, it should be enough to just delete all the fields like vm_import_xxxxxxx of your hikashop_config table.
I'm going to do some tests for the order import. Hikashop uses the file yourwebsite/administrator/components/com_virtuemart/virtuemart.cfg.php to locate the virtuemart's images folder, and then proceed to the copy. Can you verify for me the file is still here ?

Tr'istan

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

  • Posts: 73
  • Thank you received: 7
10 years 10 months ago #138415

Nevermind, this file only exists on Virtuemart 1.0.
Can you check your table '#__virtuemart_configs' then, and see if you find fields like 'media_category_path' or 'media_product_path' ?

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

  • Posts: 73
  • Thank you received: 7
10 years 10 months ago #138433

Ok, I've got it.

The order import doesn't work, because of the name of the Virtuemart's status 'Confirmed by shopper'. If you take a look at your table '#_virtuemart_orderstates', you'll see all the order status. Hikashop imports those status, as you can see if you observe the table '#_hikashop_category'. And if you compare the status COM_VIRTUEMART_ORDER_STATUS_CONFIRMED_BY_SHOPPER on the Virtuemart's table with the one imported on Hikashop's table, you'll see a difference : the name has been changed to 'bevestigd'.

I assume you modified it, did you do it manually on the database ? Orders will be imported correctly if you keep the same name as Virtuemart.

Last edit: 10 years 10 months ago by Tristan.

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

  • beertje_007
  • Topic Author
10 years 10 months ago #138437

Hi Tristan,

When i add in hikashop a status com_virtuemart_order_status_confirmed_by_shopper, it changes to bevestigd.
I did not change this manualy. Do you know why this happens?

regards,
roy

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

  • beertje_007
  • Topic Author
10 years 10 months ago #138438

Hi Tristan,

The path is the correct one. I will add the images manualy. No problem.

Thx roy

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

  • beertje_007
  • Topic Author
10 years 10 months ago #138439

beertje_007 wrote: Hi Tristan,

When i add in hikashop a status com_virtuemart_order_status_confirmed_by_shopper, it changes to bevestigd.
I did not change this manualy. Do you know why this happens?

regards,
roy


I added the com_virtuemart_order_status_confirmed_by_shopper status, it changed to bevestigd, but i now have imported the orders correctly. strange..

kind regards,
roy

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

  • Posts: 73
  • Thank you received: 7
10 years 10 months ago #138446

I added the com_virtuemart_order_status_confirmed_by_shopper status, it changed to bevestigd, but i now have imported the orders correctly. strange..

That's actually normal. You had a status on Virtuemart unkown by Hikashop (bevestigd). Now you added it manually to Hikashop, the orders can be imported correctly. I can't figure out why the status is renammed, but if it's good for you, it's good for me.

And for the images, I'll post here a new file until tonight, which should work better. And we'll probably make a new package until monday, if you want to wait a bit more.

The following user(s) said Thank You: beertje_007

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

  • Posts: 73
  • Thank you received: 7
10 years 10 months ago #138449

Here is the file you're waiting for Roy :

File Attachment:

File Name: hd37b19d.txt
File Size:81 KB


I hope everything will work better now, images import included.
Just replace your file yourwebsite/administrator/components/com_hikashop/helpers/importvm.php by the one attached.

Have a nice week end !

Attachments:

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

  • beertje_007
  • Topic Author
10 years 10 months ago #138513

Hi Tristan,

With some manual work i got all products correctt.
Some where still not imported with images and others had downloadable files instead of images after import.
The order i did not import, it did not work or i just did not know how to do it. I only got 49 orders imported. There where more in VM.

I just have one last question. I would like to change the width of the product title column in the order confirmation email sent to te user, but as i have the starter edition, i kan not edit the emails under system. Can you tell me if i can change this under the views section in the configuration?

Thanks for your help. Hikashop look great!

roy

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 10 months ago #138601

No you can't do that as the emails are not views. If you don't have the Business edition you won't be able to modify the emails via the interface. You can always edit them directly in the folder media/com_hikashop/mail but please note that you will loose your changes when you update/upgrade HikaShop.

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

  • beertje_007
  • Topic Author
10 years 10 months ago #138711

Hi Tristan and Nicolas.

Ok, another reason to upgrade to the commercial license.

I have read some information concerning the spamfilter and the order emails. Our order emails are send to the spamfilter.
Everything is fine except i have not used dkim. Is it possible to use dkim in the bussiness edition of hikashop?
I understand i need to provide a public and private key. One of these needs to be sent with the email.
Acymail has this option, cant find it in hikashop starter.

Thanks again,
Roy

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 10 months ago #138716

Hi,

That can be done with the Business edition but for that, you need to configure the DKIM directly in your email server settings. That way, it's not only HikaShop but all the emails sent out from your website (joomla emails, acymailing emails, etc) which will get the DKIM added to them.

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

  • beertje_007
  • Topic Author
10 years 10 months ago #138718

Hi Nicolas,

I can add the dkim into the dns, but also need to add the other part of the key to the sender.
Acymail and as you stated the business edition of hikashop have options to do so.
Where can i add it to joomla so all joomla mails are also sent with dkim signature.
Maybe this is a "stupid" question, but i have not used dkim in joomla yet.

Thanks again,
Roy

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 10 months ago #138816

Hi,

No, that's not what I said. As Joomla, HikaShop doesn't have any DKIM option. What I said is that you should add the DKIM support on your email server. For example, if you use postfix on your server, you can do like that:
blog.rimuhosting.com/2012/05/17/setting-...eys-dkim-on-postfix/
If you don't know what an email server is or how to configure yours, I invite you to contact your hosting company for help.

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

Time to create page: 0.096 seconds
Powered by Kunena Forum