Customer Portal Language
 
HomeKnowledge BaseASPDotNetStoreFront Bulk Order Tracking Number Import
Information
Article ID5
Created On7/14/2009
Modified7/14/2009
Share With Others
ASPDotNetStoreFront Bulk Order Tracking Number Import

Being that ASPDotNetStoreFront currently only imports UPS related tracking, I got tired of waiting and created my own bulk tracking number import function for ASPDotNetStoreFront, I am currently using ML 8.0.1.1/8.0.1.1

This code performs an ASP.Net Excel Import that Updates a SQL Server Database Using SQLBulkCopy and a Stored Procedure

Download Code

It uses a standard Excel template, SQLBulkCopy functionality, and could be customized for other applications if so desired. This code only handles single product orders and does not perform any email communication.

Below are the installation instructions and at the bottom you can download a copy of the source code.

Disclaimer: The developers of this code offer no support, and make no guarantees.
Use at your own risk
The developers are in no way affiliated with ASPDotNetStoreFront
ASPDotNetStoreFront is in no way affiliated with the developers

  1. Connect to your website database
  2. Execute SQL\CreateTrackingStagingTable.sql Query (this is the import staging table)
  3. Execute SQL\CreateTrackingUpdateSProc.sql Query (performs the update to the orders table using the related OrderNumber)
  4. Update the connection strings in the web.config if needed, and the code section of the BulkTrackingImport.aspx file to match your environment.
  5. Copy the ExcelImport folder to you admin directory this contains a blank Excel template
  6. Copy BulkTrackingImport.aspx to your admin directory
  7. Adjust any other settings and directory permissions accordingly
  8. Do not edit  or rename the TrackingImport.xls template unless you understand where and how it is accessed in the source code.

i.e.
WEB.CONFIG:
<connectionStrings>
        <add name="DevelopmentConnectionString" connectionString="Data Source=LOCALHOST;Initial Catalog=Development;Persist Security Info=True;User ID=sa;Password=password" providerName="System.Data.SqlClient"/>
    </connectionStrings>

and any of these lines in the .aspx page:
ConfigurationManager.ConnectionStrings("DevelopmentConnectionString").ConnectionString

You can add a link in your admin menu here, I added it to the bottom of the Orders Menu as follows open admin\skins\skin_x\menuData.xml and add it in your desired section.

<!-- Orders Menu -->