SKU problem while importing products?

SKU problem while importing products?

Apr 11, 2016
Timo wrote
Hello,

Im struggling with quite weird problem.
While importing product information everything works fine except sku field.
I tried also to update only sku fields with same result.

For example my product ID is 10 and its sku is SKU_10101010
Import generates this sku to SKU_100000543 and so on...

Do you have any idea about this issue?
Is it because of my sku has this "SKU_" prefix?
Some of my products have to have this kind of format: SKU_productnumber


Thank you


Reply
3 Answers
Avatar image
Apr 12, 2016
Support Manager agent wrote
Hello,

Thank you for contacting us

Actually, If you assign id and sku during import, Store Manager tried uses ids as main identifier (this functionality was added, since customers wanted to be able to update skus by id). In you case, if product with id 10 has different sku, than you want to update, please un-assign id and use sku as identifier to import the file correctly

Let us know if you have any other questions
Apr 13, 2016
Timo wrote
Ok,

Product ID is "10"
Product SKU is "xxx"

If I want to update this SKU "xxx" to "SKU_101010" I have to use sku as identifier rather than ID + un-assign column ID?

Sorry if you have to explain this in plain english to me :)
Avatar image
Apr 13, 2016
Support Manager agent wrote
Hello,

Thank you for your question

If you want to update sku, you have to use id as identifier, but if product with id 10 at your store has other sku, than should be updated, you have to correct ids at your file. We'd recommend you to export products to the file (id and sku), manage skus at this file and re-import it to update correct products

Let us know if you have any other questions