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:
Import fields:
Kind regards,
Daniel
- sabikeuk
- RO CSVI
- Wednesday, 09 September 2020
- Subscribe via email
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- more than a month ago
- RO CSVI
- # Permalink
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »