The Export/Import Tool is now available for OpenCart 1.4.8.
The spreadsheet comes with a newly added field column for the product tags.
did you catch the cost field also?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Well spotted. I have now added support for the following new fields:did you catch the cost field also?
product.subtract
product.minimum
product.cost
category.status
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I've extended your import-export tool also for orders and customers (with handling of md5 passwords)..unluckily my developer abandonated me and did'nt updated the work, actually it's only for 1.4.0 are you interested?JNeuhoff wrote:Well spotted. I have now added support for the following new fields:did you catch the cost field also?
product.subtract
product.minimum
product.cost
category.status
Hi guys,
I've installed this brilliant module after updating to 1.4.8, but I found that after procedure of importing product catalog my meta_keyword - disappeared:(
I suppose that some field has been changed in new 1.4.8 version.
If I'm right could you please tell me what I need to change in this module..
PS: my somebody can tell me how can I add meta keywords for the first page (not only for every product page)
Thanks for advance.
Alex
I've installed this brilliant module after updating to 1.4.8, but I found that after procedure of importing product catalog my meta_keyword - disappeared:(
I suppose that some field has been changed in new 1.4.8 version.
If I'm right could you please tell me what I need to change in this module..
PS: my somebody can tell me how can I add meta keywords for the first page (not only for every product page)
Thanks for advance.
Alex
Yes, the spreadsheet format has changed. Just do an export from your OpenCart 1.4.8 server and compare the resulting spreadsheet to that from your previous version.I've installed this brilliant module after updating to 1.4.8, but I found that after procedure of importing product catalog my meta_keyword - disappeared:(
I suppose that some field has been changed in new 1.4.8 version.
What first page? Can you be more precise?my somebody can tell me how can I add meta keywords for the first page
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi JNeuhoff,
My shop is new, so I didn't use .xls file from previous version, but I found the reason!
column meta_keywords has been missed.
file export.php
row 291 and 292
changed to
so now import is fine, might by I missed something else... experts will know better, I'm a new one 
the second question is, when you look at source code for the first shop page, you can not see any meta keywords, only meta description
PS: for product page I have meta keywords and description
My shop is new, so I didn't use .xls file from previous version, but I found the reason!
column meta_keywords has been missed.
file export.php
row 291 and 292
Code: Select all
$sql2 = "INSERT INTO `".DB_PREFIX."product_description` (`product_id`,`language_id`,`name`,`description`,`meta_description`) VALUES ";
$sql2 .= "($productId,$languageId,'$productName','$productDescription','$meta');";
Code: Select all
$sql2 = "INSERT INTO `".DB_PREFIX."product_description` (`product_id`,`language_id`,`name`,`description`,`meta_description`, `meta_keywords`) VALUES ";
$sql2 .= "($productId,$languageId,'$productName','$productDescription','$meta','$keyword');"; the second question is, when you look at source code for the first shop page, you can not see any meta keywords, only meta description
PS: for product page I have meta keywords and description
Well spotted, the meta_keywords is indeed not yet supported in the spreadsheet.My shop is new, so I didn't use .xls file from previous version, but I found the reason!
column meta_keywords has been missed.
However, your proposed fix won't work, your are now adding the seo_keyword from the spreadsheet to your meta_keywords in the database.
I'll will add a new spreadsheet column 'meta_keywords' with proper support for both the Export and Import in the next release. The 'meta_keywords' was only introduced to the DB table 'product_description' in OpenCart 1.4.8, it didn't exist in previous releases.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote:However, your proposed fix won't work, your are now adding the seo_keyword from the spreadsheet to your meta_keywords in the database.
thanks, I thought that I've done something wrong:)Could you please tell me a date for new release?
+/- 1 week/month/year
Hello,
I'm working on a friends shop and he has quite a few products that need to be imported, however, when I installed this and configured what was needed, I uploaded his XLS file and nothing was imported...
Am I missing something?
Thanks.
I'm working on a friends shop and he has quite a few products that need to be imported, however, when I installed this and configured what was needed, I uploaded his XLS file and nothing was imported...
Am I missing something?
Thanks.
Yes, you didn't give us enough details.Am I missing something?
For example, what's in your server's error_log?
Have you installed the latest release of the Export/Import tool which I only uploaded a few hours ago to the contributions section.
How big is your XLS file?
What are your PHP settings for e.g.
post_max_size
upload_max_filesize
memory_limit
How many products and categories do you have?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello,
The original details were;
post_max_size = 8m
upload_max_filesize = 2m
memory_limit = 64m
I then checked his cPanel to see if the PHP Configuration utility was available which it was set to System Default. I set it to PHP5 and it shows much larger sizes for the above. I then tried to upload the CSV/XLS file and it turned out with a Internal 500 Error.
Any ideas?
The original details were;
post_max_size = 8m
upload_max_filesize = 2m
memory_limit = 64m
I then checked his cPanel to see if the PHP Configuration utility was available which it was set to System Default. I set it to PHP5 and it shows much larger sizes for the above. I then tried to upload the CSV/XLS file and it turned out with a Internal 500 Error.
Any ideas?
You need to check your server's error_log, which can be reached via your cPanel. That will tell you the reason for the Internal Error 500 message.MikeP wrote:Hello,
The original details were;
post_max_size = 8m
upload_max_filesize = 2m
memory_limit = 64m
I then checked his cPanel to see if the PHP Configuration utility was available which it was set to System Default. I set it to PHP5 and it shows much larger sizes for the above. I then tried to upload the CSV/XLS file and it turned out with a Internal 500 Error.
Any ideas?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
What about the other details:
How big is your XLS file? How many products and categories?
Could well be that you'll have to increase your memory_limit or the other max - values in your PHP settings.
How big is your XLS file? How many products and categories?
Could well be that you'll have to increase your memory_limit or the other max - values in your PHP settings.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 1 guest
