Welcome, Guest
Username: Password: Remember me
Default product support category.
  • Page:
  • 1

TOPIC: import problems slug, sku and short desc

import problems slug, sku and short desc 3 years 1 week ago #180

  • seppo
  • seppo's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 19
  • Thank you received: 1
  • Karma: 5
I have faced following problems when importing:

errors:
Duplicate entry 'product-6-6' for key 'slug'
Not Imported Skipped: SKU exists in database one or more times.
Not Imported Missing required field: 'product_short_desc'

About slug and SKU: There is no duplicates, and still it claims to find them. At first there was, but then I made new one without dublicates and it still claimed to find them, even the file was different.

About the short description, I added that for the missing ones, but what are the fields required by your product?
The administrator has disabled public write access.

import problems slug, sku and short desc 3 years 1 week ago #181

  • seppo
  • seppo's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 19
  • Thank you received: 1
  • Karma: 5
Correction to this: there was no dublicates in the CSV file, but there was some at the virtuemart. It seems, that when exporting the CSV, it did not export all the products even though there were no red markings or errors when exporting. Maybe it left the dublicates from export, and then when importing it back it found those dublicates.
The administrator has disabled public write access.

import problems slug, sku and short desc 3 years 1 week ago #182

  • ekerner
  • ekerner's Avatar
  • OFFLINE
  • Administrator
  • Posts: 240
  • Thank you received: 24
  • Karma: 2
Hi Seppo,

1: product_short_desc ...
This is a required field. If you try to manually ad a product to VM omitting this field you will receive an error message. So this is not an error, its a notification to let you know that you are missing required fields.

2: Duplicate SKUs ...
I do not know how your database got into a corrupt state of having duplicate SKUs. As you saw VMPCSV checks for this and so I can only guess that manual SQL updates or some other product importer must have caused it.
If you try to manually create a duplicate SKU then VM will not allow it and display an error message.

VMPCSV knows your products by SKU and does not care about product ID, allowing the VM logic to manage the internal IDs. This is because many ppl export from one shop and import to another, in which case the IDs are irrelevant since new ones will be issued by the database.
I could modify VMPCSV to check for duplicate SKUs, but if I start making logic to check for stuff that isnt supposed to be, where does it end? For example: do I make a code to check if someone deleted the products table, or renamed a column? Of course not, why would someone do that.
And since VMPCSV did identify your duplicate SKU issue, id say YAY good job VMPCSV and leave it at that :)

I guess my summary is to point out that aside from being a product importer/exporter, how great VMPCSV is at locating and even in cases repairing corrupt VM databases :)

Have fun, e
The administrator has disabled public write access.

import problems slug, sku and short desc 2 years 10 months ago #218

  • billo007
  • billo007's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
I don't think the comment of short description is accurate I never use short descriptions and products save just fine. So I believe that short description should not be a mandatory field when importing.
The administrator has disabled public write access.

import problems slug, sku and short desc 2 years 10 months ago #223

  • ekerner
  • ekerner's Avatar
  • OFFLINE
  • Administrator
  • Posts: 240
  • Thank you received: 24
  • Karma: 2
OK we will investigate this and if versions of VM allow omission of product short desc then we will make the test version specific.

What version are you using?

Thanks.
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 0.199 seconds

Receive Product Updates

Logged in members may subscribe to receive product updates. LOGIN

Select Currency

Contact Us

Call us at:
+61 415 607 770

Email us at:
shop@ekerner.com

Leave us feedback:
Feedback Form

Message Us:
Enquiry Form

facebook

twitter

rss