This discussion is archived
1 Reply Latest reply: Oct 9, 2013 3:38 AM by user166646 RSS

Which table stores the published/unpublished flag for items assigned to any section in iStore

user166646 Newbie
Currently Being Moderated

Hi All

 

I want to know which table stores the published/unpublished flag for items which are assigned to sections in iStore?

 

As per my understanding:

 

When any inventory item is assigned to any section we have data in ibe_dsp_section_items for that inventory_item_id.

This table just have the start_date/end_date and does not tell me whether the item is published to the site

 

There is another table ibe_dsp_msite_sct_items which shows on what minisites the item is available.

This table just have the start_date/end_date and does not tell me whether the item is published to the site

 

 

We can still go to iStore Administrator responsibilty

iStore Merchant >> Catalog >> Products >> Summary

 

search for any item and it shows to what all sections the item has been assigned to.

 

There we have a button "Change Published Flag". This can be used to publish/unpublish items on all the sections.

 

I want to know which table is updated when we hit this button.

 

Thanks in advance!

 

 

 

 

Thanks,

Shashank

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points