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:19] andre |
start:supplyprocedures [2017/07/20 13:57] (current) andre [Prop 65 labeling Requirements] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| {{pdfjs>:shipment_entry_documentations.pdf}} | {{pdfjs>:shipment_entry_documentations.pdf}} | ||
| {{pdfjs>:containermanagement.pdf}} | {{pdfjs>:containermanagement.pdf}} | ||
| - | ===== Supply Chain Procedures ===== | + | ===== GTIN Formula ===== |
| 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 | ||