1. W8663
  2. RO CSVI
  3. Thursday, 06 January 2022
  4.  Subscribe via email
Hi - I used the vm price export template.
Added a field for virtuemart_product_id as I would prefer to import prices again based product ID.

I see that product SKU's and product ID's have many duplicates in the exported CSV file.

What could cause that? they are not duplicated on the site.

thanks
Accepted Answer Pending Moderation
As I mentioned I bought the extension to do a simple price update.
I just had to remove 15% VAT from my current prices.

As per ticket above, it was exporting loads of duplicates, when they are not duplicated on the site.

I took advice from the VM forum and updated all the prices using a simple SQL query.
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
I see that product SKU's and product ID's have many duplicates in the exported CSV file.

Your products have multiple prices in VirtueMart? If so you should be seeing each row for each price and that must be causing duplicates. If not, please check Group by and Sort by document to avoid duplicates on export.
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. # 2
Accepted Answer Pending Moderation
No. don't have products with multiples prices, and don't use shopper groups.
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
In that case, try adding virtuemart_product_id as Group by field in your VirtueMart price export template, save the template and run the export. Check if that solves the duplicate issue.
Attachments (1)
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. # 4
  • Page :
  • 1


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