Product Import

Posts: 2
Joined: 04/08/2008

I am in the process of changing my site over from oscommerce to ubercart. I am struggling with the import feature and would like to update my products on a daily basis. I convert my feed into a compatible ubercart xml file. It appears to import all the items but it orphans them all. Does anyone have any insight as to automatically creating categories for the products. I am working with about 200 categories and 200,000 products.

Thanks,
Ryan

Posts: 71
Joined: 04/05/2008
Bug Finder

Checkout the end of this thread, see if it helps

http://www.ubercart.org/forum/support/4483/importing_new_list_productspr...

Posts: 28
Joined: 04/23/2008

Yes, using the drupal node_import module with the ubercart's uc_product.inc works well.

see: http://drupal.org/project/node_import

uc_product.inc is available somewhere in this forum.

The only issue I found with node_import is that I can't import the images. There is a cck images patch to fix this, but I could not get it to work.... See: http://drupal.org/node/143471

Posts: 7
Joined: 12/13/2007

Did you try the latest incarnation of that patch?

http://drupal.org/node/143471#comment-786257

I'm not entirely sure how to load a patch myself, so I'll play around with it a bit.

Posts: 42
Joined: 05/28/2008

I got image import to work with an old version (1.2) of node_import and konsumer's original patch. This works wonderfully, except I have never been able to get taxonomy terms created under the catalog term through any import program...

good luck

Posts: 28
Joined: 04/23/2008

Well, I have always got taxonomy to work with node_import 5.x-1.6.

The taxonomy term should be a column in the csv file, and I map this to "Taxonomy: Catalog" during the import.

Multiple terms can be separated by pipe "|" sign in a csv file, assuming your fields are comma separated e.g. assuming you had products that could be classified as Term1 & Term2, then in the Taxonomy field you should have:

.....,"Term1|Term2",...., [see the readme.txt file unde modules/node_import]

I am running Taxonomy 5.7. & Taxonomy Menu 5.x-1.03 with drupal 5.7

So the only outstanding things for me are:
1. Image imports with node_import 5.x-1.6 [I have not had another go at the patch...]

2. Speed - see my support request on:
http://drupal.org/node/270584

Posts: 28
Joined: 04/23/2008

By the way, I just tried the image cck patch again on node_import 5.x-1.6 and got it to work!

A few comments:
- node_import/supported/cck/content.inc is the file that needs to be patched

- you then need to edit the patched content.inc and make this change after finding line with unset($node->$dummy_name):
//unset($node->$dummy_name)

- images need to be placed in the files directory, under your drupal installation.

- in the csv file, put name of image as a separate field e.g. if image is files\image1.gif, then only put image1.gif in field

- during import, map the image field to the "Image Fid (field_image_cache)" field.

After this it worked for me...

I am using ImageField 5.x-2.0-rc8, and all the Image modules 5.x-1.8, ImageCache 5.x-2.0-rc2, cck 5.x-1.5

Posts: 4
Joined: 01/28/2008

zeezhao wrote:

- you then need to edit the patched content.inc and make this change after finding line with unset($node->$dummy_name):
//unset($node->$dummy_name)

There are 3 such lines in content.inc! Which one?

Posts: 28
Joined: 04/23/2008

There is only one instance for me... after applying the patch. Using node_import 1.6
file is node_import/supported/cck/content.inc

Also, I used this patch: node_import_imagefield_support_0.patch
(see http://drupal.org/node/143471#comment-786257)

Did not try latest patch or any other one....