Export products from Hikashop

  • Posts: 25
  • Thank you received: 2
3 years 7 months ago #238999

-- HikaShop version -- : latest
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.6
-- Error-message(debug-mod must be tuned on) -- : Can't export, no error messages

We are trying to export all the items from the shop, as we have builkt a new version of it. When ever we try and export the products it looks like it's working and then shows a screen with what looks like a sitemap. We need to export and import today as the new site needs to be live for tomorrow, please help!

I have attached the displayed image after trying to export. :blink:

Attachments:

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

  • Posts: 67676
  • Thank you received: 10046
  • MODERATOR
3 years 7 months ago #239012

Hi,

This is what is called a "blank page". The process stops in the middle because of a fatal error.
It can be due to two things:
- a bug
- a limitation of your hosting
As you're doing an export, it's highly likely to be the second case.
On most websites, if you do the same action again after activating the "error reporting" setting of the Joomla configuration, you'll get an error message at the bottom, telling you what is the problem.
It's highly likely to come from the memory_limit parameter of the php.ini of your web server which is too low for the amount of products to be loaded for the export.
In that case, you would have to contact your hosting company to increase that parameter value, or use a mass action via the menu System>Mass actions with an action "export CSV". With a mass action, you can limit the amount of products to be exported and thus to can get several CSVs of the products with different chuncks so that you get them all.

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

  • Posts: 25
  • Thank you received: 2
3 years 7 months ago #239684

HI Nicolas,

Thasnk for your reply. We have been trying to export via mass actions, but are having some issues as when we try and import into the new website we are getting lots of errors.

Could you tell us how for example we would export all E-Liquids? The site is infinityvape.co.uk and this has the most products in it. We have been tgrying to export this but can never get it to load in the new site.

We have the categories set up with the same names but they do have different number ID's?

I can't find the answer in the documentation we have read.

Your help is appreciatted.

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

  • Posts: 13201
  • Thank you received: 2319
  • MODERATOR
3 years 7 months ago #239719

Hi,

If you export via the mass actions, you have to import via this tool too as the columns in the csv file can differ.
Export mass action: take.ms/yIqPH
Import mass action: take.ms/Xs8xN

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

  • Posts: 25
  • Thank you received: 2
3 years 7 months ago #239787

Hi,

We get an error when trying to import the file via the method you're showing:

An error has occurred.
20 JPath::check Snooping out of bounds @ /newsite2/csv/eliquids.csv

We have tried various paths with no luck:
infinityvape.co.uk/newsite2/csv/eliquids.csv
infinityvape.co.uk/newsite2/csv/eliquids.csv
/csv/eliquids.csv

We placed the cvs folder in the main directory of the newsite which is infinityvape.co.uk/newsite2

Your help is appreciatted.

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

  • Posts: 67676
  • Thank you received: 10046
  • MODERATOR
3 years 7 months ago #239803

Hi,

Please enter the absolute path to the CSV file.
It must be something like that:
/var/www/infinityvape.co.uk/newsite2/csv/eliquids.csv
If you're not sure about the path of your website, you can ask your hosting company.

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

  • Posts: 25
  • Thank you received: 2
3 years 7 months ago #240052

Hi,

I am having a nightmare with exporting and importing these products. Are you able to look at the site for us and see what's happening? We have tried to export and import as pe ryour instructions with no luck... :(

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

  • Posts: 67676
  • Thank you received: 10046
  • MODERATOR
3 years 7 months ago #240117

Hi,

We have have a look yes. Please provide a backend access, the path of the CSV you're using, the path of your website and a link to this thread through our contact form:
www.hikashop.com/support/contact-us.html

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

  • Posts: 25
  • Thank you received: 2
3 years 6 months ago #240222

Thankyou, email sent with details

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

  • Posts: 13201
  • Thank you received: 2319
  • MODERATOR
3 years 6 months ago #240233

Hi,

It seems that you does not have the latest version of HikaShop.

The "20 JPath::check Snooping out of bounds @ /newsite2/csv/eliquids.csv" error means that the file is not reachable.
You have to place it in the new website environment., but you seems to have solved that issue.

Now there is a MySQL error present when trying to import the csv file. I just tried on my local, and the import went just fine.
So please update your HikaShop version and try again.
If that still does not work, so you can send ftp access via our contact form.

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

  • Posts: 25
  • Thank you received: 2
3 years 6 months ago #240470

I have sent an email with FTP details.

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

  • Posts: 13201
  • Thank you received: 2319
  • MODERATOR
3 years 6 months ago #240434

Hi,

In which subfolder is the "newsite2" on the FTP ?
I tried in public_html and subdomains/dev but it seems to be somewhere else..

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

  • Posts: 25
  • Thank you received: 2
3 years 6 months ago #240507

I've put the folder within the site:

infinityvape.co.uk/newsite2

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

  • Posts: 13201
  • Thank you received: 2319
  • MODERATOR
3 years 6 months ago #240563

Hi,

We had a little issue in our code indeed. So I just tried to export and import and it worked.
But now it seems that there is some missing data. I was able to reproduce the issue on my local and will debug it.

I keep you informed.

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

Time to create page: 0.077 seconds
Powered by Kunena Forum