Laddawn.com : Programming Spec - Selecting Stock Centerfold Sheeting

5/8/14 - Owen, John and Judy had further discussion, specifically about the opposite product category YMAC for MOD items (singlewound vs centerfold).  Phase I MOD YMAC only includes Boxed vs Cradlepacked, so we decided to hold off until Phase II for MOD YMAC specified below.  This is what the 3 options now return:

1. Enter Singlewound 60x60x2 … 60x60x2 singlewound rolls MOD item is exact match. First YMAC: Centerfold stock item 004973 60x60.  Second YMAC: MOD singlewound 60x60 cradlepacked
2. Enter Centerfold 30x60x2… stock 004973 cf 60x60 is exact match.  YMAC’s  MOD centerfold 30x60 rolls, boxed and MOD centerfold 30x60 rolls, cradlepacked
3. Enter 15x15x60x2 … we never actually spoke about this.  It returns: 2 gusseted 15x15x60x2 MOD results (no stock)

Judy

From a conversation with Judy on May 6, 2014:

From: Owen Richardson
Sent: Tuesday, May 06, 2014 9:11 AM
To: Judy Ascensao
Subject: RE: Perf Sheeting - stock selects

Here’s my concern as I look at this anew: customers are likely to care about roll width.  So, we can’t mix and match roll configurations as exact matches.  YMACs – Yes, exact matches – No.

So to correct what you wrote below:

• If I enter 60x60x2 mil singlewound, I should get a 60x60x2 mil singlewound MOD as an exact match and item 004973 (a centerfold version) as a YMAC - along with the MOD of 004973 as another YMAC.
• If I enter 30x60x2 mil centerfold, I should get 004973 as an exact match. It’s the same product.  I should also get a MOD version of it, too, along with a MOD singlewound version of it.
• If I enter 15x15x60x2 mil gusseted, I should get a MOD of 15x15x60x2 mil gusseted as an exact match.  My YMACs should be item 004973, a MOD of 004973 and a mod of 60x60x2 mil singlewound.

 I would not offer YMAC gusseted sheeting MODs for the first two above, as (a) I don’t think it would be useful and (b) there are too many gusset sizes that would fill the bill.

________________________________________________________________

On the shop widget when any 'centerfold sheeting' product category is selected, the entered width must be doubled when selecting centerfold stock items.  This is because MOD items are configured with the assumption that the width that was entered is the 'folded' width.  Stock items have the width dimension identified as the 'open' width.  Currently, either centerfold stock items are not being shown in results or the incorrect stock item is being shown.  For example:

• If the customer is looking for a 30" centerfold sheet that opens to 60", they enter 30 in the width field.  If they enter 30x30x1.5, they would get the stock item 005905 (which is 15" that opens to 30") and the MOD result(s) would be for 30" opening to 60"

Modify RPC$WEBPRODUCTITEM_GETBYFILTER (renamed WEB.GET.STOCK.ITEMS) (timeline 81-1):

• When the selected PROD.TYPE = "402" or "408", double the contents of SHOP.WIDTH before the stock selection is done.  Do not change what's in SHOP.WIDTH ... use a separate variable for your stock selection. Currently, we only have stock items in the 408 category (perforated sheets-centerfold) but we should allow for continuous centerfold sheeting in case we ever decide to stock this. 

To Test:

•  For Perforated Sheets-Centerfold: Enter width=30; length = 60; gauge = 2; leave color as 'Clear'.  You should get item 004973 in results.  Note:  Also try Perforated Sheets-Singlewound and change width to 60.  You should see item 004973 as a result here too (these are singlewound so are not folded).
• For Perforated Sheets-Centerfold: Enter width=24; length=48; gauge=1.5; Color=Clear:  You should see item 005930 (48x48x1.5)

Additional change:

When entering a stock centerfold sheeting item# from the top bar (Laddawn or your item#), the stock item isn't being selected.  This is because it is looking for the stock item with the width doubled (because of the code that was just placed into the GETBYFILTER).  Modify BP  FCT.WIDTH.DEFAULT.VALUE in the CPN # “” area (which is the stock select – don’t touch the logic below which is the MOD logic).  If SHOP.RULESET=”402” or “408” then divide the width from ITMMST<117> in half when setting DEFAULT.VAL.  This will make the shop widget display the correct ‘folded’ width, and then when the x2 logic happens in the getbyfilter, it will work correctly.

To test:

• Enter item 005930 at the top bar
• It should display in the widget as width=24; length=48; gauge=1.5
• Stock exact match should show 005930 (48x48x1.5)
• MOD match(s) should show 24x48x1.5