I am having trouble importing my products, well not so much trouble importing them as making them show up on my shopping cart.
All my products show up in the admin panel just fine however they do not show up on my store front at all. In fact only two products show up. Please any help would be appreciated.
Thanks.
Hi,
Firstly apologies if this is not the right way to reach out for help, let me know if I need to find another forum. I am trying to get this great add-on working on a localhost version. I have the following setup;
OpenCart 1.5.4, Export/Import 1.5.4-x Exp/Imp 13, VQMOD 2.4.1 and XAMPP OS X 1.8.3-0 on OS X 10.8.4.
I have a site on an Arvixe web host and that all works. I want to export from the Arvixe site to an XLS and then upload to the local site where I want to make changes, sort out some new templates etc. Downloading works, but when I uploaded the first time to the local version, I lost all the product and categories in the sample setup. So I cleared the XLS down to just a couple of products and categories (see attached). When I load this, the load says it was a Success, but nothing shows in the Products or Categories section (or MySQL tables). I have no errors in logs that I can see.
I appreciate that OpenCart and Import/Export works (as it does on the Arvixe site), but really looking for a good samaritan that could give me some pointers as to why the local version may not be working.
Any ideas?
Yours hopefully, Simon
Firstly apologies if this is not the right way to reach out for help, let me know if I need to find another forum. I am trying to get this great add-on working on a localhost version. I have the following setup;
OpenCart 1.5.4, Export/Import 1.5.4-x Exp/Imp 13, VQMOD 2.4.1 and XAMPP OS X 1.8.3-0 on OS X 10.8.4.
I have a site on an Arvixe web host and that all works. I want to export from the Arvixe site to an XLS and then upload to the local site where I want to make changes, sort out some new templates etc. Downloading works, but when I uploaded the first time to the local version, I lost all the product and categories in the sample setup. So I cleared the XLS down to just a couple of products and categories (see attached). When I load this, the load says it was a Success, but nothing shows in the Products or Categories section (or MySQL tables). I have no errors in logs that I can see.
I appreciate that OpenCart and Import/Export works (as it does on the Arvixe site), but really looking for a good samaritan that could give me some pointers as to why the local version may not be working.
Any ideas?
Yours hopefully, Simon
Attachments
Basic product and category load
sexypetals: I think your problem is caused by your non-English language setting, you are using language_id=3 in your spreadsheet worksheets. In order to import for your non-English language, go to the admin backend, under
System > Settings > Edit > Tab Local > Language
and set it to your non-English language. Then do an Import.
System > Settings > Edit > Tab Local > Language
and set it to your non-English language. Then do an Import.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have an opencart 1.5.4.1. and installed the module. I first exported a new file, made some changes but now alot of products don't have the procuct tags anymore? I tried a new version but i cannot run that because of memory limits ( i tried to upgrade the memory in the php.ini, and htaccess)
In the excell sheet the tags are still there but opencart can't find them.
In the excell sheet the tags are still there but opencart can't find them.
Hi All,
I'm using 1.5.5.1.
I was using this tool and was working fine. I only have 300ish products on the store, so no problem with downloading and was very quick.
There were some changes done, were SKUs was added to product options and ever since then when i export, it looks like it works, but I open with Openoffice and get:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in .../public_html/system/PHPExcel/Classes/PHPExcel/Cell.php on line 532
Looking at this line, the issue looks to be:
How can i fix this? and is there any way I can amend the extension to be able to also export product option SKUs?
Much appreciated to you all.
Regards,
Helen
I'm using 1.5.5.1.
I was using this tool and was working fine. I only have 300ish products on the store, so no problem with downloading and was very quick.
There were some changes done, were SKUs was added to product options and ever since then when i export, it looks like it works, but I open with Openoffice and get:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in .../public_html/system/PHPExcel/Classes/PHPExcel/Cell.php on line 532
Looking at this line, the issue looks to be:
Code: Select all
return array($matches[1],$matches[2]);Much appreciated to you all.
Regards,
Helen
See Common OpenCart Errors and How to Solve Them on how to resolve this.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
@JNeuhoff thanks for the link.
I had already asked our host to increase the memory to 128mb and also altered the php.ini file but still the same problem.
I believe it is related to the database amendment that was done (integration company adding SKUs to product options). As I mentioned in my original post, I only have approx. 300 products so there's no real reason for the exporting to be so intense on the system that it needs so much memory. Most posts here are related to products in the thousands.
Any help from anyone that can perhaps have a look would be much appreciated.
Regards,
Helen
I had already asked our host to increase the memory to 128mb and also altered the php.ini file but still the same problem.
I believe it is related to the database amendment that was done (integration company adding SKUs to product options). As I mentioned in my original post, I only have approx. 300 products so there's no real reason for the exporting to be so intense on the system that it needs so much memory. Most posts here are related to products in the thousands.
Any help from anyone that can perhaps have a look would be much appreciated.
Regards,
Helen
Can anyone help me.
I am getting this error.
I uploadet images via ftp and set the name in the import tool (xlsx file).
Now I dont see the image on my site and get this warning.
warning: imagecopyresampled(): supplied argument is not a valid Image resource in /var/www/vhosts/domain.com/subdomains/tiskaj/httpdocs/system/library/image.php on line 109Warning: imagedestroy(): supplied argument is not a valid Image resource in /var/www/vhosts/domain/subdomains/tiskaj/httpdocs/system/library/image.php on line 110
Thanks for any responde.
I am getting this error.
I uploadet images via ftp and set the name in the import tool (xlsx file).
Now I dont see the image on my site and get this warning.
warning: imagecopyresampled(): supplied argument is not a valid Image resource in /var/www/vhosts/domain.com/subdomains/tiskaj/httpdocs/system/library/image.php on line 109Warning: imagedestroy(): supplied argument is not a valid Image resource in /var/www/vhosts/domain/subdomains/tiskaj/httpdocs/system/library/image.php on line 110
Thanks for any responde.
Hi
i have installed the latest OC 1.5.6 and also the latest import/export opencart tool.
i want to export data from ekmpowershop to opencart. the OC ecommerce is hosted by 123reg
to the best of my knowledge i have tried different things so it can work. i have over 4k products to export from ekm to OC.
the error logs says:
2013-09-11 08:36:55 - Export/Import: Invalid number of worksheets, 8 worksheets expected
so i have tried to create 8 worksheets and the error log says:
2013-09-10 22:02:49 - PHP Fatal Error: Out of memory (allocated 31719424) (tried to allocate 786432 bytes) in /websites/123reg/LinuxPackage23/xx/xx/xx/xxxxxxxxxx.co.uk/public_html/xxxxxxxxxxx/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 950
can anyone tell me what i am doing wrong? what are the 8 worksheets OC expect to receive?
Can anyone provide me with an example of excel doc containing the 8 worksheets OC expects?
re-uploading over 4k products is not an option as it will take over 9 months to do.
any help is greatly appreciated. im very stuck here
i have installed the latest OC 1.5.6 and also the latest import/export opencart tool.
i want to export data from ekmpowershop to opencart. the OC ecommerce is hosted by 123reg
to the best of my knowledge i have tried different things so it can work. i have over 4k products to export from ekm to OC.
the error logs says:
2013-09-11 08:36:55 - Export/Import: Invalid number of worksheets, 8 worksheets expected
so i have tried to create 8 worksheets and the error log says:
2013-09-10 22:02:49 - PHP Fatal Error: Out of memory (allocated 31719424) (tried to allocate 786432 bytes) in /websites/123reg/LinuxPackage23/xx/xx/xx/xxxxxxxxxx.co.uk/public_html/xxxxxxxxxxx/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 950
can anyone tell me what i am doing wrong? what are the 8 worksheets OC expect to receive?
Can anyone provide me with an example of excel doc containing the 8 worksheets OC expects?
re-uploading over 4k products is not an option as it will take over 9 months to do.
any help is greatly appreciated. im very stuck here
imverypoor: Do an Export first from your Opencart sample data to see the exact format of the 8 worksheets.
As regards your memory problem: This same question has been asked so many times, you have to drastically increase your memory_limit PHP setting.
As regards your memory problem: This same question has been asked so many times, you have to drastically increase your memory_limit PHP setting.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello JNeuhoff,
I tried your mod this morning, looks like it would work good for a first time import or some maintenance issues, but looks like it would be a lot of work to use it to add products every once in awhile.
JNeuhoff, what do you use this mod for?
What do other users use this for?
JNeuhoff, Have you ever looked at Easy Populate CSV used with zencart?
Located here: http://www.zen-cart.com/downloads.php?do=file&id=868
I am sure it would be a complete re-code if you were to... for OC. I have used this module with zencart a lot and it works superbly.
And please no posts about other modules.... Thanks for your response to my questions.
I tried your mod this morning, looks like it would work good for a first time import or some maintenance issues, but looks like it would be a lot of work to use it to add products every once in awhile.
JNeuhoff, what do you use this mod for?
What do other users use this for?
JNeuhoff, Have you ever looked at Easy Populate CSV used with zencart?
Located here: http://www.zen-cart.com/downloads.php?do=file&id=868
I am sure it would be a complete re-code if you were to... for OC. I have used this module with zencart a lot and it works superbly.
And please no posts about other modules.... Thanks for your response to my questions.
Alvin
Hi,
Firstly I love the import/export tool and thank you for developing it.
I have installed and it exports perfectly but I am getting errors when trying to import. I might be able to solve my problem myself if you first tell me how many of the products fields are compulsory, as in must have some content? I am wondering if I have overlooked something that is a must.
Thanks in anticipation.
Johanne
Firstly I love the import/export tool and thank you for developing it.
I have installed and it exports perfectly but I am getting errors when trying to import. I might be able to solve my problem myself if you first tell me how many of the products fields are compulsory, as in must have some content? I am wondering if I have overlooked something that is a must.
Thanks in anticipation.
Johanne
Dear JNeuhoff,
does this Ext. work with Custom theme?
I already import product to my OC without any error but when I go to my admin product page I don't find any product there , but when I checked my DB product Table I found the product inserted on the table.
what the issue could be ?
please help
does this Ext. work with Custom theme?
I already import product to my OC without any error but when I go to my admin product page I don't find any product there , but when I checked my DB product Table I found the product inserted on the table.
what the issue could be ?
please help
I am unable to reproduce your error, yuou simply don't provide enough details.mfairouz wrote:Dear JNeuhoff,
does this Ext. work with Custom theme?
I already import product to my OC without any error but when I go to my admin product page I don't find any product there , but when I checked my DB product Table I found the product inserted on the table.
what the issue could be ?
please help
It should work with custom themes as long as these are compliant to Opencart standards. However, there are some web themes out there, especially from 'themeburn.com', which tend to break many VQmod XML scripts, such as 'shoppica'.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello,
Thanks for plugin but have problem with it. It looks like on hosting but there must be some workaround. Here is error:
Could you tell me what can be problem and how to fix it?
Thanks for plugin but have problem with it. It looks like on hosting but there must be some workaround. Here is error:
Code: Select all
2013-10-28 1:37:30 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/home/users/xube/:/usr/share/pear/) in /home/users/xube/letaky24.sk/web/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-10-28 1:37:30 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/home/users/xube/:/usr/share/pear/) in /home/users/xube/letaky24.sk/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 205
2013-10-28 1:37:30 - PHP Exception: Could not close zip file php://output. in /home/users/xube/letaky24.sk/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378Yes, switch web host. Seriously, some web hosts are not worth your money.xube wrote:Hello,
Thanks for plugin but have problem with it. It looks like on hosting but there must be some workaround. Here is error:
.....
Could you tell me what can be problem and how to fix it?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hey guys!
Shop A is 1.5.4
Shop B is 1.5.5.1
I am asking because Shop A is a live shop and if the above is not possible I would prefer not to mess/alter with the files & configuration of the live shop, for no reason.
Thank you for your awesome work, JNeuhoff!
- Parameters:
- 1) Shop A has 1000 products in 2 languages, English and Greek
- 2) Shop B is new
- Problem:
- Export all English products from Shop A and Import them on Shop B
- Is this possible? Any suggestions on how to approach this?
Shop A is 1.5.4
Shop B is 1.5.5.1
I am asking because Shop A is a live shop and if the above is not possible I would prefer not to mess/alter with the files & configuration of the live shop, for no reason.
Thank you for your awesome work, JNeuhoff!
Hi all, This mod works brilliantly.
I too would like to add more info into the excel sheet however one of the fields i want to get is from another table `oc_option_value` there is a field called `color_code`
Any ideas how to do this?
I too would like to add more info into the excel sheet however one of the fields i want to get is from another table `oc_option_value` there is a field called `color_code`
Any ideas how to do this?
Hi all!
I'm using 1.5.4.1 and version 13 of the Export/Import tool.
With the help of Qphoria a few years back I managed to make a little mod for the version 1.4.1.x I used. The problem is that after I upgraded to 1.5.4.1 this mod doesn't fully work.
What's it about:
I have around 2000 products. A few hundreds of them have a photo. On my server the photo's name are the same as product model, but with the .jpg extension.
Example: product model: 96535010. For this product, its' photo is 96535010.jpg
Well, the mod for your E/I tool did the following thing: checking for every product model if it has a productmodel.jpg on the server. If that product has it, show it. If not, put default no_image.jpg instead, for every product that doesn't have a photo on the server.
This is where the problem rises. It no longer shows no_image.jpg when I run the E/I Tool.
Qphoria replaced in admin/model/tool/export.php:
with:
Question is: when I use the import tool, how can I make my shop automatically show no_image.jpg for every product that has no photo on the server, like it did on the Opencart Ver. 1.4.x?
I'm using 1.5.4.1 and version 13 of the Export/Import tool.
With the help of Qphoria a few years back I managed to make a little mod for the version 1.4.1.x I used. The problem is that after I upgraded to 1.5.4.1 this mod doesn't fully work.
What's it about:
I have around 2000 products. A few hundreds of them have a photo. On my server the photo's name are the same as product model, but with the .jpg extension.
Example: product model: 96535010. For this product, its' photo is 96535010.jpg
Well, the mod for your E/I tool did the following thing: checking for every product model if it has a productmodel.jpg on the server. If that product has it, show it. If not, put default no_image.jpg instead, for every product that doesn't have a photo on the server.
This is where the problem rises. It no longer shows no_image.jpg when I run the E/I Tool.
Qphoria replaced in admin/model/tool/export.php:
Code: Select all
$imageName = $product['image'];Code: Select all
$imageName = (($product['image']) ? $product['image'] : (($model) ? "data/produse/$model.jpg" : ""));I'm using Open Cart 1.5.4.1 on http://www.importpieseauto.ro
Who is online
Users browsing this forum: No registered users and 8 guests
