parent/child Part II (similar parents and children)

May 27, 2005 4 Replies

Another twist to the parent/child issue:



We order brake cables in a box of 100, but sell them individually. HOWEVER, we don't always get the same brand of cable from a given supplier, therefore the reorder numbers are different, as would be the ILCs, I'd imagine. For instance:



Supplier Brand # in Box Reorder #



1 A 100 CABLE-A
1 B 50 CABLE-B


2 B 50 B-CABLE



2 C 50 C-CABLE


3 A 100 BRANDA100



3 C 50 BRANDC50

At the POS, we just consider the cables one brand, not A, B, or C. So, without having to keep track of which brand is being used, how could we have as few ILCs as possible at the register, without being restricted to just stocking one brand?



Thanks!



______________________________________________________



Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!


124 State Avenue NE Olympia, WA 98501

P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com



formatting link
Featuring free bike advocacy and safety materials!


Best way is to create a generic ILC. Put it at the register and add all additional suppliers tot he supplier tab. Using the alias tab, put each reorder number there. It accomplishes a two fold task:

  1. not having multiple ILC for same component
  2. You can see which supplier charges you what in one glance.

I appreciate your reply, but it doesn't seem to resolve the issue of different suppliers handling similar objects in different parent quantities that we sell by the each.

So far, we are have just committed to > Best way is to create a generic ILC. Put it at the register and add

I appreciate your reply, but it doesn't seem to resolve the issue of different suppliers handling similar objects in different parent quantities that we sell by the each.

So far, we are have just committed to one supplier's parent/child item, but it's not very convenient, so other solutions are appreciated.

Elizabeth wrote: > Best way is to create a generic ILC. Put it at the register and add > all additional suppliers tot he supplier tab. Using the alias tab, > put each reorder number there. It accomplishes a two fold task: > 1. not having multiple ILC for same component > 2. You can see which supplier charges you what in one glance. >

--

______________________________________________________

Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!

124 State Avenue NE Olympia, WA 98501

P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com

formatting link
Featuring free bike advocacy and safety materials!

I think the problem is that each supplier may supply multiple brand/quantity combinations for the same generic part. I'm about 95% sure that you can't add the same supplier to an item twice...

I think you could get most of what you want by creating multiple SUPPLIER Records (1A, 1B, etc...) so that when you want to buy a particular brand or quantity you would select the appropriate supplier on that PO.

This doesn't solve the problem of trying to order the different quantities in case lots (1 case of 100 vs. 100 single items).

I don't think this is ever going to be clean on both the ordering and selling ends. Maybe you could create individual skus for each brand and set them up as substitutes for each other?

Glenn Adams Tiber Creek C> Larry,

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required