The Import can be very memory hungry.
To give you some ideas, look at this forum thread.
You may have to significantly increase your memory_limit setting.
Andrea,
The mod is a lifesaver but memory hungry, the way I find best to use it is to setup a local copy of OC140. I use XAMPP. I then upload my .xls file, then do a backup. I then open the backup.sql file with a text editor and select the product tables i.e. product, product to category, product options etc etc and drop them table by table into the sql section of phpmyadmin and click go.
This Normally does the trick, I know it seems long winded (because it is) but once your products are on the spreadsheet and exported as backup.sql its pretty simple.
Hope this helps
Stewart
The mod is a lifesaver but memory hungry, the way I find best to use it is to setup a local copy of OC140. I use XAMPP. I then upload my .xls file, then do a backup. I then open the backup.sql file with a text editor and select the product tables i.e. product, product to category, product options etc etc and drop them table by table into the sql section of phpmyadmin and click go.
This Normally does the trick, I know it seems long winded (because it is) but once your products are on the spreadsheet and exported as backup.sql its pretty simple.
Hope this helps
Stewart
Hello,
I would like to ask is there any ideas for including the special price and discount information to the import/export module?
Maybe it should be done the same way as with the product options.
Anyway this will be hugely appreciated.
Best regards,
Ivan
I would like to ask is there any ideas for including the special price and discount information to the import/export module?
Maybe it should be done the same way as with the product options.
Anyway this will be hugely appreciated.
Best regards,
Ivan
btw... just a heads up that might be nice to include in the install instructions, make sure you upload the files without changing everything to lower-case, the "OLE" and "Spreadsheet" folders have capital letters and the reference does so too, with lower case names, the export won't work...
Opencart specialist | Our website | Our modules
I've spoken to Jneuhoff personally, he's put a lot of time into the current mod. I spoke to him for about an hour on the phone giving him some ideas on how to solve some of the current issues people are experiencing. I think we should compile a list of things that people feel would be an improvement to the current release of import export. Hopefully if we get a good response JN may release an improved version and we could all donate for his efforts. I'll start the list with
1. Incremental product numbering automatically
2. Break down the current process so that the admin can import and export only products, only options,or only customers. (this will help with the memory hungry issue)
hope this helps
Stewart
1. Incremental product numbering automatically
2. Break down the current process so that the admin can import and export only products, only options,or only customers. (this will help with the memory hungry issue)
hope this helps
Stewart
multi-lingual support! it already exports the language ID...
Opencart specialist | Our website | Our modules
Thank you all for your proposals.
To summarize so far I have got this on the to-do list for the Export/Import:
To summarize so far I have got this on the to-do list for the Export/Import:
- multi-lingual support
- product discounts (using a separate worksheet)
- product specials (using a separate worksheet)
- support for incremental updates, with auto-generated product ids if not present
- support for exporting/importing to/from separate worksheets (e.g. only product options)
- support for related products
- Exporting customers to a spreadsheet file
- A bestsellers module including an Export to a spreadsheet file
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello there!
I'm pretty new in Opencart system and this is my first post in here, so please be patient! :-)
I tried to run "Export/Import for OpenCart 1.4.x" module, but the same error is repeating over and over again:I searched a lot on the web, but still could not force it to work 
Right now, I'm using: Opencart 1.4.0, Spreadsheet Excel Writer 0.9.2, OLE 1.0.0RC1.
I'm pretty new in Opencart system and this is my first post in here, so please be patient! :-)
I tried to run "Export/Import for OpenCart 1.4.x" module, but the same error is repeating over and over again:
Code: Select all
"Fatal error: require_once() [function.require]: Failed opening required 'System.php' (include_path='.') in /home/.../admin/OLE/PPS/Root.php on line 24"Right now, I'm using: Opencart 1.4.0, Spreadsheet Excel Writer 0.9.2, OLE 1.0.0RC1.
What's in your include_path?I tried to run "Export/Import for OpenCart 1.4.x" module, but the same error is repeating over and over again:
Code: Select all
"Fatal error: require_once() [function.require]: Failed opening required 'System.php' (include_path='.') in /home/.../admin/OLE/PPS/Root.php on line 24"
I searched a lot on the web, but still could not force it to work
Right now, I'm using: Opencart 1.4.0, Spreadsheet Excel Writer 0.9.2, OLE 1.0.0RC1.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I am trying to get the import/export to work but am getting an error on export.
Here is my information:
Location of Opencart
C:\wamp\www\opencart
Location of PEAR.PHP
C:\wamp\bin\php\php5.3.0\PEAR
When attempting to run the export, I get the following:
Parse error: parse error in C:\wamp\www\opencart\admin\Spreadsheet\Excel\Writer.php on line 33
From the Writer.PHP file, the lines in question appears as follows:
*/
include_path='.;C:\wamp\bin\php\php5.3.0\PEAR\';
require_once 'PEAR.php';
require_once 'Spreadsheet/Excel/Writer/Workbook.php';
Greatly appreciate some help. Rather new to this and sure I am making a minor/stupid error.
Thanks
Here is my information:
Location of Opencart
C:\wamp\www\opencart
Location of PEAR.PHP
C:\wamp\bin\php\php5.3.0\PEAR
When attempting to run the export, I get the following:
Parse error: parse error in C:\wamp\www\opencart\admin\Spreadsheet\Excel\Writer.php on line 33
From the Writer.PHP file, the lines in question appears as follows:
*/
include_path='.;C:\wamp\bin\php\php5.3.0\PEAR\';
require_once 'PEAR.php';
require_once 'Spreadsheet/Excel/Writer/Workbook.php';
Greatly appreciate some help. Rather new to this and sure I am making a minor/stupid error.
Thanks
After installing, I get
Fatal error: Call to a member function https() on a non-object in /usr/local/4admin/apache/vhosts/website.com/httpdocs/webcartfolder/admin/controller/common/header.php on line 80
just loggin in to the admin page.
get the same error trying in 1.4.2
Fatal error: Call to a member function https() on a non-object in /usr/local/4admin/apache/vhosts/website.com/httpdocs/webcartfolder/admin/controller/common/header.php on line 80
just loggin in to the admin page.
get the same error trying in 1.4.2
The Export/Import module has not yet been ported over to the 1.4.2 version of OpenCart, hence I am unable to provide any support for that version until I have completed a proper upgrade. It is on my to-do list.
As regards 1.4.1: I will skip that version as it was only meant to be a short-lived beta release of a newer OpenCart release which became 1.4.2.
As regards 1.4.1: I will skip that version as it was only meant to be a short-lived beta release of a newer OpenCart release which became 1.4.2.
Last edited by JNeuhoff on Wed Mar 10, 2010 2:37 am, edited 1 time in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
How near is the fix for 1.4.2 as I have a customer who is very interested in using the spreadsheet function?
I'm using 1.4.4, so I know that may be a problem from the outset.
However, with the help of a few edits / mods / comments I have got it working, as far as no errors at all. In fact, it will do an export, but all that is included is the categories.
I have gone in and added a new category and a new item, figuring there may be something about the existing products that kept them from show. No joy! The new category shows, but still no products.
The main reason for the export is to get the proper structure for an import. I've got 1800 items and 100 or so cats and sub-cats. That would sure save days of work.
Any ideas on what is keeping the products from coming? There are no errors on the screen or in the log, just brings the categories and that's that.
However, with the help of a few edits / mods / comments I have got it working, as far as no errors at all. In fact, it will do an export, but all that is included is the categories.
I have gone in and added a new category and a new item, figuring there may be something about the existing products that kept them from show. No joy! The new category shows, but still no products.
The main reason for the export is to get the proper structure for an import. I've got 1800 items and 100 or so cats and sub-cats. That would sure save days of work.
Any ideas on what is keeping the products from coming? There are no errors on the screen or in the log, just brings the categories and that's that.
A Trusted Wholesale Dropshipper
Web Hosting Under $ 5.00 Month! FREE Shopping Carts!
25,000+ Real Wholesale & Dropship Sources!
shoo002 wrote:Andrea,
The mod is a lifesaver but memory hungry, the way I find best to use it is to setup a local copy of OC140. I use XAMPP. I then upload my .xls file, then do a backup. I then open the backup.sql file with a text editor and select the product tables i.e. product, product to category, product options etc etc and drop them table by table into the sql section of phpmyadmin and click go.
This Normally does the trick, I know it seems long winded (because it is) but once your products are on the spreadsheet and exported as backup.sql its pretty simple.
Hope this helps
Stewart
Thanks Stewart, I used you idea to just go straight into the php admin, and then just work right out of there, you can upload 15,000 products straight into the product DB no problems at all, and thats on a shared hosting service.
Dude if i could kiss you i would, but your idea is worth a hard shagging! lmao
It does take a bit longer, but its either that, or pay $100 + for a monthly dedicated hosting package.
Who is online
Users browsing this forum: No registered users and 13 guests
