Categories
View Replies (2)

Resolved Importing file getting Duplicate Error' 729' PRIMARY

  1. WhiteCastlePtyLtdAdmin1
    WhiteCastlePtyLtdAdmin1
  2. RO CSVI
  3. Tuesday, 10 October 2017
  4.  Subscribe via email
[attachment]01de1a42edee78fbebfcbf3def6e5eb2[/attachment]Attempted to import 20,000+ line CSV file. This file was exported from a database on a local hardrive. Some SKUs are duplicated dut to different suppliers having the same number for differing items. This is not an issue on the website because items on the website database have unique SKUs. The file attached is to be imported so that I can update the items on the website in one operation as opposed to exporting from the website,then matching both the local and exported files.
I have already looked for a solution on the forums (see screenshot), but it seems that there is another issue probably to do with the spreadsheet but I am not sure.
I could cut up the file into smaller blocks, e.g 2500 lines and then home in the un-detected duplicate, but that is only a stop-gap solution.
Is there any other way to detect duplicate SKUs?
Attached are the files.
ALL_SKU_PURE.csv is the cleaned non-duplicate SKU file after deleting duplicates
Screenshot of Forum solution for similar issue
Screenshot of CSV and Joomla versions
PHPmyAdmin SQL query
PHPmyAdmin SQL with null result
CSV file with duplicates,and formula to expose the duplicates (OpenOffice)
CSVI Preview of import template
CSVI Duplicate Primary Error
Error Log
Template
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Looking at your file the product_sku 729 appears only once and there are no duplicates for it in your import file so your import file is good. Now you can check if there are duplicate product_sku's in your VirtueMart database by going to CSVI maintenance menu, Select VirtueMart in first option >> Check Duplicate SKUs in the second option and click on Continue. This will list out all the duplicate SKUs in your VirtueMart database. You need to clean them before running your import.
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. # 1
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
Thanks tharuna. That solved it. Cheers.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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