1. sabikeuk
  2. RO CSVI
  3. Wednesday, 09 September 2020
  4.  Subscribe via email
Hello,

is it possible to create a copy of existing products (clone products) in bulk via CSVI ?

I have tried to export and then import but "old" products are rewritten with the new products and prices were changed (How can I disable RULE for import? )

Export fields:
Screenshot 2020-09-09 at 13.22.01.png

Import fields:
Screenshot 2020-09-09 at 13.22.14.png

Kind regards,

Daniel
Attachments (2)
Accepted Answer
Accepted Answer Pending Moderation
Hello Daniel,
You don't have to do this manually, in your export template for product_sku field you can create RO CSVI combine rule to combine product_sku with another field. This another field will be custom with a default value set in template fields page. Say if the default value set for custom field is 1 and product_sku in database is XXXX, with the combine character set as _ in the rule, the rule will combine these two fields and get a new product_sku field value as XXXX_1 in export file. Let me know if that is clear.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
Hello Daniel,
With RO CSVI the existing products are selected from database using product_sku field. If there is a matching row in database with the product_sku, the record is updated else a new record is created. So if you want to create new products on import then the product_sku in your import file should be different from what is stored in database.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Tharuna,

thanks for respond.

How can I do this (the product_sku in your import file should be different from what is stored in database) ? I have tried to delete product_sku field from import template but then product wasnt created at all.

Kind regards,
Daniel
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Daniel,
Your product_sku should be different from what is stored in database. Without product_sku field a product will not be created or updated as it is a required field in VirtueMart product import operation. It is called required field as this field is used to select a product record from database. So if the existing product_sku is XXXX then you should have a different product SKU something like XXXX_1. Hope it is clear.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Tharuna,

Do you mean I need to manually amend CSV export file / product SKU - for each product ?

Kind regards,
Daniel
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Thank you very much Tharuna, its working now.
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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