Ayeom Posted October 29, 2012 Share Posted October 29, 2012 Hello all This is my first post, so please let me know if there is any info that I am leaving out. I am running presta shop 1.5, installed less then a week ago. I am exploring all of the product tables as an alternative to using the CSV import method which seems to be timing out per about 1000 products while also skipping over some of my products and leaving me quite clueless whats missing from my catalog after an import. I want to import my products using SQL queries but I came across an interesting "problem?" It seems presta shop stores six Product_Lang records per product? It that necessary? a bug? See my attached .jpg . What am I missing? Thanks everyone for your time. Link to comment Share on other sites More sharing options...
Ayeom Posted October 29, 2012 Author Share Posted October 29, 2012 Solution: The database builds a language translation record for the default six languages, even if those languages are not enabled. Deleting the languages removed the duplicate reccords. This should be the default, no? Seems rather clunky to have that many duplicate reccords for no reason. Also makes my life easier by not having to standardize the sql im going to write to add five times the data for no reason. Link to comment Share on other sites More sharing options...
Ayeom Posted October 29, 2012 Author Share Posted October 29, 2012 For all I know, the CSV might actually be able to handle more products at a time now. Will test and post back. Link to comment Share on other sites More sharing options...
Recommended Posts