[Skip to main content](#vessel-content) # order showing twice ## - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 13 years 7 months ago [\#97621](#97621) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") *[order showing twice](/forum/2-general-talk-about-hikashop/79993-order-showing-twice#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...")* was created by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* 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 - [ ![screen_shot_aritable.jpg](/forum/attachment/9480) ](/forum/attachment/9480 "...t_aritable.jpg") [ ](/forum/attachment/9480?download=1 "...t_aritable.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5OTkzLW9yZGVyLXNob3dpbmctdHdpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 13 years 7 months ago [\#97705](#97705) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order showing twice](/forum/2-general-talk-about-hikashop/79993-order-showing-twice#97705 "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...")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5OTkzLW9yZGVyLXNob3dpbmctdHdpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.046 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)