1. indu2069
  2. RO CSVI
  3. Tuesday, 23 February 2021
  4.  Subscribe via email
I have made that you said and I set "no" in the field "Delete existing prices" but after import duplicate the prices. I thougt that not, but yes.

I attach you the debug file and an image with the error.

I'm using a trial site.
Attachments (2)
Accepted Answer Pending Moderation
Hello,
VirtueMart products supports multiple prices, in order to find an existing price in database RO CSVI needs few fields in import file. Based on the value of these fields prices are found and updated in database else a new price is inserted. To know on these needed fields and examples to use them please check VirtueMart Prices import document. You need to prepare your import file as explained in the document to update a price. Let me know if that helps.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Yes but the extrange is that I import with the same file that I export. I only change the price adding a 0

It must be the same field, isn't ?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
It must be the same field, isn't ?

If you are updating existing price to a new price in your case it is 0, you need to add field product_price_new and set value to 0 in import file. You should also have product_price field in import file with existing price values so RO CSVI can search for the record in database.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
When I say adding a 0 i wanted to say for example if I have a price with the value 1, the new price is 10, if I ha a price with 150, the new price is 1500. I only do this to make trial, the field is the same. Is an example to update the prices.

And CSVI that mades is to add a new price, it keeps the old price with the taxes, and add the new price without taxes.

If you want I can create you an user in the trial sites and you try...
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Ok, this is what you can do

1. Using VirtueMart Product export template export product_sku and product_price fields.
2. With RO CSVI Multi replace plugin and using Add after value operation, create a rule to add 0 at end of product_price field. Apply the rule on product_price field.
3. Run import using VirtueMart Product import to update the price with exported file.

If you want I can create you an user in the trial sites and you try...

Try the above suggestion and if you still have a problem, send me the user details and i can take a look.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
I see what's happening. When I do a export there are some products that is duplicated in the generated CSV, for this reason when I import the price is duplicated because I'm using this same CSV to do the import trials. In the virtuemart product only there is a line price

I have made a user to you

I have reset the database to make the import again

If you see the product POMDOR496020002 in the virtuamart products only has a price, but when I export the file appear twice. I attach you the expor file. You can see the POMDOR496020002 twice in the line 260
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
In your export template set Group by field to virtuemart_product_id, save the template and run the export. That will avoid duplicate rows in export file. Check Group by and sort by field document to know on how to set virtuemart_product_id as group by field. Let me know if that solves the issue.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
I make that you said, and it continues duplicating some products in the export...

I attach you the csv file..

I send the user credentials in the site details tab if you want to check....
Attachments (1)
References
  1. http://www.giralsint.es/administrator
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
I am not sure if you miss to save the template after selecting the group by field, your template did not have group by field set to virtuemart_product_id. I added it to your export template and also added virtuemart_product_id as export field and set it to unpublished so it does not appear in export file. Now there are no more duplicate rows. Please check the export and let me know.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Ok now works fine.

In the example template the field virtuemart_product_id wasn't in the template field.

It's strange. This will be happenging with other of your customer, isn't?

Is a bug?
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
Is a bug?

This is not a bug. Example templates have minimum needed template fields. Our customers can add or delete template fields based on their requirements. Since you had a requirement of using virtuemart_product_id field, it was added to your example template.

Hope it is clear now.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Now the import run fine but there is other problem. If the product has a disscount, after the importation the discount field remain unselected and the final price is wrong.
If I do an importation without the discount field, why is modified?
  1. one week ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
Please post import debug log and import file to check. To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
I attach you the debug file. I have only import a product to make it easy.

Yoy can see after impotation that the tax and the discount are deconfigured
Attachments (1)
  1. 4 days ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Thank you for posting the import debug log. It helped in finding the issue with price update. In your import template on Options tab you have set Delete Existing prices to Yes. This setting will delete the existing prices for product in database and insert new prices from import file. When inserting this new price, tax and discount fields are inserted as 0 and that is because you do not have these fields in import file. If you want to update the existing prices, you need to set Delete Existing prices to No, save the template and run the import.
Kind regards,

Tharuna

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


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