View Cart|Wish List|Login|Register | Thursday, May 24, 2012
 
 Search   ..:: Support &
    Service
  Forum
::..
 
    Minimize
www.catalooksupport.com ::: another place for CATALooK.netStore support

    Minimize
SearchForum Home
     
  DotNetNuke  CATALooK.netStore  One product dat...
 One product database, multiple portals on same instance
 
 10/11/2006 2:59:41 PM
cchubb
10 posts


One product database, multiple portals on same instance
I have three web sites running on the same DNN installation. Three different stores, but I would like all three to sell the exact same products. Is this possible without having to manage three different product databases? I don't want to have to enter the same product three times, upload the same images three times or do an export/import every time the products are uploaded.

I have been over the manual a couple of times and I can't see how I would configure for this behavior.


 10/11/2006 6:35:18 PM
YodaRocks
60 posts


Re: One product database, multiple portals on same instance

I am currently maintaining two child portals on the same DNN installation, each carrying the same products. To do so, I first tried to do data synchronization, with the products in each child portal carrying the same product number. To be honest, this was not working very well for me though I no longer remember exactly why. Since I do not maintain inventory for my stores, I ended up turning off synchronization and, instead, did an XML export from one store with products and then an import into the other store. I don't have a lot of change in the "inventory" so when I add something, I do it manually to each portal at this point.

The thing that I recall about the synchronization method (again, I no longer use that method), is that certain data fields but not all are synchronized. I think the product description is synchronized, if I recall, but the title is not though I only briefly tried this method before concluding I didn't really need it for my particular solution.

Anyway, the point is that it is possible to have one code base for products using synchronization. However, I spent so little time with that technique that Susanne or someone more knowledgeable about it would have to respond on the more technical aspects.

Hope this helps.

 10/12/2006 5:17:46 PM
host
1836 posts
1st


Re: One product database, multiple portals on same instance

All products must be added to all portals with the same product number / item code before they will be included in the sync process. If you want add fields to sync. or remove fields from sync., you must change the following stored stored procedure:  CAT_ProductUpdate . The default fields are listed in the chapter below:

Database synchronization between portals

The Product tables of all portals which have the [Product data synchronization] option enabled will be included in the synchronization job.
The unique key is the field (column) ProductNumber of the table CAT_Products. This field is named [Item code] on module CAT_Products. If a field of the table CAT_Products which is included in the synchronization is changed in one portal all products of the other portals with the same ProductNumber will also be changed.

The synchronization is realized under the consideration of these fields (UnitCost and BulkPriceLimit Fields are not included):

Category3
ProductName EAN
ISBN
Free1
Free2
...

 

If you only use English as portal language, you must delete all entries of the CAT_Resources table to activate the standard entries from the cat_products table for the localized fields e.g. Productname, Description, DescriptionHTML etc:

 

Host -> SQL execute: Delete from {databaseOwner}CAT_Resources

 

 10/12/2006 6:58:10 PM
cchubb
10 posts


Re: One product database, multiple portals on same instance
Thanks, I did not have a product key. I went back and added that to my products in the master portal. I checked and all three portals have the "Product Data Syncronization" checkbox checked.

I deleted the regionalization descriptions with:
Delete from {databaseOwner}CAT_Resources WHERE [name] LIKE 'Product%' so I would not loose the category descriptions.
Do I have to do the delete of the local resources every time a description is updated or a new product is added?


After I went through and added product keys to my products, I still don't see the products on my secondary portals. Do I have to do an export/import sync to make the products distribute? Your note makes it sound like it will happen whenever a product is edited, but I edited my products and that did not distribute the data to the other portals. Is there something else that I have to do?


 10/14/2006 11:00:26 AM
host
1836 posts
1st


Re: One product database, multiple portals on same instance
1) Yes, currently you must run this script after you have updated any field on one of the portals. This will be fixed in one of the coming versions.
2) The sync feature will not add the products to the other portals. They must exists there with the same productnumber (item code). To add the products to the other portals you can use the item export of module CAT_Products and the item import of module CAT_StoreSettings. 
 4/25/2007 1:37:27 AM
webTester
39 posts


Re: One product database, multiple portals on same instance
Ok I have the same scenario.  I want to have one store and many child stores selling a subset of products from the main store.  So let me just do a run-down of what I've read here and in the manual of ways to acheive this:

1.  Add the subset of products to the child store with the product number and item code matching whats in the parent store.  (I'm assuming that I don't have to add all products if I don't plan to sell all products).  The parent store may have 1800 products while the child store may have only 10 so I would just add those 10 to the child store.

2.  Make sure that the 'Product data synchronization' option is selected for all stores.

3.   Delete everything from the CAT_Resources if english is my only portal language.

4.  Then when I make an update to products in the main / parent store I need to run a special script that will sync the data (or does it happen automatically?  I'm a little fuzzy on this point).

Have I got it right?  This is very important functionality for us as we presently have many stores that feed from one store.
  DotNetNuke  CATALooK.netStore  One product dat...

    Minimize
www.excommerce.com ::: eXcommerce are a dedicated reseller of Catalook. If you want the features of catalook without the hassle of setup and maintenance and want some extra support options please check our services.
      

References / Live Stores | Forum | Trial Downloads | Resource Directory | Release History | Support Requests | Referral Program | Contact
CATALooK |  Terms Of Use |  Privacy Statement
Copyright 2002-2010 CATALooK