Parsing Excel Spreadsheet into Volusion database

Completed Posted Mar 30, 2012 Paid on delivery
Completed Paid on delivery

Vendors give their prices in an Excel format. Unfortunately they put similar models in one row. To import to Volusion database, I need to parse so that each product has its own row.

For example, in a spreadsheet of hundreds of products, they typically merge multiple types in one row separated by a comma or '/' :

(Delimiter is either comma or '/')

Product Brand Model Color Manufacturer Number

Toner Brother TN-620 DCP-8080DN, DCP-8085DN,etc etc Black M1960G/A

Toner Brother TN-620 DCP-8080DN/DCP-8085DN, Black M1960G/A

I need a script, macro etc to be able to parse multiple items and create new rows for each model, so I can import them into Volusion:

Product Brand Model

Toner Brother TN-620 DCP-8080DN Black M1960G/A

Toner Brother TN-620 DCP-8085DN Black M1960G/A

Toner etc etc Black M1960G/A

It can be done in Excel, Access, SQL etc.

Or if there's another way to import these into Volusion, open to suggestions too.

Data Processing Excel Microsoft Access SQL Volusion

Project ID: #1536794

About the project

33 proposals Remote project Active Apr 6, 2012

Awarded to:

nagybatonyi

Such jobs are my daily practice. If you send me a sample source file I'll make a free pilot conversion for you. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fee More

$250 USD in 2 days
(64 Reviews)
5.7

33 freelancers are bidding on average $286 for this job

thetechie13

Volusion expert

$250 USD in 4 days
(285 Reviews)
8.1
Teloquence

Excel expert at your service. Check your inbox for details.

$250 USD in 1 day
(330 Reviews)
7.6
rhomeu

MS Access, VBA expert here. This can be done in MS Access. Please check PM Thanks

$250 USD in 1 day
(66 Reviews)
7.0
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$350 USD in 7 days
(29 Reviews)
6.0
LK1811

A comma separated values spreadsheet will do. Please let me have the details.

$250 USD in 3 days
(47 Reviews)
5.7
srinichal

I am an expert in automation and can deliver the script to your needs

$420 USD in 5 days
(27 Reviews)
5.6
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$250 USD in 1 day
(41 Reviews)
5.4
thelogicgates1

Please see pmb.

$250 USD in 7 days
(5 Reviews)
5.4
sigmasolve

Hi, Please check PMB for more details and our portfolio. Thanks.

$250 USD in 5 days
(12 Reviews)
5.2
gshiels

I have 20 years Excel experience and have worked with many different systems, so this is straightforward for me. Please check my feedback and 100% completion rating.

$250 USD in 2 days
(11 Reviews)
5.2
northwolves

Ready to start,provide more details,please.

$250 USD in 3 days
(48 Reviews)
5.0
rapidwebservices

Hi, I have about 6 years experience in Volusion products, categories, options, etc (Volusion Expert). I can done it very well to be able these product to import in Volusion database and without any error. Hoping you wi More

$250 USD in 1 day
(9 Reviews)
5.1
hemi

Hi, Please check PMB for workout of proposed project. Thanks

$250 USD in 2 days
(33 Reviews)
5.0
Nhcuong

Hi, An Excel expert at your service! parsing various data file formats an put in backend database is my daily work. I would be glad to do this job for you. Please send me the excel source file as an example and file fo More

$250 USD in 1 day
(26 Reviews)
5.0
ssquareit

I am a Volusion Experienced Programmer

$250 USD in 4 days
(9 Reviews)
5.0
Desksolution

Please check private message.

$300 USD in 15 days
(4 Reviews)
4.8
muthumuni

...........#####... "KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE" ...##### ............

$250 USD in 0 days
(8 Reviews)
4.0
momo2619

Dear Sir, Please read your PM. Thanks Meena

$250 USD in 0 days
(14 Reviews)
3.7
hardcorefs

Hi, I have recently completed a 'cleanup' on a 750,000 row database

$300 USD in 4 days
(1 Review)
3.3
AccuPro

Can do this.

$250 USD in 2 days
(7 Reviews)
3.6