How to export a csv of hikashop products

  • Posts: 158
  • Thank you received: 0
5 months 7 hours ago #284918

-- url of the page with the problem -- : www.prima.pk

Hi. i want to export a CSV file of hikashop products. Wanted to update prices in bulk and the best way is to do is to update CSV file.. how can i downlod a CSV of my current products list ?

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

  • Posts: 62142
  • Thank you received: 8855
  • MODERATOR
4 months 4 weeks ago #284923

Hi,

Click on the "export" button in the menu Products of the backend of HikaShop.

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

  • Posts: 81
  • Thank you received: 2
  • Hikashop Business
3 months 2 weeks ago #287561

Having issues with there being semicolons in the HTML breaking the import of the CSV.
Any suggestions?

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

  • Posts: 62142
  • Thank you received: 8855
  • MODERATOR
3 months 1 week ago #287562

Hi,

HikaShop adds double quotes around the elements so that even with semicolons in the HTML, it should be able to parse the CSV correctly.
How are you opening the CSV ? If you try with something like libreoffice calc, does it work ?

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

  • Posts: 81
  • Thank you received: 2
  • Hikashop Business
3 months 1 week ago #287668

it exports as .csv, and just directly opening it w/ Excel yields a mess.
I saved it as .txt and tried importing as semicolon, but it has issues with both ' "" ' as text and 'none' options.

Even if I have "" as text, it still is delimiting all the semicolons in the HTML.

File Attachment:

File Name: hikashopexportRAW.txt
File Size:326 KB

Attachments:
Last Edit: 3 months 1 week ago by BounceHouseOwner.

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

  • Posts: 81
  • Thank you received: 2
  • Hikashop Business
3 months 1 week ago #287670

I guess it'd be fine, but your product_ID and product_parent_ID (the 1st 2 columns) don't have "" around the data after export.

At least then I'd be able to do a find/replace all to fix it.

Last Edit: 3 months 1 week ago by BounceHouseOwner.

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

  • Posts: 62142
  • Thank you received: 8855
  • MODERATOR
3 months 1 week ago #287744

Hi,

Numbers don't need double quotes around them in CSV files. In fact only texts with special characters like semi-colons, or return carriage need them. So you should not have to add them.

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

  • Posts: 81
  • Thank you received: 2
  • Hikashop Business
3 months 1 week ago #287881

so how do you suggest I get this formatting to not screw up?

I want to import the products db output into Excel

Last Edit: 3 months 1 week ago by BounceHouseOwner.

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

  • Posts: 22333
  • Thank you received: 3477
  • MODERATOR
3 months 1 week ago #287909

Hello,

Excel should be able to handle the CSV format.
We are using OpenOffice, LibreOffice or even Google tools ; they don't have any issue to parse the CSV. Sometimes they can open a popup to select the "settings" for the CSV parsing (encoding ; coma, semi-colon and/or tabulation separators ; etc).

Afterwards, you still have settings to tweak the export CSV :
www.hikashop.com/support/documentation/5...nfig.html#main_files

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: 81
  • Thank you received: 2
  • Hikashop Business
3 months 1 week ago #287993

Direct opening of CSV yields this:

Attachments:

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

  • Posts: 81
  • Thank you received: 2
  • Hikashop Business
3 months 1 week ago #287994

Same in sheets (google) and OpenOffice

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

  • Posts: 62142
  • Thank you received: 8855
  • MODERATOR
3 months 6 days ago #287995

Hi,

Looking at your screenshot, the issue is that your software is configured to open CSVs with a semi colon separator while the CSVs exported by HikaShop use a coma separator.
HikaShop has a setting in the HikaShop configuration to change the CSV separator. So you can change that if you want.
Also, Excel, LibreOffice and other software have settings to select the separator to use when opening CSV files.
help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files
support.office.com/en-us/article/import-...ce-937b-339e391393ba

For example, with your previous CSV, it opens just fine on my LibreOffice:
monosnap.com/file/BqH1caAGlCR1ePPmx3UuGNopWTr3sO

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

  • Posts: 81
  • Thank you received: 2
  • Hikashop Business
3 months 21 hours ago #288336

Where do you change HikaShop's product export delimiter?

Attached is the raw text version of your base products export.
The delimiter is definitely ;

File Attachment:

File Name: hikashopex...2-21.txt
File Size:326 KB

Attachments:

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

  • Posts: 62142
  • Thank you received: 8855
  • MODERATOR
3 months 11 hours ago #288340

Hi,

As I said in my previous message, that setting is in the configuration of HikaShop. You can find it in the "main" tab, in the "files" section.

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

Time to create page: 0.167 seconds
Powered by Kunena Forum