Shopping Feeds

[Scott.]

We run a retail B2C business and advertise a fair bit in comparison shopping engines.

Has anyone ever put together anything to manage shopping feeds? The information needed in these feeds would be based on the engines format and will change from feed to feed. They are the type of things that need to be updated daily and uploaded to shopping engines ftp sites using various rules, user names and passwords or by being placed our server for the engines to download from us.

Is anyone using ofbiz to create this kind of thing? Is there any interest in something like this?

[BJ Freeman]

basically a java service would have to produce the xml the feed needs
then store it so an URL can access it in ofbiz
or you give an FTP to where to put the xml.
then set the service to run every day.

Scott. sent the following on 10/18/2007 2:56 PM:

> We run a retail B2C business and advertise a fair bit in comparison shopping
> engines.
>
> Has anyone ever put together anything to manage shopping feeds? The
> information needed in these feeds would be based on the engines format and
> will change from feed to feed. They are the type of things that need to be
> updated daily and uploaded to shopping engines ftp sites using various
> rules, user names and passwords or by being placed our server for the
> engines to download from us.
>
> Is anyone using ofbiz to create this kind of thing? Is there any interest in
> something like this?
>
>

[wikitec]

Hi Scott

I am looking to set up ofbiz as a purely drop ship virtual warehouse,
whereby, products are displayed purely on amount available filters hopefully
using realtime xml direct links from b2b

Don't know whether this is where you are heading or not

cheers

> -----Original Message-----
> From: Scott. [mailto:[hidden email]]
> Sent: Friday, 19 October 2007 7:57 AM
> To: [hidden email]
> Subject: Shopping Feeds
>
>
> We run a retail B2C business and advertise a fair bit in comparison
> shopping
> engines.
>
> Has anyone ever put together anything to manage shopping feeds? The
> information needed in these feeds would be based on the engines format and
> will change from feed to feed. They are the type of things that need to be
> updated daily and uploaded to shopping engines ftp sites using various
> rules, user names and passwords or by being placed our server for the
> engines to download from us.
>
> Is anyone using ofbiz to create this kind of thing? Is there any interest
> in
> something like this?
>
>
> --
> View this message in context: http://www.nabble.com/Shopping-Feeds-
> tf4649990.html#a13284538
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Scott.]

Thanks for the reply guys. Here is the way I see it happening

Open the Data Feed Page. First Choice is to create a name for the data feed. Let’s use MSN Shopping as an example.

So we create the name MSN shopping and then we have a whole bunch of dropdowns that relate to fields in the database. So, using the example below, we choose from the dropdowns the corresponding fields in our database. For this particular feed it would be like this;

OFBiz Database Name              Shopping Feed Name                Friendly Name in Database
Poduct.productName               Product Name                          Widget
Product.description                 Product Description                   Nice Blue Widget
Product.manufacturerPartyId    Manufacturer Name                   My Company, Sony, Apple (Different than Vendor)
External                                MSN Categorization                   Widget Category
Product.productId                   MPN/UPC/ISBN/UniqueCode         123456 Serial Number or Item Number                
ProductPrice.Price                    Price                                         $100 (Selling Price)
Product.detailScreen                 Product URL                            ...8080/ecommerce/control/product/~category_id=WIDGETS/~product_id=123456
Prodct.detailImageUrl                Image URL                                …/images/Widgets/Blue_Widget.jpg
Inventoryitem.QuantityOnHand   Stock Availability                       Yes or No
Product.ChargeShipping            Shipping Costs                         $10, Free, Already set in OFBiz
ProductKeyword.keyword          Keywords                                 Auto Created Keywords already created in catalog manager

Once we have mapped the database to the filed requirements we would need to determine the output format and also assign a tracking code and perhaps a data source for tracking purposes. That would be appended to the url. In this case it would be a csv file but I guess XML, etc would also be good to have. Then we would choose where to place the file, enter the file name and in some instances if the file should be tarballed or zipped.

