Hi Carlos.
You can load your product on dedicate entity (like "CustomerProduct) on
a dedicate entity group. OFBiz would be connected at both database. Each
night, run a incremental loading product service to load from
CustomerProduct to Product only new product. If you need manage update
and delete, see if you have stamp field on your customer database to
detect change quickly or look if you can use webservice to alert your OFBiz.
Nicolas
Le 20/11/2012 02:36, J. Carlos Cigala a écrit :
Hi Everyone! This is our issue:
Our Customer has a 3 million's products database. It is likely that many of
the 3 million products not be sold, but must be able to show them if someone
wants to see while visiting the website.
This database is updated whenever has new product information; this can be
done even daily.
The product's database is MySQL, but we have installed PostgreSQL for OfBiz.
Of course, we need the ability to index and search for products.
We have some ideas to handle this requirement:
One, run the MySQL database in a local server, where we execute the updates,
and then export the changes to the production server (PostgreSQL)
Other one, install MySQL in the production server for make the updates and
the export process into the production server; this could affect the server
performance in the future, when the website has more visits.
Both proposals above are a few "brute force based", due to the need of
export ALL 3 million products from the external database (many of which will
not ever sell, so they will not generate purchasing, inventory, and other
movements) to the OfBiz database.
All of this for enjoys the product's search and index possibilities.
However, at the end of the day, the external product's database is a
"read-only" database or, in other words, a catalog, like the gadgets
catalog, which we read in the airplane: many pretty products but perhaps we
purchase one; so, why we will create millions of products in the database
that may never be used?
Also, faced with the integration issues...
Since we are working on OfBiz I'm looking for an easier and more elegant way
to solve this issue. I have thought to generate product pages via to access
external information (MySQL in this case) and, only if the Customer buys the
product, then create the product in the inventory system with the shopping
cart information. I think it could be related to the Content Manager System.
Today, some business have no merchandise stock, but they purchase once they
have sold. Our Customer has the inventory information of their providers,
and when he make a sale, then he put a order, asking to the provider if they
can ship the merchandise directly to the consumer.
Any idea? Thank you in advance.
--
J. Carlos Cigala
http://www.infovolution.com/
