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 5 of 5

Thread: Uploading Mfgrs and Distributors

  1. 04-02-2011, 09:03 PM #1
    USNFC3 is offline Junior Member
    Join Date
    Apr 2011
    Location
    Mid West
    Posts
    10

    Question Uploading Mfgrs and Distributors

    Hello,
    Ive spent HOURS on the website trying to find a couple of simply answers, and all I can seem to find are others asking the same questions!

    1. Is there a way I can upload all my MANUFACTURES?
    2. Is there a way I can upload all my DISTRIBUTORS?
    (in an excel spreadsheet format)
    If so .. HOW?
    and ...

    3. Where can I find a sample spreadsheet with all the proper titles I need in order to upload products to the site?

    4. Where can I find the instructions on how to do all of the above?
    Thank You!!
  2. 04-04-2011, 10:24 AM #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    All of that (at least the ones that are supported) is in the online manual, easily found with a quick search for 'excel'.

    Excel import - http://manual.aspdotnetstorefront.co...ct-import.aspx
    Excel import fields - http://manual.aspdotnetstorefront.co...rt-fields.aspx

    That covers all the product/entity data that can be imported through Excel, and what each field does. If it's not in that spreadsheet, then you can't import it from Excel, and would want to look into WSI instead. It's much more complicated, but also much more powerful.
    ECommerce Shopping Cart
  3. 04-05-2011, 01:25 AM #3
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    The same technique can be used as I have discussed in this other thread

    Create a spreadsheet with the correct columns and then use a formula to create the SQL insert statements.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!
  4. 05-12-2011, 09:30 PM #4
    USNFC3 is offline Junior Member
    Join Date
    Apr 2011
    Location
    Mid West
    Posts
    10

    Default Thanks!

    Thank You, but ... <sigh>... Im one of those people who learns best (and easiest) If I can be shown something (hands on) for the first time. Then It burns in and Ive got it, but I have NO clue as what to do with that file other than put it in with the others that cause me a great deal of anxiety! LOL <smile> At this point, Id rather laugh about it - as Im running out of hair to pull out! But THANK YOU all the same!

    Quote Originally Posted by esedirect View Post
    The same technique can be used as I have discussed in this other thread

    Create a spreadsheet with the correct columns and then use a formula to create the SQL insert statements.
  5. 05-13-2011, 02:47 AM #5
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Post a spreadsheet with a few sample rows of your distributor data and I'll amend it for you. You can obfuscate the data if it makes you feel more comfortable.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!