User Tools

Site Tools


start:supplyprocedures

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
start:supplyprocedures [2017/05/08 15:20]
andre [Supply Chain Procedures]
start:supplyprocedures [2017/07/20 13:57] (current)
andre [Prop 65 labeling Requirements]
Line 7: Line 7:
 After creating a SKU and a UPC, a GTIN also needs to be created. This Excel function may help:​\\ ​ After creating a SKU and a UPC, a GTIN also needs to be created. This Excel function may help:​\\ ​
 <​code>​="​10"&​LEFT($a2,​11)&​10-MOD(MID("​10"&​LEFT($a2,​11),​2,​1)+MID("​10"&​LEFT($a2,​11),​4,​1)+MID("​10"&​LEFT($a2,​11),​6,​1)+MID("​10"&​LEFT($a2,​11),​8,​1)+MID("​10"&​LEFT($a2,​11),​10,​1)+MID("​10"&​LEFT($a2,​11),​12,​1)+(MID("​10"&​LEFT($a2,​11),​1,​1)+MID("​10"&​LEFT($a2,​11),​3,​1)+MID("​10"&​LEFT($a2,​11),​5 ,​1)+MID("​10"&​LEFT($a2,​11),​7,​1)+MID("​10"&​LEFT($a2,​11),​9,​1)+MID("​10"&​LEFT($a2,​11),​11,​1)+MID("​10"&​LEFT($a2,​11),​13,​1))*3,​10)</​code>​ <​code>​="​10"&​LEFT($a2,​11)&​10-MOD(MID("​10"&​LEFT($a2,​11),​2,​1)+MID("​10"&​LEFT($a2,​11),​4,​1)+MID("​10"&​LEFT($a2,​11),​6,​1)+MID("​10"&​LEFT($a2,​11),​8,​1)+MID("​10"&​LEFT($a2,​11),​10,​1)+MID("​10"&​LEFT($a2,​11),​12,​1)+(MID("​10"&​LEFT($a2,​11),​1,​1)+MID("​10"&​LEFT($a2,​11),​3,​1)+MID("​10"&​LEFT($a2,​11),​5 ,​1)+MID("​10"&​LEFT($a2,​11),​7,​1)+MID("​10"&​LEFT($a2,​11),​9,​1)+MID("​10"&​LEFT($a2,​11),​11,​1)+MID("​10"&​LEFT($a2,​11),​13,​1))*3,​10)</​code>​
 +===== Prop 65 labeling Requirements =====
 +FIXME
start/supplyprocedures.1494282001.txt.gz · Last modified: 2017/05/08 15:20 by andre