Post by munaim1 » Wed May 07, 2014 8:00 am

Hi,

This extension is working perfectly on our store, an absolute god send :) Just one question, do you know if the import export tool will work with this extension: http://www.opencart.com/index.php?route ... rch=remote

Thanks for your time.

Active Member

Posts

Joined
Tue Dec 10, 2013 2:05 am

Post by JNeuhoff » Wed May 07, 2014 5:44 pm

munaim1 wrote:Just one question, do you know if the import export tool will work with this extension:
Depends on whether there are underlying changes (e.g. new fields) done to the database.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Wed May 07, 2014 10:23 pm

@Mike I also emptied my vqmod cache and still get the double header titles.

I read the stuff about messing with the db but I don't want to start doing with that. I need a mod without such complications :)

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by rawmeattt » Thu May 08, 2014 12:33 am

Guys - do your importing and exporting - directly from your phpmyadmin - just did a 34,000 sku upload not one error.

For get using extra memory setting - upto a 1gb ??? c'mon - really !


Use cvs files looking into phpmyadmin download the sample info that is there when you do a fresh install and you will get to see how the headers are set up and how the info needs to be entered.

The excel files are overloading the system and are just full of bugs. The database uses CSV why use excel files.

Newbie

Posts

Joined
Mon Apr 28, 2014 5:21 am

Post by munaim1 » Thu May 08, 2014 3:10 am

JNeuhoff wrote:
munaim1 wrote:Just one question, do you know if the import export tool will work with this extension:
Depends on whether there are underlying changes (e.g. new fields) done to the database.
Image

Well looking at the screenshot of the extension it does create a URL field, not sure if your import export tool will capture that in the xl file. ???

Active Member

Posts

Joined
Tue Dec 10, 2013 2:05 am

Post by TAC » Thu May 08, 2014 4:06 am

@rawmeattt I thought that sounded like a good idea so I downloaded my db as a csv file but found the layout probably too confusing to replicate for new products :(

Others may not find it complicated of course :)

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by rawmeattt » Thu May 08, 2014 6:08 am

hi, the product section in the db is 13 files - not all are used. so if you download everything for the products then you will end-up with these 13 files on just one file. In that file you will end-up with 13 sections in length divided by headers.

So you make a master file (with all the headers in just one line) of this in excel as a csv file and then you place all your info there. You can then use your downloaded file just for a reference. Then you cut and paste the columns and save as files for each section.Then you upload 13 separate files, it takes just split seconds or less.

If there is an error and it tells you straight, error in line 50 or error in headers because you may have one extra or missing column. You don't have to email anyone because its easy.

Same thing for manufacturers and categories. I understand that it looks intimidating and it did to me at first as well.

You have to look at the phpmyadmin as the ultimate extension - then you will see its very basic and simplistic- you can erase and update fix things at will . Don't be scared to make a mess of it -you can just reload the startup database and start from something fresh.

trying to to upload everything - products,categories,manufacturers(not there), additional images, options, attributes,specials and discounts and reward -All in one file and then wonder what is wrong with the upload .NOT GOOD

Back to this import export thing - ever since my first battles with these very bad import/export tools I start using the database directly - its actually inexcusable and I am being polite. Anyone defending these extensions is laughing at all us users, anyone that keeps telling us to increase php memory to a 1gb is laughing at us. Trying to learn to deal with each extension free or purchased and all those bugs is an insult to the cart industry. I have never used excel files to upload to a database. I am not a coder, I am a user and I think these coders should go out and use the import and export features from other cart and copy the logic -yes copy the logic. I will again mention Pinnacle cart because there are no issues on their boards about importing or exporting - because it works and is a non issue. If they did not go to the pay by month type of sale, I would have kept buying more licenses.As for Opencart this cart is great in itself and almost all extensions I purchased I am totally pleased with but not the import export extensions - these functions should be part of the basic cart and not offered as an extension. Not doing this will turn off users and cost more in lost extension sales in the future.

ah now I feel better...

Newbie

Posts

Joined
Mon Apr 28, 2014 5:21 am

Post by Malaiac » Sun May 11, 2014 10:57 pm

@JNeuhoff : a way of bypassing upload limits on shared hosts would be to allow direct upload (via FTP) and to allow the extension to work from a local file. Memory limits would still be annoying.

New member

Posts

Joined
Thu Jan 07, 2010 12:06 am

Post by jeepstone » Fri May 16, 2014 5:15 pm

I've just tried to do a Product Filter import and my filter items have appeared as attributes. Does the filter import work?

They appear correctly when I export the spreadsheet, but if I update them and try to reimport, they appear as attributes. Is this a bug?

Pete Jones
http://www.petersencreative.com


