Hi,
I was wondering if there was a way to update the price of my products using "virtuemart_product_id" rather than "product_sku" in the criteria fields ? Because I have a bunch of products that are actually services and don't need sku code, so they're saved into the virtuemart database by their product name and ID but they've got no sku...
And if not, is there a way to randomly generate sku code for all of them by using CSV improved ?
Thank you in advance!
- kiratot
- RO CSVI
- Sunday, 29 April 2018
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello,
As i said earlier, product_sku is one of the required field in price import and since that was missing in your import file the record has been skipped. Did you see message that "Missing required fields" when the import is done?
I'm still wondering why it doesn't work with the "price" operation ?
As i said earlier, product_sku is one of the required field in price import and since that was missing in your import file the record has been skipped. Did you see message that "Missing required fields" when the import is done?
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,Ah ok now I get it! It would be nice to also include the virtuemart_product_id as an option of a required field since it's an unique ID for the product !
In VirtueMart price import product_sku is one of the needed field
Also thank you for the fast reply.
Accepted Answer
Pending Moderation
Hi again,
I've just figured out that I was doing a "price" operation which seemed more appropriate for a price update but when I used the "product" operation the price got updated as expected with only "virtuemart_product_id".
I'm still wondering why it doesn't work with the "price" operation ?
Thanks again and sorry for the inconvenience !
I've just figured out that I was doing a "price" operation which seemed more appropriate for a price update but when I used the "product" operation the price got updated as expected with only "virtuemart_product_id".
I'm still wondering why it doesn't work with the "price" operation ?
Thanks again and sorry for the inconvenience !
Accepted Answer
Pending Moderation
Hello,
In VirtueMart price import product_sku is one of the needed field and since it is not there, the rows are getting skipped. To solve this add product_sku field to your import with a fake value say 1. This way we are passing on with the needed field check and the price is updated with virtuemart_product_id. Let me know if this helps.
In VirtueMart price import product_sku is one of the needed field and since it is not there, the rows are getting skipped. To solve this add product_sku field to your import with a fake value say 1. This way we are passing on with the needed field check and the price is updated with virtuemart_product_id. Let me know if this helps.
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
Thank you for your reply,
I've just tried to do it and didn't work, maybe I've missed something. I tried to put only :
"virtuemart_product_id";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_override" all the lines get skipped.
Also tried :
"virtuemart_product_id";"product_sku";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_override" while I gave only one sku code for the product in the first line, this one doesn't get skipped while all the other lines without sku code do get skipped.
Here is the debug file for the last case: com_csvi.log.33.zip
Thank you for your help.
I've just tried to do it and didn't work, maybe I've missed something. I tried to put only :
"virtuemart_product_id";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_override" all the lines get skipped.
Also tried :
"virtuemart_product_id";"product_sku";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_override" while I gave only one sku code for the product in the first line, this one doesn't get skipped while all the other lines without sku code do get skipped.
Here is the debug file for the last case: com_csvi.log.33.zip
Thank you for your help.
Attachments (1)
Accepted Answer
Pending Moderation
Hello,
You can use the virtuemart_product_id instead of the SKU to update products, just can't use it to create new products. To use it, simply replace product_sku with virtuemart_product_id in your import file. In your template set the Update based on field to virtuemart_product_id as well.
You can use the virtuemart_product_id instead of the SKU to update products, just can't use it to create new products. To use it, simply replace product_sku with virtuemart_product_id in your import file. In your template set the Update based on field to virtuemart_product_id as well.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
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 »