Benham Collectibles Posted July 9, 2010 Share Posted July 9, 2010 I currently have a live Zen Cart site right now that works well enough to sell stuff for me. Therefore, to replace Zen Cart, this has to be better.I successfully sell individual baseball cards in my store, so my inventory will get into the millions at some point, so I absolutely have to have bulk uploading. With that said, I couldn't help but notice the blatant hatefulness for Excel in some of these posts. I absolutely have to use Excel for my bulk importing. I have been using Excel for so many years that I can't possibly spend the time to learn another program, knowing how long it took me with Excel.If Prestashop is not right for me, with everyone now knowing what my requirements are, please let me know so I don't waste a boatload of my time trying to make something work that isn't going to work no matter what.Kristofer Link to comment Share on other sites More sharing options...
rocky Posted July 10, 2010 Share Posted July 10, 2010 To import millions of products using PrestaShop's CSV import tool is quite difficult, since your server will keep timing out, and there is no simple "Resume" button. You must instead re-select the CSV file, then figure out yourself which row it stopped on, then enter that row number in the "Start from" field. If this is easier in ZenCart, then you should stick with it. Link to comment Share on other sites More sharing options...
Benham Collectibles Posted July 10, 2010 Author Share Posted July 10, 2010 I appreciate your reply, but that is not the question that I was asking. I am wanting to know if I absolutely cannot use Excel to create the CSV files needed for import into Prestashop. There was so much negativity about Excel, I am not positive that it can be used. If that is true, or if it can be used, but is very difficult, then I cannot use Prestashop for a store.I am aware that most shopping carts can import millions, even billions of items. I would never have suggested to do this in one upload. I was only trying to point out the fact that it is not intelligent for me to enter millions of items by hand, one at a time. And if there is a problem with the images uploading each time creating multiples of the same image, then that would be a negative as well. Because I already have a cart that works, I have to find one that is better than what I have for me to change it. I was hoping that Prestashop would be it, but it isn't looking good with what I have be reading in this forum. Link to comment Share on other sites More sharing options...
rocky Posted July 10, 2010 Share Posted July 10, 2010 There are some problems with the format that Excel saves its CSV files. I've personally managed to import CSV files exported by Excel, but I had to manually do a search and replace using Notepad afterwards to get the delimiters right. The problem is that Excel may choose not to escape some strings, which can cause problems, and it uses "," as the column delimiter, whereas PrestaShop uses ";" as the column delimiter and "," as the field delimiter by default. Link to comment Share on other sites More sharing options...
Benham Collectibles Posted July 10, 2010 Author Share Posted July 10, 2010 Thank you for explaining that there will be some difficulty with Excel. With the Zen Cart that I have now, I can import and export in .txt file format. All of my inventory files are set up for the Zen Cart way, and using Prestashop would make me have to change all of my files to .csv and run all of them through Notepad++ to get rid of the problems, whereas now, I don't have to do this. Thank you again. I will continue to look at my other options to see if there may be a better way.Kristofer Link to comment Share on other sites More sharing options...
rob84 Posted February 13, 2011 Share Posted February 13, 2011 Use Calc from OpenOffice. Simple perfect. I easly migrated from Virtuemart to Prestashop in few clicks. Trust me, download Calc. Link to comment Share on other sites More sharing options...
Recommended Posts