User avatar
Newbie

Posts

Joined
Tue May 21, 2013 12:18 am
Location - Cheltenham, United Kingdom

Post by JNeuhoff » Fri May 16, 2014 9:49 pm

jeepstone wrote:I've just tried to do a Product Filter import and my filter items have appeared as attributes. Does the filter import work?

They appear correctly when I export the spreadsheet, but if I update them and try to reimport, they appear as attributes. Is this a bug?
Our free Export/Import does not support product filters, so you wouldn't even be able to import them, nor export them.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jeepstone » Fri May 16, 2014 9:54 pm

Does that mean that there's a paid for version that does? The filters definitely export.

Pete Jones
http://www.petersencreative.com


User avatar
Newbie

Posts

Joined
Tue May 21, 2013 12:18 am
Location - Cheltenham, United Kingdom

Post by labeshops » Fri May 16, 2014 10:16 pm

Can this be used to import new products adding to the existing products in the store? I don't want to overwrite the product tables or download all existing 6000 products since I don't need to change them but add to new products only as one of my new vendors has a spreadsheet for all their products which would make it easier to add.

I would also like to add them all as "disabled" so I can go thru, edit and enable them one by one.

Is this possible with this mod?

Running Opencart v2.2 with multi-stores from https://www.labeshops.com which has links to all my stores.

Image


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by JNeuhoff » Fri May 16, 2014 10:28 pm

labeshops wrote: Is this possible with this mod?
Not yet, at the moment it always first deletes all old products before importing the new ones.

We are planning a new release which will include incremental import and multi-lingual support.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Fri May 16, 2014 10:30 pm

@labeshops this one can't, it overwrites everything. I am now using this one http://www.opencart.com/index.php?route ... rch=export that does import and export incrementally.

Though copying from this one to the paid one's spreadsheet is a nightmare as this one adds the p> tags if you've made your description into paragraphs. When you copy & paste, those cells split into several rows and mess the whole thing up.

Sooooo looking forward to the day OC has bulk upload options built in ;)

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by labeshops » Sat May 17, 2014 2:23 am

Thanks for the info @tac I'll check it out.

Running Opencart v2.2 with multi-stores from https://www.labeshops.com which has links to all my stores.

Image


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by Kido » Mon May 26, 2014 7:40 pm

This is in the error log...
2014-05-26 11:04:02 - PHP Notice: iconv(): Detected an illegal character in input string in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-05-26 11:04:02 - Export/Import: Invalid number of worksheets, 8 worksheets expected
2014-05-26 11:28:56 - PHP Notice: Undefined variable: fileHandle in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-05-26 11:28:56 - PHP Warning: rewind() expects parameter 1 to be resource, null given in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-05-26 11:28:56 - PHP Notice: iconv(): Detected an illegal character in input string in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
String.php on line 386 is this

Code: Select all

$value = @iconv('UTF-8', 'UTF-8', $value);
CSV.php on line 147 is this

Code: Select all

rewind($fileHandle);
Language on website is Bulgarian. Not English :)

Newbie

Posts

Joined
Thu Aug 08, 2013 5:54 pm

Post by gogo359 » Tue May 27, 2014 12:56 am

Hello,

Greeting for perfect extencion.

I have one questions.

When I press export button, it is begin loding, and after around minute, show front page on shop and say : Page not found.

What is the problem. I try many things, but not result.

Kind Regards!

Newbie

Posts

Joined
Tue Apr 29, 2014 3:21 am

Post by Palpatin » Thu Jun 05, 2014 9:26 pm

Please, help!
Opencart version 1.5.5.1. , 800 goods in store.
Today I tried to export to the Excel and received an error:
PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes) in /home/....system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123

As far as I understood from previous posts, do not fix it?

Please, help.

Newbie

Posts

Joined
Thu Jun 05, 2014 9:03 pm

Post by widiz1312 » Wed Jun 11, 2014 12:22 am

hi
i just installed this extension

and tried to add an item into my store , but when i import the .xlsx file i got this error message

Image

i already tried any solution , like reimport again using the first xls file and check my product database but , the error message still there
can u please give me any solution and the thing that i have done wrong ?

Newbie

Posts

Joined
Wed May 04, 2011 4:36 pm

Post by JNeuhoff » Wed Jun 11, 2014 12:35 am

Palpatin wrote:Please, help!
Opencart version 1.5.5.1. , 800 goods in store.
Today I tried to export to the Excel and received an error:
PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes) in /home/....system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123

As far as I understood from previous posts, do not fix it?

Please, help.
About how to increase your memory_limit PHP setting, see http://www.opencartnews.com/tutorials/c ... olve-them/

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 8 guests