I am using this extension on 1.5.4.1 and it works fine.
However, I also have the UKSB Google feed installed and this extension adds extra fields to the product and category table.
I want to include these in the export and import (since they get over-written by an import).
Can you advise which files need amending please?
Thanks
Dale
storeProductsIntoDatabase
uploadProducts
validateProducts
populateProductsWorksheet
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I'm using OC 1.5.3.1 and Import/Export tool and I'm facing the following problem: I can export the database correctly, I can open the file with Excel correctly, but when I want to import the data to my store, after I click import button, appears a white window seems nothing happening further.
This was a test with 25 prods, so I think it is not a problem of memory.
Can U help me, pls?
Since some days i try to use this tool without any success.
I have no error, but at the beginning it was import nothing and delete my previous products.
Now it still delete my products, but insert just the last line of my excel file...
So i have two question :
1) How can i do for the import ?
2) Is it normal that the tool delete the products before import (differents product), so how to do if i want just update a column, like quantity ?
Thanks !
PS : My Opencart version is the last one 1.5.4.1 in french, with vqmod installed and opencart-1-5-4-x-export-import-13
Since some days i try to use this tool without any success.
I have no error, but at the beginning it was import nothing and delete my previous products.
Now it still delete my products, but insert just the last line of my excel file...
So i have two question :
1) How can i do for the import ?
2) Is it normal that the tool delete the products before import (differents product), so how to do if i want just update a column, like quantity ?
Thanks !
PS : My Opencart version is the last one 1.5.4.1 in french, with vqmod installed and opencart-1-5-4-x-export-import-13
The Import always first deletes all existing products and categories on the database.
If you get an error or a blank screen, the first thing to do is to check all the error logs, e.g. OpenCart's system/logs/error.txt, or your sever's error_log.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I haven't any error and i haven't any blank screen. I have a success message, but only the last row of my excel file is record.
Any idea ?
EDIT : I can't check my errors log now... i tell you later what about the logs...
Thanks
No idea, unable to reproduce your error.junfan wrote:Thanks for your answer.
I haven't any error and i haven't any blank screen. I have a success message, but only the last row of my excel file is record.
Any idea ?
EDIT : I can't check my errors log now... i tell you later what about the logs...
Thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Can you help please im using OC 1.5.4 on a fresh install with this module
When i export the products and edit them then import the file it works file . But when i try and add my own products and import the same file it say incorrect format .
Can any one help ive tried every thing its driving me mad now
Ive the csv file with all the products on can anyone make it to work with OC please
Many Thanks
Attachments
Can anyone help im running OC 1.5.4. with this module with a fresh install
The module looks like its working fine . But when i import the file i get error message .. Could not retrieve table.
Ive attached the file im using if anyone can tell me were im going wrong that would be great
Many Thanks
Attachments
In second, my xml file is corrupted due to the lenght of my product descriptions. I edited the code so the tool doesnt export the product descriptions, and the generated file comes fines (i dont need to edit descriptions in the xml).
The problem is that i cant export it back... db seems to corrupt or it doesnt work.
Could you point me in the right direction?
Thanks.
I test again and now it's working !
I tried it again just before with the same file...
I think it didn't work before because of my hosting. Because in the error log there was a message about disk space.
Normally i have an unlimited disk space hosting, but it seems that it's not every time !
So i'm sorry for the inconvenience...
Bye
Glad to hear you got it to work now. Check your cPanel (if you have one with your webhost), normally it tells you the remaining free disk space on the left column.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Yours is a totally wrong spreadsheet format, it won't import. Are you sure you are talking about the free Export/Import tool?ukgamingpcs wrote:hi
Can anyone help im running OC 1.5.4. with this module with a fresh install
The module looks like its working fine . But when i import the file i get error message .. Could not retrieve table.
Ive attached the file im using if anyone can tell me were im going wrong that would be great
Many Thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
In first place, thanks for giving this great tool for free.
In second, my xml file is corrupted due to the lenght of my product descriptions. I edited the code so the tool doesnt export the product descriptions, and the generated file comes fines (i dont need to edit descriptions in the xml).
The problem is that i cant export it back... db seems to corrupt or it doesnt work.
Could you point me in the right direction?
Thanks.
The Export/Import tool requires the exact format to be kept, and it has to be an XLS file, not XML!Astroloco wrote: In second, my xml file is corrupted due to the lenght of my product descriptions. I edited the code so the tool doesnt export the product descriptions, and the generated file comes fines (i dont need to edit descriptions in the xml).
Thanks.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Getting Error in System/logs/error.txt when exporting 8000+ products,
As after doing modification, it will better export the file as the file size will become less
2012-11-01 12:54:45 - PHP Notice: Error: Incorrect key file for table '/home/mysqltmp/#sql_285a_0.MYI'; try to repair it<br />Error No: 126<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/mygrahak/public_html/system/database/mysql.php on line 49
Hi JNeuhoffJNeuhoff wrote:Yours is a totally wrong spreadsheet format, it won't import. Are you sure you are talking about the free Export/Import tool?ukgamingpcs wrote:hi
Can anyone help im running OC 1.5.4. with this module with a fresh install
The module looks like its working fine . But when i import the file i get error message .. Could not retrieve table.
Ive attached the file im using if anyone can tell me were im going wrong that would be great
Many Thanks
Thanks for your reply
Yes i have the right module . is there away to convert the file to the right format ? All i have done is exported the products edited it and saved . Im editing it with MS excel
Do you know were im going wrong
Many Thanks
Users browsing this forum: No registered users and 32 guests