Laddawn.com : Certificate of Compliance - Automation

Release DateTBD

Document Status

FINAL
Document Owner
Ticket #TBA


Introduction

The purpose of this wiki document is to outline all of the changes we are making to our current (manual) Certificate of Compliance process.

Goals

  • Automate our current C of C process therefor eliminating user error and bad practices.
  • Automating this process will allow for greater efficiency of our Customer Experience Department. As a result, freeing them up to handle more demanding tasks in the queue.

Background

Since January 1st 2018 - June 24th 2018, we have sent 1,591 C of C's at the time of shipment. This number does not include C of C's created after an order has been placed (and possibly shipped) which is believed to be several hundred more.

C of C Requests

01/01/18 - 03/29/18 (87 Days) = 755 C of C's (694 Materials + 61 HACCP)

03/30/18 -  06/24/18 (86 Days) = 836 C of C's (768 Materials + 68 HACCP) 11% increase

Total (174 Days) = 1,591 C of C's (1,462 Materials + 129 HACCP)

  • The information above does not include customers who request C of C's after an order has been placed.

Historically, when Customer Experience pulls an order from the queue that requests a C of C - these steps would be followed:

  1. The order gets placed with "Materials Certificate of Compliance" enabled (via Special Instructions popup window).
  2. CE determines which C of C is required, based on the specifications of the item.
  3. CE fills out the document with the required information.
  4. CE prints the document.
  5. A supervisor signs paper document.
  6. CE scans the document back into a digital format (PDF).
  7. CE emails the document to Shipping.
  8. Shipping prints the document and attaches it to the order before shipment.

Note: If CE forgets to procure this documentation at the time of order, shipping will eventually send an email into the queue asking for the documentation.

If our customer places an order on laddawn.com and enables the "Materials Certificate of Compliance" option themselves - these steps would take place:

  1. The order gets placed with "Materials Certificate of Compliance" enabled (via Special Instructions popup window).
  2. The order prints to the warehouse, alerting Shipping that C of C documentation is required.
  3. Shipping sends an email into the queue asking them to procure the required documentation.
  4. CE determines which C of C is required, based on the specifications of the item.
  5. CE fills out the document with the required information.
  6. CE prints the document.
  7. A supervisor signs paper document.
  8. CE scans the document back into a digital format (PDF).
  9. CE emails the document to Shipping.
  10. Shipping prints the document and attaches it to the order before shipment.

Note: Most often the C of C document is attached to a physical order; it's also very common for the documentation to be emailed directly to the customer - often before the product has even left our warehouse. Additionally, many customers request C of C documentation 'after the fact,' sometimes weeks/months after the order has shipped.

Over time we have adopted the bad practice of sending Word Documents (bypassing the printing & scanning of documents) directly to our customers. Therefore giving our customers the ability to alter these documents any way they wish, including having ‘easy access’ to our digital signatures found within these documents.

It is important to note, all of this is still possible regardless of the type of media we choose to send our customers. However, we probably shouldn’t be making it ‘this easy’ for them to alter our documents.


UI Changes

The screenshots below highlight some UI changes we will be making which also include improvements to how we handle HACCP orders.

Non-HACCP OrderHACCP OrderOrder Summary


The before screenshot is from an order that does not contain HACCP compliant items.

The before screenshot is from an order that does contain HACCP compliant items. As you can see, "Haccp Certificate of Compliance" is checked and disabled - because this selection is mandatory. Considering this selection is mandatory across all HACCP orders - we should not allow for the user to set this as a preference per Ship To.Provide the user with a means of downloading these documents after an order has been placed.

Recommendations:

  • Disable "Haccp Certificate of Compliance" on Non-HACCP compliant orders.

Recommendations:

  • Remove the ability to make this selection a preference because this selection is mandatory for all HACCP compliant orders.

Recommendations:

  • Include a textual link allowing for the user to download documents

Document Template


Default TemplateLayflat (Under 18" Width)Layflat (Over 18" Width)Gusseted (VCI)Layflat (Black Conductive)

Multiple Items

When a customer requests a C of C, they're requesting it on the bundling level - which may contain multiple items. C of C documents should display multiple items as long as all items meet the criteria displayed in the document. The templates above do not illustrate this, but the item description and part numbers should but displayed underneath each other.


Dynamic Text



