Post by JNeuhoff » Mon Dec 03, 2012 6:53 pm

baillie11 wrote:Hi,

I have downloaded opencart-1-5-4-x-export-import-13.zip for OpenCart 1.5.4.1 and have been able to export without any problems, however, when I import products, I receive a message saying it has worked, however, none of the products appear in the admin-catalog-products area, nor on the front end.

I have checked and error logs in VQModManager & System-Error Logs and have even cleared them.

I have opened cart in different browser (in case the cache hasn't cleared properly). I even exported the data back out and it still doesn't appear in the spreadsheet.

Any suggestions on what I could be doing wrong (im presuming it me, not your software - lol).

Thanks

Andrew
I am aware of this issue, I'll probably switch from XLS to ODS in the next version, in order to get proper UTF-8 support implemented, Microsoft's XLS format simply has too many issues with UTF-8.

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 * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by texx2cart » Wed Dec 05, 2012 2:51 am

Hallo!

It would be very useful to import/export the links for the download. + the download itself (to create it).

My shop has only products to be downloaded. So if you import - the link to the download has gone. It cannot be used for this purpose at the moment?! :-(

Could you include this in your tool?

best regards,

Axel

Newbie

Posts

Joined
Wed Dec 05, 2012 2:43 am

Post by liamcaff » Wed Jan 09, 2013 6:28 pm

meggabecca wrote:Hi

Because of memory issues, I spilt my spreadsheets into sections, but the problem is everytime I upload a spreadsheet, it gets rid of all the other products, so now back to square one, it seems most have memory problems this rubbish, can anyone suggest something else other than paying out £30 per month for dedicated server, which seems extreme, and can not validate paying that, so any other suggestions of finding a work around, to solve these memory issues...

Thanks in Advance
Any luck getting this sorted? I'm in the same boat - have been for quite a while...

Does anyone know how to do incremental uploads or if it is even possible?

Thanks,

L

New member

Posts

Joined
Wed Mar 21, 2012 9:20 pm

Post by Lao » Tue Jan 22, 2013 1:48 am

Hello JNeuhoff!

I use your extension since my first opening of my shop. I now encountered a big problem with memory limits.

I have a 1.7 MB excel file, so I don't know what can cause this (maybe it's because I have a few romanian characters in UTF-8?):
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 93 bytes) in /clients/HR7409/domains/importpieseauto.ro/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

Especially since it worked well so far.

I'm on 1.5.1.3 with 8.1 version of your extension.

Info.php file says:
memory_limit 230M 230M

I'm using Open Cart 1.5.4.1 on http://www.importpieseauto.ro


User avatar
Lao
Active Member

Posts

Joined
Tue Nov 23, 2010 3:31 pm
Location - Craiova, Romania

Post by Jurexco » Tue Jan 22, 2013 6:15 pm

Hi

I use OC 1.5.4.1 and extension ADV salesreportprofit. That make to DB oc_product cost-field. And I wonder if that field can Export/Import too. Is that possible?

Newbie

Posts

Joined
Tue Jan 22, 2013 6:11 pm

Post by picstart » Tue Feb 05, 2013 5:29 am

Hi ,
we have installed your vqmod on a version of 1.5.3.1 and when we export the spreadsheet it is a 0kb file and excel says it is in wrong format please help. it did work when we first installed it but now does not
thanks

New member

Posts

Joined
Fri Dec 09, 2011 6:44 am

Post by tidusbg » Mon Feb 25, 2013 5:08 pm

Hello!
Can you someone send me one .xls file redy to use (only one product inside or more)
I just want to see how to make this .xls file to be redy for use in Impot.
I cant make this file. :crazy:

http://www.bijuta-kristali.com


Newbie

Posts

Joined
Mon Feb 25, 2013 5:03 pm

Post by tidusbg » Mon Feb 25, 2013 6:04 pm

Hello!

Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.

Thanks in advance.

http://www.bijuta-kristali.com


Newbie

Posts

Joined
Mon Feb 25, 2013 5:03 pm

sry


Post by tidusbg » Mon Feb 25, 2013 8:25 pm

Ops 2 time i send
Last edited by tidusbg on Mon Feb 25, 2013 10:11 pm, edited 1 time in total.

http://www.bijuta-kristali.com


Newbie

Posts

Joined
Mon Feb 25, 2013 5:03 pm

Post by JNeuhoff » Mon Feb 25, 2013 10:03 pm

tidusbg wrote:Hello!

Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.

Thanks in advance.
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

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 * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by tidusbg » Mon Feb 25, 2013 10:33 pm

JNeuhoff wrote:
tidusbg wrote:Hello!

Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.

Thanks in advance.
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

When i export xls I recive this massage in xls file:

Code: Select all

