To delete product

[Prabhakaran Duraisamy]

Hi,

  How to delete a created product

--
Regards,

Prabhakaran.D

[phone]

[S K Pradeep kumar]

just don't assign it to any category if you don't want in the database
delete using query.
With regards,
S K Pradeep kumar,



On Wed, Oct 7, 2009 at 12:49 PM, Prabhakaran Duraisamy <
[hidden email]> wrote:

> Hi,
>
>  How to delete a created product
>
> --
> Regards,
>
> Prabhakaran.D
>
> [phone]
>

[Prabhakaran Duraisamy]

Thanks Pradeep.. That is in Web tools ---> Entity SQL Processor

On Wed, Oct 7, 2009 at 12:52 PM, S K Pradeep kumar <
[hidden email]> wrote:

> just don't assign it to any category if you don't want in the database
> delete using query.
> With regards,
> S K Pradeep kumar,
>
>
>
> On Wed, Oct 7, 2009 at 12:49 PM, Prabhakaran Duraisamy <
> [hidden email]> wrote:
>
> > Hi,
> >
> >  How to delete a created product
> >
> > --
> > Regards,
> >
> > Prabhakaran.D
> >
> > [phone]
> >
>

--
Regards,

Prabhakaran.D

[phone]

[Prabhakaran Duraisamy]

Hi pradeep,

Where I Specify the Query to delete the product in database

[S K Pradeep kumar]

Try in EntitySQLProcessor
With regards,
S K Pradeep kumar,



On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
[hidden email]> wrote:

> Hi pradeep,
>
> Where I Specify the Query to delete the product in database
>

[Prabhakaran Duraisamy]

Hi pradeep

   I specify the Query to delete product in Entity SQL Query, there is error
report of foreign Key .Can you help me with Query

Thanks
D.Prabhakaran

On Wed, Oct 7, 2009 at 2:42 PM, S K Pradeep kumar <
[hidden email]> wrote:

> Try in EntitySQLProcessor
> With regards,
> S K Pradeep kumar,
>
>
>
> On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
> [hidden email]> wrote:
>
> > Hi pradeep,
> >
> > Where I Specify the Query to delete the product in database
> >
>

--
Regards,

Prabhakaran.D

[phone]

[S K Pradeep kumar]

delete from `PRODUCT_KEYWORD` where `PRODUCT_ID`='SP-1000';
delete from `PRODUCT_CALCULATED_INFO` where `PRODUCT_ID`='SP-1000';
delete from `PRODUCT_PRICE` where `PRODUCT_ID`='SP-1000';
delete from `INVENTORY_ITEM_DETAIL` where `INVENTORY_ITEM_ID` IN (SELECT
`INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000');
delete from `INVENTORY_ITEM_VARIANCE` where `INVENTORY_ITEM_ID` IN (SELECT
`INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000');
delete from `SHIPMENT_RECEIPT` where `INVENTORY_ITEM_ID` IN (SELECT
`INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000');
delete from `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000';
delete from `PRODUCT_CATEGORY_MEMBER` where `PRODUCT_ID`='SP-1000';
delete from `PRODUCT` where `PRODUCT_ID`='SP-1000';


With regards,
S K Pradeep kumar,



On Thu, Oct 8, 2009 at 10:32 AM, Prabhakaran Duraisamy <
[hidden email]> wrote:

> Hi pradeep
>
>   I specify the Query to delete product in Entity SQL Query, there is error
> report of foreign Key .Can you help me with Query
>
> Thanks
> D.Prabhakaran
>
> On Wed, Oct 7, 2009 at 2:42 PM, S K Pradeep kumar <
> [hidden email]> wrote:
>
> > Try in EntitySQLProcessor
> > With regards,
> > S K Pradeep kumar,
> >
> >
> >
> > On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
> > [hidden email]> wrote:
> >
> > > Hi pradeep,
> > >
> > > Where I Specify the Query to delete the product in database
> > >
> >
>
>
>
> --
> Regards,
>
> Prabhakaran.D
>
> [phone]
>

[Prabhakaran Duraisamy]

Thanks Pradeep,,,,

On Thu, Oct 8, 2009 at 11:26 AM, S K Pradeep kumar <
[hidden email]> wrote:

> delete from `PRODUCT_KEYWORD` where `PRODUCT_ID`='SP-1000';
> delete from `PRODUCT_CALCULATED_INFO` where `PRODUCT_ID`='SP-1000';
> delete from `PRODUCT_PRICE` where `PRODUCT_ID`='SP-1000';
> delete from `INVENTORY_ITEM_DETAIL` where `INVENTORY_ITEM_ID` IN (SELECT
> `INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000');
> delete from `INVENTORY_ITEM_VARIANCE` where `INVENTORY_ITEM_ID` IN (SELECT
> `INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000');
> delete from `SHIPMENT_RECEIPT` where `INVENTORY_ITEM_ID` IN (SELECT
> `INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000');
> delete from `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000';
> delete from `PRODUCT_CATEGORY_MEMBER` where `PRODUCT_ID`='SP-1000';
> delete from `PRODUCT` where `PRODUCT_ID`='SP-1000';
>
>
> With regards,
> S K Pradeep kumar,
>
>
>
> On Thu, Oct 8, 2009 at 10:32 AM, Prabhakaran Duraisamy <
> [hidden email]> wrote:
>
> > Hi pradeep
> >
> >   I specify the Query to delete product in Entity SQL Query, there is
> error
> > report of foreign Key .Can you help me with Query
> >
> > Thanks
> > D.Prabhakaran
> >
> > On Wed, Oct 7, 2009 at 2:42 PM, S K Pradeep kumar <
> > [hidden email]> wrote:
> >
> > > Try in EntitySQLProcessor
> > > With regards,
> > > S K Pradeep kumar,
> > >
> > >
> > >
> > > On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
> > > [hidden email]> wrote:
> > >
> > > > Hi pradeep,
> > > >
> > > > Where I Specify the Query to delete the product in database
> > > >
> > >
> >
> >
> >
> > --
> > Regards,
> >
> > Prabhakaran.D
> >
> > [phone]
> >
>

--
Regards,

Prabhakaran.D

[phone]