Categories
View Replies (9)

Resolved Add Hikashop Order Statuses

  1. davec
    davec
  2. RO CSVI
  3. Friday, 24 April 2020
  4.  Subscribe via email
Hi

I have just purchased CSVI. I have installed this and the Hikashop plugin. I have added the test data templates. On the export orders I have the standard order statuses. However I have other order statuses but these do not appear as an option. How can these be added to a template please?

Thanks

Dave
Attachments (2)
Hikashop-order-status.jpg Hikashop-order-status.jpg
Hikashop-Administration---Order-Statuses.jpg Hikashop-Administration---Order-Statuses.jpg
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Dave,
Please load the attached patch file and run your export. Check if the error is gone.

Also please attach the debug log as file in your reply. Posting it in Optional Information section makes it difficult for us to read the content.
Attachments (1)
patch_hikashop_2020_04_27.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (9)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Dave,
Thank you for pointing that out. We realised HikaShop stores order status in its own individual table other than category table. RO CSVI code was retrieving status from category table and so your other status were not shown. I have fixed this issue with attached patch file. Please load the patch file from RO CSVI Maintenance menu as explained in the linked document and check your export.

Let me know on how it goes.
Attachments (1)
patch_hikashop_2020_04_24.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
davec
davec
Accepted Answer Pending Moderation
Hi Tharuna

I now have the other statuses. So when the next set of orders are ready to be exported I can run and check that it is working as expected.

Thanks

Dave
  1. more than a month ago
  2. RO CSVI
  3. # 2
davec
davec
Accepted Answer Pending Moderation
Hi Tharuna

I have just created a test using confirmed orders and where users have more than one order there is several duplicated addresses. Is there a way to prevent this as only one address would be required for an order.

Thanks

Dave
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Dave,
I now have the other statuses. So when the next set of orders are ready to be exported I can run and check that it is working as expected.

Sure let us know. Such issues comes up when HikaShop change their code behaviour. Glad to know that you found it out for us:D

I have just created a test using confirmed orders and where users have more than one order there is several duplicated addresses. Is there a way to prevent this as only one address would be required for an order.

Please check Use Group by and Sort by document to avoid duplicates on export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
davec
davec
Accepted Answer Pending Moderation
Hi Tharuna

I have tried this and get the following error:

Error
Unknown column 'as.shipping_address_firstname' in 'group statement'

Thanks

Dave
Attachments (1)
Screenshot_2020-04-24 RO CSVI - Log details - Administration.png Screenshot_2020-04-24 RO CSVI - Log details - Administration.png
  1. more than a month ago
  2. RO CSVI
  3. # 5
davec
davec
Accepted Answer Pending Moderation
Hi Tharuna

just added log file.

Dave
  1. more than a month ago
  2. RO CSVI
  3. # 6
davec
davec
Accepted Answer Pending Moderation
Good morning Tharuna

thanks for the patch file. l have created a template and exported a file and all is as expected.

I will also remember to attach a log file in the future with any other queiries

Thanks

Dave
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Good morning Dave,
Thank you for confirming that patch is working. This fix will be included in our upcoming RO CSVI 7.15.1 release.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!