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.
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 fees. Regards!
$250 USD en 2 días
4,9 (64 comentarios)
5,7
5,7
33 freelancers están ofertando un promedio de $286 USD por este trabajo
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 will consider me for this job. Thanks,
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 format of you choice( csv, excel, sql etc) so i can do it asap.
i can write a VBA in excel and/or Mac Applescript so you can do it yourself from now on.
Please contact me if you need discuss about your requirements in more details.
Looking forward to working with you,
Cuong NH