Update entity product - mass update for producut price

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
su2
Reply | Threaded
Open this post in threaded view
|

Update entity product - mass update for producut price

su2
Hello All,

We have requirement where we need to do mass update on product price(also few other things, supplier etc) once every two weeks, we have thousands of products for which manual updates are not possible.

I would really appreciate if someone can give me some idea. We have ProductID and Product Price in one excel.

Thank you in advance.
Su-

 
Reply | Threaded
Open this post in threaded view
|

Re: Update entity product - mass update for producut price

Jeroen van der Wal-2
Hi Su,

We've used Talend Open Studio in a project to upload data from various
sources by calling services through the XML-RPC interface.

Jeroen van der Wal
Stromboli b.v.
+31 655 874050


On Mon, Jan 25, 2010 at 3:47 PM, su2 <[hidden email]> wrote:

>
> Hello All,
>
> We have requirement where we need to do mass update on product price(also
> few other things, supplier etc) once every two weeks, we have thousands of
> products for which manual updates are not possible.
>
> I would really appreciate if someone can give me some idea. We have
> ProductID and Product Price in one excel.
>
> Thank you in advance.
> Su-
>
>
> --
> View this message in context:
> http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
su2
Reply | Threaded
Open this post in threaded view
|

Re: Update entity product - mass update for producut price

su2
In reply to this post by su2
Thank you Jeroen for the reply.

Can you please elaborate the 'calling services through the XML-RPC interface.'

As what I understood from webtools > XML import  i can import data, but i want to update data that means I will have "WHERE" condition while updating the tables/entities.

I am looking into Talend Open Studio.

Thank you.
su-
Reply | Threaded
Open this post in threaded view
|

Re: Update entity product - mass update for producut price

Rishi Solanki
In reply to this post by su2
Hi,
Have a look at the ImprotProductServices.java >>
productImportFromSpreadsheet.
More you find at -
http://cwiki.apache.org/confluence/display/OFBIZ/Import+Data+Using+Apache+POI+api

Rishi Solanki
Enterprise Software Developer
HotWax Media Pvt. Ltd.


On Mon, Jan 25, 2010 at 8:17 PM, su2 <[hidden email]> wrote:

>
> Hello All,
>
> We have requirement where we need to do mass update on product price(also
> few other things, supplier etc) once every two weeks, we have thousands of
> products for which manual updates are not possible.
>
> I would really appreciate if someone can give me some idea. We have
> ProductID and Product Price in one excel.
>
> Thank you in advance.
> Su-
>
>
> --
> View this message in context:
> http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Update entity product - mass update for producut price

Ashish Vijaywargiya
In reply to this post by su2
For more details on XML-RPC please have a look on http://ws.apache.org/xmlrpc/.
Using XML-RPC libraries you can call OFBiz services remotely by
setting attribute export="true" in service definition.

For more details you can refer existing code OOTB.
Refer XmlRpc*.java files & refer "xmlrpc" controller entry in webtools
component.

    <request-map uri="xmlrpc" track-serverhit="false" track-visit="false">
        <event type="xmlrpc"/>
        <response name="error" type="none"/>
        <response name="success" type="none"/>
    </request-map>

HTH!

--
Ashish

On Mon, Jan 25, 2010 at 9:55 PM, su2 <[hidden email]> wrote:

>
> Thank you Jeroen for the reply.
>
> Can you please elaborate the 'calling services through the XML-RPC
> interface.'
>
> As what I understood from webtools > XML import  i can import data, but i
> want to update data that means I will have "WHERE" condition while updating
> the tables/entities.
>
> I am looking into Talend Open Studio.
>
> Thank you.
> su-
> --
> View this message in context: http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289508.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
su2
Reply | Threaded
Open this post in threaded view
|

Re: Update entity product - mass update for producut price

su2
Will this XMLRPC work with the "WHERE" clause.

I have 4000+ items/rows to update with "WHERE" clause. My Sample query I want to execute is

UPDATE PRODUCT SET WEIGHT = 1 WHERE PRODUCT_ID = 'xyz123'

Can please somebody help me with this?

Thank you.
Su-
Reply | Threaded
Open this post in threaded view
|

Re: Update entity product - mass update for producut price

Bilgin Ibryam-2
su2 wrote:

> Will this XMLRPC work with the "WHERE" clause.
>
> I have 4000+ items/rows to update with "WHERE" clause. My Sample query I
> want to execute is
>
> UPDATE PRODUCT SET WEIGHT = 1 WHERE PRODUCT_ID = 'xyz123'
>
> Can please somebody help me with this?
>
> Thank you.
> Su-
>  

First you have to create an ofbiz service which takes the productId(your
where clause) and fields to update (wight for example).
Then using xmlrpc you can call this service for each line (4000 times)

Bilgin