[Skip to main content](#vessel-content)

#   Can't import sales CSV data correctly

##

- **[iDanny](/forum/user/43074-idanny "View iDanny's Profile")**
- [![iDanny's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar43074.png)](/forum/user/43074-idanny "View iDanny's Profile") Topic Author
- [ Offline](/forum/user/43074-idanny)

Less More

- Posts: 75
- Thank you received: 12
-
-
- [](https://benu.ca)
-

8 years 9 months ago [\#286494](#286494) by [iDanny](/forum/user/43074-idanny "View iDanny's Profile")  *[Can't import sales CSV data correctly](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly#286494 "-- Joomla version -- : 3.8 -- PHP version -- : 7  Hi, I am trying to import our exported CVS sales report content but the format breaks at the currency column Can you see what's wrong ? Thanks Danny")* was created by *[iDanny](/forum/user/43074-idanny "View iDanny's Profile")*

-- Joomla version -- : 3.8
-- PHP version -- : 7

Hi,
I am trying to import our exported CVS sales report content but the format breaks at the currency column
Can you see what's wrong ?
Thanks
Danny

---

Danny Malouin
BeNu - Digital success agency
[ benu.ca](https://benu.ca)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM1NzAtY2FudC1pbXBvcnQtc2FsZXMtY3N2LWRhdGEtY29ycmVjdGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86323
- Thank you received: 14284
-
-

8 years 9 months ago [\#286503](#286503) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can't import sales CSV data correctly](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly#286503 "-- Joomla version -- : 3.8 -- PHP version -- : 7  Hi, I am trying to import our exported CVS sales report content but the format breaks at the currency column Can you see what's wrong ? Thanks Danny")*

Hi,

How did you get that CSV ?
I've never seen a CSV coming from HikaShop with such formatting. It looks like you're using a third party extension or some customization.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM1NzAtY2FudC1pbXBvcnQtc2FsZXMtY3N2LWRhdGEtY29ycmVjdGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[iDanny](/forum/user/43074-idanny "View iDanny's Profile")**
- [![iDanny's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar43074.png)](/forum/user/43074-idanny "View iDanny's Profile") Topic Author
- [ Offline](/forum/user/43074-idanny)

Less More

- Posts: 75
- Thank you received: 12
-
-
- [](https://benu.ca)
-

8 years 9 months ago [\#286514](#286514) by [iDanny](/forum/user/43074-idanny "View iDanny's Profile")  Replied by *[iDanny](/forum/user/43074-idanny "View iDanny's Profile")* on topic *[Can't import sales CSV data correctly](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly#286514 "-- Joomla version -- : 3.8 -- PHP version -- : 7  Hi, I am trying to import our exported CVS sales report content but the format breaks at the currency column Can you see what's wrong ? Thanks Danny")*

Hi Nicolas,
This is how the default Export function (button) behaves - see attached screenshot

---

Danny Malouin
BeNu - Digital success agency
[ benu.ca](https://benu.ca)

- [ ![hikashop-export.jpg](/forum/attachment/42287) ](/forum/attachment/42287 "...hop-export.jpg") [ ](/forum/attachment/42287?download=1 "...hop-export.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM1NzAtY2FudC1pbXBvcnQtc2FsZXMtY3N2LWRhdGEtY29ycmVjdGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86323
- Thank you received: 14284
-
-

8 years 9 months ago [\#286528](#286528) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can't import sales CSV data correctly](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly#286528 "-- Joomla version -- : 3.8 -- PHP version -- : 7  Hi, I am trying to import our exported CVS sales report content but the format breaks at the currency column Can you see what's wrong ? Thanks Danny")*

Hi,

Ah, I see what you mean. You're talking about the export of reports and this happens only for some reports, not all of them.
Fortunately, I was able to reproduce the problem thanks to your screenshot and I've added a patch.
You can download the install package again on our website and install it on yours to get the patch.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM1NzAtY2FudC1pbXBvcnQtc2FsZXMtY3N2LWRhdGEtY29ycmVjdGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.057 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
