Arometique Fashions Posted February 26, 2016 Share Posted February 26, 2016 Is there anyone here who can tell me what is wrong with this file i am testing to import my products? The fields won't separate and no matter what i try still cannot load anything using excel file. Zip attached. Link to comment Share on other sites More sharing options...
NemoPS Posted March 4, 2016 Share Posted March 4, 2016 There is no zip attached.In any case you can only import files in csv format Link to comment Share on other sites More sharing options...
bellini13 Posted March 5, 2016 Share Posted March 5, 2016 excel file extension is .xls or .xlsx csv is comma separated values excel != csv Link to comment Share on other sites More sharing options...
Arometique Fashions Posted March 6, 2016 Author Share Posted March 6, 2016 Thanks for all your replies, i realized i did not attach a file but the troubles i have experienced has made me to look elsewhere for a cart that can import products placed within separate excel cells rather than been jumbled together in this stupid useless semi colon and endless quotation marks. I have an excel file with over 36,000 products and these will have to be converted to the Presta style, the only way to do this will be to configure each cell with a semi colon, how long will that take? Every file i try to load into the store by Admin using the suggested headings and format is rejected... Finally got some done with eMagic One Store Manager on a free trial... Presta is great but the file format sucks.. Anyone has a bullet proof way of converting and loading files in Presta format? Link to comment Share on other sites More sharing options...
bellini13 Posted March 6, 2016 Share Posted March 6, 2016 you realize you can "save as" a csv file from within excel? Link to comment Share on other sites More sharing options...
Arometique Fashions Posted March 6, 2016 Author Share Posted March 6, 2016 Wow!! Did you even read the message? I am not asking about saving, its about converting 36,000 products in excel single cell to the jumbled up semi colon joined format used by Presta Shop. It will take months to go through them and join them up to the excel format they use. Link to comment Share on other sites More sharing options...
bellini13 Posted March 7, 2016 Share Posted March 7, 2016 so tell me exactly how you place everything about a product into a SINGLE CELL in excel? and how useful that can actually be to anyone? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now