Legend: Product Type / Product Category / Material / Additive / Manufacturer
Text StringCategorySequenceEqual ToNot Equal To
Product meets industry standards regarding length, width, and material.Start1-1Bags or Sheeting or Tubing
Linear Low-Density Polyethylene (1 melt, 920 density) is a virgin material, produced with Medium Slip and Medium Anti-Block.Material2-1Bags or Sheeting or Tubing and Standard LLDPE
Linear Low-Density Polyethylene (1 melt, 920 density) is a virgin material, produced with Medium Anti-Block (and may contain trace amounts of Slip).Material2-2Bags or Sheeting or Tubing and Non-Slip LLDPE
Linear Low-Density Polyethylene is a virgin material, produced with Low Slip and Low Anti-Block.Material2-3Bags or Sheeting or Tubing and Black Conductive
Low-Density Polyethylene (2 melt, 920 density), is a virgin material, produced with Medium Slip and Medium Anti-Block.Material2-4Bags or Sheeting or Tubing and Standard LDPE
Low-Density Polyethylene (2 melt, 920 density), is a virgin material, produced with Medium Anti-Block (and may contain trace amounts of Slip).Material2-5Bags or Sheeting or Tubing and Non-Slip LDPE
High-Density Polyethylene is a virgin material.Material2-6Bags or Sheeting or Tubing and HDPE
Polypropylene is a virgin material, produced with Low Slip and Medium Anti-Block.Material2-7Bags or Sheeting or Tubing and PP
Material is paper and wire.Material2-8Twist Tie
Produced from industry-standard VCI material.Material2-9Bags or Sheeting or Tubing and VCI
Anti-Block additive used to produce this product is talc-based.Material2-10Bags or Sheeting or TubingNon-Scratch
Material can be transparent or any other color.Material2-11Bags or Sheeting or TubingBlack Conductive
Material is pink in color.Material2-12Bags or Sheeting or Tubing and Pink Color Anti-Static
Metallic Static Shielding Bags provide Faraday Cage projection for highly sensitive components.Features3-1Bags and Static Shielding
Protects metal surfaces against corrosion or oxidation where it is impractical to apply other rust-inhibiting protectants.Features3-2Bags or Sheeting or Tubing and VCI
VCI film is multi-metal functional and can protect these materials: Carbon Steel, Stainless Steel, Cast Iron, Aluminum Alloys, Galvanized Steel, Brass (<30%ZA), Copper and Solder.Features3-3Bags or Sheeting or Tubing and VCI
The raw material used to produce this product complies with the Federal Food, Drug and Cosmetic Act CFR 21 177.1520 as amended.Specifications4-1Bags or Sheeting or TubingPrinted VCI or (Purchased) C&A
Meets Vapor Inhibitor requirements of MIL-PRF-22019E (Test Method 4031), according to MIL-STD-3010A.Specifications4-2Bags or Sheeting or Tubing and VCI
Material meets Federal Specification PPP-C-795.Specifications4-3Bags and Bubble Bags
Material meets MIL-P-82646 Rev. B.Specifications4-4Bags or Sheeting or Tubing and Black Conductive

Specifications4-5Bags or Sheeting or Tubing and LDPE or LLDPE and Laddawn
Material does not contain any wheat-based release agents.Contains5-1Bags or Sheeting or Tubing
Material contains amides.Contains5-2Bags or Sheeting or TubingNon-Slip

Material may contain trace amounts of amides.

Contains5-3Bags or Sheeting or Tubing and Non-Slip
Material contains Anti-Static concentrate without amides.Contains5-4Bags or Sheeting or Tubing and Anti-Static
Material is recyclable.End6-1Bags or Sheeting or TubingStatic Shielding
Made in the USA.End6-2Laddawn

.

Sequence

The sequence column specifies the order in which that string of text should appear on the document.


Open Questions


QuestionAnswer
Will we have the ability to offer automated C of C's on non-stock items? 

No.

This only applies to stock and mod items.

Will we have the ability to generate C of C's after an order has been placed? Perhaps via a download link on the summary page (in each bundling section).

Yes.

However, this link should only be visible AFTER a bundle has shipped. 

Do we need to retain copies of C of C's that are generated?

No (Per Meredith)

We currently do not retain any copies of HACCP documentation, so we do not need to preserve these either.




Attachments:

01 - Default Template.png (image/png)
02 - Layflat (Under 18in Width).png (image/png)
03 - Layflat (Over 18in Width).png (image/png)
04 - Gusseted (VCI).png (image/png)
05 - Layflat (Black Conductive).png (image/png)
Continued.jpg (image/jpeg)
Z1.png (image/png)
Z2.png (image/png)
Z3.png (image/png)
Z4.png (image/png)
Z5.png (image/png)
Copy of CofC 2.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)