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-ASP Shopping Cart Customer Forum

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

 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Bulk Import, CSV formatting etc
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bengreen1980
Starting Member

27 Posts

Posted - January 18 2011 :  16:01:50  Show Profile  Reply with Quote
Hi All,

I have lots of product data in an excel spreadsheet.

THIS INCLUDES:

ccode
cname
cprice
artist
ccategory
cdescription
extendeddesc
cstock
cimageurl
keywords
extendedimage
productmetatitle
productmetakeyword
productmetadescription

Will the bulk import handle this?

Also, my descriptions contain symbols, including commas.

I have 20 spreadsheets to bring in, one for each category.

Looking for the simplest way to do this. Its a one off, once the data is in I do not need to import/update again.

I also have direct access to the MySQL via Navicat.

Any advice welcome...

chrisredco
VP-ASP Super User

282 Posts

Posted - February 26 2012 :  13:34:42  Show Profile  Visit chrisredco's Homepage  Reply with Quote
I believe the Import function should handle this no problem, as long as table names, etc are all correct and match what is in VPASP. I have started bulk importing recently with no problems, regardless of quantity.

Redco Audio
www.redco.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000