1. maik85
  2. RO CSVI
  3. Friday, 04 March 2016
  4.  Subscribe via email
Hi Roland,

CSVI don't create new products. The log said CSVI uses an update query, but must use an insert for new products. Skip new items is set to NO.

Regards,
Maik
Accepted Answer Pending Moderation
Hello Maik,

You are using the primary key of the product table, virtuemart_product_id, this forces the system to always do an update. That is why we always suggest to use the product_sku as unique product identifier and not use database IDs.

Once you start controlling the database controlled IDs, it can become unpredictable.
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Roland,

Yes it can, but we must use the ID. Where is this written in the code?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Maik,

There are 3 options, modify the Joomla core code where it happens:

https://github.com/joomla/joomla-cms/blob/staging/libraries/joomla/table/table.php#L800

or change the override that calls the Joomla code. This is located in the file administrator/components/com_csvi/tables/default.php on line 154.
$result = parent::store($updateNulls);


or leave the database IDs alone and use the gtin or mpn field with your own IDs to manage the products. That is not viable?
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!