This shows you the differences between two versions of the page.
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 |