Rank: Member
Joined: 5/24/2004(UTC)
Posts: 4,147
|
From merchant: BVC5 is saying the SKUs must be a unique value, though they already are. The SKUs are absolutely unique.
They were, however, switched, ie: bonsch-kdc was bonsch-qdc, and visa versa.See attached. Cliff attached the following image(s):  GhostSKUs.png (184kb) downloaded 9 time(s).You cannot view/download attachments. Try to login or register. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
And you are sure that those sku's aren't on any other products? The way we check those is that we actually query out of the database looking for a product with that sku, and if we find one then we know that the sku already exists. Are you absolutely sure that these skus aren't in the table anywhere else? |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
I've found this message a few times, and I then noticed other products with the same sku. I am now very careful when thinking of SKUs so I don't accidentally make this mistake. |
|
|
|
|
|
|
Rank: Member
Joined: 5/24/2004(UTC)
Posts: 4,147
|
I just looked in the database and I don't see them. The merchant was trying to switch them, so they were there originally, but is it possible that they can't be switched like that? |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Ohhhhh, so he was trying to swap the two? Yeah, that would probably blow up. Have them change one sku to something temporary, then change the other sku. The issue is that it is trying to save all of them at the same time, so when it goes to save the first, it finds the sku for the other in the database already. We cannot save the first item to the database, because it will have the same sku as the second item until the second item is saved. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 5/24/2004(UTC)
Posts: 4,147
|
Great, thanks, Justin. :) |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.