Results 1 to 4 of 4
  1. #1
    Newbie
    Join Date
    November 11th, 2005
    Posts
    1
    Feed Integration Project
    Greetings,

    I have an OSCOMMERCE site at http://www.loopwise.com/shop

    and I am looking to follow the instructions seen below to add www.zzounds.com products to my site.
    I am unsure of the best way to go about integrating this feed into my existing Oscommerce Shopping Cart, but I would like to pay someone who has a keen understanding of this process to complete the project with me. There are about 6000 products in the feed. Does anyone have any idea of how this workS?

    EXPECTATIONS:

    -50% up front 50% when completed
    -$5 for every day project is overdue
    -1 month time frame
    -work to be performed on my server / site directly


    If you are interested in working with me on this project, please outline for me what your understanding of the project is, and how EXACTLY you will go about completing the project. I need to specifics of your strategy and what you will be doing at what stages in the process. Thanks for your interest! -taylor


    https://www.zzounds.com/aff--feedaccess


    zZounds Data feed Access
    Download the feed using one of the following methods:
    Use a web browser.
    Good for interactive use.
    The URL is: https://www.zzounds.com/feed-pickup/feed--affiliate.txt

    After entering the URL and hitting return to go to the site, you will be prompted to enter your username and password. The username is your affiliate id and the password is your affiliate password.
    You can avoid the username and password prompting if you include these in the URL. Use the standard format for these requests:
    https://usernameassword@host/path
    If your affiliate id was 99999 and your password was "mypass", then the URL would be:
    https://99999:mypass@www.zzounds.com...-affiliate.txt
    Use the GNU wget application.
    Good for use in a script and/or for more advanced users.
    Example Usage:
    wget --http-user=AFFILIATE_ID --http-passwd=AFFILIATE_PASSWORD https://www.zzounds.com/feed-pickup/feed--affiliate.txt
    The username is your affiliate ID and the password is your affiliate password.
    The general GNU wget information page is located here.
    The feed will be saved as "feed--affiliate.txt". If a file with this name already exists, wget will not overwrite the file but will instead save it with a version number, e.g. "feed--affiliate.txt.1". Since this behavior is likely to be undesirable for most users, you should delete or rename the existing "feed--affiliate.txt" file before starting a new download with wget.
    Windows users should follow these steps to install wget.
    Create a Directory in which to store the wget application and related files. We recommend "C:\Program Files\wget".
    If you are running Windows 2000 or XP and you do not have administrator privliges on your machine, you can still use wget. Just specify a different installation directory. wget will run from any directory location and it does not make or require any registry changes.
    Download the primary wget zip file and unzip the files into the new directory you created in step 1.
    Download the SSL library zip file and unzip the files into the new directory you created in step 1.
    You can now access the wget application using the Windows Command Prompt. Keep in mind that you will need specify the wget path you used for installation when calling wget, i.e.
    "C:\Program Files\wget\wget"
    or you will need to add this directory to your path statement. You can also just "cd" to this directory and call wget directly.
    Windows users should follow these steps to use wget.
    Open up a command prompt. On Windows 95 & 98, this is accessed from Start->Programs->MS-DOS Prompt. On Windows NT 4.0, 2000 and XP, this can be accessed under Start->Programs->Accessories->Command Prompt. Running wget from Start->Run is not recommended as wget expects a command prompt enviroment to display normal messages and errors. If you run wget from the Start-Run window, Windows will temporarily create a command prompt for wget, but as soon as wget finishes, it will delete the temporary command prompt before you have a chance to read the wget messages.
    Use the "cd" command to change to the directory to where you want to store the downloaded file.
    Use the wget command as described above under "Example Usage:" bullet. Also, refer to the wget session transcripts below to see what should occur.
    A complete wget session on a Windows system will look like this:
    C:\temp>c:\progra~1\wget\wget --http-user=XXXXX --http-passwd=XXXXXXXX https://www.zzounds.com/feed-pickup/feed--affiliate.txt
    --16:57:08-- https://www.zzounds.com/feed-pickup/feed--affiliate.txt
    => `feed--affiliate.txt'
    Resolving www.zzounds.com... done.
    Connecting to www.zzounds.com[66.147.161.22]:443... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: unspecified [text/plain]

    [ <=> ] 2,988,131 174.21K/s

    16:57:46 (174.21 KB/s) - `feed--affiliate.txt' saved [2988131]

    C:\temp>

    A complete wget session on a Unix/Linux system will look like this:
    sounds:/home/au$ wget --http-user=XXXXX --http-passwd=XXXXXXXX https://www.zzounds.com/feed-pickup/feed--affiliate.txt
    --22:42:54-- https://www.zzounds.com/feed-pickup/feed--affiliate.txt
    => `feed--affiliate.txt'
    Resolving www.zzounds.com... done.
    Connecting to www.zzounds.com[66.147.161.22]:443... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: unspecified [text/plain]

    [ <=> ] 2,781,009 171.63K/s

    22:45:07 (171.63 KB/s) - `feed--affiliate.txt' saved [2781009]

    sounds:/home/au$

    The data feed is dynamically generated, it can take a few minutes for the download to start after the https request is initially received. If you are using wget, this pause will occur after this message is displayed: "HTTP request sent, awaiting response...". The size of the data feed file is about 2.5MB.
    Access using the FTP protocol is not offered.
    As the data feed is dynamically generated when each affiliate requests it, it may take up to a minute for the feed to start downloading after the initial HTTP or wget request is made. This delay will occur after username-password authorization.
    Data feed access is limited to approved affiliates.
    The data feed can be retrieved only once per hour. We recommend that you update your site daily, but you can update more often if you choose.


    Data feed File Format
    The data feed file is a standard tab delimited text file with these features:
    Simple 8-bit text file, i.e. not Unicode.
    Field names are in the first row.
    Fields are delimited by the tab character.
    Lines are delimited by newline & carriage return characters, i.e. standard windows text file format.
    Character fields are NOT enclosed by quotes.
    In the future, we may augment the data feed file with additional fields. Examples could include a promotion field that indicates that the item is on sale, being closed out, etc. We already have tentative plans to add 2-day and overnight shipping costs. Although we will give you advance notice of any changes in the file, you will probably find it advantageous to design your file importation routine so that it can read a file with extra fields without breaking. This way, if you choose not to use the new fields, you site can continue to operate without intervention on your part. While we expect that we may add fields to the file in the future, we do not anticipate changing or dropping any of the existing fields.



    File Fields
    Name Name of Product. Character Field, Up to 128 Characters.
    Description Short Description of Product in text. No HTML. Character Field, Up to 1024 Characters, although most descriptions will be only 3-4 lines long.
    SKU Product SKU. Character Field, Up to 20 Characters.
    URL_Product URL for product. This URL includes your affiliate code so that you can be paid for the referral. Character Field, Up to 255 Characters.
    URL_Image_Small Location of Small product image hosted by ZZ/SDM. Character Field, Up to 255 Characters.
    URL_image_Large Location of Large product image hosted by ZZ/SDM. Character Field, Up to 255 Characters.
    Price Actual zZounds selling price. Manufacturers sometimes restrict us from show prices for some items. If the price is missing, then Call zZounds for price must be shown. You may choose to display only products where a price can be shown. Numeric Field.
    Price_High High selling price range. For most products, this field will be missing. It will be present for items like guitars, where the price can vary according to the guitars color and/or finish. If this field is populated, then you should show the price as occurring in a range between the Price field and this Price_High field, e.g. from $259.00 to $329.00. Numeric Field.
    Price_List List price of product. Numeric Field.
    Category Leaf category for product. Character Field, Up to 64 Characters.
    Manufacturer Manufacturer name of product. Character Field, Up to 64 Characters.
    Shipping_Cost Minimum (ground) shipping cost to customer. If 0, then shipping is free and this should be noted on your site as Free Shipping or something similar. Users may feel that a shipping price of $0 is inaccurate and represents a bug. Numeric Field.


    Other Notes
    Please keep in mind that the feed will add and drop products as we add or drop them from our master catalog. If a product is no longer listed in the data feed, then you should remove the zZounds link for this product.
    You can use the category and/or manufacturer fields to select out a manageable set of products to display.



    Kind Regards,

    Taylor
    Founder/Webmaster
    cell: 562-544-2355
    office: 562-430-2829
    AIM Y! MSN chat: loopwisechat
    http://www.loopwise.com - Collaborate With Other Musicians Online!

  2. #2
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    It sounds like you need to have this feed imported on a regular basis. The instructions you listed here just describe how to download the feed. You have to consider updating your products, removing out of stock products and keeping everything up to date. It's not a very difficult process and I may be able to help you. I sent you an IM through Yahoo chat.

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  3. #3
    notary sojac Herb ԿԬ's Avatar
    Join Date
    January 18th, 2005
    Location
    Central/Western NY State
    Posts
    7,741
    I have the proper credentials but have never succeeded in downloading the feed.

  4. #4
    Intergalactic Trader IGshop's Avatar
    Join Date
    January 18th, 2005
    Posts
    87
    Quote Originally Posted by jahwise
    Greetings,

    I have an OSCOMMERCE site at http://www.loopwise.com/shop

    and I am looking to follow the instructions seen below to add www.zzounds.com products to my site.
    I am unsure of the best way to go about integrating this feed into my existing Oscommerce Shopping Cart, but I would like to pay someone who has a keen understanding of this process to complete the project with me. There are about 6000 products in the feed. Does anyone have any idea of how this workS?
    Taylor,

    I have this feed automated on one of my websites. I sent you an email to offer help.

    Jim

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. cPanel Integration Project
    By paladin in forum Midnight Cafe'
    Replies: 0
    Last Post: February 28th, 2008, 10:54 AM
  2. Feed Integration Project
    By jahwise in forum Midnight Cafe'
    Replies: 2
    Last Post: November 11th, 2005, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •