do not work together.loukiad wrote:hello,
i checked the demo page and I have one question. Is it possible to select the products I want to export(and update) by manufacturer or product category??
I've already installed another extension ( http://www.opencart.com/index.php?route ... order=DESC) which gives me this option but I don't know if it will work probebly in combination...
can you please take a look and let me know??
thanks a lot in advance!
One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.
you will be able to use without the extra filters.loukiad wrote:Thank you for the quick response!
So if I use your extension I will have to cancel the other one?
or will I still be able to use yours just without the extra filters?
Since our extension located in catalog - product import/export,all brand new files.
bingo
One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.
Hi, what's the best method for approaching product images for new products? Is the only way to FTP them up to the server and insert the relative URLs? Is there a nice automated approach?
upload to server and insert the urls.cjinternet wrote:Hi, what's the best method for approaching product images for new products? Is the only way to FTP them up to the server and insert the relative URLs? Is there a nice automated approach?
One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.
empty excel file means pear function can not write contents to excel.kpurcell wrote:Installed v1.0 & v1.1 but in either case I get a empty Excel file. The weird thing is that the excel file size does get bigger with the more products selected to export!
Anyone have a similar issue?
First,check if you set write permission to system/cache/
if not,set first and try again.
If problem still the same,please contact your server for help.
Ask them you have install the excel export,but can export excel,but it is expty excel file.
The extension using pear function.
See if they can help.
One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.
I have a question. I've tried the demo but I couldn't figure out how can I insert data to 2nd language.
There's english and chinese on the demo. When I export something to excel, there's no column to insert second language data on the excel file.
Could you please explain it for me, I really need this add-on.
Regards
There's english and chinese on the demo. When I export something to excel, there's no column to insert second language data on the excel file.
Could you please explain it for me, I really need this add-on.
Regards
Hallo, I'm using your beautiful plugin on my opencart. I have a question, I have a problem updating via Xls the "additionalimage" path.
If I add image ok, but if I need to delete images added for error I can't do it; clean the cell, update, but the additionalimages are still there, any advise?
Thaks in advance
Graziano De Maio
Gdmtech.it
If I add image ok, but if I need to delete images added for error I can't do it; clean the cell, update, but the additionalimages are still there, any advise?
Thaks in advance
Graziano De Maio
Gdmtech.it
Hi
I just purchased the utility - it look like it might just work for me.....but
I am getting the error message:
Import: Invalid header in the Products worksheet
I have saved the spreadsheet as excel 2003 compatible, and excel 95/2000 compatible and I still get that error.
The spreadsheet just consists of one header line, and one product line. Any hints what that error message
really means?
Thanks
Ross
I just purchased the utility - it look like it might just work for me.....but
I am getting the error message:
Import: Invalid header in the Products worksheet
I have saved the spreadsheet as excel 2003 compatible, and excel 95/2000 compatible and I still get that error.
The spreadsheet just consists of one header line, and one product line. Any hints what that error message
really means?
Thanks
Ross
I just installed and it exports perfectly, but when I try to import 100 or so products in one spreadsheet, I get this error:
Fatal error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /home/content/t/l/c/tlcincorporate/html/tlg/admin/model/catalog/productimportexport.php(1181): PHPExcel_Reader_Excel5->load('/tmp/phpL8UDgJ') #3 /home/content/t/l/c/tlcincorporate/html/tlg/admin/controller/catalog/productimportexport.php(352): ModelCatalogProductImportExport->upload('/tmp/phpL8UDgJ', '1') #4 [internal function]: ControllerCatalogProductImportExport->bulk() #5 /home/content/t/l/c/tlcincorporate/html/tlg/vqmod/vqcache/vq2-system_engine_front.php(47): call_user_func_array(Array, Array) #6 /home/content/t/l/c/tlcincorpo in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91
Fatal Error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /home/content/t/l/c/tlcincorporate/html/tlg/admin/model/catalog/productimportexport.php(1181): PHPExcel_Reader_Excel5->load('/tmp/phpL8UDgJ') #3 /home/content/t/l/c/tlcincorporate/html/tlg/admin/controller/catalog/productimportexport.php(352): ModelCatalogProductImportExport->upload('/tmp/phpL8UDgJ', '1') #4 [internal function]: ControllerCatalogProductImportExport->bulk() #5 /home/content/t/l/c/tlcincorporate/html/tlg/vqmod/vqcache/vq2-system_engine_front.php(47): call_user_func_array(Array, Array) #6 /home/content/t/l/c/tlcincorpo in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91
Here is the code fix:
Fatal error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /home/content/t/l/c/tlcincorporate/html/tlg/admin/model/catalog/productimportexport.php(1181): PHPExcel_Reader_Excel5->load('/tmp/phpL8UDgJ') #3 /home/content/t/l/c/tlcincorporate/html/tlg/admin/controller/catalog/productimportexport.php(352): ModelCatalogProductImportExport->upload('/tmp/phpL8UDgJ', '1') #4 [internal function]: ControllerCatalogProductImportExport->bulk() #5 /home/content/t/l/c/tlcincorporate/html/tlg/vqmod/vqcache/vq2-system_engine_front.php(47): call_user_func_array(Array, Array) #6 /home/content/t/l/c/tlcincorpo in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91
Fatal Error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /home/content/t/l/c/tlcincorporate/html/tlg/admin/model/catalog/productimportexport.php(1181): PHPExcel_Reader_Excel5->load('/tmp/phpL8UDgJ') #3 /home/content/t/l/c/tlcincorporate/html/tlg/admin/controller/catalog/productimportexport.php(352): ModelCatalogProductImportExport->upload('/tmp/phpL8UDgJ', '1') #4 [internal function]: ControllerCatalogProductImportExport->bulk() #5 /home/content/t/l/c/tlcincorporate/html/tlg/vqmod/vqcache/vq2-system_engine_front.php(47): call_user_func_array(Array, Array) #6 /home/content/t/l/c/tlcincorpo in /home/content/t/l/c/tlcincorporate/html/tlg/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91
Here is the code fix:
Code: Select all
Index: Classes/PHPExcel/Shared/CodePage.php
===================================================================
--- Classes/PHPExcel/Shared/CodePage.php (revision 66289)
+++ Classes/PHPExcel/Shared/CodePage.php (working copy)
@@ -45,6 +45,7 @@
*/
public static function NumberToName($codePage = '1252')
{
if($codePage == 0) $codePage = 1252;//add this line right here.
switch ($codePage) {
case 367: return 'ASCII'; break; // ASCII
case 437: return 'CP437'; break; //OEM USHowdy Bingo,
I've installed this import/export tool onto my opencart 1.5.4.1...
Finally I got it to export a spreadsheet with my existing three products which I opened and, copying the exact same formats of the fields, added three new products (excluding any values in "model codes" as per the above instruction), deleted the first three, saved the spreadsheet without changing neither the name or .xls file extension then tried to upload as "insert".
I get the error message: "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!"
I'm wondering what the issue is, including is there a compatibility issue with open source Office?
And as a matter of interest, I downloaded the "sample-insert" spreadsheet from your website and it won't accept that one either.
I've installed this import/export tool onto my opencart 1.5.4.1...
Finally I got it to export a spreadsheet with my existing three products which I opened and, copying the exact same formats of the fields, added three new products (excluding any values in "model codes" as per the above instruction), deleted the first three, saved the spreadsheet without changing neither the name or .xls file extension then tried to upload as "insert".
I get the error message: "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!"
I'm wondering what the issue is, including is there a compatibility issue with open source Office?
And as a matter of interest, I downloaded the "sample-insert" spreadsheet from your website and it won't accept that one either.
Hosting for Oc 2.x: Well tested on 2.03.1 including emails work correctly, cPanel Shared or WHM VPS, managed security, fast & reliable SSD drives, Raid 10 /4 disk redundancy, server locale - Texas, contact me to discuss further.
Active Member
hello Bingo, i managed to install the extension, but when i try to test it and export a file, the xcel file got the error notice(the file you are trying to open, 'download_products.xls', is in a different format than specified by the file extension. verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?) and resulted in a blank file. can you please help me? thx
Hello
I have purchased this extension and it works brilliantly apart from one thing. When I export a product to an excel file the the additional images are in reverse order and then when i import the excel file the sort order of all the additional images is set to 0. Is this a bug or something that i am missing.
Thanks.
I have purchased this extension and it works brilliantly apart from one thing. When I export a product to an excel file the the additional images are in reverse order and then when i import the excel file the sort order of all the additional images is set to 0. Is this a bug or something that i am missing.
Thanks.
Hi!
I am using two languages, which are English and Traditional Chinese and installed the product-import-export-v2.1
The bulk items uploaded successfully and works for English front end. Yet, when select Chinese, it doesn't work.
I can see the item on the product list. but when I click the item, it shows item no found.
What can I do?
Thanks!
David
I am using two languages, which are English and Traditional Chinese and installed the product-import-export-v2.1
The bulk items uploaded successfully and works for English front end. Yet, when select Chinese, it doesn't work.
I can see the item on the product list. but when I click the item, it shows item no found.
What can I do?
Thanks!
David
I've used the free Import/Export extension from JNeuhoff, but that extension replaces all the categories and products every time it's run (it's not designed to add to the database, just replace what's there). This is fine (and that extension works very well) if you're only going to do a one-time import, but I need an extension I can use on an ongoing basis to add a new batch of products from time to time without destroying what's already on the database. Does your Bulk Insert Update Export extension support this? If not, can you suggest another extension that does?
Thanks.
David
Thanks.
David
Fatal error: Class 'PHPExcel_Reader_' not found in /[...]/public_html/ocart/system/PHPExcel/Classes/PHPExcel/IOFactory.php on line 170
Does anyone know how to fix this error. I am using Open Cart 1.5.5.1
Does anyone know how to fix this error. I am using Open Cart 1.5.5.1
Last edited by FaeCaverns on Wed Jun 19, 2013 4:58 pm, edited 1 time in total.
Fatal error: Class 'PHPExcel_Worksheet_AutoFilter' not found in /[...]/public_html/ocart/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 370
I got rid of the last one, now I cannot get rid of this one.
I got rid of the last one, now I cannot get rid of this one.
Hello,
I am getting a strange error (clean logs) with my install of the script. I have a very small shop with 39 products. They will download but when you go to open in excel it says the data is corrupt and it can try to fix it. It averages 14-19 of the 39 with varying degrees of success. The error log has no mention of the script of all.... excel has:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/sprea ... ary>Errors were detected in file 'C:\Users\David\Downloads\download_products (1).xls'</summary><additionalInfo><info>Excel recovered your formulas and cell values, but some data may have been lost.</info></additionalInfo></recoveryLog>
I can log into to the database directly with excel and pull down a clean copy of the full database in .sql, seems data is clean.
I am getting a strange error (clean logs) with my install of the script. I have a very small shop with 39 products. They will download but when you go to open in excel it says the data is corrupt and it can try to fix it. It averages 14-19 of the 39 with varying degrees of success. The error log has no mention of the script of all.... excel has:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/sprea ... ary>Errors were detected in file 'C:\Users\David\Downloads\download_products (1).xls'</summary><additionalInfo><info>Excel recovered your formulas and cell values, but some data may have been lost.</info></additionalInfo></recoveryLog>
I can log into to the database directly with excel and pull down a clean copy of the full database in .sql, seems data is clean.
Hi Guys
I am trying to import 7K products onto a clean install.
I am getting the following message:-
Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/masbus/public_html/admin/model/catalog/productimportexport.php on line 1176
Any idea how I correct it please?
Many thanks in advance!!
J
I am trying to import 7K products onto a clean install.
I am getting the following message:-
Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/masbus/public_html/admin/model/catalog/productimportexport.php on line 1176
Any idea how I correct it please?
Many thanks in advance!!
J
Who is online
Users browsing this forum: No registered users and 17 guests
