UPS by Shipworks - Claims Report

Follow

Philip Doolittle

• May 28, 2020 18:51

Shipworks requires the information below to file a claim.  All of this resides in Shipworks.

Step 1 - There should be a canned report to generate this information.

Step 2 - Users should be able to submit a claim directly from the shipment to UPS by Shipworks.

 

Required information

• Shipper information:
  • Company name -
  • Contact name -
  • Telephone number -
  • Fax number OR E-mail address -
  • Complete address -
• Consignee information:
  • Company name -
  • Contact name -
  • Telephone number -
  • Complete address -
  • E-mail address -
• Shipment information:
  • Shipment Tracking Number -
  • Weight of the goods -
  • Value of the goods -
  • P.O. or invoice number -
  • Complete & detailed description of the goods (size, brand, color, model number, etc.) -
  • Has a replacement package been shipped? If yes, please provide the replacement tracking number. If no, do -you plan on shipping a replacement package? -

0

• Official comment

  

  Ryen M.

  • May 28, 2020 19:26

  Hi Philip,

  Agreed! That would be a great template to have, I will get a ticket started for you with that request. You should get an email here soon with your new ticket for your template request.

  Comment actions Permalink
• 

  Philip Doolittle

  • June 15, 2020 21:51

  I'm not sure why no one updated the thread, but the report was created and the template is below:
  
  

  <!DOCTYPE xsl:stylesheet[ <!ENTITY nl "&#xd;&#xa;"> <!ENTITY nbsp "&#160;"> ]>
  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:sw="http://www.interapptive.com/shipworks" extension-element-prefixes="sw">

  <xsl:import href="System\Snippets" />
  
  <xsl:output method="text" encoding="utf-8" />

  <!-- Start of template -->
  <xsl:template match="/"><xsl:apply-templates /></xsl:template>
  <xsl:template match="ShipWorks">
  
  <xsl:text>SHIPPER INFO:</xsl:text>
  
  <xsl:text>&nl;&nl;</xsl:text>
  
  <xsl:text>Company name, Contact name, Telephone number, Fax number, Email address, Complete address&nl;</xsl:text>
  
  <xsl:for-each select="//Shipment[Status = 'Processed']">
  
  <xsl:variable name="FromAddress" select="Address[@type='from']"/>
  
  
  <xsl:text>"</xsl:text><xsl:value-of select="$FromAddress/Company" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="$FromAddress/FullName" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="$FromAddress/Phone" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="$FromAddress/Fax" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="$FromAddress/Email" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="$FromAddress/Line1" /><xsl:text> </xsl:text><xsl:value-of select="$FromAddress/Line2" /><xsl:text> </xsl:text><xsl:value-of select="$FromAddress/Line3" /><xsl:text> </xsl:text><xsl:value-of select="$FromAddress/City" /><xsl:text>, </xsl:text><xsl:value-of select="$FromAddress/StateCode" /><xsl:text> </xsl:text><xsl:value-of select="$FromAddress/PostalCode" /><xsl:text>"</xsl:text>
  
  <xsl:text>&nl;</xsl:text>
  
  </xsl:for-each>
  
  <xsl:text>&nl;&nl;</xsl:text>
  
  <xsl:text>COSIGNEE INFO:</xsl:text>
  
  <xsl:text>&nl;&nl;</xsl:text>
  
  <xsl:text>Company name, Contact name, Telephone number, Complete address, Email address&nl;</xsl:text>
  
  <xsl:text>&nl;&nl;</xsl:text>
  
  <xsl:variable name="ship" select="//Shipment[Status = 'Processed']/Address[@type='ship']"/>
  
  
  <xsl:value-of select="$ship/Company" /><xsl:text>,</xsl:text>
  <xsl:value-of select="$ship/FullName" /><xsl:text>,</xsl:text>
  <xsl:value-of select="$ship/Phone" /><xsl:text>,</xsl:text>
  <xsl:value-of select="$ship/Line1" />&#160;<xsl:value-of select="$ship/Line2" />&#160;
  <xsl:value-of select="$ship/City" />&#160;<xsl:value-of select="$ship/StateCode" />&#160;
  <xsl:value-of select="$ship/PostalCode" /><xsl:text>,</xsl:text>
  <xsl:value-of select="$ship/Email" />
  
  <xsl:text>&nl;&nl;&nl;&nl;</xsl:text>
  
  <xsl:text>SHIPMENT INFO:</xsl:text>
  
  <xsl:text>&nl;&nl;</xsl:text>
  
  <xsl:text>Tracking number, Shipment weight, Shipment cost, Order number&nl;</xsl:text>
  
  <xsl:for-each select="//Shipment[Status = 'Processed']">
  <xsl:variable name="order" select="../../Order"/>
  
  <xsl:text>SHIPMENT:"</xsl:text><xsl:value-of select="TrackingNumber" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="TotalWeight" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="TotalCharges" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="$order/Number" /><xsl:text>"</xsl:text>
  
  <xsl:text>&nl;&nl;</xsl:text>
  
  <xsl:text>ITEM INFO:</xsl:text>
  
  <xsl:text>&nl;</xsl:text>
  
  <xsl:text>Name, SKU, Quantity&nl;</xsl:text>
  
  <xsl:for-each select="../../Order/Item">
  
  <xsl:text>"</xsl:text><xsl:value-of select="Name" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="SKU" /><xsl:text>", </xsl:text>
  <xsl:text>"</xsl:text><xsl:value-of select="Quantity" /><xsl:text>"</xsl:text>
  
  <xsl:text>&nl;</xsl:text>
  
  </xsl:for-each>
  
  <xsl:text>&nl;</xsl:text>
  
  </xsl:for-each>
  
  </xsl:template>
  </xsl:stylesheet>

  0

  Comment actions Permalink

Please sign in to leave a comment.