Find Jobs
Hire Freelancers

csv conversion

€8-30 EUR

Completed
Posted over 8 years ago

€8-30 EUR

Paid on delivery
Hello I have a csv file from turbolister that I need to convert in a magmi csv to import configurable products in magento. You don't need to have skills in magmi or magento, just strong skills in csv and XML file manipulation. I have a csv file from turblister and I need to do the following operation on it. At the end we will have a new csv like specified. Sample files are in attachment. Here are the steps 1. Load original file and parse the VariationSpecifics fields, a new csv file for each field will be created with this info inside: SKU,StartPrice,Quantity,SYS_SKU,Flags,VariationSpecifics ,5.99,30,20395,0,Design/Finitura|2 lupi - wolves - 0003 ,5.99,30,20396,0,Design/Finitura|3D - 3d background - 0004 ,5.99,30,20397,0,Design/Finitura|3d abstrect - 0005 ,5.99,30,20398,0,Design/Finitura|143 ti amo - 143 i love u - 0002 ,5.99,30,20399,0,Design/Finitura|1000 cuori - hearts - 0001 ,5.99,30,20400,0,Design/Finitura|abbraccio - cant live - 0006 ,5.99,30,20401,0,Design/Finitura|abbraccio - heaven - 0007 ,5.99,30,20402,0,Design/Finitura|abbraccio - titanic jack n rose - 0008 ,5.99,30,20403,0,Design/Finitura|abstrac clock hd - 0011 each new file will have the sku name that will be taken from the item name like stated below. 2. On the original csv file you will have to do this operations and create a new file: Copy 'Title' column to new column 'name' add column sku = last characters after the last space (last 6 chars in the sample provided) add column short_description = Title add column price = 5.99 add column qty = 30 add column image = [login to view URL] tagliando 'C:\ProgramData\eBay\Turbo Lister2\Data\user002\' add column small_image = image add column thumbnail = image add column type = 'configurable' add column attribute_set = Default add column configurable_attributes = design_finitura add column design_finitura = '' but for every lines it should open and loop on the csv file named wih sku as stated in point 1. So looping on csv will add new lines for every line of this sku named csv, with the same fields but of the original lines but with this column modified sku = original sku + '_' + SYS_SKU design_finitura = Cut 'VariationSpecifics senza 'Design/Finitura|' and leave the rest (ie. Design/Finitura|2 lupi - wolves - 0003 becomes 2 lupi - wolves - 0003 ) image = column 'name' value + '/' + design_finitura + '.jpg' type = simple Do not add line if Finitura = "Pellicola" Let me know if there something it's not clear
Project ID: 8842030

About the project

14 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi Good Day I can convert the CSV file from turbolister format to magmi format. I know about the turbolister format. Looking forward to hear from you. Thanks Rinsad
€38 EUR in 1 day
4.9 (1111 reviews)
9.1
9.1
14 freelancers are bidding on average €40 EUR for this job
User Avatar
I can deliver the relevant script to your specifications and requirements .
€42 EUR in 1 day
4.8 (131 reviews)
7.4
7.4
User Avatar
I will do it for you and I will start work now. Regard Ladora IT
€80 EUR in 2 days
5.0 (57 reviews)
5.6
5.6
User Avatar
Dear Employer, thanks for this opportunity to bid for the project, we are an India Based IT and Software Development firm working on technologies of PHP, CMS like joomla, Wordpress, Mobile Application Development (Android and IOS). we have 12 highly experienced Team of Designers and Developers ready to work for you and provide you with expected solutions. As coming to this project it is much within our scope of development. please open the message box so that we can discuss. Thanks Regards codeembassy
€23 EUR in 1 day
4.8 (42 reviews)
5.1
5.1
User Avatar
Hi There, Hope you are doing well. Thanks for the requirement. We have gone through your description and we are confident to deliver you best solution. Your Goal of the project and your requirement is very clear to us. Looking forward to hear back from you and maintain a long term relationship. Cheers! Subrata R.
€60 EUR in 1 day
5.0 (25 reviews)
4.9
4.9
User Avatar
A proposal has not yet been provided
€111 EUR in 0 day
4.9 (17 reviews)
4.6
4.6
User Avatar
Hi, I can do good job in manipulation data using CSV file and create CSV file in new format. I have done similar kind of project in the past project and you can refer to my profile. I will be able to complete your work within 3 to 4 hours of time. Looking forward to work with you. Waiting for your reply.
€30 EUR in 1 day
5.0 (3 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
€12 EUR in 1 day
3.8 (18 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
€9 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have strong XML / XSLT skills and years of experience. =======================================
€50 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€29 EUR in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
ROMA, Italy
5.0
101
Payment method verified
Member since Sep 22, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.