Categories
You need to be logged in to view a user's profile.
View Replies (4)

Resolved Duplicates

  1. W8663
    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
0
Responses (4)
W8663
W8663
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. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
W8663
W8663
Accepted Answer Pending Moderation
No. don't have products with multiples prices, and don't use shopper groups.
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
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)
Screenshot 2022-01-07 at 5.10.27 PM.png Screenshot 2022-01-07 at 5.10.27 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month 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!