Automatic Product Variable

[elvis84369]

Hi all!!

Could anyone help me ?

I am trying to set up a variable, similar to an automatic product ref..

I would like the variable to be automatically generated when a new product is entered into the catalogue ..

The variable is for a GTIN number - which begins which a seven digit constant number, then finishes with a six digit number which increases by 7 each product.

e.g "xxxxxxx000001","xxxxxxx000008","xxxxxxx000015","xxxxxxx000022","xxxxxxx000029",etc

Is it possible to reference the total number of products in the catalogue and then from that automatically generate the variable when you add a product? (eg "xxxxxx"& "(if([lastprodnumber]<10,"00000",if([lastprodnumber]<100,"0000",if([lastprodnumber]<1000,"000","00")))" & "[lastprodnumber]x7" )

where lastprodnumber = total products in catalogue.

I will be bulk adding these codes to my current catalogue, through hierarchical exports and imports, but would like it to be an automatic feature when adding more products.. Is this possible?

[leehack]

Not possible automatically no, use imports to create your products instead and an excel formula can do it for you then.

[elvis84369]

So there is no way to adapt the automatic product ref?

[leehack]

No

[TraceyHand]

No

you absolutely SURE now, Lee?

[leehack]

you absolutely SURE now, Lee?

Don't start.

[jont]

Bold claims Lee with TraceyG and Zoltan lurking in the shadows.

[Jan]

I would add it to the wish list though, it's quite a nice idea.

Regards,

[leehack]

Bold claims Lee with TraceyG and Zoltan lurking in the shadows.

I have the courage to fall down in public young Jedi.

[Jan]

So there is no way to adapt the automatic product ref?

Autogenerated product references can be reused (when products are deleted etc), so there is no guarentee that the reference number will increase so you could possibly end up with duplicates if you try to generate your numbers based on this.

.... said another way, Lee was right :-)

Regards,

[elvis84369]

Ok - I suppose it'll be alot of leg work until its added as a feature -

Is there any way of having a numeric variable for each product, then being able to find out what is the Max number for this variable is in the catalogue - At least this way the manual inputs of the GTIN numbers can be made easier, by know what the last one that has been entered. (make sense?)

- Or for that matter is there a way of counting how many products there are in the catalogue and manually calculate and input the GTIN number from there?