Page 1 of 2

[UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Tue Mar 23, 2010 8:42 pm
by JNeuhoff
The Export/Import module has now been upgraded to support OpenCart 1.4.4.
New features include support for the specials and discounts.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Tue Mar 23, 2010 8:59 pm
by allenshea
Always appreciated your hard work. Thanks for updating.

Allen

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Wed Mar 24, 2010 12:04 am
by peteVA
Bless you!

Can't say the import works yet, but at least I got a good export and have some idea of the structure of the files.

Thanks so much!

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Wed Mar 24, 2010 2:05 am
by pesnemarn5
Thank you for this man, I appreciate it very much!

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Wed Mar 24, 2010 10:59 am
by rph
Great work!

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Thu Mar 25, 2010 7:02 pm
by OCyvon2
My hosting provider tell me that I cannot use PEAR because its not save on a shared hosting.
Is there another option to use this import/export module?

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Fri Mar 26, 2010 8:12 am
by tilesupply
Hi JNeuhoff

Can you help me with your mod.
The old one was working for me on my old site. I am having a problem when I run the export.

When i run it it's fine but when i open the file i get this
Slide1.JPG

Slide1.JPG (27.18 KiB) Viewed 4085 times

I was running V1.40 with a few mods from Q.
Then i used the upgrade mod from Q to change over to 1.44.

When i had 1.40 I had added special prices and discounts to some of the products.
What it tends to do some times is download the cats, specials and discounts and leave the products blank.
Another time it only download half the discounts special and products but all the cats.

I have now set up a local test server so i have full access to the sql database.
If I send you the DB backup are you able to fix it for me.

Also what would your rate be for fixing this?
If possible i need to get this sorted ASAP.

Many Thanks

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Sat Mar 27, 2010 1:01 am
by JNeuhoff
OCyvon2 wrote:My hosting provider tell me that I cannot use PEAR because its not save on a shared hosting.
Is there another option to use this import/export module?
Change your web host. I recommend Hostgator, you can find a summary of their packages on my website.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Sun Mar 28, 2010 5:13 am
by JNeuhoff
tilesupply wrote:Hi JNeuhoff

Can you help me with your mod.
The old one was working for me on my old site. I am having a problem when I run the export.

When i run it it's fine but when i open the file i get this
Slide1.JPG
I was running V1.40 with a few mods from Q.
Then i used the upgrade mod from Q to change over to 1.44.

When i had 1.40 I had added special prices and discounts to some of the products.
What it tends to do some times is download the cats, specials and discounts and leave the products blank.
Another time it only download half the discounts special and products but all the cats.

I have now set up a local test server so i have full access to the sql database.
If I send you the DB backup are you able to fix it for me.

Also what would your rate be for fixing this?
If possible i need to get this sorted ASAP.

Many Thanks
As I said in my PM, I accidentally uploaded the wrong version of the Export/Import module for OpenCart 1.4.0, I have now corrected it.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Sun Mar 28, 2010 6:20 am
by peteVA
It's exporting great.

I could not quite figure out how to enter categories / sub-categories, so I entered online and exported. Gave me a good lesson in how that works.

But, nothing I added to the categories came back.

Images for the categories, meta description, keywords - none imported.

Went back and deleted the categories in the cart. Tried again. And again. And again.

Looked at the xls file, everything there. Looked again, etc.

Tried it with the xls saved, open, no difference. Everything is there, but not coming into the cart.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Sun Mar 28, 2010 10:44 pm
by JNeuhoff
peteVA wrote:It's exporting great.

I could not quite figure out how to enter categories / sub-categories, so I entered online and exported. Gave me a good lesson in how that works.

But, nothing I added to the categories came back.

Images for the categories, meta description, keywords - none imported.

Went back and deleted the categories in the cart. Tried again. And again. And again.

Looked at the xls file, everything there. Looked again, etc.

Tried it with the xls saved, open, no difference. Everything is there, but not coming into the cart.
Just sent you a PM, need a copy of your XLS file to investigate.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Tue Mar 30, 2010 7:03 am
by saint
Hi J.

I'm having a problem. I'm able to import and export just fine. However on export with the description when I open it in excel the description gets cut in half when I open it. Mind you, my version of excel is from 2001 and I know inner pinnings of the software have changed a lot.

When I open it with openoffice.org the descriptions are still there, so I know it's not the export that is bad, but when I save the excel file it saves it in a format that causes an error on import. Also, saving the saved openoffice.org file in excel is useless and just shows another error message.

I don't know. I'm guessing it would be best for my mental health to just accept the fact that if I want to do a mass upload of products, it's best to keep the product descriptions to a shorter length and just forget about having beautiful product descriptions.

- -S

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Tue Mar 30, 2010 6:41 pm
by JNeuhoff
When using OpenOffice, do a Save As MS Excel 97/2000/XP (.XLS) , and it will preserve the whole length of your descriptions beyond the 255 character limitation.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Wed Mar 31, 2010 2:32 am
by saint
J, Thank you so much. Awesome awesome awesome.

I swear I tried this but i've tried so many techniques it's possibly I missed it somehow. Either way, you get the star for the day. This is rad. So much to update now!

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Thu Apr 01, 2010 11:25 pm
by Affableaardvark
I am using the module with 1.4.5 clean install. I can import 2000 products then when I try to import another 2000 products the response says successful though still just the original 2000 products.
All the product ID's are different as well as model and sku.
Any advice would be appreciated.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Thu Apr 01, 2010 11:46 pm
by JNeuhoff
First of all, the current version of the Export/Import module hasn't yet been officially ported by me to versions of OpenCart later than 1.4.4, though chances are it will work.

As regards the Import not going beyond a certain number of products: This looks like an issue with your PHP settings. In particular, the Import can by quite memory hungry and your memory_limit setting may not be enough, see this thread for more details.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Sat Apr 03, 2010 5:29 pm
by kkk26
It does not work in 1.4.6

Could you please update this?

Thanks!

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Sun Apr 04, 2010 7:13 am
by tilesupply
I have it working in 1.46.

But the fixes from 1.44 to 1.46 like google site map dont work.

Once I installed it site map stopped working in google.
So in short backup a copy of your site and you should be fine to have it running as a temp fix till a new one comes out.

Question about export/import mod

Posted: Tue Apr 06, 2010 12:51 am
by squeaky
Am I understanding this correctly? I must first export from the system, make my changes, and then re-import the updated file?

Is there anyway to mass import new products?

One more - Any idea when the mod will be updated to work with the latest oc version 1.4.6?

thanks in advance.

Re: [UPDATED] Export/Import module for OpenCart 1.4.4

Posted: Tue Apr 06, 2010 6:53 pm
by Affableaardvark
JNeuhoff wrote:First of all, the current version of the Export/Import module hasn't yet been officially ported by me to versions of OpenCart later than 1.4.4, though chances are it will work.

As regards the Import not going beyond a certain number of products: This looks like an issue with your PHP settings. In particular, the Import can by quite memory hungry and your memory_limit setting may not be enough, see this thread for more details.
Thank you for your reply. I have done further tests and have split the import file into smaller chunks. The imported file overwrites the original for example I had 2000 products stored and imported 650 all with different product_id, sku and model and the shop now only shows the 650 products.
Is there a way of importing in chunks to get round my hosts php.ini limits?

Thank you for an excellent module much better than easypopulate! (Zencart)