5 replies [Last post]
Mariano's picture
Offline
Joined: 09/04/2007
Juice: 110
Was this information Helpful?

Hi.
I want to export the whole catalog from a UC store. I then would like to import it to another UC site. So, exactly what table(s) should be exported from the database? Surely it might be necessary to edit the sql file in order to match the new paths and avoid broken links for images or products.

I considered uc_products, uc_product_* and uc_catalog_images.

The idea is to update just the catalog for the main site, and then export it to other 'mirror sites' (different databases, different drupal + uc installations). I'm still trying to play around with the import/export module, but for the meantime, I thought of this option.

Thanks for any help.

torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Export Catalog - DB

Well I'd imagine you would want the node table since each product is technically a node (the product tables have to reference it everytime they look up a "nid").. and that can cause issues with your variables table unless you export that too (since it will be looking up what the next nid is for each product, at least, I think that's the case still!).. there are other factors that I could be missing!

To be honest it might cause more grief than it's worth to do it that way, unless you were to do a mostly-complete backup.

Unless others have a different opinion. I've been wrong before Smiling

--
Help directly fund development: Donate via PayPal!

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Export Catalog - DB

Since you're going from an Übercart site to another one, it should be much easier to use the importer module. Also, if you're going to be continuously updating your catalog and need those changes to show up on several other sites, enable the Repeater module on all of your sites.

Pick one site to be the master catalog. This will be the one you make the changes on. On that site's Repeater settings, list the domains of each of your other sites as slaves. On each of those sites, list the first site as the master. (Basically, leave off the "http://" part of the URL.) Now, when you edit a product, there will be a check box labeled "Export to other sites". If it is checked when you submit the changes it sends a message to those other sites with the new product values. Since it uses the importer's XML functions, make sure the Importer settings are set to overwrite existing products. This makes revisions so you can always undo the changes if you need to.

Mariano's picture
Offline
Joined: 09/04/2007
Juice: 110
Thanks for your help. I was

Thanks for your help.
I was able to accomplish what I wanted using Importer+Repeater. This was quite a simple solution.

Thanks again =)

careykf@drupal.org's picture
Offline
Joined: 08/10/2008
Juice: 2
Repeater / importer issues - mine not working

Hi,

I would like to know how you got the importer/repeater modules working. I currnetly have two drupal sites. Master and Slave? I followed the instrutions above to set up the repeater /importer functionality, however when adding/update a product with 'export to other sites' it adds/changes the product to the master, but the product does not get pushed to the slave site.

1. Can you maybe enlighten me as to how you managed to get this right.
2. when does the 'push' take place? (cron.php)
3. do you share any tables between your sites.
4. Running Postgres or mysql (does that make a diference)
5. PHP version?
6. Any other modules other than repeater and importer? Do you know how we can check if either of the modules are working/not working?
7. We also get the following after making a change to a procuct. It displays as a message, same as where the 'The Product has been updated' displays

Array
(
[vocabularies] => Array
(
[0] => 1
)

[categories] => Array
(
[0] => 2
[1] => 1
)

[manufacturers] => Array
(
)

[attributes] => Array
(
[0] => 1
)

[classes] => Array
(
)

[products] => Array
(
[0] => 7
)

)

Any help would be greatly apppreciated.

Thanks

kirstykf's picture
Offline
Joined: 08/28/2008
Juice: 2
FCKEditor Conflict

Just a comment on the above issue, we managed to get this working by specifically excluding the Repeater settings page from FCKEditor. Even though the urls were added in 'Plain Text mode' it must have still been putting some funny tags in there because it wouldn't work at all (no error message, just didn't do anything). Now that we have excluded that page and it is strictly plain text it works like a charm! Just wanted to put this out there in case anyone else is also confused with the same problem.