Similar sku issue

[yannp]

Hi,

We currently have a sku item database with all the product we sell. Each item can have 3 different sku assign to it, 11111 (is the item in it's english and french packaging), 1111101 (is the item in it's english and spanish packaging) and 1111102 (is the item in it's english packaging).

I'm looking into a way to create a portal that will show all of the sku that are similar.

Can anyone help?

Yann

[IdealData]

Does that coding 11111 mean "any 5 digit number" ?

How about coding them as

nnnnnNN - where nnnnn = product, NN = packaging_type, then you could have

Field: PRODUCT, 5 digits

Field: PACKAGING, 2 digits

Field: SKU_CODE = PRODUCT * 100 + PACKAGING

You can now use PRODUCT matches PRODUCT as the basis for a relationship, and make your portal on that relationship. The portal should then display all the packaging variants for a given PRODUCT

[RalphL]

If all of your sku's are 5 digits plus either nothing or 01 or 02 there is an easy way you can do this. In each table create a calculation field = Left (sku; 5) use these fields in your relationship for the portal.

Even easier if self relationship.

[yannp]

Sadly I do not have control over how the sku number are generated, trust me, if I did, this would not be the way I would build it.

[yannp]

I'm trying the Left command and it doesn't show anything the in portal. Here is what I did

Calculation field, Similar sku:

Similar sku = Left (item number; 5)

Relationship, Similar

Similar sku = similar sku

Portal, from relation Similar, show:

item number

Nothing is showing up, what I am doing wrong?

[LaRetta]

A text function will work just as well whether applied to number or text (I assume your sku is number). I suspect then that your calculation is unstored. If so, unclick 'Do Not Store' in the Storage Options. It must be Indexed to be in the right side of your relationship.

[yannp]

that was it, thank you very much it works. Also open a bunch of possibilities