Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 26
  1. #11
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: Importing from an external dropship site

    Quote Originally Posted by djcr View Post
    Is there a manual anywhere that explains what fields Zen Cart requires for a product or category import?

    I've a CSV file from a drop shipping supplier and need to bring this into my cart, through whatever method, but need to make sure that the fields tally.

    Thanks
    For people who struggle with SQL commands and queries, Easy Populate is the most practical way to upload and administer product information in your zenshop.

    See above for links to Easy Populate module.

    My Easy Populate tutorial is here:
    http://www.zen-cart.com/wiki/index.php/Easy_Populate
    We host with Terranetwork.

  2. #12
    Join Date
    Oct 2008
    Posts
    19
    Plugin Contributions
    0

    Default Re: Importing from an external dropship site

    Hi
    i have 16000 products to import and every day that changes too.so i have to update them.is it any easy way to change the Column Headings in excel,stead of all copy and past .
    thanks

  3. #13
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: Importing from an external dropship site

    Quote Originally Posted by mm99 View Post
    Hi
    i have 16000 products to import and every day that changes too.so i have to update them.is it any easy way to change the Column Headings in excel,stead of all copy and past .
    thanks
    No...

    (But doing this manually only takes a couple of minutes...)
    We host with Terranetwork.

  4. #14
    Join Date
    Oct 2008
    Posts
    19
    Plugin Contributions
    0

    Default Re: Importing from an external dropship site

    yes you are right .specially for updating price and quantity .but my drop ship site ,almost add some new product everyday.maybe i have to look for some program to compare and sync excel files.
    thank you for reply

  5. #15
    Join Date
    Apr 2008
    Posts
    48
    Plugin Contributions
    0

    Default Re: Importing from an external dropship site

    Quote Originally Posted by schoolboy View Post
    If you are able to grab your supplier's product data as a csv file or even a MS Excel spreadsheet, the easiest way to load it into your database is to use EasyPopulate.

    If you are using Zencart version 1.3.xxx (including 1.3.8a) then the version of EP you need is 1.2.5.4 available from Langer's Modhole (www.modhole.com - follow links to Easy Populate Standard).

    If your supplier provides a list of image url's, the easiest way to get all the images is to use wget. This program automatically downloads all the images from the remote site to your hard drive.

    Your supplier's spreadsheet is likely to have a column that lists the paths to the images - something like:

    http://www.supplier.com/images/1234567.jpg
    http://www.supplier.com/images/2345678.jpg
    http://www.supplier.com/images/3456789.jpg

    Copy this column and paste it into a plain text editor (notepad++), then save it as a .txt file .

    Save this file in the root (c:) of your hard drive.

    (We used this last night to grab over 4000 images - took 30 minutes).

    Get wget from:-

    http://sourceforge.net/project/downl...se_mirror=garr

    install it

    open a cmd prompt e.g. start | run | type: cmd
    in the command prompt type cd.. press enter

    type this again till you get to just the c:

    (The program may be located in a BIN folder, and if so, the likely path will be: C:\Program Files\GnuWin32\bin. At the c: prompt, type cd Program Files\GnuWin32\bin)

    When you reach this location...

    type wget -i c:\textfile.txt (replace textfile.txt with the name of the textfile you created)

    let it run till it downloads all your images. (They will be located in the bin folder, so later you can move them to another folder).

    you will now have a folder with all the images as they were on the remote server.

    You can then FTP the images to your own server.
    question, i tried this and it said it downloaded my pictures, but i cant find them, i did exactly like you wrote and looked in bin folder, ??

  6. #16
    Join Date
    Apr 2008
    Posts
    48
    Plugin Contributions
    0

    Default Re: Importing from an external dropship site

    Quote Originally Posted by jgg1974 View Post
    question, i tried this and it said it downloaded my pictures, but i cant find them, i did exactly like you wrote and looked in bin folder, ??
    ANY!?

  7. #17
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: Importing from an external dropship site

    If you know what one of the images is called, use the search function in windows to locate it, or use FF at the command prompt.
    We host with Terranetwork.

  8. #18
    Join Date
    Apr 2008
    Posts
    48
    Plugin Contributions
    0

    Default Re: Importing from an external dropship site

    I did the search but no luck finding the image, also can you tell me what is FF?

    thanks

  9. #19
    Join Date
    Mar 2009
    Location
    Peterborough UK
    Posts
    336
    Plugin Contributions
    0

    Default Re: Importing from an external dropship site

    hi
    thanks for the useful information on the scraping tool schoolboy.

    I also cant find the images - I looked in the .bin file and there are about 4.dll files. one file is about 1,150kb which might be the one holding the images but i cant seem to open it.

    Ive done a search for the images and windows just points me to the datafeed from which i pulled the urls from.

    ANy idea

    thanks

  10. #20
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: Importing from an external dropship site

    I use the wget function regularly, and I follow the procedure I outlined. The images are always in my bin folder

    (dos-path c:\Program Files\GnuWin32\bin )

    On your computer, go to START button and open command screen (cmd).

    when in DOS mode, change directories until you have the following:

    c:\Program Files\GnuWin32\bin >

    Then at the command prompt, type DIR, then hit [Enter] key.
    We host with Terranetwork.

 

 
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. add to cart from external site
    By rolfcarol in forum General Questions
    Replies: 2
    Last Post: 9 Jan 2011, 04:04 PM
  2. Importing attribute values sent from an external Form?
    By JeremyS in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 18 Jun 2009, 02:20 AM
  3. Search Box from External site?
    By wootoot1234 in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 19 Feb 2009, 08:39 PM
  4. importing customers from an external sql database
    By aeisecurity in forum Managing Customers and Orders
    Replies: 4
    Last Post: 20 Apr 2008, 05:08 AM
  5. Populate cart from an external site?
    By hughjaas in forum General Questions
    Replies: 0
    Last Post: 27 Nov 2007, 09:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR