Greetings,
Have some issues with Product Import with a csv via Node Import:
1. How to import images directly from a URL at the time of the batch import of all products via Node Import. I am able to create the products with Node Import, and then go into each product node and use Filefield Sources to specify a URL for image import. This is a manual process... I'm looking for an automated process that essentially does the same thing Filefield Sources does, but takes the URL from the csv and imports the image along with the rest of the product information. Then have ImageCache work its magic to create an appropriately size image and thumbnail.
2. How to update products without duplicating products. Currently, when a new import is done, completely new products are created such that an exact duplicate now exists in the catalog. It would be great if the import looked for the same SKU (in our case we have a unique product ID) and if it finds the same SKU, it will either ask if the user would like to go product node by product node for those SKUs and merge, or simply overwrite the old product information with the new information. Even better would be to look at two fields, like SKU and part no., such that a confirmation that this is in fact the same product, just in case the product ID is not unique.
3. How to import taxonomy and make it useful. Currently, I used taxonomy import to import three levels of classification, ie., parents, children, and grandchildren, or Lawn and Garden (parent), Lawn Care (child),and trimmer (grandchild). Then, in the csv, I have three columns: Category 1 (parent), Category 2 (child), Category 3 (grandchild). This appears to place the product in the appropriate categories, but the counting for the Catalog is off. If I have two products in Lawn Care, since these products are classified as both Lawn and Garden AND Lawn Care, it looks like Drupal counts them twice, such that there are four Lawn and Garden Products. This may be a bug in the Taxonomy module, I'm not 100% sure.
If you need clarification on any of these points, please let me know. Also, if any of this would be more appropriate for a contracted developer to look at (functionality like this simply does not exist), please provide that advice, as I'm considering seeking out a qualified developer to help implement these items and make our product import work per our needs.
Cheers everyone!
Bret
