Hi, I am trying to export data feeds having COMMA (,) delimiter as TAB & Semi Colon is very messy and becomes difficult to figure out which column is it.
Now the issue is when I generate COMMA Delimiter feeds it creates problems in Categories that have comma, In google categories which have comma and if there is meta keywords or meta description having comma.
So basically what I understood was that the moment cs-cart finds a COMMA(,) , it makes a new column for that particular product attribute.
Kindly help me fix the issue as I want to use these feeds to upload products on google shopping ads and facebook.
What should not cause the problem? Can you please elaborate?
I am tryying to export using Comma(,) delimiter as it gives me column wise feeds but the moment there is a comma(,) anywhere in text, category name, google category name meta details etc it puts them in different column.
It should not cause this problem since CS-Cart puts data to quote. E.g.
What should not cause the problem? Can you please elaborate?
I am tryying to export using Comma(,) delimiter as it gives me column wise feeds but the moment there is a comma(,) anywhere in text, category name, google category name meta details etc it puts them in different column.
Given that the 2nd column is enclosed in quotation marks, the comma will not be seen as a column separator if someone is honoring the CSV statnadards. Google certainly should be. My guess is that you have something that is filtering out the quotes around column data and that's what's causing your problem.
But I am afraid this is not happening in my case. The moment trhere is a comma, it is putting the next word or sentence in the next column for some of the products. For eg. If I try to extract meta keywords which are separated by comma(,) then each keyword goes into new column. Same happens when there is comma(,) in category name or google category name. Can you suggest what is filtering it. I really cannot understand.
Given that the 2nd column is enclosed in quotation marks, the comma will not be seen as a column separator if someone is honoring the CSV statnadards. Google certainly should be. My guess is that you have something that is filtering out the quotes around column data and that’s what’s causing your problem.
I think i managed to make it work. The enclosure was empty under data feeds settings. When I put " there it worked. Thanks both of you for replying and trying to help.
But I am afraid this is not happening in my case. The moment trhere is a comma, it is putting the next word or sentence in the next column for some of the products. For eg. If I try to extract meta keywords which are separated by comma(,) then each keyword goes into new column. Same happens when there is comma(,) in category name or google category name. Can you suggest what is filtering it. I really cannot understand.
I think i managed to make it work. The enclosure was empty under data feeds settings. When I put " there it worked. Thanks both of you for replying and trying to help. :)
I think i managed to make it work. The enclosure was empty under data feeds settings. When I put " there it worked. Thanks both of you for replying and trying to help. :)
Can you please tell me more about how you managed to make it work, because I have had the exact same problem of it reading commas withing the " ". Where did you find the data feeds setting?
