#661 Need help with simple import/export plugin

Posted in ‘Technical Support / Bugs’
This is a public ticket

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

Latest post by Olivier on Thursday, 19 February 2026 03:48 UTC

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

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.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

74604

files sent

Olivier

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.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Olivier

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.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

74604

I've made huge progress and now have 244 items in the catalog as there should be. BUT when using simple csv to export it only exports 178 items.

74604

it didn't add the import template

Olivier

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.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Stay Updated

Subscribe for free and be the first to know about the latest features, updates, and new additions.