How to export a csv of hikashop products

Hi,

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

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 ?

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.

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,

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

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.

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.

Hi,

Go in the menu Products>Products. There, on your products listing, you have an "export" button at the top.