Hello, everybody!
I've got a big list of books (48445) which I have to import to Ubercart. I did try to use Importer module, and unfortunately, it didn't gave me the functionality I expected. That's why I decided to write my own script which is gonna import products directly from one database to another, Ubercart's one.
The first step I made is comparing Uber Database before and after importing 1 product (a book). I've found out the following tables affected:
(When importing taxonomy)
- term_data
- term_hierarchy
- sequences
(When importing products)
- node
- node_revisions
- node_comment_statistics
- uc_products
- content_type_book
- files
- content_field_image_cache
- term_node
- sequences
- variable
- cache
- sessions
- uc_store_footers
Could you please answer the following questions:
- Is it critical to update cache, sessions during the importing process? What may happen if I won't do that?
- Why when I add a product, uc_store_footers table is added by an extra line (a copy of one that already exists) and why it happens sometimes, not always? What if I will not add those additional lines?
- Am I missing something? May be the above list of affected tables is not complete or the deductions I made don't match the state of things?
Any help will be highly appreciated!
Look forward to your reply...