Importing Store and Product info Contribution.

[BJ Freeman]

I view this more as a working example, and skeleton for others to build on.

In Yahoo, there is an xml export that has the store settings and products.
I have created a little more than a straight forward import that lets
you read in your own product structure and create products in a catalog
and link it to a product Store. in the Case of Yahoo the Store setting
are included in the Products export.

This is used over and over as the yahoo store is modified and is run as
a scheduled task. There are properties to control its behavior.

This is accomplish thru two classes that you load with your import and
the classes to the work of loading it into ofbiz.

At this time, it has handled about a 8 meg xml file.

here is what it does.

The Store Setting class will Create a new ProductCatalog, Store and
Website, if it does not find one, then associated them all together. it
has properties for defaults.


This uses the Product ID assigned by Yahoo for the ProductID in ofbiz.
the import checks if the productID already exists and make a Task if it
does.  I left a hook in there for Checking Good Identification as an
alternative.

if it does not exist the it creates a product and inventory item and
imports the various data.  if the data includes Categories then they are
added to the product catalog. if it does exist but all the values do not
match then a task is created for someone to check an make changes.


The Product processing is sort of kludge in the way that it is from my
online system, so I stole my code for products as a class that does all
the work and modified it to ofbiz entities.  At some point I may make it
a service, but not this year.

the Products Class has some properties for setting defaults on import,
so if they are Blank it fills them in.

if anything new is added then a task is generated, so it can be checked out.



   for my purposes, I have created a application folder for my various
import Exports, about 50 so far. This includes importing from suppliers
emails, FTP and Websites exporting to website and ftp sites.

so should I create a patch from that folder or do you have some Ideas on
how I should integrate  the store/product/inventory import.

[davidnwelton]

>    for my purposes, I have created a application folder for my various
> import Exports, about 50 so far. This includes importing from suppliers
> emails, FTP and Websites exporting to website and ftp sites.

Interesting work - this is definitely something that's quite necessary
for a 'real world' ecommerce app - managing and integrating data feeds
to and from various suppliers.

--
David N. Welton
 - http://www.dedasys.com/davidw/

Linux, Open Source Consulting
 - http://www.dedasys.com/

[BJ Freeman]

My main Business is SupplyChain and B-B communications
I run Database farms for Businesses and keep their inventory data.
Then I provide service to buyers on providing the inventory data.
So Now I am bringing alot of this to ofbiz, both as a backend processor
for Websites already running and New Customers that had not thought of a
website, but just Retail Inventory control.

The other application that I will be contributing, is not Apache
acceptable, since it was originally license under GNU, The author
approved my use of the code.
This is an AS2 application for Supply chain communication, that I have
modified to use the ofbiz framework.

So if it can not be included in the Jira, I will be putting it on my
sourceforge site.

David Welton sent the following on 7/2/2006 1:26 AM:
>>    for my purposes, I have created a application folder for my various
>> import Exports, about 50 so far. This includes importing from suppliers
>> emails, FTP and Websites exporting to website and ftp sites.
>
> Interesting work - this is definitely something that's quite necessary
> for a 'real world' ecommerce app - managing and integrating data feeds
> to and from various suppliers.
>