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
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
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
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.
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.