<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist<br />Error No: 1146<br />SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories,  p.sku,  p.upc,  p.location,  p.quantity,  p.model,  m.name AS manufacturer,  p.image AS image_name,  p.shipping,  p.price,  p.points,  p.date_added,  p.date_modified,  p.date_available,  p.weight,  wc.unit,  p.length,  p.width,  p.height,  p.status,  p.tax_class_id,  p.viewed,  p.sort_order,  pd.language_id,  ua.keyword,  pd.description,   pd.meta_description,   pd.meta_keyword,   p.stock_status_id,   mc.unit AS length_unit,   p.subtract,   p.minimum,   GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related,   GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=2 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id   AND wc.language_id=2 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id   AND mc.language_id=2 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_product_tag` pt ON pt.product_id=p.product_id   AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;  in <b>public_html/openchart/system/database/mysql.php</b> on line <b>50</b>

http://www.bijuta-kristali.com


Newbie

Posts

Joined
Mon Feb 25, 2013 5:03 pm

Post by JNeuhoff » Mon Feb 25, 2013 10:59 pm

tidusbg wrote:

Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

When i export xls I recive this massage in xls file:

<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist
You are using the wrong version of the Export/Import tool, there is no longer a product_tag table in OpenCart.
Last edited by JNeuhoff on Mon Feb 25, 2013 11:21 pm, edited 1 time in total.

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 * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by tidusbg » Mon Feb 25, 2013 11:15 pm

JNeuhoff wrote:
tidusbg wrote:
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

When i export xls I recive this massage in xls file:

Code: Select all

<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist<br />Error No: 1146<br />SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories,  p.sku,  p.upc,  p.location,  p.quantity,  p.model,  m.name AS manufacturer,  p.image AS image_name,  p.shipping,  p.price,  p.points,  p.date_added,  p.date_modified,  p.date_available,  p.weight,  wc.unit,  p.length,  p.width,  p.height,  p.status,  p.tax_class_id,  p.viewed,  p.sort_order,  pd.language_id,  ua.keyword,  pd.description,   pd.meta_description,   pd.meta_keyword,   p.stock_status_id,   mc.unit AS length_unit,   p.subtract,   p.minimum,   GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related,   GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=2 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id   AND wc.language_id=2 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id   AND mc.language_id=2 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_product_tag` pt ON pt.product_id=p.product_id   AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;  in <b>public_html/openchart/system/database/mysql.php</b> on line <b>50</b>
You are using the wrong version of the Export/Import tool, there is no longer a product_tag table in OpenCart.[/quote]

Yes now I see. I use 1.5.3 and i have OC 1.5.5
Thanks

http://www.bijuta-kristali.com


Newbie

Posts

Joined
Mon Feb 25, 2013 5:03 pm

Post by tidusbg » Tue Feb 26, 2013 5:23 am

Sorry if the question seem stupid.
Can I import more than 1500 products?
I try but it gives me an error.
If I try a second import - tool deletes older products.
If there is a way to import product more of 1500, could you share.

http://www.bijuta-kristali.com


Newbie

Posts

Joined
Mon Feb 25, 2013 5:03 pm

Post by HasanJunaidHashmi » Thu Mar 21, 2013 1:32 pm

By mistake I installed Export/Import tool for OpenCart 1.5.3.x on OpenCart 1.5.4.
How to remove this isntallation, so that i can install the new Export/Import tool for OpenCart 1.5.4


Posts

Joined
Thu Mar 21, 2013 1:30 pm

Post by maney » Wed Apr 03, 2013 5:29 am

Hey,

Installed on 1.5.5 and I'm getting this error, can you help?

Fatal error: Call to undefined method Loader::language() in /var/sites/r/reliablereptile.co.uk/public_html/admin/controller/tool/export.php on line 6

Thanks!

Newbie

Posts

Joined
Fri Sep 07, 2012 3:16 am

Post by JNeuhoff » Wed Apr 03, 2013 5:54 am

maney wrote:Hey,

Installed on 1.5.5 and I'm getting this error, can you help?

Fatal error: Call to undefined method Loader::language() in /var/sites/r/reliablereptile.co.uk/public_html/admin/controller/tool/export.php on line 6

Thanks!
Use 1.5.5.1

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 * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by pstruh » Sun Apr 07, 2013 6:46 pm

Hi,
is there any way how to bypass memory problem ? Still have memory issue with import. php.ini set correctly but hosting cant allowd more memory.

Newbie

Posts

Joined
Sun Apr 07, 2013 6:44 pm

Post by sleenheer » Mon Apr 08, 2013 6:27 pm

Hi,

one possible solutions might be following:

1. go to your site with an ftp client
2. find and open .htaccess file or htaccess.txt

add this line into the file:

3. php_value memory_limit 1024M

4. if you have htaccess.txt then rename it to .htaccess

usually there are limitations set by providers, but they almost always have a backdoor by editing this into the htaccess file.

this is a small piece of my file:

# Prevent Directoy listing
Options -Indexes

# Memory allocation
php_value memory_limit 1024M

# Prevent Direct Access to files
<FilesMatch "\.(tpl|ini|log)">
Order deny,allow
Deny from all
</FilesMatch>

hope this helps!

Newbie

Posts

Joined
Thu Aug 23, 2012 9:11 pm

Post by pstruh » Tue Apr 09, 2013 1:45 am

Still the same error even after modifying .httaccess

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1048576 bytes) in /home/dx4455/www/stor/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 47
Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1048576 bytes) in /home/dx4455/www/stor/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 47

Newbie

Posts

Joined
Sun Apr 07, 2013 6:44 pm
Who is online

Users browsing this forum: No registered users and 4 guests