Carpet setup in DB

Hi Ed,

Call me in London on Monday (+ 44 20 8907 6900). We have done a few carpet stores and special developments in this area.

We sell carpet & floorcoverings at one of our four stores. It accounts for about 25% of that stores revenue. I guess what I'm saying is that I've implemented a carpet scheme but am far from expert on the subject...

We set up a series of ILCs CARPETxx where xx was a number for $/sqyd. If the carpet prices out at $19.75/sqyd, we use CARPET20 (I have all of these ILCs set up to require price entry at POS). We use these items on POs, too, and enter the carpet style/color manually in the order # and/or description fields.

It's far from perfect, but it works.

Tom

We just use standard items for this. Style number and then color number together form the item lookup code. We find this easier than trying to do it via matrix item. of course we don't stock much carpet we order what we need. So no need for on hand items that we don't actually have. Keeps inventory a bit cleaner. Example: Say you have a piece of Shaw goods. They use a 5 digit style number and a 5 digit color number, so your item lookup code is the two together to form a

10 digit code. Descprition is 00000 style name 00000 color name. Department assigned as usual, price updated each time we enter the the product since we recieve latest pricing information when the order is placed. I just use a standard 50% markup and discount it manually at the checkout for the contract work we do. Everything is done by Square Yard. We price both SY and SF on our displays but limiting it to one quantity type is far easier for actually estimating and selling the product. Most carpet companies set pricing by the SY anyway.

That's the manual way to do it a little at a time. There may be other ways to actually insert the products in the database if you want to add large quantities of products at once. I find that to be a lot of clutter though, unless you plan to have a lot of carpet on hand.