Skip to Content

New J2Commerce 6.6.5 is out. Here is everything in the release.

See What’s New

Search

Start For Free
Account
Enter the email address on your account.
Forgot your username?
Enter your password.
Forgot your password?

Or continue with

Pending Public Technical Support / Bugs Ticket #661

Need help with simple import/export plugin

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Conversation

74604

I'm having a problem importing a file I created from hikashop into j2.
I've gone thru the csv and made sure all the product names match but when I import I get a 500 error after a while.
i've tried both simple import and ro csvi with no luck.
please help me figure this out.
I'm working with ali on a big client.
I don't know how to send a file with this ticket so I'll have to wait for our email

Thanks

Bear

Olivier Buisard Staff

Hi Troy,

can you send us a sample file at support@j2commerce.com? Just with a few items if possible.

Have you tried with just a couple products?
How large is the file you are trying to import? You may just run into an out of memory error. In which case you may want to allocate more memory.

I suspect this is what is happening since you don't get luck with ROcsvi either.

Olivier.

Edited by Olivier Buisard on 02-08-2026 16:43 EST
Olivier Buisard Staff

Thanks Troy, I did not see you initially sent the files already. My apologies for requesting them again. I have not been able to check it out, I am about to do it now. 

Olivier.

Olivier Buisard Staff

OK, from what I see:

  • you do not need the product_id column since you insert products as 'new'.
  • manufacters must be created before referring to them. so manufacturer_id can't be used if the manufacturer does not exist.
  • manufacturer_name is not recognized in the import,
  • category_path is not recognized in the import,
  • product_created is not recognized in the import. Use 'created' or let the system do it for you (will be today's date).

Last, I can see that multiple lines for the fulltext is a bit of an issue. However, even though a error is reported, the product is still imported.

I have tried all previous recommendations and was able to import a product.

Olivier.

Olivier Buisard Staff

Hi Troy,

The solution is simpler than I thought it would be :-)

66 products in your hikashop store are not enabled.

Export with the Simple CSV add-on only exports the enabled ones. Hence the difference.

Olivier.