How to export a csv of hikashop products

  • Posts: 159
  • Thank you received: 0
4 years 3 weeks 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: 74542
  • Thank you received: 11497
  • MODERATOR
4 years 3 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: 90
  • Thank you received: 2
3 years 11 months 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: 74542
  • Thank you received: 11497
  • MODERATOR
3 years 11 months 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: 90
  • Thank you received: 2
3 years 11 months 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 years 11 months ago by BounceHouseOwner.

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

  • Posts: 90
  • Thank you received: 2
3 years 11 months 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 years 11 months ago by BounceHouseOwner.

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

  • Posts: 74542
  • Thank you received: 11497
  • MODERATOR
3 years 11 months 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: 90
  • Thank you received: 2
3 years 11 months 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 years 11 months ago by BounceHouseOwner.

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

  • Posts: 25139
  • Thank you received: 3891
  • MODERATOR
3 years 11 months 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: 90
  • Thank you received: 2
3 years 11 months ago #287993

Direct opening of CSV yields this:

Attachments:

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

  • Posts: 90
  • Thank you received: 2
3 years 11 months ago #287994

Same in sheets (google) and OpenOffice

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

  • Posts: 74542
  • Thank you received: 11497
  • MODERATOR
3 years 11 months 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: 90
  • Thank you received: 2
3 years 10 months 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: 74542
  • Thank you received: 11497
  • MODERATOR
3 years 10 months 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.

  • Posts: 8
  • Thank you received: 0
  • Hikashop Business
5 months 5 days ago #334983

My csv looks like mess
it's not organized at all
and semicolon was the separator not comma

and some products have only product ids and some titles

why is it like that?

I tried to export products to google shopping and it doesnt recognize it

Thx

Last edit: 5 months 5 days ago by denis467.

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

  • Posts: 74542
  • Thank you received: 11497
  • MODERATOR
5 months 5 days ago #334984

Hi,

1. In the HikaShop configuration, have a setting to select which CSV separator you want in your CSV files in the "Files" section of the Main tab.

2. If you have rows with the product_id filled in and most of the columns empty, it's probably variants of products. When you export a CSV, you'll have one row per product + one row per variant. And if you don't configure the variants differently from your main products, the variant rows will be most likely empty.

3. Google Shopping has many requirements for the XML to be valid. Normally, when you import the XML manually there, it will tell you what are the problems. Usually, it's because you need to configure the different settings of the Google Products plugin according to your situation.
For example, just for the settings related to the GTIN / MPN / brand, Google Products has a long page with many sub sections to explain how to configure your XML based on what product you're selling and which country you're based in:
support.google.com/merchants/answer/160161?hl=en
So unfortunately, I can't say exactly what needs to be done in general for that to work. It depends greatly on the situation and there is no one-size-fits-all solution.

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

  • Posts: 8
  • Thank you received: 0
  • Hikashop Business
5 months 5 days ago #335017

Thank you for your reply Nicolas
I guess, I'll just need to create all listings for google shopping manually..

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

Time to create page: 0.118 seconds
Powered by Kunena Forum