order showing twice

  • Posts: 73
  • Thank you received: 2
11 years 7 months ago #97621

I think this is a Hika shop issue and not AriTable report program issue. I use AriTable to retrieve SQL data from Hika order table. But for some reason orders that show a different billing address and shipping address show in the report twice. For those orders that use the same billing/shipping address there are not problems.

I already asked the AriTable developer and they said they only pull data and this is the Hikashop issue. Hope you can help. Attached is the screen shot of the table report

Hope you can help.
Thanks

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 7 months ago #97705

HikaShop cannot technically store the orders in duplicate in the database.
There is a unique key on the order table which prevents that.
So it is not possible that you can have two orders with the same order number.
I'm afraid that you will have to contact aritable for your issue as, as far as I can see, the issue is that aritable's query to load the orders data is no correct.

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

Time to create page: 0.043 seconds
Powered by Kunena Forum