I have been having a problem for well over a month and after following advice found on this forum I have still not got much further even though it seemed like I have made slight progress.
PROBLEM, I am having a problem importing large amounts of products in one go.
Information:
Open cart: V1.4.9.1
clean install.
(mac osx)
Import/Export module
After trying to use the import export module it became apparent that the XLS file with my products was too large. From reading the forums I setup a local server with a local install of Open Cart 1.4.9.1 with the Import/Export Module.
I then started to upload my products (stripping down the xls file) in batches of around 6,000 to the local hosted shop. This worked fine. Products where showing on the store front.
Using phpMyAdmin I then exported specific tables (product, product_description, product_to_category, product_to_store) in CSV format.
I next accessed my database on my hosted (hosted shared server) site via phpMyAdmin and imported the specific data into the specific table(s) - Making sure I used CSV using LOAD DATA and changing Fields terminated by from (;) to (,).
This seemed to be working fine, The hosted database was showing signs of the records being uploaded. When I viewed on my live store the products where missing. When I accessed the admin section it confirmed that the products where not showing. When I viewed the data in the database in phpMyAdmin the records that had been added where actually blank (product id is there but everything else contains a 0 or NULL).
Im puzzled why my data shows fine locally but, once exported and imported to my live hosted shop it doesn't add the data correctly.
Does anyone have any advice? Has anyone got a different procedure I can try to have some success i uploading products? My php skills are basic to say the least. I have a friend who has created an Import script which he says should work but looking at it, it is a bit daunting and I'd rather exhaust other means which I do understand before I have to give up.
Hope I've added enough information.
Any help will be much appreciated.
Many thanks
Darren
I have a couple of import modules in my signature that can do straight from csv to OpenCart.
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Mucho gracias
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Also could anyone confirm the exact tables I need to edit to add bulk products? I just need to clarify that I have not been missing out some important tables.
Many thanks Peeps
products,
product_description,
product_to_category,
product_to_store
Also
has anybody got any strategies to upload lots of products. I currently have 21,000 products but need to have many more.
Thanks.
ps I am willing to buy any module or script if you can confirm that I will be able to populate my dbase with 50,000+ products.
I'd be happy to support the module for 50,000 products.
Justin
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Has anyone had success with CSV Import Pro? I thought it would be my saviour but seeing as though its not, i'm guessing I have some major underlying problem.
http://www.youtube.com/watch?v=-6k1_Qrq9_Y
Justin
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
your module looks very fine. I am working on webshop based on opencart for our stone shop and will need to have module which is able to transfer all product changes (in XML or CSV) from our accounting system to webshop and back in "real" time to provide our customers actual information about new products, new prices and availability.
Is this idea executable? Is Opencart able to do this with some special module?
you could probably get close to real time with batch runs with high frequency. I'm not sure what format your accounting system requires, but perhaps the google base feed or my anyfeed module will produce something it could use. Then you could use CSV Import PRO to import from your accounting system to OpenCart, and AnyFeed to export from OpenCart to your accounting system.
Alternatively, you could write a custom solution with our OpenCart RESTful API module as a basis, or someone from commercial section could write something for you. It certainly sounds like a task for automation.
Good luck!
Justin
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Would you able to do this automatic module?justinv wrote:Hi poshook,
Alternatively, you could write a custom solution with our OpenCart RESTful API module as a basis, or someone from commercial section could write something for you. It certainly sounds like a task for automation.
Good luck!
Justin
If they are on your computer the csv import module will not upload them for you.
thanks.
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
i m interested in your extension but i would like to know first if there is a way to upload product photos in my computer with your extension?justinv wrote:If the pictures are on your server you can import them by including their path in the csv file you are importing - eg: data/image.jpg. If they are on another server you can import them using a tweak to the image.php file in OpenCart documented somewhere on this forum.
If they are on your computer the csv import module will not upload them for you.
thanks.
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Thanks, before buying, there is sth which i have to know, you said that we can import photos using a tweak to the image.php file in OpenCart, could you please provide the hyperlink or details? Thanks.justinv wrote:You would have to upload the product photos using your ftp server manually. The CSV Import module only updates the database to point at the image location, it does not actually fetch the image onto the server.
Here is the thread, the third comment in is the method that I use: http://forum.opencart.com/viewtopic.php?f=20&t=23708
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Users browsing this forum: No registered users and 12 guests