Hello,
To clarify my last post . . .
Anyone who is familiar with OS Commerce's CMS function "EPA Import" and "EPA Export". This is what I do step-by-step:
- - -
1. I log in to the admin section of my OS Commerce site.
2. I click "Data Manager" > "EPA Export".
3. I keep all defaults except "Limit By Manufacturer" where I choose "ManufacturerA".
4. I click "Start File Creation".
5. Within a short moment, a .txt file is created that I save to my desktop.
6. I open the .txt file with OpenOffice Spreadsheet.
7. I also open a .xls file (provided by "ManufacturerA") with OpenOffice Spreadsheet. This file includes "ManufacturerA"'s current product list with the product SKUs, descriptions, prices, and image file names.
8. I manually update the changes to my downloaded .txt file for any new items or changes there are for existing one. One of the columns in the spread sheet is labeled "v_products_image" and contains the name of the image files stored in the site's "catalog/images/" folder.
9. With an image CD (provided by "ManufacturerA"), I do an FTP upload of all the .jpg image files to the "catalog/images/" folder.
10. I save the .txt file.
11. I go back to the admin section of the OS Commerce site.
12. I click "Data Manager" > "EPA Import".
13. Under the section "Upload EP File for Import", I click the "Browse" button to locate the modified .txt file on my desktop.
14. Once found, I click "Insert into DB". My modified .txt file is imported and my changes are updated in the data base for the products shown on the live site.
- - -
In Drupal a product is a "node". By default, I can edit them one-by-one. This takes FOREVER with 10,000+ products. What I need is a module or modules (somewhere out there) that can allow me to download all of a given "type" of nodes to a spread sheet file (such as .txt or .csv) where I can edit it to include any new items (or "product" nodes) and update any existing ones, then upload it back through Drupal. In the same fashion it works for me with OS Commerce.
Is there a way to do this with Ubercart? Does anyone do this besides me? With ALL that Ubercart is capable of . . . I would think there MUST be a way.
I would be extremely grateful for anyone who can get me the answer in as much detail as I described my current process with OS Commerce. I am sure it would be beneficial to anyone who works with thousands of products like me.
Thank you for your time!
~ Tom