Post
by Gift&Ship » Wed Aug 09, 2017 7:10 am
Hi Guys,
I have installed Open Cart 3.0.2.0 and downloaded this extension. I'm having a few problems I can't seem to sort out...
Firstly, when I filled out the Excel Workbook to uploads my products, I have encountered several errors and I'm hoping you guys might know what it means or have seen it before and have solved this. This is a clip of what I'm getting:
2017-08-08 21:13:43 - Export/Import: Missing product_ids in worksheet 'Products'!
2017-08-08 21:13:43 - Export/Import: Missing product_ids in worksheet 'ProductSEOKeywords'!
2017-08-08 21:13:43 - Export/Import: Invalid store_id='' used in worksheet 'ProductSEOKeywords'!
2017-08-08 21:13:43 - Export/Import: Invalid store_id='' used in worksheet 'ProductSEOKeywords'!
Now I can't see how there is missing Product_ID's as I've only added the ones I've needed and nothing more. I figured it was my formula's at first, but I get the same problem when I Copy everything and Paste Values which gets rid of the formulas, but this does not work. I ended up making each product manually and then exported them. There was no difference that I could see at all, so I added products onto that export file, only to discover that when I imported it with my product additions, it wouldn't accept it. I then even did an export and straight away imported that very file, and magically, it works! Am I missing something?
As for the Invalid store_id, its always been 0...I don't knwo what else has changed. I even went as far as to use the export sheet to copy the entire sheets and pasted the formatting on my sheet so everything is exact as it should be...yet this does not work either...any ideas guys?
As for my second issue...for the few times I mystically made an upload work, I put the links to the pictures exactly as they should be and yet it does not do the pictures, it leaves them blank. At first I tried with links to external sites to try and import them that way, didn't work, then I added them onto my hosting server and doing it that way...didn't work either. Yet I do an export and import that very file, and yet again, magically it keeps the pictures, rather than leaving it blank...
Any help you guys have will be very much appreciated. Thank you.
P.S. Hope that lot made some form of sense...lol
P.S.S. Sorry for the 'essay' post