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.
35 pekerja bebas membida secara purata $284 untuk pekerjaan ini
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.
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)