VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Bulk Import of csv with commas in Description
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

United Kingdom
131 Posts

Posted - October 03 2006 :  05:32:35  Show Profile  Visit jmccann's Homepage  Reply with Quote

I have been given CSV file to be used for the bulk import of Products. However, the problem I have is that the description uses commas (,) within the text. I use Excel to produce the formatted output, but can only get a csv file file which gets thrown out of alignment becuse of the embedded commas. I dont want to change the comma within product descrption as it improves readability.

Can anyone suggest a way to use excel to keep comas and to output an import file that VPASP can use?


jim mccann

Senior Member

United Kingdom
1898 Posts

Posted - October 03 2006 :  05:57:38  Show Profile  Visit devshb's Homepage  Reply with Quote
vpasp imports can use any separator, so if you save your file as one that's separated by another character (say, "{", instead of a comma) and then use that when importing as your delimiter, it should be ok.

another possibility is to save it as a tab-separated file, and tweak the import asp to be able to cope with a tab delimiter, see the link below which explains how to do it (free!) :


Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons

Edited by - devshb on October 03 2006 06:21:19
Go to Top of Page

VP-ASP New User

137 Posts

Posted - October 03 2006 :  19:55:31  Show Profile  Visit bmw000's Homepage  Reply with Quote
I would have to say the tab-separated is the way to go. I almost never have a problem importing tab-separated files.

Brian Weber
Variety Solutions, LLC
Go to Top of Page

VP-ASP New User

113 Posts

Posted - October 05 2006 :  08:23:57  Show Profile  Reply with Quote

Vpasp can also import it using a | separator.

I've used it and it also works very well.

Just for info.


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000