22 replies to this topic

[SmetDenis]

Hi

As i said earlier, you may call

JBModelSku::model()->updateItemSku($item);

where $item is instance of Item class. For example

$item = App::getInstance('zoo')->table->item->get('<ITEM_ID>');

How often price changes in your catalog?

[P.K]

Hi

The price may change daily and i execute a loop to change the prices of each and every product. So calling this function may slow down the process when each item is updated. Isnt there any other fast way? What about database reindex?

 

For the function to call, can you tell me in which file is this function defined so i may include it in my script?

thanks

[SmetDenis]

Hi

 

Earlier I offered to you SQL query for manual table update.

This is the fastest way.

 

For the function to call, can you tell me in which file is this function defined so i may include it in my script?

 

 

For index only one Item via JBZoo API

\media\zoo\applications\jbuniversal\framework\models\jbmodel.sku.php

// in any joomla code
require_once(JPATH_ADMINISTRATOR . '/components/com_zoo/config.php');
$item = App::getInstance('zoo')->table->item->get('<ITEM_ID>');
JBModelSku::model()->updateItemSku($item);

For batch reindex (step by step)

\media\zoo\applications\jbuniversal\framework\models\jbmodel.searchindex.php

// in any joomla code
require_once(JPATH_ADMINISTRATOR . '/components/com_zoo/config.php');
JBModelSearchindex::model()->reIndex($limit, $offset);