Problem Importing Csv

[shida]

Hi Prestashop new users and PROFESSIONALS. Honestly i dont know how to start (cos of my English). Im having a issue with editing CSV file, Please is there anybody who can help with this issue? I am attaching CSV file:

 

Thank you

Regards

[Guest]

It would help if you actually say what the problem is

 

Are you getting error messages?

What version of prestashop?

Lnk the actual csv file not a screen print of excel

 

and anything else that may help show the problem

[shida]

Hi, Thank you for reply. Greatly appreciated. My problem was that i want step by step guides and how csv should be edited?

 

Thank you

Regards

[shida]

Hi again, here is my result:

 

23 errors 

1. No Name (ID: 1012100,"Mens Fahsion Casual Stand Collar Jacket Winter Thick Cotton Polyester Coat","Clothing and Apparel","Men's Clothing>Coats & Jackets",39.99,0.312,") cannot be saved
2. Property Product->name is empty
3. No Name (ID: ) cannot be saved
4. No Name (ID: Material:Cotton+Polyester) cannot be saved
5. No Name (ID: Color:Gray) cannot be saved
6. No Name (ID: Occasion: Casual) cannot be saved
7. No Name (ID: Season: Fall,Winter) cannot be saved
8. No Name (ID: Details&nbsp) cannot be saved
9. No Name (ID: ) cannot be saved
10. No Name (ID: ) cannot be saved
11. No Name (ID: ) cannot be saved
12. No Name (ID: ) cannot be saved
13. No Name (ID: in&nbsp) cannot be saved
14. No Name (ID: Package&nbsp) cannot be saved
15. No Name (ID: 1*coat) cannot be saved
16. No Name (ID: More&nbsp) cannot be saved
17. No Name (ID: About&nbsp) cannot be saved
18. No Name (ID: guide&nbsp) cannot be saved
19. No Name (ID: accordingly.we&nbsp) cannot be saved
20. No Name (ID: and&nbsp) cannot be saved
21. No Name (ID: ,http://www.banggood.com/Mens-Fahsion-Casual-Stand-Collar-Jacket-Winter-Thick-Cotton-Polyester-Coat-p-1012100.html,,Size L ) cannot be saved
22. No Name (ID: Size XL ) cannot be saved
23. No Name (ID: Size XXL ") cannot be saved

× There are 41 warnings

• id_tax_rules_group (ID 1) Invalid tax rule group ID. You first need to create a group with this ID.
• Rewrite link for (ID: 1012100,"Mens Fahsion Casual Stand Collar Jacket Winter Thick Cotton Polyester Coat","Clothing and Apparel","Men's Clothing>Coats & Jackets",39.99,0.312,"
• Rewrite link for (ID: ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID:
• Rewrite link for (ID: ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID:
• Rewrite link for (ID: in ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: Package ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 1*coat
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: More ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: 
  ) was re-written as friendly-url-autogeneration-failed.
• Rewrite link for (ID: '+data.result.file.name+' : '+data.result.file.error).show(); else { $(data.context).find('button').remove(); var filename = encodeURIComponent(data.result.file.filename); var row = $('#csv_uploaded_history tr:first').clone(); $('#csv_uploaded_history').append(row); row.removeClass('hide'); row.find('td:first').html(data.result.file.filename); row.find('button.csv-use-btn').data('filename', data.result.file.filename); row.find('a.csv-download-link').attr('href','index.php?controller=AdminImport&token=d8cbf20cdc9c0dbbcaaf8081ab777825&csvfilename='+filename); row.find('a.csv-delete-link').attr('href','index.php?controller=AdminImport&token=d8cbf20cdc9c0dbbcaaf8081ab777825&csvfilename='+filename+'&delete=1'); csv_select(data.result.file.filename); var items = $('#csv_uploaded_history tr').length -1; $('.csv-history-nb').html(items); enableHistory(); } } } }, }).on('fileuploadalways', function (e, data) { file_add_button.stop(); }).on('fileuploadprocessalways', function (e, data) { var index = data.index, file = data.files[index]; if (file.error) { $('#file-errors').append(''+file.name+' ('+humanizeSize(file.size)+') : '+file.error).show(); $(data.context).find('button').trigger('click'); } }); $('#csv_uploaded_history').on('click', 'button.csv-use-btn', function(e){ e.preventDefault(); var filename = $(this).data('filename'); csv_select(filename); }); $('#file-add-button').on('click', function(e) { e.preventDefault(); $('#file-success').hide(); $('#file-errors').html('').hide(); $('#file').trigger('click'); }); $('#file-remove-button').on('click', function(e) { e.preventDefault(); csv_unselect(); }); $('.csv-history-btn').on('click',function(e){ e.preventDefault(); $('#csv_files_history').toggle(); $('#csv_file_uploader').toggle(); }) //show selected csv if exists var selected = '20160108152304-TRY.csv'; if(selected){ $('#csv_file_selected').show(); $('#csv_file_uploader').hide(); } var truncateAuthorized = 1; enableHistory(); $('#preview_import').submit(function(e) { if ($('#truncate').get(0).checked) { if (truncateAuthorized) { if (!confirm('Are you sure that you would like to delete this entity' + ' ' + $.trim($('#entity > option:selected').text().toLowerCase()) + '?')) e.preventDefault(); } else { jAlert('You do not have permission to delete this. When the MultiStore mode is enabled, only a SuperAdmin can delete all items before an import.'); return false; } } }); $("select#entity").change(function() { if ($("#entity > option:selected").val() == 8 || $("#entity > option:selected").val() == 9) { $("#truncate").closest('.form-group').hide(); } else { $("#truncate").closest('.form-group').show(); } if ($("#entity > option:selected").val() == 9) { $(".import_supply_orders_details").show(); } else { $(".import_supply_orders_details").hide(); $('input[name=multiple_value_separator]').val(','); } if ($("#entity > option:selected").val() == 1 || $("#entity > option:selected").val() == 2) { $("#match_ref").closest('.form-group').show(); } else { $("#match_ref").closest('.form-group').hide(); } if ($("#entity > option:selected").val() == 1 || $("#entity > option:selected").val() == 0) { $(".import_products_categories").show(); } else { $(".import_products_categories").hide(); } if ($("#entity > option:selected").val() == 0 || $("#entity > option:selected").val() == 1 || $("#entity > option:selected").val() == 5 || $("#entity > option:selected").val() == 6) { $("#regenerate").closest('.form-group').show(); } else { $("#regenerate").closest('.form-group').hide(); } if ($("#entity > option:selected").val() == 0 || $("#entity > option:selected").val() == 1 || $("#entity > option:selected").val() == 3 || $("#entity > option:selected").val() == 4 || $("#entity > option:selected").val() == 5 || $("#entity > option:selected").val() == 6 || $("#entity > option:selected").val() == 7) { $("#forceIDs").closest('.form-group').show(); } else { $("#forceIDs").closest('.form-group').hide(); } $("#entitie").html($("#entity > option:selected").text().toLowerCase()); $.ajax({ url: 'ajax.php', data: { getAvailableFields:1, entity: $("#entity").val() }, dataType: 'json', success: function(j){ var fields = ""; $("#availableFields").empty(); for (var i = 0; i < j.length; i++) fields += j.field; $("#availableFields").html(fields); $('.help-tooltip').tooltip(); }, error: function(j){} }); }); $("select#entity").trigger('change'); $('#file-selectbutton').click(function(e){ $('#file').trigger('click'); }); $('#filename').click(function(e){ $('#file').trigger('click'); }); $('#file').change(function(e){ var val = $(this).val(); var file = val.split(/[\\/]/); $('#filename').val(file[file.length-1]); }); });

[Guest]

Looks like you are not matching your CSV file columns with the prestashop column titles

 

make sure these settings match your csv file

 

 

then on the next screen make sure you match the column titles in prestashop with the correct data in your csv files. 

Should look something like this

 

If it still does not work add screen prints of the same screens I have so I can see what is happening. And attach the actual csv file

 

Also, in the CSV import screen click "help" at the top right hand side and it will give you a lot of info about the process

 

[shida]

Hi Haylau, thank you again for answer appreciated. Honestly i didnt get it how it works. Would you mind to give me your email so i would send the csv file and you will see?

 

Thank you

Regards

[Guest]

You can send me a private message. Just hover over my profile