OpenCart Community

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!

do not work together.

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?

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?

you will be able to use without the extra filters.
Since our extension located in catalog - product import/export,all brand new files.

bingo

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?

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?

upload to server and insert the urls.

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?

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?

empty excel file means pear function can not write contents to excel.
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.

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

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

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 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:

Howdy 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.

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.

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'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

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

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.

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.

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