Product table partition per catalog

[Former Member]

I need to understand the possibility of store/manage the same product information for each catalog distributed to different tables. For example, if I have a product say 'A' and the catalogs 'C1', 'C2, and 'C3' then is there a possibility to store A:C1, A:C2 and A:C3 in more than one table (which would be usually PRODUCT table).

[Former Member]

Though you've shared you suggestion already, we would like to know whether there's a feature in Hybris to support to store different catalog version in mode than one table?

[Former Member]

Thanks once again for your suggestion.

I'm not clear whether the restriction mechanism with single catalog would be able to support following: duplicate check, workflows (enrichment/approval), DAM, business rules and so on. If these functionality are mandate then, we are left with no choice to have a staging area at PCM end. Please correct me if I'm wrong.

Is there any best practices on the PCM vs eCommerce deployment design which Hybris recommends? So that I can use it as a reference to finalise the solution for the implementation we're about the complete the design phase.

[Former Member]

One option is to look a separating PCM and Commerce into different instances and not share the DB.

To optimize a single instance in many cases we can avoid excessive use of CatalogVersions (which are a copy of the catalog content) and instead use a restriction mechanism (e.g. a relation between Product and something) to determine the availability of a Product in channels, brands, regions etc. We have a package that does exactly this, see "Multi Country and Channel Enhancements" here https://wiki.hybris.com/display/hyps/hybris+Professional+Services+-+Service+Packages

[Former Member]

Thanks a lot for the prompt response.

I'm looking to setup the Hybris PCM and eCommerce in a single instance/sharing single JVM. Check for the potential implementation options to distribute the Product table to more than one table so that PCM and eCommerce access of Product table can be optimally managed. More technically, the staged/online version of product data should sit in Product_PCM table and stage/online version of product data should sit in Product_eCommerce table.

Please suggest even if there's a better design approach to implement the Hybris PCM and eCommerce in single instance model which should support large volume of product data (multiple sellers, multiple categories, multiple variants combinations).

[Former Member]

This isn't possible unfortunately. What problem are you trying to solve?