[RELEASED] Export/Import tool for OpenCart 1.5.5.x

Hi JNeuhoff,

After you solved my problem with downloading from an old version of OC http://forum.opencart.com/viewtopic.php?f=112&t=120109 I am now having a problem with the new site.

I am running OC 1.5.6.1, your mod version 17 and vQmod 2.4.1

I have followed the installation instructions and added the tool to the Top Administrator permissions.
The site is still not live so there are no products yet, just a few dummy categories so there's no question of memory issues.

However the tool does not appear in admin where it should be so I cannot export the empty spreadsheet to start filling it with the data from the old store
These are the errors from system/logs/errors.txt:
Is there something I am doing wrong?

Thanks in advance

Look into your vqmod/logs, there might be some log files with messages relating to your vqmod/xml/export.xml.

Thanks JNeuhoff but I don't know where to find any vqmod/logs.

In my vQmod folder and sub folders there is no mention of logs or errors of any kind. I forgot to mention I reinstalled E/I twice yesterday to be sure it was current.
The last attachment will have to be added separately.

And the last one....

Send me a PM with your OpenCart and FTP login details so that I can take a closer look at it. I can't see anything wrong from your screenshots.

Thanks for the quick reply JNeuhoff, details on their way

TAC wrote:Thanks for the quick reply JNeuhoff, details on their way

OK, now sorted. You forgot to run the VQmod installer.

Oh how stupid of me

Thanks so much for your help and this great mod

I got various errors but after searching the thread managed to get the import to work. Or so I thought....

The categories link to the ones from the old shop
Although they are visible in admin they are not in the shop

The categories not showing in the shop seems to be because the Store has not been set in the data tab. I must have missed that column when I added the date to the spreadsheet.

Am hoping the categories will link to the correct pages once this site replaces the old one

Hi JNeuhouff,
I have OC 1.5.5.1 installed and am getting this error when I run the export. Can you please help? Thank You!

2014-04-23 0:37:48 - PHP Notice: Error: Table 'justtake_opencart13.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=1 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=1 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 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=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in /home/justtake/public_html/system/database/mysql.php on line 50
2

stimacm :

You are using the wrong non-matching version of the Export/Import tool.

Hi again,

Will the categories will link to the correct pages once this site replaces the old one? Or is there something else I need to correct now?

Hello Jneuhoff,

Can you please help me with my problem ? I need this because I can't edit products from admin and export, I can only edit them in the xlsx and it's really annoying.

"Allowed memory size of 1073741824 bytes exhausted (tried to allocate 32 bytes)

I have the same problem when trying to export. Not many modifications in database, only Journal theme if it's somehow related... Import works like a charm, exporting is an issue.

~3300 products here."

I have had no luck with the import /export tools free or purchased, I have a few sites using Pinnacle Cart and I must admit uploading 30,000-60,000 items is just so easy, you add to existing products, you can add and remove everything, and a few more options, exporting is also just a joy to work with. Opencart lacks alot here, making us use excel is not good and I have just started upload and downloading from the database directly in CSV format and I have had no issues what so ever. Things happen in split seconds.

Someone needs to sit down and figure what I consider the most important function that a modern cart needs, besides bulk uploading of Categories and Manufacturers, images separately. Now if there is a solid import export tool I would love to use it. These posts with responses that keep telling users to increase memory setting is just not right in most cases.

my 2 cents in CSV

Hi There!
We have used your export/import tool on older versions of opencart and LOVE it! However we just had the newest version of OC Installed Version 1.5.6.1 - and we exported just fine, added our products and then imported just fine. Then next time we tried to export we got the message below - except the end was the Supervisor - line 126 - I found this comment several times on the forum so I adusted our php.ini settings to the following:
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 512M;
max_execution_time = 36000;
upload_max_filesize = 998M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;


Then we got this error -

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 20 bytes) in /home/content/62/7811162/html/supplies/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 110

Could you help me fix this problem?

Your webhost doesn't alow more than 64MB, despite your meory_limit set top 512M. Get in touch with your webhost, or change webhost if they don't allow it.

Hi I suggest you start uploading(import/export) directly through your database - no one is going to give you more than 128mb on a shared server and you don't need it. The import tool is not good - the rest of the cart is wonderful.

This standard answer of asking everyone to increase their memory limits in PHP.ini is not the solution.

I have a new issue now. I got things to work (on a different site) only to discover all my options have been altered.

I exported my products, added some new one and imported the updated spreadsheet.

I use a mod called Product Options Max Length because I can only accept certain length messages on my products. After the import all the values for the options have been reset to 0.

Is this mod conflict known about and is it fixable at all? I have also asked in the thread for the mod Product Options Max Lengthhttp://forum.opencart.com/viewtopic.php ... 0&start=20

Hello.
I cant find topic for 1.5.6x, so I write here.
I am working on a mod of your extension to insert a "Filters" tab after the "Attributes" tab.

I have now get it working, but it is one thing i dont know if you have missed or not.
At the attribute tab, i think it should be a row for sort_order. Or?

Is that something you have missed or why dosnt you have it there?
If people insert attributes from admin, they can set sort order for each attribute and attribute group.

Thanks.