business, and they're having issues because they have added multiple colors
with the same SKU. (i.e 006=red and 006=blue) I've explained that each one
should be unique inside the database. But they express that it just can't
be....
In the DB I created the SKU as a separate "Key" different from the
ProductID, SizeID, and ColorID. So each product SKU is broken down to have
a product style SKU, a color sku, and a size sku.
(i.e. A003/006/005 ) This would represent some XXL red shirt.
When all are put together you get the unique SKU....simple concept.
The problem is that they have added colors and product SKU's that are
identical, but represent different products. I update the inventory via a
third party who supplies the input file that I read in, parse, and then look
in the database for the match. If the match exists, I then update the
inventory level. The inventory file only contains the SKU values, not the
ID values of the particular product, color, and size.
example:
Input file
STYLE SKU / COLORSKU / SIZESKU
A036/0832
A036/0833
A036/0834
A036/0835
A036/0836
Output result:
A036 (413) | 083 (162) | 2 (37)
A036 (413) | 083 (162) | 3 (38)
A036 (413) | 083 (162) | 4 (39)
A036 (413) | 083 (162) | 5 (46)
A036 (413) | 083 (162) | 6 (87)
My problem is that when searching for the unique product, I get four and
sometimes five products because multiple SKU's exist. In this example the
color SKU "083" represents both "Orange" and "Burnt Orange". Therefore only
one updates.
Has anyone ran into this before and is there a way to accommodate these
folks, or did I do something completely wrong? I've been working on this
all day and reading articles on what not to do, but they still seem to think
that it should be possible. Obviously they aren't programmers, but I'm
starting to second guess because they are being so persistent. It might be
because they sent out the catalog before thinking things through and they
want me to fix it. Can it be done?
Matt
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
