Export only exporting first product

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #81182

Hi,

For some reason when I export my orders the system only adds the first product to the export sheet. For example the customer may have bought: 'product 1 @ £30' & 'product 2 @ £20' When I export the data the total is correct - £50 for both the products but the second product is not mentioned in the export so when I send it to people to fulfil they do not know what the second product is and have to manually go back which takes a lot of time.

Any ideas welcomed!

Thanks

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

  • Posts: 13201
  • Thank you received: 2322
11 years 4 months ago #81240

Hi,

I just tried on my end and all the products present in the order are in the export.

Are you sure that the problem don't come from your csv reader ?
Do you have edited anything (view / classe) in the backend of HikaShop ? Which version do you have ?

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #81253

Hi,

I have version 1.6.0

I have tried opening in LibreOffice Calc as well as Excel and the only files I have made changes to in HikaShop are the email files, and customising CSS classes of the shop in the front end but I have done this in the template CSS not by editing the files of Hikashop..

I have attached a screen shot showing the contents of item two in the export are empty..

Thanks

Alex

Attachments:

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

  • Posts: 13201
  • Thank you received: 2322
11 years 4 months ago #81256

Try to update to HikaShop 2.0
Don't forget to make a backup before updating.

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #81265

I have a test area where I tried installing version 2.0 The export still doesn't work right. There is information missing about the items on the export. Would it be possible for you to take a look at the Joomla install I have?

Thanks

Alex

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
11 years 4 months ago #81553

What information is missing ? We could take a look but we would first need more precise information as to what is the problem.

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #81607

Of course,

The information about the second product is missing. When a client buys two items, I export their order information to excel or any program and the columns for item 2 are empty...

Thanks

Alex

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
11 years 4 months ago #81869

Could you provide the CSV that is generated by HikaShop ?

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #81884

Sure,

Can I email it to you? I can't post on the forum as customer info is confidential?

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

  • Posts: 13201
  • Thank you received: 2322
11 years 4 months ago #81991

Yes you can email it via our contact form, don't forget to include the link of the topic in this email.

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

  • Posts: 26008
  • Thank you received: 4004
  • MODERATOR
11 years 4 months ago #82106

Hi,

Your CSV is not an "official" order export CSV generated by HikaShop.
HikaShop 2.0 uses semi colon as separator and add quotes for all his texts. Regarding your CSV file, I see comma as separator and no quotes.
Are you sure that the export view does not have been modified ?

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.

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #82119

No I haven't modified this at all, I am not sure whereabouts I would even make a change to this. Can you check to see or is there a way i can update the export code so that it works correctly?

Thanks

Alex

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
11 years 4 months ago #82339

We were able to reproduce the problem and fix it.
Please replace the files administrator/components/com_hikashop/views/order/view.html.php and administrator/components/com_hikashop/views/order/tmpl/export.php by the ones in the archive below and that should work fine after that.

Attachments:

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #82340

Sorry I only just understood what you meant. I thought you were referring to me modifying code, not the csv file. I have resent another CSV file which I have not broken into columns

Thanks

Alex

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #82588

This seems to be working now, thanks

Alex

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

  • Posts: 377
  • Thank you received: 7
11 years 4 months ago #83119

Sorry i thought it was working but it's not. There are still exports which are leaving the second product blank when it should be filling it in.

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

  • Posts: 26008
  • Thank you received: 4004
  • MODERATOR
11 years 4 months ago #83266

Hi,

We did not forget you. I have create an issue in our bug tracker. We would work to fix your problem as soon as possible.
I think that Nicolas had reproduce your problem but his patch should fixed it so, maybe you have another specific case which we have to reproduce.

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.090 seconds
Powered by Kunena Forum