Categories
View Replies (4)

Resolved How to use category_delete?

  1. iMbroidr
    iMbroidr
  2. RO CSVI
  3. Wednesday, 03 May 2017
  4.  Subscribe via email
I've made some products child products and now I want to delete the categories attached to those products.

When I add "category_delete" to my csv file and set it "y", the import log returns:
Unsupported
Failure
These fields have been found but are not supported by CSVI:
• category_delete

I ran the field update but that didn't fix anything. What am I missing here please?

CSVI 7.0.1, VM3.0.18 on Joomla 3.6.5 PHP 5.4.40
Attaching files

TIA - Lindee
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lindee,
category_delete field is for category import and not supported in product import. To delete a category you need to have category_path and category_delete fields in your import.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
iMbroidr
iMbroidr
Accepted Answer Pending Moderation
So, let me see if i have this… If I wanted to delete a category from the categories list, I would use category_delete but not to delete the list of categories to which the product is assigned?

I don't want to delete the actual category, just delete the product from the category by setting the category field in the product to blank. I guess the real question is, if I want to set any field to blank, is there a way to do that?

Thanks!

Lindee
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lindee,
So, let me see if i have this… If I wanted to delete a category from the categories list, I would use category_delete but not to delete the list of categories to which the product is assigned?

Thats correct. category_delete field is to delete a category from list of categories.

I don't want to delete the actual category, just delete the product from the category by setting the category field in the product to blank. I guess the real question is, if I want to set any field to blank, is there a way to do that?

There is no direct way of removing a category set for a product but a category can always be updated using CSVI. One way is you can clean the category for a product in the table #__virtuemart_product_categories using your phpmyadmin manually.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

CSVI works the other way around from what you are suggesting. Let's say your product is assigned to 3 categories but you want to delete one of them. You don't delete the one category you want to remove but instead you need to import the 2 categories you want to keep.

The idea behind this is that you have a master file with your data in it, if something changes, you update the master file and run the import with that again.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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