Lastly, if we have a location to upload to (i.e. ftp://msn.com/shopping_feed) and a username and password to allow for that.

wikitec wrote

Hi Scott

I am looking to set up ofbiz as a purely drop ship virtual warehouse,
whereby, products are displayed purely on amount available filters hopefully
using realtime xml direct links from b2b

Don't know whether this is where you are heading or not

cheers


> -----Original Message-----
> From: Scott. [mailto:[e-mail]]
> Sent: Friday, 19 October 2007 7:57 AM
> To: [e-mail]
> Subject: Shopping Feeds
>
>
> We run a retail B2C business and advertise a fair bit in comparison
> shopping
> engines.
>
> Has anyone ever put together anything to manage shopping feeds? The
> information needed in these feeds would be based on the engines format and
> will change from feed to feed. They are the type of things that need to be
> updated daily and uploaded to shopping engines ftp sites using various
> rules, user names and passwords or by being placed our server for the
> engines to download from us.
>
> Is anyone using ofbiz to create this kind of thing? Is there any interest
> in
> something like this?
>
>
> --
> View this message in context: http://www.nabble.com/Shopping-Feeds-
> tf4649990.html#a13284538
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[BJ Freeman]

My preference  is to do something like the product store emails.
were you can put in the variables and point to a template that generates
the output.
This is what i am moving to from the service implementation

my second option is to use the standard outputs as a service.
no user intervention.
the user can be told where the output is on a page.
if you read the feeds you will see that the assigning of where to get
the feed from ofbiz is done at the feeds themselves.



Scott. sent the following on 10/19/2007 1:17 PM:

> Thanks for the reply guys. Here is the way I see it happening
>
> This is the way I see it happening.
>
> Open the Data Feed Page. First Choice is to create a name for the data feed.
> Let’s use MSN Shopping as an example.
>
> So we create the name MSN shopping and then we have a whole bunch of
> dropdowns that relate to fields in the database. So, using the example
> below, we choose from the dropdowns the corresponding fields in our
> database. For this particular feed it would be like this;
>
> OFBiz Database Name              Shopping Feed Name                Friendly
> Name in Database
> Poduct.productName               Product Name                        
> Widget
> Product.description                 Product Description                  
> Nice Blue Widget
> Product.manufacturerPartyId    Manufacturer Name                   My
> Company, Sony, Apple (Different than Vendor)
> External                                MSN Categorization                  
> Widget Category
> Product.productId                   MPN/UPC/ISBN/UniqueCode         123456
> Serial Number or Item Number                
> ProductPrice.Price                    Price                                        
> $100 (Selling Price)
> Product.detailScreen                 Product URL                          
> ...8080/ecommerce/control/product/~category_id=WIDGETS/~product_id=123456
> Prodct.detailImageUrl                Image URL                              
> …/images/Widgets/Blue_Widget.jpg
> Inventoryitem.QuantityOnHand   Stock Availability                       Yes
> or No
> Product.ChargeShipping            Shipping Costs                        
> $10, Free, Already set in OFBiz
> ProductKeyword.keyword          Keywords                                
> Auto Created Keywords already created in catalog manager
>
> Once we have mapped the database to the filed requirements we would need to
> determine the output format and also assign a tracking code and perhaps a
> data source for tracking purposes. That would be appended to the url. In
> this case it would be a csv file but I guess XML, etc would also be good to
> have. Then we would choose where to place the file, enter the file name and
> in some instances if the file should be tarballed or zipped.
>
> Lastly, if we have a location to upload to (i.e.
> ftp://msn.com/shopping_feed) and a username and password to allow for that.
>
>
>
>
>
> wikitec wrote:
>>
>> Hi Scott
>>
>> I am looking to set up ofbiz as a purely drop ship virtual warehouse,
>> whereby, products are displayed purely on amount available filters
>> hopefully
>> using realtime xml direct links from b2b
>>
>> Don't know whether this is where you are heading or not
>>
>> cheers
>>
>>
>>> -----Original Message-----
>>> From: Scott. [mailto:[hidden email]]
>>> Sent: Friday, 19 October 2007 7:57 AM
>>> To: [hidden email]
>>> Subject: Shopping Feeds
>>>
>>>
>>> We run a retail B2C business and advertise a fair bit in comparison
>>> shopping
>>> engines.
>>>
>>> Has anyone ever put together anything to manage shopping feeds? The
>>> information needed in these feeds would be based on the engines format
>>> and
>>> will change from feed to feed. They are the type of things that need to
>>> be
>>> updated daily and uploaded to shopping engines ftp sites using various
>>> rules, user names and passwords or by being placed our server for the
>>> engines to download from us.
>>>
>>> Is anyone using ofbiz to create this kind of thing? Is there any interest
>>> in
>>> something like this?
>>>
>>>
>>> --
>>> View this message in context: http://www.nabble.com/Shopping-Feeds-
>>> tf4649990.html#a13284538
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

[Scott.]

I think I understand what you are saying.... I think.

That said, shopping feeds differ from network to network as do their file types and location to upload or download for that matter. Any serious B2C will need them at some point.

If anyone else would consider collaborating on this, I'd be happy to throw $500 in the kitty to kick the ball off.

BJ Freeman wrote

My preference  is to do something like the product store emails.
were you can put in the variables and point to a template that generates
the output.
This is what i am moving to from the service implementation

my second option is to use the standard outputs as a service.
no user intervention.
the user can be told where the output is on a page.
if you read the feeds you will see that the assigning of where to get
the feed from ofbiz is done at the feeds themselves.



Scott. sent the following on 10/19/2007 1:17 PM:
> Thanks for the reply guys. Here is the way I see it happening
>
> This is the way I see it happening.
>
> Open the Data Feed Page. First Choice is to create a name for the data feed.
> Let’s use MSN Shopping as an example.
>
> So we create the name MSN shopping and then we have a whole bunch of
> dropdowns that relate to fields in the database. So, using the example
> below, we choose from the dropdowns the corresponding fields in our
> database. For this particular feed it would be like this;
>
> OFBiz Database Name              Shopping Feed Name                Friendly
> Name in Database
> Poduct.productName               Product Name                        
> Widget
> Product.description                 Product Description                  
> Nice Blue Widget
> Product.manufacturerPartyId    Manufacturer Name                   My
> Company, Sony, Apple (Different than Vendor)
> External                                MSN Categorization                  
> Widget Category
> Product.productId                   MPN/UPC/ISBN/UniqueCode         123456
> Serial Number or Item Number                
> ProductPrice.Price                    Price                                        
> $100 (Selling Price)
> Product.detailScreen                 Product URL                          
> ...8080/ecommerce/control/product/~category_id=WIDGETS/~product_id=123456
> Prodct.detailImageUrl                Image URL                              
> …/images/Widgets/Blue_Widget.jpg
> Inventoryitem.QuantityOnHand   Stock Availability                       Yes
> or No
> Product.ChargeShipping            Shipping Costs                        
> $10, Free, Already set in OFBiz
> ProductKeyword.keyword          Keywords                                
> Auto Created Keywords already created in catalog manager
>
> Once we have mapped the database to the filed requirements we would need to
> determine the output format and also assign a tracking code and perhaps a
> data source for tracking purposes. That would be appended to the url. In
> this case it would be a csv file but I guess XML, etc would also be good to
> have. Then we would choose where to place the file, enter the file name and
> in some instances if the file should be tarballed or zipped.
>
> Lastly, if we have a location to upload to (i.e.
> ftp://msn.com/shopping_feed) and a username and password to allow for that.
>
>
>
>
>
> wikitec wrote:
>>
>> Hi Scott
>>
>> I am looking to set up ofbiz as a purely drop ship virtual warehouse,
>> whereby, products are displayed purely on amount available filters
>> hopefully
>> using realtime xml direct links from b2b
>>
>> Don't know whether this is where you are heading or not
>>
>> cheers
>>
>>
>>> -----Original Message-----
>>> From: Scott. [mailto:[e-mail]]
>>> Sent: Friday, 19 October 2007 7:57 AM
>>> To: [e-mail]
>>> Subject: Shopping Feeds
>>>
>>>
>>> We run a retail B2C business and advertise a fair bit in comparison
>>> shopping
>>> engines.
>>>
>>> Has anyone ever put together anything to manage shopping feeds? The
>>> information needed in these feeds would be based on the engines format
>>> and
>>> will change from feed to feed. They are the type of things that need to
>>> be
>>> updated daily and uploaded to shopping engines ftp sites using various
>>> rules, user names and passwords or by being placed our server for the
>>> engines to download from us.
>>>
>>> Is anyone using ofbiz to create this kind of thing? Is there any interest
>>> in
>>> something like this?
>>>
>>>
>>> --
>>> View this message in context: http://www.nabble.com/Shopping-Feeds-
>>> tf4649990.html#a13284538
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

[BJ Freeman]

Scott here is a more detailed way.
https://localhost:8443/catalog/control/EditProductStoreEmails?productStoreId=9000
as the format type for the user.
this would be an entity
as each feed is designed, it is given a place on this list like the emails.
You have a place for template that generates the data for the feed.
flag that would set if the date is pushed to a site
a place for the URL of the push.
and a URL that is set for the pull from the feed location.
If a push then the time to push.
the service for this would read this list and perform the tasks necessary.

Always open to other ideas.

Scott. sent the following on 10/20/2007 7:48 AM:

> I think I understand what you are saying.... I think.
>
> That said, shopping feeds differ from network to network as do their file
> types and location to upload or download for that matter. Any serious B2C
> will need them at some point.
>
> If anyone else would consider collaborating on this, I'd be happy to throw
> $500 in the kitty to kick the ball off.
>
>
>
>
> BJ Freeman wrote:
>> My preference  is to do something like the product store emails.
>> were you can put in the variables and point to a template that generates
>> the output.
>> This is what i am moving to from the service implementation
>>
>> my second option is to use the standard outputs as a service.
>> no user intervention.
>> the user can be told where the output is on a page.
>> if you read the feeds you will see that the assigning of where to get
>> the feed from ofbiz is done at the feeds themselves.
>>
>>
>>
>> Scott. sent the following on 10/19/2007 1:17 PM:
>>> Thanks for the reply guys. Here is the way I see it happening
>>>
>>> This is the way I see it happening.
>>>
>>> Open the Data Feed Page. First Choice is to create a name for the data
>>> feed.
>>> Let’s use MSN Shopping as an example.
>>>
>>> So we create the name MSN shopping and then we have a whole bunch of
>>> dropdowns that relate to fields in the database. So, using the example
>>> below, we choose from the dropdowns the corresponding fields in our
>>> database. For this particular feed it would be like this;
>>>
>>> OFBiz Database Name              Shopping Feed Name              
>>> Friendly
>>> Name in Database
>>> Poduct.productName               Product Name                        
>>> Widget
>>> Product.description                 Product Description                  
>>> Nice Blue Widget
>>> Product.manufacturerPartyId    Manufacturer Name                   My
>>> Company, Sony, Apple (Different than Vendor)
>>> External                                MSN Categorization                  
>>> Widget Category
>>> Product.productId                   MPN/UPC/ISBN/UniqueCode        
>>> 123456
>>> Serial Number or Item Number                
>>> ProductPrice.Price                    Price                                        
>>> $100 (Selling Price)
>>> Product.detailScreen                 Product URL                          
>>> ...8080/ecommerce/control/product/~category_id=WIDGETS/~product_id=123456
>>> Prodct.detailImageUrl                Image URL                              
>>> …/images/Widgets/Blue_Widget.jpg
>>> Inventoryitem.QuantityOnHand   Stock Availability                      
>>> Yes
>>> or No
>>> Product.ChargeShipping            Shipping Costs                        
>>> $10, Free, Already set in OFBiz
>>> ProductKeyword.keyword          Keywords                                
>>> Auto Created Keywords already created in catalog manager
>>>
>>> Once we have mapped the database to the filed requirements we would need
>>> to
>>> determine the output format and also assign a tracking code and perhaps a
>>> data source for tracking purposes. That would be appended to the url. In
>>> this case it would be a csv file but I guess XML, etc would also be good
>>> to
>>> have. Then we would choose where to place the file, enter the file name
>>> and
>>> in some instances if the file should be tarballed or zipped.
>>>
>>> Lastly, if we have a location to upload to (i.e.
>>> ftp://msn.com/shopping_feed) and a username and password to allow for
>>> that.
>>>
>>>
>>>
>>>
>>>
>>> wikitec wrote:
>>>> Hi Scott
>>>>
>>>> I am looking to set up ofbiz as a purely drop ship virtual warehouse,
>>>> whereby, products are displayed purely on amount available filters
>>>> hopefully
>>>> using realtime xml direct links from b2b
>>>>
>>>> Don't know whether this is where you are heading or not
>>>>
>>>> cheers
>>>>
>>>>
>>>>> -----Original Message-----
>>>>> From: Scott. [mailto:[hidden email]]
>>>>> Sent: Friday, 19 October 2007 7:57 AM
>>>>> To: [hidden email]
>>>>> Subject: Shopping Feeds
>>>>>
>>>>>
>>>>> We run a retail B2C business and advertise a fair bit in comparison
>>>>> shopping
>>>>> engines.
>>>>>
>>>>> Has anyone ever put together anything to manage shopping feeds? The
>>>>> information needed in these feeds would be based on the engines format
>>>>> and
>>>>> will change from feed to feed. They are the type of things that need to
>>>>> be
>>>>> updated daily and uploaded to shopping engines ftp sites using various
>>>>> rules, user names and passwords or by being placed our server for the
>>>>> engines to download from us.
>>>>>
>>>>> Is anyone using ofbiz to create this kind of thing? Is there any
>>>>> interest
>>>>> in
>>>>> something like this?
>>>>>
>>>>>
>>>>> --
>>>>> View this message in context: http://www.nabble.com/Shopping-Feeds-
>>>>> tf4649990.html#a13284538
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>
>>
>

[David E Jones]

Scott,

There are a few such integrations around. I know, for example, some  
have been done with amazon and shop.com at least. There is an ebay  
integration in place in OFBiz (kind of spread around, though I think  
it should be moved to it's own component and special app as it is  
kind of funny to have buttons that say "eBay" in the ofbiz order  
manager).

These are generally fairly simple, though sometimes customization is  
needed for different types/sets of products to send over and such. I  
know there are others on this list who have more experience than I do  
with these, hopefully someone will chime in.

BTW, not sure what BJ was saying about email and such, but in general  
with OFBiz integrations take whatever form the other system needs,  
and in this case like you mentioned I think sending files over FTP is  
actually pretty common, and what the ones I have seen do (and the  
ones we've done for clients at Hotwax).

-David


On Oct 20, 2007, at 8:48 AM, Scott. wrote:

>
> I think I understand what you are saying.... I think.
>
> That said, shopping feeds differ from network to network as do  
> their file
> types and location to upload or download for that matter. Any  
> serious B2C
> will need them at some point.
>
> If anyone else would consider collaborating on this, I'd be happy  
> to throw
> $500 in the kitty to kick the ball off.
>
>
>
>
> BJ Freeman wrote:
>>
>> My preference  is to do something like the product store emails.
>> were you can put in the variables and point to a template that  
>> generates
>> the output.
>> This is what i am moving to from the service implementation
>>
>> my second option is to use the standard outputs as a service.
>> no user intervention.
>> the user can be told where the output is on a page.
>> if you read the feeds you will see that the assigning of where to get
>> the feed from ofbiz is done at the feeds themselves.
>>
>>
>>
>> Scott. sent the following on 10/19/2007 1:17 PM:
>>> Thanks for the reply guys. Here is the way I see it happening
>>>
>>> This is the way I see it happening.
>>>
>>> Open the Data Feed Page. First Choice is to create a name for the  
>>> data
>>> feed.
>>> Let’s use MSN Shopping as an example.
>>>
>>> So we create the name MSN shopping and then we have a whole bunch of
>>> dropdowns that relate to fields in the database. So, using the  
>>> example
>>> below, we choose from the dropdowns the corresponding fields in our
>>> database. For this particular feed it would be like this;
>>>
>>> OFBiz Database Name              Shopping Feed Name
>>> Friendly
>>> Name in Database
>>> Poduct.productName               Product Name
>>> Widget
>>> Product.description                 Product Description
>>> Nice Blue Widget
>>> Product.manufacturerPartyId    Manufacturer  
>>> Name                   My
>>> Company, Sony, Apple (Different than Vendor)
>>> External                                MSN Categorization
>>> Widget Category
>>> Product.productId                   MPN/UPC/ISBN/UniqueCode
>>> 123456
>>> Serial Number or Item Number
>>> ProductPrice.Price                    Price
>>> $100 (Selling Price)
>>> Product.detailScreen                 Product URL
>>> ...8080/ecommerce/control/product/~category_id=WIDGETS/
>>> ~product_id=123456
>>> Prodct.detailImageUrl                Image URL
>>> …/images/Widgets/Blue_Widget.jpg
>>> Inventoryitem.QuantityOnHand   Stock Availability
>>> Yes
>>> or No
>>> Product.ChargeShipping            Shipping Costs
>>> $10, Free, Already set in OFBiz
>>> ProductKeyword.keyword          Keywords
>>> Auto Created Keywords already created in catalog manager
>>>
>>> Once we have mapped the database to the filed requirements we  
>>> would need
>>> to
>>> determine the output format and also assign a tracking code and  
>>> perhaps a
>>> data source for tracking purposes. That would be appended to the  
>>> url. In
>>> this case it would be a csv file but I guess XML, etc would also  
>>> be good
>>> to
>>> have. Then we would choose where to place the file, enter the  
>>> file name
>>> and
>>> in some instances if the file should be tarballed or zipped.
>>>
>>> Lastly, if we have a location to upload to (i.e.
>>> ftp://msn.com/shopping_feed) and a username and password to allow  
>>> for
>>> that.
>>>
>>>
>>>
>>>
>>>
>>> wikitec wrote:
>>>>
>>>> Hi Scott
>>>>
>>>> I am looking to set up ofbiz as a purely drop ship virtual  
>>>> warehouse,
>>>> whereby, products are displayed purely on amount available filters
>>>> hopefully
>>>> using realtime xml direct links from b2b
>>>>
>>>> Don't know whether this is where you are heading or not
>>>>
>>>> cheers
>>>>
>>>>
>>>>> -----Original Message-----
>>>>> From: Scott. [mailto:[hidden email]]
>>>>> Sent: Friday, 19 October 2007 7:57 AM
>>>>> To: [hidden email]
>>>>> Subject: Shopping Feeds
>>>>>
>>>>>
>>>>> We run a retail B2C business and advertise a fair bit in  
>>>>> comparison
>>>>> shopping
>>>>> engines.
>>>>>
>>>>> Has anyone ever put together anything to manage shopping feeds?  
>>>>> The
>>>>> information needed in these feeds would be based on the engines  
>>>>> format
>>>>> and
>>>>> will change from feed to feed. They are the type of things that  
>>>>> need to
>>>>> be
>>>>> updated daily and uploaded to shopping engines ftp sites using  
>>>>> various
>>>>> rules, user names and passwords or by being placed our server  
>>>>> for the
>>>>> engines to download from us.
>>>>>
>>>>> Is anyone using ofbiz to create this kind of thing? Is there any
>>>>> interest
>>>>> in
>>>>> something like this?
>>>>>
>>>>>
>>>>> --
>>>>> View this message in context: http://www.nabble.com/Shopping- 
>>>>> Feeds-
>>>>> tf4649990.html#a13284538
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Shopping-Feeds- 
> tf4649990.html#a13310611
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jacques Le Roux]

De : "David E Jones" <[hidden email]>

Scott,

There are a few such integrations around. I know, for example, some  
have been done with amazon and shop.com at least. There is an ebay  
integration in place in OFBiz (kind of spread around, though I think  
it should be moved to it's own component and special app as it is  
kind of funny to have buttons that say "eBay" in the ofbiz order  
manager).

+1 : Yes, if the person who did is reading, please move it away from order, thanks

Jacques

[Jacopo Cappellato]

Jacques Le Roux wrote:

> De : "David E Jones" <[hidden email]>
>
> Scott,
>
> There are a few such integrations around. I know, for example, some  
> have been done with amazon and shop.com at least. There is an ebay  
> integration in place in OFBiz (kind of spread around, though I think  
> it should be moved to it's own component and special app as it is  
> kind of funny to have buttons that say "eBay" in the ofbiz order  
> manager).
>
> +1 : Yes, if the person who did is reading, please move it away from order, thanks
>
> Jacques

Who the hell was he? :-)
I've created two Jira issues (OFBIZ-1358, OFBIZ-1359), and assigned to
me, to move the Google and eBay integration into two specialpurpose
components:
"google" and "ebay" are good names?

I'll work on these tasks asap.

Should we then merge the googleCheckout component?


Jacopo

[Jacques Le Roux]

De : "Jacopo Cappellato" <[hidden email]>
Objet : Google and eBay integration WAS: Re: Shopping Feeds

> Jacques Le Roux wrote:
> > De : "David E Jones" <[hidden email]>
> >
> > Scott,
> >
> > There are a few such integrations around. I know, for example, some  
> > have been done with amazon and shop.com at least. There is an ebay  
> > integration in place in OFBiz (kind of spread around, though I think  
> > it should be moved to it's own component and special app as it is  
> > kind of funny to have buttons that say "eBay" in the ofbiz order  
> > manager).
> >
> > +1 : Yes, if the person who did is reading, please move it away from order, thanks
> >
> > Jacques
>
> Who the hell was he? :-)
> I've created two Jira issues (OFBIZ-1358, OFBIZ-1359), and assigned to
> me, to move the Google and eBay integration into two specialpurpose
> components:
> "google" and "ebay" are good names?

Maybe with more suggesting names. THoug ebay sounds clear but Google alone sounds ambiguous (Google offers a lot of services)
 
> I'll work on these tasks asap.
>
> Should we then merge the googleCheckout component?

I don't know much about them, but sounds like logical.(if it's possible to do so)

Jacques

>
> Jacopo
>

[BJ Freeman]

I guess there are two terms for shopping feeds.
The one I was thinking of is like what scott describe and froggle.
These are where you products are advertised on other search engines,
then I directed to your store.

David E Jones sent the following on 10/20/2007 10:07 AM:

>
> Scott,
>
> There are a few such integrations around. I know, for example, some have
> been done with amazon and shop.com at least. There is an ebay
> integration in place in OFBiz (kind of spread around, though I think it
> should be moved to it's own component and special app as it is kind of
> funny to have buttons that say "eBay" in the ofbiz order manager).
>
> These are generally fairly simple, though sometimes customization is
> needed for different types/sets of products to send over and such. I
> know there are others on this list who have more experience than I do
> with these, hopefully someone will chime in.
>
> BTW, not sure what BJ was saying about email and such, but in general
> with OFBiz integrations take whatever form the other system needs, and
> in this case like you mentioned I think sending files over FTP is
> actually pretty common, and what the ones I have seen do (and the ones
> we've done for clients at Hotwax).
>
> -David
>
>
> On Oct 20, 2007, at 8:48 AM, Scott. wrote:
>
>>
>> I think I understand what you are saying.... I think.
>>
>> That said, shopping feeds differ from network to network as do their file
>> types and location to upload or download for that matter. Any serious B2C
>> will need them at some point.
>>
>> If anyone else would consider collaborating on this, I'd be happy to
>> throw
>> $500 in the kitty to kick the ball off.
>>
>>
>>
>>
>> BJ Freeman wrote:
>>>
>>> My preference  is to do something like the product store emails.
>>> were you can put in the variables and point to a template that generates
>>> the output.
>>> This is what i am moving to from the service implementation
>>>
>>> my second option is to use the standard outputs as a service.
>>> no user intervention.
>>> the user can be told where the output is on a page.
>>> if you read the feeds you will see that the assigning of where to get
>>> the feed from ofbiz is done at the feeds themselves.
>>>
>>>
>>>
>>> Scott. sent the following on 10/19/2007 1:17 PM:
>>>> Thanks for the reply guys. Here is the way I see it happening
>>>>
>>>> This is the way I see it happening.
>>>>
>>>> Open the Data Feed Page. First Choice is to create a name for the data
>>>> feed.
>>>> Let’s use MSN Shopping as an example.
>>>>
>>>> So we create the name MSN shopping and then we have a whole bunch of
>>>> dropdowns that relate to fields in the database. So, using the example
>>>> below, we choose from the dropdowns the corresponding fields in our
>>>> database. For this particular feed it would be like this;
>>>>
>>>> OFBiz Database Name              Shopping Feed Name
>>>> Friendly
>>>> Name in Database
>>>> Poduct.productName               Product Name
>>>> Widget
>>>> Product.description                 Product Description
>>>> Nice Blue Widget
>>>> Product.manufacturerPartyId    Manufacturer Name                   My
>>>> Company, Sony, Apple (Different than Vendor)
>>>> External                                MSN Categorization
>>>> Widget Category
>>>> Product.productId                   MPN/UPC/ISBN/UniqueCode
>>>> 123456
>>>> Serial Number or Item Number
>>>> ProductPrice.Price                    Price
>>>> $100 (Selling Price)
>>>> Product.detailScreen                 Product URL
>>>> ...8080/ecommerce/control/product/~category_id=WIDGETS/~product_id=123456
>>>>
>>>> Prodct.detailImageUrl                Image URL
>>>> …/images/Widgets/Blue_Widget.jpg
>>>> Inventoryitem.QuantityOnHand   Stock Availability
>>>> Yes
>>>> or No
>>>> Product.ChargeShipping            Shipping Costs
>>>> $10, Free, Already set in OFBiz
>>>> ProductKeyword.keyword          Keywords
>>>> Auto Created Keywords already created in catalog manager
>>>>
>>>> Once we have mapped the database to the filed requirements we would
>>>> need
>>>> to
>>>> determine the output format and also assign a tracking code and
>>>> perhaps a
>>>> data source for tracking purposes. That would be appended to the
>>>> url. In
>>>> this case it would be a csv file but I guess XML, etc would also be
>>>> good
>>>> to
>>>> have. Then we would choose where to place the file, enter the file name
>>>> and
>>>> in some instances if the file should be tarballed or zipped.
>>>>
>>>> Lastly, if we have a location to upload to (i.e.
>>>> ftp://msn.com/shopping_feed) and a username and password to allow for
>>>> that.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> wikitec wrote:
>>>>>
>>>>> Hi Scott
>>>>>
>>>>> I am looking to set up ofbiz as a purely drop ship virtual warehouse,
>>>>> whereby, products are displayed purely on amount available filters
>>>>> hopefully
>>>>> using realtime xml direct links from b2b
>>>>>
>>>>> Don't know whether this is where you are heading or not
>>>>>
>>>>> cheers
>>>>>
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Scott. [mailto:[hidden email]]
>>>>>> Sent: Friday, 19 October 2007 7:57 AM
>>>>>> To: [hidden email]
>>>>>> Subject: Shopping Feeds
>>>>>>
>>>>>>
>>>>>> We run a retail B2C business and advertise a fair bit in comparison
>>>>>> shopping
>>>>>> engines.
>>>>>>
>>>>>> Has anyone ever put together anything to manage shopping feeds? The
>>>>>> information needed in these feeds would be based on the engines
>>>>>> format
>>>>>> and
>>>>>> will change from feed to feed. They are the type of things that
>>>>>> need to
>>>>>> be
>>>>>> updated daily and uploaded to shopping engines ftp sites using
>>>>>> various
>>>>>> rules, user names and passwords or by being placed our server for the
>>>>>> engines to download from us.
>>>>>>
>>>>>> Is anyone using ofbiz to create this kind of thing? Is there any
>>>>>> interest
>>>>>> in
>>>>>> something like this?
>>>>>>
>>>>>>
>>>>>> --
>>>>>> View this message in context: http://www.nabble.com/Shopping-Feeds-
>>>>>> tf4649990.html#a13284538
>>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>>
>>>
>>>
>>>
>>
>> --View this message in context:
>> http://www.nabble.com/Shopping-Feeds-tf4649990.html#a13310611
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>