User Tools

Site Tools


start:supplyprocedures

Differences

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

Link to this comparison view

Next revision
Previous revision
start:supplyprocedures [2017/04/20 12:24]
andre created
start:supplyprocedures [2017/07/20 13:57] (current)
andre [Prop 65 labeling Requirements]
Line 1: Line 1:
 ====== Supply Chain Procedures ====== ====== Supply Chain Procedures ======
 +===== Container Management =====
 +{{pdfjs>:​container_management_workflow.pdf}}
 +{{pdfjs>:​shipment_entry_documentations.pdf}}
 +{{pdfjs>:​containermanagement.pdf}}
 +===== 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
start/supplyprocedures.1492716279.txt.gz · Last modified: 2017/04/20 12:24 by andre