Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 8 of 8

Thread: Import Drop Ship Tracking Numbers

  1. 04-16-2010, 03:45 PM #1
    shaser is offline Junior Member
    Join Date
    Oct 2009
    Posts
    28

    Default Import Drop Ship Tracking Numbers

    What is the best method of importing tracking numbers from drop ship suppliers?

    They can export tracking details from their UPS wordship....how can I get that information into the storefront?
  2. 04-16-2010, 05:59 PM #2
    Rob is offline Senior Member
    Join Date
    Aug 2004
    Posts
    3,037

    Default

    Direct SQL back to orders table or use WSI to update via Xml web service.
    AspDotNetStorefront
    Shopping Cart
  3. 04-17-2010, 07:14 AM #3
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    You can also import that data through the admin interface if you can export it from UPS into the right format.
    ECommerce Shopping Cart
  4. 04-19-2010, 08:31 AM #4
    shaser is offline Junior Member
    Join Date
    Oct 2009
    Posts
    28

    Default

    Scott,

    Thank you, that was exactly what I was looking for!
  5. 07-22-2010, 12:31 PM #5
    jspatt2 is offline Junior Member
    Join Date
    Sep 2008
    Posts
    27

    Default Question about the file format

    okay I see that sccording to the Documentation that:

    "if the 3rd-party app supports it they can re-output the CSV file with the shipping information (tracking number, shipping date, carrier, etc) filled in and the ASPDNSF software can import it, through the field on this page. "

    But in the Kowledge Base it says this:
    "In order to import tracking numbers through the Orders->Shipping Import/Export option in the admin site, the CSV file has to be properly formatted. The file should be 3 columns, with no headers.


    - The first column should be either Y or N, indicating whether or not the order has been voided.
    Note: This will not appear on ML 7.1.1.0+ and can be ignored.
    - The second column is the order number *
    - The third column contains the tracking number from the shipping carrier"

    So the first statement is not correct?
    Or is there another file format that can be used to do what the documentation says?

    Thank you.
  6. 07-23-2010, 12:27 AM #6
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Can you provide URL of the manual you're seeing Statement #1? Follow the KB article instead - https://support.aspdotnetstorefront....barticleid=153
  7. 07-23-2010, 05:45 AM #7
    jspatt2 is offline Junior Member
    Join Date
    Sep 2008
    Posts
    27

    Default Url

    http://manual.aspdotnetstorefront.co...ortexport.aspx

    I also see that on this page you can use USPS Endicia DAZzle:

    http://manual.aspdotnetstorefront.co...g-numbers.aspx

    how do I get this to work, I found in the ShippingImportFormats that you have DAZzle listed, again how do I get this Exporting/Importing to work for Endicia DAZzle?

    Thank you.
  8. 09-16-2010, 03:16 PM #8
    ShawnOswald is offline Junior Member
    Join Date
    Sep 2010
    Posts
    2

    Default

    Quote Originally Posted by shaser View Post
    What is the best method of importing tracking numbers from drop ship suppliers?

    They can export tracking details from their UPS wordship....how can I get that information into the storefront?
    There are a few software solutions that make that process pretty simple. Mailware imports the tracking numbers from the drop shippers and puts it right in the aspdotnetstorefront cart. lol it defiantly saves you from a hassle.

    (I don't mean to advertise on the forum, but I believe Mailware is a truly good solution to the OP's question)