Storage location of credit card numbers

  • Posts: 234
  • Thank you received: 4
8 years 3 months ago #247999

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.4.45
-- Browser(s) name and version -- : Chrome

Hello all,

I am using CSVi and exporting my online orders, where does hikashop store customer card details so I can include these in the export.

Cheers
Iain

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

  • Posts: 2143
  • Thank you received: 747
8 years 3 months ago #248012

Hi,

Please see www.hikashop.com/forum/import-export-csv...rt-card-details.html , it might help you, too.

Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
The following user(s) said Thank You: Jerome

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

  • Posts: 234
  • Thank you received: 4
8 years 3 months ago #248015

Hello,

Thank you for that, this was the first avenue that I tried and no-one was able to help. Then I found CSVi however they need to know where the details (which table etc) are stored,

Cheers
Iain

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 3 months ago #248017

Hi,

As explained in the other thread : It depends on the payment plugin you are using.

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: 234
  • Thank you received: 4
8 years 3 months ago #248088

Hi, I use the credit card plug in. The main problem I found was that I contacted a couple of people in the list and they were unable to help this is why I thought csvi would do the job. What do other people do? It takes me a couple of hours a day to process the online orders.

Cheers
Iain

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 3 months ago #248090

Hi,

The plugin "credit card" store the data in the order history.
It could be possible to modify that plugin to let it save the data in the "order payment_params" instead of the order history table.

But you have to know that we are not very found of saving credit card number in a database ; that plugin has been made to answer to some specific needs but it should not be used in every countries.
For example in France that plugin is forbidden by some laws.
So we want to be sure that you are sure you want to use that plugin.

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: 234
  • Thank you received: 4
8 years 2 months ago #248744

Hello

Thank you for that, I have looked in the SQL table hikashop_history and can not find it in there. Is this the correct table to look in?

Cheers
Iain

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

  • Posts: 82864
  • Thank you received: 13372
  • MODERATOR
8 years 2 months ago #248746

Hi,

Yes. It is in the history_data column. Note that the data is base64 encoded and serialized. So you need to decode it and then deserialize it.

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

  • Posts: 234
  • Thank you received: 4
8 years 2 months ago #248809

Hello Nicolas

Thank you for that, how can I get that done for the purposes of CSVi?

Cheers
Iain

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

  • Posts: 82864
  • Thank you received: 13372
  • MODERATOR
8 years 2 months ago #248818

Hi,

I don't think that CSVi supports that by default. It will require some development I think but I can't say as I don't know the code of CSVi. You better ask them about that directly with the information we provided about the location of the data you want to export with CSVi.

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

Time to create page: 0.089 seconds
Powered by Kunena Forum