Post by bingo » Thu May 03, 2012 12:07 am

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.

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.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by loukiad » Thu May 03, 2012 2:34 am

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?

New member

Posts

Joined
Fri Oct 28, 2011 11:45 pm

Post by bingo » Thu May 03, 2012 3:07 am

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

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.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by cjinternet » Wed Jul 04, 2012 6:26 pm

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?

Newbie

Posts

Joined
Thu Aug 05, 2010 3:55 pm

Post by bingo » Fri Jul 06, 2012 10:44 am

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.

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.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by kpurcell » Thu Aug 09, 2012 1:22 am

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?

Newbie

Posts

Joined
Thu Aug 09, 2012 1:18 am

Post by bingo » Thu Aug 09, 2012 2:27 pm

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.

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.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by evin » Thu Sep 06, 2012 1:06 am

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

Newbie

Posts

Joined
Sat Jul 07, 2012 8:41 pm

Post by grazianodemaio » Thu Sep 06, 2012 7:31 pm

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


Posts

Joined
Tue Aug 21, 2012 9:55 pm

Post by rosswakelin » Mon Oct 15, 2012 3:56 pm

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

Newbie

Posts

Joined
Mon Oct 15, 2012 3:52 pm

Post by champton » Sun Oct 28, 2012 10:29 am

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:

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 US

Newbie

Posts

Joined
Tue Sep 29, 2009 9:25 pm

Post by VictorDrummond » Sun Dec 23, 2012 11:09 pm

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.

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.


User avatar
Active Member

Posts

Joined
Sat Dec 15, 2012 12:41 pm
Location - On the balcony slammin' Margaritas

Post by iksan_ps » Mon Apr 29, 2013 5:16 pm

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

Newbie

Posts

Joined
Mon Apr 29, 2013 5:14 pm

Post by digitaltag » Thu May 09, 2013 12:37 am

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.

Newbie

Posts

Joined
Thu Aug 02, 2012 8:07 pm

Post by columstore » Thu Jun 06, 2013 1:15 am

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

Newbie

Posts

Joined
Thu Jun 06, 2013 1:11 am

Post by ocdavid » Tue Jun 11, 2013 10:29 am

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

Newbie

Posts

Joined
Fri Oct 19, 2012 1:11 pm

Post by FaeCaverns » Wed Jun 19, 2013 3:39 pm

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 ???
Last edited by FaeCaverns on Wed Jun 19, 2013 4:58 pm, edited 1 time in total.

Newbie

Posts

Joined
Tue Jun 18, 2013 6:10 pm

Post by FaeCaverns » Wed Jun 19, 2013 4:57 pm

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. :'(

Newbie

Posts

Joined
Tue Jun 18, 2013 6:10 pm

Post by yeagerd » Fri Jun 28, 2013 6:57 pm

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.

Newbie

Posts

Joined
Wed Sep 21, 2011 7:21 pm

Post by jackal999 » Sat Aug 03, 2013 12:19 am

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

Newbie

Posts

Joined
Sat Aug 03, 2013 12:15 am
Who is online

Users browsing this forum: No registered users and 5 guests