Parsing Excel Spreadsheet into Volusion database
$250-750 USD
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.
Project ID: #1536794
About the project
Awarded to:
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
33 freelancers are bidding on average $286 for this job
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
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)
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.
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
...........#####... "KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE" ...##### ............