{"id":6816,"date":"2018-06-07T21:57:22","date_gmt":"2018-06-07T21:57:22","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=6816"},"modified":"2020-09-10T16:09:25","modified_gmt":"2020-09-10T23:09:25","slug":"how-to-use-eformz-to-create-drop-ship-pack-slips","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/how-to-use-eformz-to-create-drop-ship-pack-slips\/","title":{"rendered":"How to Use eFORMz to Create Dropship Packing Lists"},"content":{"rendered":"<p><strong>Note:<\/strong> Consult our <a href=\"\/support\/index.php\/dropship-standardized-xml-schema\/\">Dropship Standardized XML Schema<\/a> post<\/p>\n<p>Minisoft maintains a library of packing lists of popular retail brands (over 200 and counting) for the purpose of <a href=\"https:\/\/www.minisoft.com\/wp-content\/uploads\/2018\/04\/DropShip-Template-library.pdf\">drop shipping<\/a> and <a href=\"https:\/\/www.minisoft.com\/index.php\/fulfillment\/\">third-party fulfillment<\/a>. To use the drop shipping and third-party fulfillment templates you must decide how you will be giving eFORMz the data to display on the packing slip. Some common methods include:<\/p>\n<ul>\n<li>Relational Database Queries<\/li>\n<li>Web Service Calls (<a href=\"\/support\/index.php\/integrating-eformz-with-salesforce\/\">Salesforce<\/a>, <a href=\"\/support\/index.php\/netsuite-integration\/\">NetSuite<\/a>, etc.)<\/li>\n<li>XML Data Files<\/li>\n<li>Virtual Printer<\/li>\n<li>Monitoring a Directory<\/li>\n<\/ul>\n<p>For more information, view the following resource:\u00a0<a href=\"\/support\/index.php\/how-does-eformz-integrate\/\">How Does eFORMz Integrate?<\/a><\/p>\n<p>In this article, we will describe how easy it is to use the eFORMz dropship library through a relational database query. Other methods will vary slightly but will generally follow the same process:<\/p>\n<ul>\n<li>Capture information from the shipping label used for matching with a packing list<\/li>\n<li>Execute a stored procedure, a web service call or some other action to retrieve the packing list<\/li>\n<li>Capture the data through eFORMz variables<\/li>\n<li>Place and position the data on the form<\/li>\n<\/ul>\n<h2>Using the Dropship Library<\/h2>\n<p>eFORMz has powerful functionality for extracting data from a shipping label. It will be able to use any type of shipping label, such as Fedex, UPS, USPS, OnTrac and others. The tracking number of any shipping label or any ZPL file can be extracted and utilized by eFORMz. Why do we want to extract the tracking number? It is a common identifier for a database to distinguish data among the different pack slip orders. It is commonly used as a parameter for stored procedures in database calls.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6817\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel.png\" alt=\"\" width=\"626\" height=\"868\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel.png 626w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel-216x300.png 216w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel-108x150.png 108w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel-250x347.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel-550x763.png 550w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel-130x180.png 130w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/ShippingLabel-361x500.png 361w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/a><\/p>\n<p>This is what the tracking number looks like once it is captured by an eFORMz variable.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6818\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar.png\" alt=\"\" width=\"772\" height=\"167\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar.png 772w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar-300x65.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar-768x166.png 768w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar-150x32.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar-250x54.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/TrackingNumberVar-550x119.png 550w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><\/a><\/p>\n<p>eFORMz can execute stored procedures in a database as shown below.<\/p>\n<ul>\n<li>The blue arrow is the name of the database.<\/li>\n<li>The first green arrow is the SQL statement and the second green arrow is the input parameter of the tracking number that was extracted from the shipping label.<\/li>\n<li>The pink arrow is the output parameters of the stored procedure call. These parameters are the different columns returned from the stored procedure call.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6819\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database.png\" alt=\"\" width=\"403\" height=\"582\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database.png 403w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database-208x300.png 208w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database-104x150.png 104w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database-250x361.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database-125x180.png 125w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Database-346x500.png 346w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/a><\/p>\n<p>Here is what the data returned by the stored procedure looks like upon being stored in eFORMz variables.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6820\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars.png\" alt=\"\" width=\"636\" height=\"98\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars.png 636w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars-300x46.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars-150x23.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars-250x39.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/DatabaseVars-550x85.png 550w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<p>Next, the data is placed into the dropship templates. This example shows the data being placed into a Fred Meyer template but could be used for any of the 200+ templates.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6821\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip.png\" alt=\"\" width=\"759\" height=\"599\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip.png 759w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-300x237.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-150x118.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-250x197.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-550x434.png 550w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-228x180.png 228w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-380x300.png 380w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/06\/Packslip-634x500.png 634w\" sizes=\"(max-width: 759px) 100vw, 759px\" \/><\/a><\/p>\n<h3>Summary &#8211; Database Method<\/h3>\n<ul>\n<li>Capture the tracking information of the label or some other common identifier for a database to distinguish data<\/li>\n<li>Execute a stored procedure or a statement to retrieve the data<\/li>\n<li>Capture the data through eFORMz variables<\/li>\n<li>Place and position the data on the form<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Note: Consult our Dropship Standardized XML Schema post Minisoft maintains a library of packing lists of popular retail brands (over 200 and counting) for the purpose of drop shipping and third-party fulfillment. To use the drop shipping and third-party fulfillment templates you must decide how you will be giving eFORMz the data to display on [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[411,3],"tags":[439,410,412,413,440],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/6816"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=6816"}],"version-history":[{"count":4,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/6816\/revisions"}],"predecessor-version":[{"id":8397,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/6816\/revisions\/8397"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=6816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=6816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=6816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}