Leon,
I've just completed a site for window blinds that had this problem
multiplied by a factor of 3: fabric, colour, size, and various features
could all be variations on a single SKU. In the end, I abandoned most of
FreeTrade and rolled my own database design and functions. But I still used
the basic FreeTrade structure because of its clarity and elegance.
I suspect this is a common problem and wonder whether you've considered
extending FreeTrade to encompass this.
In another message today, you noted that
>The backtick (`) doesn't have any special meaning to SQL, as far as I know.
>It does have meaning to PHP, though. It works like it does in Perl...it
>executes the string in a shell.
News to me, but great news! Is this undocumented and/or is there anywhere I
might get more info? (I'm not up on Perl).
Rick Cooper
----- Original Message -----
From: Leon Atkinson <[EMAIL PROTECTED]>
To: FreeTrade <[EMAIL PROTECTED]>
Sent: Tuesday, June 06, 2000 9:11 AM
Subject: RE: [FreeTrade] Pricing & SKU Question!
> > I'm looking through my client's print catalog and I noticed that there
are
> > quite a few items which have a couple of SKU numbers, each having
> > different
> > sizes, with each size of the item having a different price. For example:
> >
> > Green Cotton (#SKU123) Organic Cotton (#SKU567)
> > Single $129 $189
> > Double $149 $199
> > Queen $149 $198
> >
> > and so on...
> >
> > Some of the items also have more than one SKU number, which isn't
> > abnormal.
> > However, each of those SKU numbers come in a variety of sizes at
different
> > prices.
> >
> > I'm hoping they're not setting me up for an inventory nightmare.
> > Is there a
> > preferred method of tackling this?
>
> Well...it could be a problem. FreeTrade is going to require that you have
> six different SKUs in this situation. Multiple SKUs can share an External
> SKU ID, so you're OK as far as transmitting orders to the fulfillment
side,
> but if you only get inventory figures by those External SKU IDs, you won't
> really be able to track it accurately. Realistically, there must be
> inventory levels for each of the six. Are you planning on automating the
> setting of inventory?
>
> Leon
>
>
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
